Quote Originally Posted by BlessIsaacola View Post
Okay, I need help with two issues I am experiencing. One is easier to explain and the other I will explain and if you need more clarification to make sense of it please ask questions.

1. The first issue is with upc field. We have some products with upc code starting with zeros. Something like, 000768251143. When I generate an export file. The csv file that is generated drops the leading zeros in the upc column. 000768251143 becomes 768251143. Is there a way to protect this field during file generation to treat it as a text field so the numbers are not messed up? I did not have this issue with previous easy populate that uses text file instead of csv file. I will greatly appreciate any help in solving this issue as this is a show stopper.

2. The second problem is when I export a file, some of the description fields are empty even though they have content. There's nothing unique about the products that are missing descriptions so I am not sure how tell you how to duplicate this problem. However, it seems that the seem products that are dropping description fields on export remains the same (which makes me think there's something common between them even if I can see it).

I will appreciate any help to get to the bottom of these two issues.

Thanks!
Quote Originally Posted by GAM View Post
1. I'm not sure what program you're using for your source data but assuming something like Excel, try specifying 'custom' field/column formatting in your spreadsheet program e.g., "000000000000#", to force display of leading zeros.
2. Open your CSV file in something like Notepad (or something better like Notepad++ [free]) and check those descriptions closely. You might have field and/or value delimiters that are either missing or being misinterpreted. Quite likely something in those descriptions is being interpreted as a delimiter and omitting everything thereafter... or something like that.

Best of luck.

Cheers
GAM
Totally agree with 1. That's a relatively quick fix and should be available in any spreadsheet program. (Haven't tried the recommended Open Office yet)
2. Deals with export of the file and while there might be an interprelation problem from the text file to the spreadsheet program as suggested, more information is definitely needed.

So assuming that there are three products and four fields of concern, does the folloing "table" represent a possible scenario?

"Field1","Field2","Field3","Field4"
"Data11","Data12",,"Data14"
"Data21","Data22","Data23",
"Data31","Data32","Data33","Data34"

Where DataXY represents the data for item X in column (field) Y or is a complete field not shown?
As far as us duplicating the problem there's a number of ways I can think of but would involve either exporting/downloading your database (or portions of) or providing access to areas of your store. Please do not publicly state your admin directory location/path. Or could do as GAM suggested and evaluate the output of EP before it is "processed" any further. I've seen where a field would have some sort of obnoxious character and cause errors in ZC, so I wouldn't be surprised if there is some errant "special" character(s) in your fields causing the problem.