Import failed

[ssanchezp]

Hello

When I import purchase orders through the Flexera import tool I get the following error:

"Import failed. Error: An error occurred when trying to execute the query [select *, FORMAT([Date], 'yyyy/MM/dd') AS Date_Format of [Purchase Orders$]]. The error message is ['Purchase Orders$' is not a valid name. Make sure it does not include invalid characters or punctuation and is not too long]".

Does anyone know why?
From what I can read in the problem, it is a problem in the import of the information and not in the quality of the information in the excel.

[kclausen]

@ssanchezp - My guess is that your Excel spreadsheet does not exactly match the PO Template.

Make sure that you download and use the Purchase Order Template from the User Interface.  Don't change any of the Column Names or the name of the Worksheet.

[KendraF]

I am getting this very same error.  I have recreated the Excel file three separate times and am still getting the same error as above.  Attaching file for you to look at.

[kclausen · Accepted solution]

@KendraF - Column F (Qty Per Unit) must be a numeric field, and you have a value of 'EACH'.  Just leave that column blank, and a default value of 1 will be used.  Or, you can change your spreadsheet and put a value of 1 in this column for each row.

[mfranz]

Hi,

Please also be aware that the pseudo SQL, when importing directly from an Excel file, is very limited. Consider staging the data first, then transforming date values from the staged data.

Best regards,

Markward