You can import certain formula files from your nutritionist in to create Formulas along with the Nutrients that make up the Formula.

1 Configurations
- 1.1 Nutrient Map
- 1.2 Calories
2 Data Import
- 2.1 New Import Type
- 2.2 Run Import

Configurations

You must first map the nutrient codes found in your file to the corresponding nutrient in Aeros LIVE.

Nutrient Map

In the database, you will need to update the table 'NutrientMap'

BrillNumber, C5Number and RePete Number are all different files that can be imported, I usually just make sure they all have the same number to reference.

Specify whether it should come through as a percentage or a decimal. You can also define if it is a calorie.

BusinessTypeID comes from the UserBusinessType table, you will want to reference objectid = 16

Calories

The only one that does not show up in the above nutrients is Calories such as M/E Poultry. This comes from the same table but references objectid = 27

Data Import

New Import Type

Once everything is configured correctly you can set up your data import.

System → Data Import → Data Import Schedules

Select Add New

Import Type: Currently we have 3 different formula file formats that can be brought in

Select the one you should utilize and enter a code/Description for the file so you can find this config easily.

Enter a source folder in and out were the file is located to be pulled and where it should go once processed.

With the scheduler installed you can schedule the import to run at a specified day/time.

More information on Data Imports is located here: Data Imports

Run Import

To execute the import select the cog in the right hand corner of the form.

Once the file runs you can go to Import History to see if the file was successful.

Once the file has processed, you can go to the Formula Manager to see the formula.