You can import certain formula files from your nutritionist in to create Formulas along with the Nutrients that make up the Formula.
| Table of Contents |
|---|
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
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.
