Occasional contributor

Import failed


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.


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

Trusted advisor


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,


Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos