Import EDI files

STORAGE -> Import EDI

This page allows you to review and search across all files that have been imported so far and view the alert status of each file. You can click on any file to drill into its full import log to review any information, warnings or errors.

To import EDI files

  1. Click the Upload files button
  2. Either click Select file or drag and drop the files you would like to import onto the import box.
  3. Click the Upload button to send the selected files to the server.

Once uploaded the files will begin processing and you should see the status of each file change from pending -> succeeded / warnings / failed. Click on any file for more details.

Note

The type of file you are importing will be detected automatically.

Resolving import errors with Aliases

EDI files sometimes contain data that doesn't match your codes or descriptions. Sometimes you'll need to add new items in the Setup pages. Sometimes the item you want is already there, but spelled slightly differently. This is what Aliases are for.

Many of the Setup pages allow you to enter Aliases against items, this allows snapPacking to find matching items even if the spelling or codes are different from yours.

Supported EDI formats

Packed submissions (NZ Apples & Pears)

These files accompany a truck load of pallets from another packhouse into your stores. After importing one of these files, got to the STORAGE -> Packed submissions page to complete the process of checking in the submission.

More details about this file format is available on the NZ Apples and Pears website.

Market requirements (NZ Apples & Pears)

This file contains details of the requirements for fruit to be suitable for export markets. It is important to have the latest file's data so snapPacking can provide you with accurate market suitability information.

Market suitability for all pallets in your inventory is reassessed when this file is imported.

This file is published by Pipfruit NZ on their FTP site and snapPacking can be configured to download and import it regularly if desired.

More details about this file format is available on the NZ Apples & Pears website.

Orchard registrations (NZ Apples & Pears)

This file contains a list of all of the Pipfruit orchards registered for the current season. It includes the blocks, varieties, and special compliance program status for each of those orchards. The data in this file can change as frequently as hourly in response to compliance program removals actioned by MPI.

This file is published by Pipfruit NZ on their FTP site and snapPacking can be configured to download and import it regularly if desired.

More details about this file format is available on the NZ Apples & Pears website.

Product/Material master data (Apples & Pears)

This is a collection of files published by Traders in the pipfruit industry:

  • PCT (Product Code Translation) file - Contains industry-standard codes for Brands, Grades, Growing Methods, PLU Stickers, Pack types, Treatments, Sizes, and Varieties.
  • CLAS (Classification) file - Contains industry-standard codes for Customer suitability, Pallet types and Storage types.
  • MATM (Material) file - Contains the Material (Product) codes for an individual Trader.
  • UOM (Unit Of Measure) file - contains quantity, weight and volume information specific to a trader's materials. Unfortunately these values have become much less reliable is recent years. It is highly recommended you maintain your own weight information in snapPacking.
  • VENDOR (Vendors) file - This contains a list of many of the operators in the Pipfruit industry and offers some standard codes for Growers, Packers, and Coolstores - albeit not comprehensive.
Note

If you publish your own master data then you should import any updated PCT, MATM and UOM files into snapPacking whenever you add new codes.

Tip

Importing of EDI files can be scheduled in SETUP -> Tasks