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
Re: ***Error: Number of tokens exceed the number of columns***
You may also want to try converting the file using the dos2unix command from within Linux. .: Mike T :. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Simon Ellis Sent: Sunday, December 02, 2012 7: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
Re: ***Error: Number of tokens exceed the number of columns***
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
Re: ***Error: Number of tokens exceed the number of columns***
Does the converted file still import every other record? And I'm not entirely sure I understand what you mean by 'every separated element'...can you provide examples of pre conversion and post conversion? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Simon Ellis Sent: Monday, December 03, 2012 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: ***Error: Number of tokens exceed the number of columns*** 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ***Error: Number of tokens exceed the number of columns***
You may want to check for extra characters and magic spaces (EC and MS). If somebody selected two cells in Excel to fill down and if one of those cells had EC/MS then it would have filled down every other cell differently. Jason On Mon, Dec 3, 2012 at 11:06 AM, Simon Ellis simon.el...@telecom.co.nzwrote: 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ***Error: Number of tokens exceed the number of columns***
I want to say you have one too many in each line -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Simon Ellis Sent: Monday, December 03, 2012 1:30 PM To: arslist@ARSLIST.ORG Subject: Re: ***Error: Number of tokens exceed the number of columns*** Yep the converted file imports every other record. From the source csv if I then copy out every record skipped and place into another csv, do another dos2unix conversion, again every other record is skipped. If I move the order of the records around, every other record is skipped... is very puzzling... -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 8:09 a.m. To: arslist@ARSLIST.ORG Subject: Re: ***Error: Number of tokens exceed the number of columns*** Does the converted file still import every other record? And I'm not entirely sure I understand what you mean by 'every separated element'...can you provide examples of pre conversion and post conversion? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Simon Ellis Sent: Monday, December 03, 2012 12:06 PM To: arslist@ARSLIST.ORG Subject: Re: ***Error: Number of tokens exceed the number of columns*** 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 ___ 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
***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
