A .csv or comma-separated formatted file is another method that can be utilized in order to submit traceability data to FoodLogiQ Connect. We have a standard template with specific column headers that will need to be retained. Simply enter each record as a new line within the file, and save as .csv. This is a manual method for submission, but the same file format could also be utilized via FTP upload (See FTP submission method section for more details).
Instructions for Setup
Login to FoodLogiQ Connect, then click on “Events” within the left-hand navigation menu. You will then see a page like the one displayed below.
Select the type of event you would like to import. In this example we will be using shipping events. You can also select from receiving and transforming.
Select “Import Events” from the icons in the top right corner. This takes you to a page where you can download the .csv templated file to fill out before submitting. You can also submit the file from this page when ready.
Select the appropriate options from the three drop-down menus.
- Associate with Community is important since your customer may have added custom attributes that they are wanting you to include.
- Type drop down menu will display the names of the events that your customer/community owner has designated.
Click the “Download Template” hyperlink to get the .csv formatted file that you will need to use when submitting traceability information.
Open the file and complete with the necessary information. No matter how your event is submitted we require the date format mm/dd/yyyy.
Once you have completed the spreadsheet with the necessary event data, save as .csv formatted file. Filename does not matter.
Below is an example with standard required fields populated, displaying the appropriate formats for each.
When ready to submit your file, navigate back to the Shipping Events Upload page, and re-select the 2 dropdown menu options that are appropriate, then click “Select File” on the right-hand side. Locate the file on your computer where you saved it, and click “Upload”, then “Save” (both are in green).
If an error occurs upon upload you can view the details on the History page, which is accessible from the “Events” page. Once on that page, click on the “WEB” tab to view the previously submitted files and any error messages if you need to troubleshoot.