ESHA Port — our workflow utility for exporting and importing database files for the Genesis R&D Foods and Food Processor programs — is designed to simplify data sharing across different platforms.
The user interface resembles Genesis R&D Foods and Food Processor, which makes using ESHA Port intuitive if you’re familiar with our other programs. Controls are accessed in the ribbon menus.
In Genesis R&D Foods, Recipes, Ingredients, Labels, and Advanced Labels can all be exported using ESHA Port. Recipe and Ingredient data are exported as text files, and Recipes include analysis data. Label and Advanced Label export will return the label image with both the ingredient and allergen statements as text files.
In Food Processor, you can export the Person data, recommendations, Ingredients, Recipes, and Intakes lists with the analysis as text files.
Import/Export Templates for ESHA Port
With the new FDA Nutrition Facts Label regulatory changes, manufacturers needed to make the process of getting supplier data in Genesis R&D Foods a faster and easier. To assist in this process, we introduced an Ingredient Import Template (an Excel spreadsheet). These templates can be used in a few ways.
If your supplier owns Genesis R&D but not ESHA Port, consider requesting they provide ingredient information by Exporting Recipes as an ingredient.
1. Genesis R&D User to Genesis R&D User
ESHA software users can easily transfer files amongst other ESHA software users. If both supplier and customer own Genesis R&D and ESHA Port, suppliers can batch export their data. The ESHA Port templates also provide ingredient suppliers an additional level of protection for their proprietary information, as they can export a recipe as a single ingredient rather than a list of the ingredients therein.
2. Non-Genesis R&D User to Genesis R&D User
If your supplier does not own Genesis R&D you can provide the excel template to your ingredient suppliers to fill out. Once the data is populated, users can import the data into Genesis R&D with ESHA Port.
It works like this:
- Give the Excel spreadsheet to your ingredient supplier.
- The supplier enters each ingredient into rows with corresponding nutrient data and fields and returns the template back in a format ready to be imported using the built-in ESHA Ingredient Import Template – US Standard.
- The template gets returned from your Supplier as an Excel document (.xlsx file). However, before ESHA Port will import it, it will need to be opened in Excel, and then Save As a Tab Delimited file, with the extension of .txt.
- Using ESHA Port, select Import, and then navigate to the .txt file created above.
- Click Execute to import the records into the Genesis R&D database.
To learn more about using the ESHA Port workflow utility view our archived webinar titled, Importing Supplier Data Using ESHA Port.