Blue Alligator Support Forums

It sounds like you haven't set up any file mappings. When uploading data files you can only upload files that your cloud account is expecting.

For example, in the file mappings screen, if you set the file mapping for your product data to products.csv then the upload process will accept this file.

Once you have set up your file mappings and uploaded files against them you will need to go through each one and set up their field mappings too.

Make sure you've mapped the fields for the reps and locations via the field mappings screen.

The final step before making the data available to your iPad is to run the Process Files option (step 8 in the getting started with your data guide). This processes your data files against your current field mappings.

I've taken a quick look at the stats for your cloud account and it looks like this option hasn't been run yet (it shows the last time the files were processed as "Unknown").

On an ongoing basis, you need to run Process Files each time you upload replacement data files or alter any of your field mappings.

Almost there I think.

Looking at some of the image filenames (such as 03757) and double-checking this against your product CSV file (which shows the product code as 3757) it looks like any prefixing zero's on your product codes are being stripped off when saving within Excel.

To preserve the leading zero's you will need to format the product code column as "text". I recommend doing this for the barcode column as well.

The leading zero's are still missing from the products in the products.csv file you uploaded about 15 minutes ago. You can double-check the CSV file by opening it in a windows application such as Notepad.

There doesn't need to be any reference in the product file if your images are named the same as the product code.

To demonstrate your images working I've doctored the uploaded CSV file to put a zero in front of the entry for 3757 (assuming it's meant to be 03757). If you perform another download on the iPad you can see that the image now appears for the product (in fact, three images for that product since you have image files 03757.jpg, 03757_1.jpg and 03757_2.jpg).

While you have approx 460 products in your CSV file there are only approx 85 images currently uploaded to your cloud storage area.

You can double-check which images have been uploaded via the Manage Files option on your cloud account home screen.

The upload process should be able to handle zip files of up to around 1GB in size. However, there is more chance of timeouts or interruptions occuring during the time it takes to upload a file that size, which would cause the upload to fail.

Personally, I would look to create batches of zip files of around 100MB maximum size and upload these.

You may want to save the master copy of the spreadsheet that you work on in one of the Excel formats rather than as a CSV file.

This means that the spreadsheet will keep any column formatting that you've set (such as formatting the product code column as text).

When you want to upload a copy of the spreadsheet to your cloud account, save/export it as a CSV file and upload that, but continue working with the master copy rather than re-loading the CSV file back into Excel.