CSV file structure of recipes

The CSV files used to import recipes must be correctly formed and contain the correct fields.
The following table shows the basic structure for a CSV file.
Row
Description
Header row
Required.
Contains the name of the recipe description field.
The value must be
Description
.
Header row
Required.
Contains the description for the recipe.
Use a blank line if the value is empty.
Header row
Required.
Contains the names of each ingredient field.
The value must be
Ingredient Name,Type,Unit,Min,Max,Tag Set,Recipe Value
.
Ingredients data rows
Required.
Each row contains recipe values of each ingredient. The values must be separated by commas and must match the type of the ingredient fields.
Note:
 Avoid blank lines in the ingredients data rows. All ingredients after the blank line will not be imported.
The following table shows the ingredient fields.
Field
Description
Ingredient Name
Required.
Specify a unique name for the ingredient. Examples might be
Sugar
,
Nitric acid,
Secret sauce
,
55mm carriage bolts
 and so on.
Type
Required.
The value must be
Number
or
String
.
  • If the type is
    Number
    , the value of the
    Recipe Value
     field, if present, must be a valid integer or floating point number.
  • If the type is
    String
    , the value of the
    Recipe Value
     field, if present, can be any string.
Unit
Optional.
Specify the unit for the ingredient.
Min
Optional.
Specify the minimum recipe value. This is only available for the
Number
 type.
Max
Optional.
Specify the maximum recipe value. The maximum value must be greater than the minimum value. This is only available for the
Number
 type.
Tag Set
Required.
Specify the tag name associated with the data value for the ingredient.
Recipe Value
Required if the type is
Number
.
Specify the data value of the tag associated with the ingredient. If the
Min
 and
Max
 values are specified, the recipe value must be within the range of the
Min
 and
Max
 values, otherwise the ingredient values of the recipe file cannot be downloaded.
Example:
The following example shows the data of a recipe file,
Chocolate.csv
.
Description
Example of Chocolate recipe
Ingredient Name,Type,Tag Set,Recipe Value
Flour,Number,Cookie\material 1,0
Butter,Number,Cookie\material2,1885.9
Salut,Number,Cookie\material3,45.9
Baking_Soda,Number,Cookie\material4 ,91.8
Sugar,Number,Cookie\material5,642.9
Sugar_Brown,Number,Cookie\material6,1102.1
Egg_Powder,Number,Cookie\material7,183.7
Water,Number,Cookie\material8,113.3
Vanilla,Number,Cookie\material9,115.5
Chocolate,Number,Cookie\material10,0
Ginger,Number,Cookie\material 11,0
OAT_Flour,Number,Cookie\material12,0
Secret,String,Cookie\recipe,OAT Meal
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal