Diet Cruncher 2

Diet Analysis Nutrition Software for Windows and Macintosh for use with the USDA (United States Food Composition Database), and New Zealand FOODfiles Food Composition Database.

For use by Nutritionists, Dietitians, Researchers, Educators, Students, Fitness Centres, Gyms, & Individuals.

Developed by Way Down South Software


Setup

Setting up Diet Cruncher 2 with the USDA Nutrient Database

Obtain the USDA Nutrient Database by following these links

(Diet Cruncher 2 has been confirmed to work with USDA SR28 as of 3 October 2019)

  • Follow this link to the USDA Nutrient Data Laboratory: https://www.nal.usda.gov/fnic/usda-nutrient-data-laboratory
  • Click on the link to 'Access data for the USDA National Nutrient Database for Standard Reference'.
  • Under the heading 'Download Databases'... Click on the link to download the 'Full Version' labelled SRxxASC.Zip (where xx is the latest version) this will download the file to your computer.
  • Locate the downloaded file and unzip the file (Right-click and choose 'Extract All...'). You will need to use the following files when setting up Diet Cruncher:
    • FD_GROUP.txt
    • FOOD_DES.txt
    • NUT_DATA.txt
    • NUTR_DEF.txt
    • WEIGHT.txt

Importing the database using 'Diet Cruncher 2 Setup'

  • Open 'Diet Cruncher 2 Setup'
  • Click 'Continue' to dismiss the information screen.
  • There are 6 steps to set up Diet Cruncher
    1. In the 'Common Setup' section, click 'Create Empty Database' - this will create an empty database ready to receive the food composition data.
      Now click on the 'USDA' section.
    2. Click on 'Import FOOD_DES.TXT'. You will then be asked to locate the 'FOOD_DES.txt' file, which is located in the srXXasc folder you downloaded earlier. This will read in the food names from the USDA database, and incorporate them into the food composition data file.
    3. Click on 'Import WEIGHT.TXT'. You will now need to locate the 'WEIGHT.txt' file - this will read in the food measures from the USDA database, and incorporate then into the food composition database file.
    4. Click on 'Import NUT_DATA.TXT'. Locate the 'NUT_DATA.txt' file - this will read in the food composition data from the USDA database, and incorporate them into the food composition data file.
      This operation will take some time, depending on the speed of your computer. It may appear that no progress is being made and your computer may report that 'Diet Cruncher 2 Setup' is not responding - be patient and let it run. If you have doubts that anything is actually happening, you can look in the directory that the database is being built.
      Windows Users: To do this, open your users folder and look for a folder called 'AppData'. If you cannot see it, use the following procedure to make it visible: Click on the 'View' menu and open 'Options', click the 'View' tab and select 'Show hidden files, folders, and drives'. Within the 'AppData' folder, open 'Roaming, and then open 'DietCruncher2' - you will see the FoodComp.sqlite file getting larger, and a few temporary files appearing and disappearing... this indicates something is happening!
      Mac Users: Use the 'Go' menu to view your 'Library' folder - if you can't see 'Library' in the 'Go' menu, hold down the 'Option' key. Within the 'Library' folder, look in the 'Application Support' folder for the 'DietCruncher2' folder - in there, you will see the FoodComp.sqlite file getting larger, and a few temporary files appearing and disappearing... this indicates something is happening!
    5. Click on 'Import NUTR_DEF.TXT'. Locate the 'NUTR_DEF.txt' file - this will read in the nutrient names and units from the USDA database, and incorporate them into the food composition database file.
    6. Click on 'Import FD_GROUP.TXT'. Locate the 'FD_GROUP.txt' file - this will read in the foodgroup names from the USDA database, and incorporate them into the food composition database file.
  • Once you have followed all these steps, go to the 'File' menu, and select 'Quit Diet Cruncher 2 Setup'.

Once you have 'Diet Cruncher 2' installed and the food composition data imported, refer to the documentation for how to use Diet Cruncher.


Setting up Diet Cruncher 2 with the New Zealand FOODfiles Nutrient Database

Obtain the New Zealand FOODfiles Nutrient Database by following these links

(Diet Cruncher 2 has been confirmed to work with FOODfiles 2018 Version 01 as of 3 October 2019)

  • Follow this link to the New Zealand Food Composition Data website: http://www.foodcomposition.co.nz/foodfiles
  • Click on the link to 'Links to Download and Archive'
  • Click on the link to the download the MSI installer for New Zealand FOODfiles.
  • If you are using Windows, follow the instructions further down the FOODfiles website to install the Foodfiles data files on your computer.
  • If you are using Macintosh, unfortunately the FOODfiles data files are distributed in a Windows installer, which does not function on a Macintosh - your best course of action is to find a friend or colleague with a Windows computer, and ask them to install the data files on their computer - and then copy these data files on to your Macintosh.

Importing the database using 'Diet Cruncher 2 Setup'

  • Open 'Diet Cruncher 2 Setup'
  • Click 'Continue' to dismiss the information screen.
  • There are 6 steps to set up Diet Cruncher
    1. In the 'Common Setup' section, click 'Create Empty Database' - this will create an empty database ready to receive the food composition data.
      Now click on the 'NZ FOODfiles' section.
    2. Click on 'Import NAME.FT'. You will then be asked to locate the 'NAMES.FT' file, which is located in the **** folder you downloaded earlier. This will read in the food names from the NZFf database, and incorporate them into the food composition data file.
    3. Click on 'Import CSM.FT'. You will now need to locate the 'CSM.FT' file - this will read in the common standard measures from the NZFf database, and incorporate then into the food composition database file.
    4. Click on 'Import DATA.FT'. Locate the 'DATA.FT' file - this will read in the food composition data from the NZFf database, and incorporate them into the food composition data file
    5. Click on 'Import CODE.FT'. Locate the 'CODE.FT' file - this will read in the nutrient names and units from the NZFf database, and incorporate them into the food composition database file.li>
    6. To complete this step you will need to click on the 'Download CAT.FT' button. This will open your web browser and download 'CAT.FT.zip'. Double click on the 'CAT.FT.zip' file to 'unzip' it - you will then have the 'CAT.FT' file. Click on 'Import CAT.FT'. You will then be asked to locate the 'CAT.FT' - this will read in the food categories, and incorporate them in the food composition database file.
  • Once you have followed all these steps, go to the 'File' menu, and select 'Quit Diet Cruncher 2 Setup'.

Once you have 'Diet Cruncher 2' installed and the food composition data imported, refer to the documentation for how to use Diet Cruncher.