More import quandries - Parse error

[lesliekirk]

The file includes quote symbol used to indicate inches, but uses the pipe character as my "choice of delimiter"

text file with your delimiter of choice

I get this error when importing the file

Import of miva.txt failed: MER-IMP-UTL-00005: Parse error: Input error, got quote inside non-quoted field

Now when I used to import the "old-fashioned" way - quotes were not an issue when importing (just when trying to create the file). So what am I doing wrong this time?

Leslie

[lesliekirk]

Re: More import quandries - Parse error

I also get a "Parse error: " popup when I tried to manually assign the fields.

[Bruce - PhosphorMedia]

Re: More import quandries - Parse error

With the non-legacy imports....the data fields are enclosed by quotes. If you open in Excel, the save to Excel as CSV...I believe you shouldn't have a problem, but I don't think you can use the new import files after opening them up as text.

[ocpxc02]

Re: More import quandries - Parse error

We went through the same thing recently and had to modify the function that builds our flatfile for import. If using something other than Excel to build your file and can't specify which csv standard to use, you can surround all text fields with quotes and replace all quotes within the field with two quotes (" becomes "").


Paul

[lesliekirk]

Re: More import quandries - Parse error

Yup - the problem comes in when the file is opened up in Excel. I've been using Open Office to open CSV files and the problem went away. But when a store owner sends me a file in the format that they have used for years, I have to open it up and convert it.

Leslie

[lesliekirk]

Re: More import quandries - Parse error

Another question - store owner wants to use a double quote for inches, so she saved the file csv file as:

field delimiter: tab
text delimited: '

Am I correct in assuming that even though she used the single quote as the text delimit - the error means it doesn't like the double quote mark?

Guess I should take a peek at her file...

[Bruce - PhosphorMedia]

Re: More import quandries - Parse error

Yes, that is correct. Its MUCH better, to use &quote; for (") inches anyway-- and if she has any foraign customers, she should use "inch" or "in."