Import Error

[lesliekirk]

I've never run across this error before when trying to do an import

Parse error: Input error, got quote inside non-quoted field

[Kent Multer]

The meaning seems clear. Did the error message include a line number? What kind of import were you trying to do?

[lesliekirk]

The meaning seems clear. Did the error message include a line number? What kind of import were you trying to do?

If it had a line number I would have been able to figure it out - maybe. It's a product import. But then how do I determine where the "non-quoted" field is at? It's a tab delimited CSV file.

[Kent Multer]

Without knowing more details, here are a few thoughts:

The lack of a line number seems odd. Doesn't Miva's import function include them in the log? Are you using a 3rd-party import module?

If you look around in the Products section of admin, you may be able to figure out how far the import got before the error occurred.

If the CSV file was generated from a spreadsheet, you may be able to look in the spreadsheet and find a field with a quote in it; or you may be able to regenerate the CSV, and check a box to put quotes around every text field.

A brute-force method that I occasionally use for problems like this is to create a new CSV file that contains only half of the original data, and import that. If the error goes away, you know it's in the other half. Once you figure out which half it's in, you repeat the process: divide the half into two quarters, and see which one of those gets the error. Then you divide again, and again ... eventually you'll narrow down the location of the error to the point where you can just open the file and look for it.

[lesliekirk]

Yes, I'm using Miva's Data Import. It didn't give any line item, it just gave that message. What I wound up doing was to import the file sans the Description field. It seemed like the most logical place to start. Then I did a second import with just the Product Code and Description - strangely I didn't get any error. Not sure where exactly it was but the data has been imported.