Hi there, Another interesting fact is that the site entry is identical for all records, so I'm importing say 100 CI's all for the same site and every other record is skipped. I did look and see if there was any extra characters or magic spaces, but nothing. Also with the dos2unix conversion of the csv all fields are encapsulated within double quotes, but it's not every separated element. It would be strange to put it round every other record when the proceeding one works fine...
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Tuesday, 4 December 2012 3:02 a.m. To: arslist@ARSLIST.ORG Subject: Re: ***Error: Number of tokens exceed the number of columns*** Simon, CSV is an interesting format...there are actually tons of different configurations for it...but if you remove Site and it works fine, can you investigate your data and tell me if there are " around every comma separated element? Is there a , inside of the site data, is it possible that there is a hidden carriage return (enter) in the data that's causing the issue? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Simon Ellis Sent: Sunday, December 02, 2012 6:13 PM To: arslist@ARSLIST.ORG Subject: ***Error: Number of tokens exceed the number of columns*** I am trying to run an AIE CI Class Mapping Data Exchange in a Linux environment into the Monitor and ComputerSystem class (2 different loads). Every other record is skipped in the data exchange when I populate site information into my csv. With the debugging enabled and apon examiniation i see the following information returned. ***Error: Number of tokens exceed the number of columns*** The site infromation is correct as it is identical for all the CI's I am adding, but every other record is skipped. If i remove the site information from the csv, all the data goes in without issue. Has anyone experienced this sort of issue before? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
