Knowledgebase
5.12.2 Index of Warnings and Error Messages for CSV Import
Posted by Johan Isoz on 08 November 2017 09:00 AM

Errors

 

Field                 

Error Condition

Description

_mandatory 

Data is empty

_mandatory fields must contain a value.

_number

Data contains characters other than numbers, periods, commas and dash

_number fields must contain only numbers.

_calculator

Data contains characters other than numbers, periods, commas and dash

_calculator fields must contain only numbers.

 

_date

Data contains text that is not in a date format

_date fields must be in the format mm/dd/yyyy

_date

Date not in correct format but another date format

_date field is not in the recommended format and may not import correctly.  We suggest you change it to the format mm/dd/yyyy.

_color

Data contains text that is not a color

_color fields must contain a valid color name.

_radio

Data has > 20 choices, suggest to make a ‘select’

_radio fields may have at most 20 choices.  We suggest you make it a _select field.

Misc

The given CSV is not saved with UTF-8 encoding.

Your file must be saved in UTF-8 encoding to work properly. Make sure you are trying to upload is in the proper CSV format and uses UTF-8 encoding

Misc

 

An error occurred parsing the csv file. <More detailed description of the error:

  • Check that the header for each column is in the correct format
  • Check that the file you are importing is a comma delimited file
  • (other) >

(Freezerbox only) Cell

Cell format invalid

Cell format must be a letter followed by a number, e.g. “A5”

(Freezerbox only) Cell

Cell is a duplicate

Cell is a duplicate in another row

 

Warnings

 

Field

Warning Condition

Description

_text

Data has only numbers

We noticed this field contains only numbers.  We suggest you make it a _number or _calculator field.

_select

Data has > 100 choices

We noticed this field has over 100 choices.  We suggest that you verify that the choices listed are correct.

 

Header name is empty

Header is blank. We recommend you specify a header name otherwise it will have the name "Column #".

(0 vote(s))
Helpful
Not helpful

Comments (0)