cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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.

 

(1) 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.

View solution in original post

(4) Replies

@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.

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.

@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
By Level 17 Champion
Level 17 Champion

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