+11I have created an import template to populate the Notes field on Installed items. It works for most of the items (I import about 5000), but fails on about 20% - with the error being that the serial is not unique. But I have checked in items-table, and it is unique. Here is the error (for one line):
Best answer by Phil Seifert
Hi Bjørn,
Please check the import load file for strange things like date formats, strange characters, etc. Reason, the import is working for many item serial numbers but not some of them so suspect there is a problem with the load file.
Often when copy/paste is done from another document, an additional space is added to the end of the string so look out for these too as that string is used for the search key. Look closely at the strings in the load file for these as they are not readily visible.
+24Hi Bjørn,
Please check the import load file for strange things like date formats, strange characters, etc. Reason, the import is working for many item serial numbers but not some of them so suspect there is a problem with the load file.
Often when copy/paste is done from another document, an additional space is added to the end of the string so look out for these too as that string is used for the search key. Look closely at the strings in the load file for these as they are not readily visible.
+11Thanks Phil - I’ll pass this back to the data analyst and transformation team
+15
It’s probably this blank space here as Phil mentioned (it probably can’t find a product ID to match so the import logic will treat it as a ‘create new’ instead of an ‘update existing’ and create a new installed item with that product ID and the same serial number which is then throwing the error)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.