Any ingredient contained in this Formula must first be present in Genesis.
All Formula information must be repeated for each Ingredient in the Formula. In this example, you can see that the SAMPLE Ginseng Plus, Formula Notes, # containers, and the other Formula data are repeated for both Ingredients. The same is true for SAMPLE Magnesium
Make sure cell values are formatted as numbers, general or date. The Import Wizard reads all numerical values as numbers. So, for example, if the field is defined in excel as percent, the program will read 100% as 1, which is probably not what you intend.
You can import more than one Formula at a time. In this example, I'm importing SAMPLE Magnesium and SAMPLE Ginseng Plus.
To map a field
This page will show you if you have any errors that would cause the import to fail. Example: Name conflict. This would indicate that you have an existing database item with the same name.
If the Validation says everything is OK, click Next to begin the import.
This will tell you when the Import is complete. Click Exit to return to the Genesis Supplements program. Click New Import to select another file to import. Select Search to return to the Open search screen.
On this page: |
COLUMN DETAILS
Mapped
Original field name
Mapped field
Active
Mapped unit
Default value
Sample data
FIELD TYPES DEFINED
Allergens
This section lists all of the allergens available in the program. Search for an item in the search box or scroll to see all of the items in a list. Click on one of the items to select it. To add the name listed in the Original Field as a new allergen, select New Allergen. In the excel spreadsheet, an “x” in the field designates that the allergen is present. The following field inputs may be used to designate that the allergen is not present: blank, 0, f, no, null, none, false, inactive. Use this option to designate allergens that are not accounted for in the ingredients. Ingredient allergens will carry through to the formula level.
Groups
This section lists all of the groups available in the program. Search for an item in the search box or scroll to see all of the items in a list. Click on one of the items to select it. To add the name listed in the Original Field as a new group, select New Group. In the excel spreadsheet, an "x" in the field designates that the ingredient is in that group. The following field inputs may be used to designate that the ingredient is not in the group: blank, 0, f, no, null, false, inactive.
User Added Fields
This section lists all of the user added fields available in the program. Search for an item in the search box or scroll to see all of the items in a list. Click on one of the items to select it. To add the name listed in the Original Field as a new user added field, select New User Added Field.
Formula Attributes
This section lists all of the formula attributes available in the program. Search for an item in the search box or scroll to see all of the items in a list. Click on one of the items to select it. Available formula attributes are listed below.