column mismatch error

Greetings fellow Thwackers!

Hoping someone can advise me o this while I wait for support to replicate the error in a test environment. 

I receive the below error when attempting to import assets into WHD. The error does not happen with every line on the asset import template 

**Line 2: Value provided for field Warranty Type exceeds maximum width of 60 characters. (Value provided = Inogeni SDI to USB Capture Card - P Card Purchase Scott Huxley already approved - $738 EACH NORTH TOWER<br>**

Now there isn't anything in the Warranty Type column so WHD is trying to put the text from the Notes column in there.. 

Weirder still if I delete the contents of the notes field WHD then tries to put the content of the Cost column in the Audit date column... 

Line 2: Error while parsing Audit Date: Unable to parse date from '476.00'.<br> {'2948', 'Peripheral', 'n/a', 'n/a', '', 'Received', 'SD1947083 SD1947291', '', 'Capture Card', '', 'Grafton Base Hospital', '', '3/2/20', '2948', 'Unknown', '$1', '476.00', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '776527', '776527', ''}<br> <br>

I can delete  Line 2 and import other lines OK. This would be a "solution" except there is 100s ....

Cheers 

Parents
  • I have not done asset importing but we are looking to do that possibly.  Does the process allow for importing a text delimited file, maybe that would work better then csv file?  

  • Hey man I was using  Excel files as this is easier to use to clean up the data coming from ITSM. That said I had the vendor do some testing with a copy of our database and import data and they found the fault does not occur with CSV format. Let me know how you go I just completed 20,400 asset imports :)  

Reply
  • Hey man I was using  Excel files as this is easier to use to clean up the data coming from ITSM. That said I had the vendor do some testing with a copy of our database and import data and they found the fault does not occur with CSV format. Let me know how you go I just completed 20,400 asset imports :)  

Children