Normal Topic Import Error (Read 610 times)
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Import Error
Sep 15th, 2008 at 6:17pm
Print Post Print Post  
I am having trouble importing a single record.  The administrative log error is a follows:
"A line break appears in a delimited field. Continuing to the next line to complete the record. "

Is there some punctuation in a field causing this?  What would I look for?

Thank you.
  
Back to top
 
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: Import Error
Reply #1 - Sep 15th, 2008 at 7:36pm
Print Post Print Post  
You will want to look for either ^J or ^M in your text document. You may also want to look for line breaks in the data.
  
Back to top
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Import Error
Reply #2 - Sep 15th, 2008 at 8:11pm
Print Post Print Post  
Neither ^J or ^M that I can see.   I am sending the log and the text file in to support to see if you can help me.
Thanks.
  
Back to top
 
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Import Error
Reply #3 - Sep 15th, 2008 at 9:51pm
Print Post Print Post  
Ben looked at the file I sent them and this is what he found:

"You had a "\" after one of your fields. This canceled out a end quote and as you can imagine caused a domino effect of problems for you."

Thank you Ben  Smiley 

As always, terrific support.  What a team.
  
Back to top
 
IP Logged