After some searching I found this similar thread : http://extranet.mivamerchant.com/for...tions+changing
Now, my issue is the exact same thing. When some (and only some, which makes the problem difficult to track down) products are imported, the descriptions are being cut off at a quotation mark. Usually (possibly always) it is the beginning that is cut off, and then a quotation mark following where it was cut off and the rest of the description is uploaded. I've been digging into this issue and examining the .csv files produced by excel in a simple text editor, but I can't notice any issues with the encoding. I could very easily have missed them though.
Then it came to me that perhaps someone else uploading files is using a different .csv format, say .csv for MS-DOS or .csv for Mac. Could this possibly be causing issues due to the Miva import function expecting a specific encoding and receiving a different one?
Any other ideas on what the issue could be? This is really starting to cause a problem as every day we find a few more descriptions that have been corrupted or changed. As an additional note for debugging purposes, I've noticed that quotation marks in the description are often getting doubled when the "bug" occurs. And I don't mean they are being doubled in the .csv text file; I understand that they are just being escaped when "" appears in the .csv text file. I mean that they are being doubled in the actual text uploaded to the product database. This indicates to me an escaping issue somewhere, but I can't seem to figure out why it would be happening.
Also, if you see post seven in the other thread (http://extranet.mivamerchant.com/for...904#post385904), jsdva notes that descriptions were spilling over into multiple columns. The fields directly next to the descriptions are fine though, so this doesn't seem likely to me.
Now, my issue is the exact same thing. When some (and only some, which makes the problem difficult to track down) products are imported, the descriptions are being cut off at a quotation mark. Usually (possibly always) it is the beginning that is cut off, and then a quotation mark following where it was cut off and the rest of the description is uploaded. I've been digging into this issue and examining the .csv files produced by excel in a simple text editor, but I can't notice any issues with the encoding. I could very easily have missed them though.
Then it came to me that perhaps someone else uploading files is using a different .csv format, say .csv for MS-DOS or .csv for Mac. Could this possibly be causing issues due to the Miva import function expecting a specific encoding and receiving a different one?
Any other ideas on what the issue could be? This is really starting to cause a problem as every day we find a few more descriptions that have been corrupted or changed. As an additional note for debugging purposes, I've noticed that quotation marks in the description are often getting doubled when the "bug" occurs. And I don't mean they are being doubled in the .csv text file; I understand that they are just being escaped when "" appears in the .csv text file. I mean that they are being doubled in the actual text uploaded to the product database. This indicates to me an escaping issue somewhere, but I can't seem to figure out why it would be happening.
Also, if you see post seven in the other thread (http://extranet.mivamerchant.com/for...904#post385904), jsdva notes that descriptions were spilling over into multiple columns. The fields directly next to the descriptions are fine though, so this doesn't seem likely to me.
Comment