Early Access: This article covers features currently in preview. These functionalities are being actively developed and will be included in our upcoming Q2 2025 release.
A .csv or comma-separated formatted file is another method that can be utilized to submit traceability data to FoodLogiQ. 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 option 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 Submitting a .CSV File
- Click on Events within the left-hand navigation menu.
- Click on the Import Event button in the upper-right section and select the type of event to import: Cooling, Harvesting (Agriculture), Harvesting (Aquaculture), Harvesting (Wild Caught), Landing, Packing, Shipping, Receiving, or Transforming.
- 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. Not all events will have a Type.
- 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 it with the necessary information. No matter how your event is submitted we require the date format to be "MM/DD/YYYY".
- Once you have completed the spreadsheet with the necessary event data, save it as a .csv formatted file. The filename does not matter.
- When ready to submit your file, either click on the browse link or drag the file into the Import File section.
- Click “Save”.
- To see the results of the upload, click on the "History" tab to see the history of files uploaded via this process.
- The important columns to note are the "Total" and "Imported" columns. The "Total" column displays how many events were attempted to be uploaded. The "Imported" column shows you how many were successfully submitted. To see the errors and details of what the errors are, click on the > icon on the row in question.
Note: .CSV files only need the required fields; previously, users needed to include optional fields (even if blank) in the files as well. See Event Data Submission article for more details on field options.
- The error details are shown on the right-hand side of the section. To view the file you used, click on the download icon to download the file you uploaded, so you can adjust/make changes to it. Revise the error rows and resubmit only the rows that you have corrected. If you resubmit the file with all lines, you will have duplicates.
- Previously submitted Events can be viewed within the Events page.
- The Event column shows whether it was a shipping, receiving, or transforming event.
- The Location column shows the Transformation
, Ship From
, and the Ship To
.
- You can use the search filter to narrow your results
.