ESHA Port Simplifies Exchange of Database Files

By in ,
559
ESHA Port Simplifies Exchange of Database Files

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.

User Interface

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.

This is the ribbon where users access the functions of ESHA Port.

Exporting Capabilities

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:

  1. Give the Excel spreadsheet to your ingredient supplier.
    This is a screen shot of the Excel data submission form for importing and exporting nutrition data in ESHA software.
  2. 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.
  3. 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.
  4. Using ESHA Port, select Import, and then navigate to the .txt file created above.
  5. Click Execute to import the records into the Genesis R&D database.

Nutrition information import using ESHA Port

To learn more about using the ESHA Port workflow utility view our archived webinar titled, Importing Supplier Data Using ESHA Port.

54321
(0 votes. Average 0 of 5)