Using the Genesis R&D Supplements Ingredient Import Template, you can import your ingredient data into Genesis R&D Supplements.
Note: not all fields are required to import using this template and the template can be modified to fit your needs.
The first step is to review your excel document. 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.
To map a field
The Moisture field can either be mapped as a “New Nutrient field” (in grams), mapped to the existing “Water” field, or not mapped at all (“Ignore”).
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 choose another file to import. Click Search to return to the program Open search page.
On this page: |
COLUMN DETAILS
Mapped
Original field name
Mapped field
Active
Mapped unit
Default value
Sample data
FIELD TYPES DEFINED
Nutrients
This section lists all nutrient components (and other components) 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 listed to select it. To add the name listed in the Original Field as a new nutrient component, select New Nutrient. Numbers and zeroes will display in the fields as entered. Blank fields are seen as Null (no data).
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.
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.
Ingredient Attributes
This section lists all of the ingredient 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 ingredient attributes are listed below