search

openthc / ccrs

Tracking for the WSLCB CCRS
https://lcb.wa.gov/ccrs
MIT License
4 stars 0 forks source link

File Upload Order #40

Closed djbusby closed 1 year ago

djbusby commented 2 years ago

The LCB has told us that file upload order is important, eg that Product must be imported before Inventory. However, if you upload multiple files at one time, Product and Inventory for example -- and the Product file was listed first in the upload -- their system doesn't process them that way. And the result is that errors occur for the Inventory file because it's processed before the Product file.

djbusby commented 2 years ago

So the work around here is only upload file of a class; don't combine them during uploads. A multiple-upload of all Area followed by another upload of all Product would be OK tho.

djbusby commented 1 year ago

Confirming this; the best process is to upload Variety, Section, Product, Inventory, Crop, B2B, B2C. And do NOT use multiple files per upload, only one file at a time. We've observed that on a multi-upload process data from the early upload in the bunch (eg: Product) is not yet availble when the, eg: Inventory upload is processing -- giving false indication of error.