Troubleshooting Goodsync and CSV data files

Commerce

Some of our clients use Goodsync to transfer images to our servers.

Checklist before syncing images Are images orientated correctly on your computer? Do your image filenames match your data file? The data is case-sensitive, it must be exactly correct. Remove any empty columns. Check for unnecessary columns like gallery name; the gallery name is not required when there is a subject name in use. No symbols allowed such as & $ % @ *  Review full data instructions here

Common problems with importing data to Fotomerchant

• Session reference must match exactly the name of the CSV data file.
• The data file headers should all use the correct formats (they are both case sensitive and space sensitive), here are examples of appropriate headers:

  • Password, Gallery, First Name, Last Name, Subject Tags, Email, Image File, Image Tags, Country, State, Street 1, Street 2, Suburb, Postcode, Phone, P1 First Name, P1 Email, P1 Phone, P2 First Name, P2 Email, P2 Phone.

• The image file path must be exactly as shown as the folders and images themselves. If images have been synced with an incorrect naming structure then the data file will be renamed to match.
• No empty columns can be present in the data file.
• Duplicate subjects and galleries when importing an updated CSV file. When importing an updated CSV file the system matches against three sets of criteria:
  1. First name
  2. Last name
  3. Password
  If any of this data is missing or does not match exactly, then the system will create a duplicate record.
• When you add a field (i.e. email address) into a session, it is best to use the original CSV file and add an Email column to that file. Make sure the data files are exact matches for existing data when it comes to First name, Last name, and Password. The data will not duplicate within a session if the data is correct.
• When Multiple email fields are being used, they rely on hierarchical rules. Always use in consecutive order as follows.
  • Email
  • P1 Email
  • P2 Email
• When a CSV data file is loaded, the system will periodically check our storage to see if the image files are available. This allows the data file to be loaded ahead of time and for images to be automatically imported as they become available. The process of checking for image files on storage uses the following retry pattern:
  • Every 5 minutes for the first 2 hours.
  • Every 10 minutes for the next 4 hours.
  • Every 60 minutes for the next 48 hours.
  • Every 4 hours for the next 14 days (after 14 days of waiting for an image file, the system will expire the process and no longer check for files).

Basic Troubleshooting Steps

If you have an issue with an upload, your first step will be to check your folder structure and the CSV data. You will need to check the data and compare for errors. You should also confirm the images have been analyzed and synced in Goodsync; they will show a green arrow if they are synced. Red arrows imply errors have occurred.

Below is an example of folder structure and image file names on the computer:

This is an example of the data file to verify the image file path:

Here is a flagged issue that was causing the problem in this example:

The folder name is StAloysius the image file name is 14_01006_30_10363_STF_01.JPG

Combined this should be: /StAloysius/14_01006_30_10363_STF_01.JPG

As opposed to: /StAloysius19/14_01006_30_10363_STF_01.JPG

If the studio updates the image file path, the images will be located and imported.

 

How to change your Image file names to include the correct folder name 

1. Using a temporary blank column to the right of the column with your image file (we call this the Helper Column), enter this formula into the first row: ="/foldername/"&D2
   • Example: "/StAloysius19/"&D2
   • If your image files are not in column D, change the D2 to the respective column letter.
     
2. Copy this formula down to the row with the last SKU.
3. Copy the whole column with the formula.
   
4. Select the column with the Image file and click Edit > Paste Special > Values.
5. Delete the Helper Column and save the file.