EasyPopulate 4.0 Support Thread

[BlessIsaacola]

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!

[GAM]

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

[BlessIsaacola]

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

I am not sure I explained myself well (even with the first part). The file that's generated from Easy Populate excludes the leading zeros in the csv file. In other words, the leading zeros are gone before I even open the file in Open Office. I know I can add the leading zero's back but that defeats the purpose because it will require me to go through 1,000s of record and add the leading zeros back. Some upc have 1 leading zero, others two leading zero and some three leading zeros. It's not even as simple as just formatting the cell to add leading zeros (because they are different). What I am asking is if it's possible to protect the source data when exporting from our site so Easy Populate does not remove the leading zero upon export?

Thanks!