ID #1027

INVALID DATE OF YYYY-MM-DD FOUND INVALID DATE IN ORDER BY DATE COLUMN

When using the Import Mapping Utility in collections MAX Administrator you might see this error when trying to map a file.  It is caused by apostrophes in the data. The software will give you a row# or a line# to tell you which row in your Excel spreadsheet you need to check and remove any apostrophes.

 

So for an example say the software gives an error on row#23

Open your excel file and look at row#23 (the numbers on the left side)

 

In one of the columns (like this example the Employer column) in row#23 you might see in a piece of data like

 

 

Employer
McDonald's

 

 

Remove the apostrophe in McDonald's so it is like

 

Employer
McDonalds

 

 

After you remove all the apostrophes in Excel simply save it, convert to csv and remap.

Tags: -

Related entries:

You cannot comment on this entry