These notes are to be used as an outline of all the steps needed to upload a batch.

• Review the data dictionary notes. The data is in a fixed field format which means that the positon of the data in the file determines which database field it will be loaded into.

  For example, Field 1 is your numerical rating of the wine on a scale of 1 to 100. Field 2 is the Winery, Field 3 is the year of vintage for the wine, etc.

  The data dictionary notes can be downloaded here.

• Arrange your data so that your dataset is in the correct field order. Use the field order in the data dictionary notes. If you do not have that data, use a place holder in the file so that the field order is correct.

• Produce a file of your data in one of three formats:

  1. Comma delimited, e.g. data,data,data (example)

  2. Double quote comma delimited, e.g. "data","data","data", (example)

  3. Pipe delimited, e.g. "|" data|data|data| (example)

• Login to the site and upload your file. A "batch" will be created that will have messages about your file. Any records that fail to load will be logged in the batch. If a record errors, the line number in your file is noted. The field causing the error is indicated with the error. Almost always the error is going to be a datatype mis-match. For example, the first field is a rating number and you submitted character (string) data:

  1. "100" loads fine

  2. "One Hundred" fails

• If some records load and some fail you have a partial batch.

• If one or more records do not load (partial batch), you have two choices:

  1. Delete the batch, which deletes all the records, fix the errors and re-submit the whole file.

  2. Fix the records with errors and re-submit the file as a separate batch.