Skip to main content
Solved

Weird error in custom import

  • December 5, 2024
  • 3 replies
  • 41 views

bskallerud
Sidekick (Customer)
Forum|alt.badge.img+11

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

View original
Did this topic help you find an answer to your question?

3 replies

Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+24
  • Ultimate Hero (Employee)
  • 1317 replies
  • Answer
  • December 5, 2024

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.


bskallerud
Sidekick (Customer)
Forum|alt.badge.img+11
  • Author
  • Sidekick (Customer)
  • 206 replies
  • December 5, 2024

Thanks Phil - I’ll pass this back to the data analyst and transformation team


Reid Gilbert
Superhero (Employee)
Forum|alt.badge.img+15
  • Superhero (Employee)
  • 342 replies
  • December 5, 2024

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)



 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings