Importing Data into Titan

What product is this article for? 

GDSN Connect

This article details how to t. Within this article, you will discover a detailed set of guidelines elucidating the process of importing data in Titan from GDSN Connect.

Transferring Item Data from GDSN Connect to Titan

To transfer the updated data back into Titan, there are two separate import steps using two different Titan Template files. GDSN Connect automatically produces these files to import into Titan.

Template Files

1. 1. Item Inventory: This will create a new item and set it up as an Inventoried and Purchased item, as well as create the Base Unit of Measure and Preferred Unit of Measure.
   2. Item w/ Ingredient: This file contains the basic item information, including allergens and nutrients (and base weight value), for all items within the database. The import process in Titan will match and update any item using the “Identifier” value (which is called “District Item ID” in GDSN Connect). For any Identifier that does not exist in Titan, then a new record will be created.
      NOTE: If there were no new item records created, then this file is all that’s required. However, if any new items records, these new records will only have limited information in Titan and will need to have the user manually configure them to be useful. The Ingredients Unit of Measure file should be imported next to setup the basic Units of Measure.
   3. Ingredients Unit of Measure: This file contains up to two Units of Measure for the items. It should be uploaded anytime there are new item records added into Titan to automatically configure the basic Units of Measure, including their descriptions and weights. The user will still need to configure these new Units of Measure and assign them as Ingredient, Inventoried, Purchased, etc.
   4. Unit of Measure Weights: You will use this report to add the missing Weights for the Preferred and Base Units of Measure created in Step 2. You may also want to add or update other Serving Units of Measure as desired.
      

      Select “Titan” as the Export File Format.

      1) Export Item Inventory from GDSN Connect

      1. Import Item Inventory into Titan
      2. Export Item w/ Ingredients from GDSN Connect
      3. Import Item w/ Ingredients into Titan
      4. Export Ingredients Unit of Measure from GDSN Connect
      5. Import Ingredients Unit of Measure [JJ1] into Titan
      6. Export Unit of Measure Weight from GDSN Connect
      7. Import Unit of Measure into Titan

For more information setting up new records from items from GDSN Connect go here.

Item w/Ingredients

To import your data back from GDSN Connect:
1. Go to the Utilities tab and click on Data Import.
2. Choose "Item w/Ingredients" as the Import Template from the options provided.
3. Select the file labeled "Item with Ingredients" that you previously exported from GDSN Connect.
4. Finally, click on "Start Import" to initiate the import process.

Titan will show you the mapped columns to verify that the data will correctly go into the appropriate fields. Verify that the column names are identical between the Source File Column and the Target Template Column. If not, please contact inTEAM for help.

Select Start Import

Once the import is completed, you’ll receive a notification.

Ingredients Unit of Measure

1. Go to the Utilities tab and click on Data Import.
2. Choose "Item w/Ingredients" as the Import Template from the options provided.
3. Select the file labeled " Ingredients Unit of Measure" that you previously exported from GDSN Connect.
4. Finally, click on "Start Import" to initiate the import process .
Note: To fully configure the units of measure, you'll need to run the Ingredients Unit of Measure import using the corresponding template. Note that the import process will not update existing units of measure in Titan

Managing New Items

For each “New Item” that was added users will need to locate the items and do the following:
On the item management tab select Item Rights and Measures, select the Gear item and configure the type

After selecting an inventoried item, choose the purchase unit and click on the "Save" button. Once you've saved, the screen will return to the General Info tab. From there, navigate to Item Rights and Measurements. Select "Case" and check the "Purchased" checkbox, then save the changes.