Managing Places via File Drop
This article covers how to:
1. Prepare your upload file
Your upload file should include one record (row) for each Place you wish to add to, or update in GoSpotCheck. The headers in your file must include the field (or combination of fields) you've selected to serve as your primary key for matching records across your file and GoSpotCheck. Additionally, it should include headers for any fields you intend to update.
Upload File Example
| custom_id* | name | p_banner |
| 205 | Fry's Marketplace | Kroger |
| 305 | King Sooper's | Kroger |
| 405 | Bakers |
2. Upload your file
When you're satisfied with your file, save it and drag it into the Uploads folder in your SFTP client (📁 PATH: places/upload). Files are picked up and processed approximately every 10 minutes.
Files uploaded to the Uploads folder are first matched to existing places in GoSpotCheck. This is an important step as it prevents the creation of duplicate records.
An exact match on the matching primary key is required (field(s) in the file match identically to the Place in GoSpotCheck) . Exact matches are case sensitive. Be mindful of leading zeros as spreadsheet programs often remove these by default.
The matching step also determines which Update Actions should take place.
3. Review the success and error reports
Once your uploaded file has been picked up and processed, it will be moved to a timestamped Results folder (📁 PATH: places/results/{timestamp}).
- If successful, results will be written to a file of the same name with the suffix _success.csv.
- If there are errors, an error file will be written with the suffix _error.csv.
It can take several minutes for the log files to be written. Review the error files to determine what corrections need to be made before re-uploading the upload file.