You can download the template here:
Importing data: Info below describes how to fill out ESHA’s Excel Genesis Import Template (attached above), and then import data into your Genesis R&D Foods Program thru ESHA Port.
- Download and use the attached Excel Document for use in importing.
Import Process:
- Fill out the ingredient information into rows with corresponding nutrient data and fields.
- Before you can import data into Genesis, you will need to save this file from Excel using Save As and selecting Tab Delimited File (TXT).
- To get the data into the Genesis R&D Foods program:
- Open ESHA Port
- Click Import
- Select ESHA Ingredient Import Template - US Standard
- It will give you an error saying you need to select a different file
- Choose your TXT File you created and saved from the Template Above
- Click Execute to Import
- When it’s finished importing, you will be able to view and edit these imported ingredients from the Open → Ingredient screen within Genesis.
You can use to template to import data into your database. The Template has all the basics you need to import your ingredients, you can add/edit the template to fit your needs (you will need to edit the epf or create your own epf when importing an edited file.)
The fields in the template:
- Ingredient Name
- Supplier Name
- Product Name
- Common Name
- User Code/SKU
- Gram Weight (g)
- Calories (kcal)
- Fat (g)
- Saturated Fat (g)
- Trans Fatty Acid (g)
- Cholesterol (mg)
- Sodium (mg)
- Carbohydrates (g)
- Total Dietary Fiber (g)
- Total Soluble Fiber (g)
- Total Insoluble Fiber (g)
- Dietary Fiber (2016) (g)
- Soluble Fiber (2016) (g)
- Insoluble Fiber (2016) (g)
- Other Fiber (2016) (g)
- Other Soluble Fiber (2016) (g)
- Other Insoluble Fiber (2016) (g)
- Total Sugars (g)
- Added Sugar (g)
- Protein (g)
- Vitamin D - IU
- Vitamin D - mcg (mcg)
- Calcium (mg)
- Iron (mg)
- Potassium (mg)
- Vitamin A - IU
- Vitamin A - RAE
- Vitamin C (mg)
- Water (g)
- Ash (g)
- Allergen Celery
- Allergen Crustaceans
- Allergen Egg
- Allergen Fish
- Allergen Gluten
- Allergen Lupin
- Allergen Milk
- Allergen Molluscs
- Allergen Mustard
- Allergen Peanut
- Allergen Sesame Seeds
- Allergen Shellfish
- Allergen Soy
- Allergen Sulphites
- Allergen Tree Nuts
- Allergen Wheat
- Notes 3
- Alternate Name (English)
- Ingredient Stmt (English)
- Unit Quantity
- Unit Measure
- Unit Gram Weight
- Volume Quantity
- Volume Measure
- Volume Gram Weight