Import Ingredients from CSV
CSV is short for comma-separated values. It’s a file format any spreadsheet application such as LibreOffice Calc, Microsoft Excel or Google Sheets can export. You can also write CSV on your own using a simple text editor.
Poyki requires the following columns for being able to import the data. Poyki expects these columns in the specified order.
Name: Any name for the ingredient. For example “Apples”
Comment: Any comment. For example “Gala only”. Can be empty.
Amount: An amount with a unit. The amount has to be a number. The decimal point has to be a point, not a comma. The unit can be any text, but has to be a single word (no spaces) (e.g. “kg”, “pieces” or “glasses”). Example: “5.5 pcs”. Alternatively, the amount can be one of the words “empty”, “low” or “full”. The amount can also be a percentage. The number can’t have a decimal point in this case and the unit has to be “%”. Example: “50 %”
Minimum amount: A number (without unit) or “never”, “empty” or “low or empty”. Has to match the “amount type” above.
Base in inventory: The smallest fraction of an amount you can have in your inventory. If your “base in inventory” is 0.5, you can have 0 or multiples of 0.5 in your inventory. For example, in this case, 2.5 pieces is a valid amount, but 2.3 is not, because it’s not a multiple of 0.5. Another example: Your “base in inventory” is 1. Now you can only have 1, 2, 3, 4, 5 etc. pieces (or whatever unit you use) in your inventory. Another example: Your “base in inventory” is 100. Now you can only have 1, 100, 200, 300 grams (or whatever unit you use) in your inventory.
Round up for shopping list: In the shopping list, round up to the next multiple of the entered value. This is useful if you can have fractions of an item in your inventory, but you can only buy whole items. Example: “Round up for shopping list” is set to 1, but “Base in inventory” is set to 0.25. So in your inventory you could have 0.25 onions, and for your scheduled recipes you need 0.5 onions, but obviously you can only buy whole onions. Without this setting, the automatically generated shopping list would suggest to buy 0.75 onions. But as “Round up for shopping list” is set to 1, 0.75 will be rounded up to 1, which makes more sense.
Barcodes: One code has the format “code:amount:comment”. Multiple codes are separated by pipes (“|”). Example: Two barcodes are specified as follows (without the quotes): “123456789:1000:White rice|123456789:1000:Brown rice”
Labels: The expected format is the label name followed by a space and then a color code. The color can be a hex code or a color name. Supported color names are: “#red”, “#green”, “#blue”, “#purple”, “#lightgray”, “#orange”, “#lemon”, “#lightgreen”, “#brown”. Multiple lables are separated by a comma. Example: “Supermarket #purple” or “Fruit and vegetables #green,Meat #ff0000”.
Note: Import of reminders and linked packages is not possible.
Import Recipes from Text
You may write your recipes on a desktop computer, save them in a single text file (plain text, UTF-8 encoded) and then import the text in Poyki. The text file has to follow a specific format. Also, all ingredients used in your recipes must be present in Poyki before importing recipes.
Title/Name
empty line
List of ingredients
empty line
Instructions
=== (at least three "="" characters)The list of ingredients must follow the following rules:
- If the ingredient has an “unit amount type“, an amount must be specified. the unit must match the unit specified for this ingredient. The amount plus unit must be separated from the ingredient name with a colon and a space. Example: “4 pcs: Eggs”
- For ingredients with a “simple amount type” or a “percent amount type“, the amount can be omitted. If you decide to use an amount, it can be any number plus a freely choosable unit name. Examples: “3 teaspoons: Salt” or “Milk”
Note: Import of linked recipes and recipe images is not possible.
Important notes
Only import of ingredients and recipes is possible. Import of schedule / plan, shopping list and packaging is currently not supported.
Please note that the following characters are only allowed for recipe instructions, but not for any other names (recipe name, ingredient name, label names etc.): * _ | ‘ ” , < > \
In the app you can load some example data to see a working example for importing recipes. Note that you have to import the example ingredients first.
