Export Formulas

You can export a recipe's default formula to a CSV/XML file. You can modify the formulas outside of AVEVA Batch Management, and then use it during runtime to change the formula values. This allows you to use the same recipe with different formula values or material during run time. However, be aware that if you change the procedure (for example, add or delete a phase) using the customized formula, validation will fail during batch initialization.

By default, when you export a formula from the Recipe Editor, the exported file is saved in the Config_A folder. You can modify the formulas in the exported file and save the modified formula file under the RuntimeFormulas\<recipeid>\<recipeid recipeversion> folder. During runtime, only the formulas under the latest RuntimeFormulas\<recipeid>\<recipeid recipeversion> folder are accessed when you select a recipe to be updated. The RuntimeFormulas folder and a <recipe> subfolder are created when you approve a recipe for Production or Test or when you export formula from an approved recipe. The recipe subfolder name is the combination of the recipe id and recipe version number.

Note: Under the <recipeid recipeversion> subfolders, if there are duplicate files (e.g. f1.csv and f1.xml), the csv file takes precedence over the xml file.

You can export formulas in either of the following two formats:

• CSV

• XML

To open the Import/Export dialog box

1. Open the Recipe Editor.

2. On the File menu, click Import/Export.

   The Import/Export dialog box appears.