Ingredient Database Dialog
This is where you manage the ingredients database.
The database is actually two databases. One is the standard online database that comes with the program and the second is your local user database. The local database is saved on disc in your data folder. You can open your data folder from the Settings in the main dialog if you need to for example make a backup. The file is located here: C:\ProgramData\Ice Cream Calculator\user.db.
The ingredients in the standard online database are all read only. So if you need to modify anything in one of these ingredients you need to make a copy first. You can however change the Cost in standard ingredients but you have to use the Cost tool in the Tools button.
The standard online database is download from an online database every time the calculator is started. This means that if any new ingredients are added you will see them immediately, you don’t have to wait for the next version of the calculator. Also, if you don’t have internet access when you start the calculator a cashed version of the database will be loaded.
Professional use
If you use Ice Cream Calculator professionally remember that the online ingredients are not always complete with all nutrient data. The reason for this is that many of the ingredients are generic and not from a specific brand. So, to have full control and be able to create correct nutrient labels you should use your own ingredients where you have full control. The online database can be copied to your local database making all these ingredients fully editable. This can be done with the Tools button.
Filtering and searching
By default the list of ingredients are sorted by most used. So, the ingredients you use the most will be at the top of the list. You can change the sorting by pressing the table headers.
Category
This will filter the list by category. To the right of the Category you can add and remove categories and you can set what category will be the default when opening this dialog.
Find
Just start typing in the Find edit to filter the list. To the right you can press the Sort by most used button to sort the list by most used ingredients.
Sub ingredient
An ingredient can have sub-ingredients that is used for label creation. This edit lets you filter on sub-ingredients.
Allergen
Ingredients can also have allergens and this lets you filter on allergens.
Clear filter
This button will clear all the filters.
Standard
Turn on/off the online database of ingredients
Local
Turn on/off your local ingredient database
Favourites
If checked you will only see your favorite ingredients. You can tag ingredients as favorites by using the add to favourites button or right clicking on the ingredient name and select add to favourites.
Ingredient list
Lists the ingredients. You can customize the list by right clicking. You can change the size and position of the columns by dragging. Double clicking on an ingredient will either open the ingredient editor or add it to the current recipe.
Add to favourites / Remove from favourites
Select this to add or remove an ingredient from your favourites list. Use the Favourites checkbox above to only show your favourite ingredients.
Visble columns
Enables you to customize what data you like to show in the table. It opens the Visible columns dialog.
Save
Save your layout. After it is saved it will show up at the bottom of the list.
Default, Simple, Saved layouts
Select a layout, the default and simple are hard coded and if you have saved a layout it will show here as well.
Add
This button is visible when you press the Add button in the main dialog. Pressing this button will add the selected ingredients to the current recipe without closing the dialog box. This means you can easily add multiple ingredients without having to re-open this dialog box.
You can also Double+Click on an ingredient to add it to the recipe with Weight=0.
If you Control+Double+Click you will also be able to set the weight of the ingredient.
New
Creates a new ingredient to your local database.
Copy
Makes a copy of the selected ingredient and opens the ingredient editor.
Remove
Removes the selected ingredients. You can only remove user ingredients.
Edit
Edit the selected ingredient. Opens the ingredient editor.
Add to favourites
Adds the selected ingredients to the favourite list.
Compare
Compare will filter the list by only showing the selected ingredients. This is useful if you like to compare for example only two ingredients. Just select the two ingredients you like to compare and press the Compare button. Pressing the button again will show the list normally again.
Tools
Change category
Change the category for all selected ingredients.
Prints the visible rows in the table. (This command needs improving)
Excel
Exports the list to Excel.
Import
Opens the bulk import of ingredients. If you for example are migrating from another software or have a database of ingredients in Excel you can import them using this conversion tool Opens the Import Ingredients dialog
Save to file
Saves the selected ingredients to a file. This file can then be used in the Load from file. Useful if you like to send ingredients to someone else.
Load from file
Loads ingredients from the file created with Save to file. If the ingredient already exists in your database it will not be imported.
Translate
Enables you to translate your local ingredients. Local ingredients are not included in the online translation database so if you need them translated to other languages you can use this tool. This is useful if you for example make ingredient lists in different languages. Opens the Translate dialog with your local ingredients.
Cost
Here you can multi change the cost of your ingredients including the standard database. Opens the Cost dialog.
Handle ingredients
This is an advanced tool to handle sub-ingredients. More info in the Handle ingredients allergens dialog.
Handle allergens
This is an advanced tool to handle allergens. More info in the Handle ingredients allergens dialog.
Copy online database to local database
This will make a total copy of the standard online database to your local database. If you do this you can uncheck the standard checkbox to turn off the online database.