Import / Export Recipes

Recipes can be read from and written to either Microsoft Excel™ spreadsheets or Access™ databases.

Spreadsheet format:

• Each worksheet is named for a matching Recipe Book
• Column A holds each Recipe (RecipeName) in the Recipe Book
• If there are versions, then Column B (RecipeVersion) will hold those names.
  Versioning available only if the Recipe Book tag is so configured.
• Other columns are named for each ingredient within the recipe. All ingredients for all recipes in the book are included in the spreadsheet. Recipes that do not include certain ingredients have blank cells for those columns.
• Ingredient addresses are not imported or exported.
  These must be entered manually in the Ingredient tags, along with any other configuration such as Data Type, Engineering Units and permitted value range.
• Up to 16,384 recipes can be exported.

 

For example, a recipe book of pump lead and lag times might be similar to the following when viewed as an Excel worksheet:

RecipeName	RecipeVersion	LeadTime	LagTime	Delay1	Delay2
Pump 1 Lead	Fast Cycle	10	2	1
Pump 1 Lead	Slow Cycle	25	8	10	5
Pump 2 Lead		2	10		2

Versioning enabled in the Recipe Book

Database format

Similar to the Spreadsheet format, noting:

• Each table holds a set of recipes, with one recipe per row, where each column is an ingredient value.
• The primary key must be the column that contains the recipe name.
• The secondary key (optional) must contain the recipe version.
• The renaming columns are treated as ingredient names. An ingredient tag will be created for each of the ingredient columns.