Easy Populate 1.2.5.4 support

Quote:

---

Originally Posted by stlnyc

I've certainly messed with the format cells option in excel. But that is usually for new spreadsheets. When I open an EP file, it opens to excels default settings with the cells not formatted the way I want, and the beginning zero removed from the barcode.

---

Yes, you are correct. The only way to get this done is to do a Data/Import into a new spreadsheet.

I am getting followin error, when I go in to edit byte size I do not find anything on that line that would enable me to do that:

Creat Froogle:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /home6/hillsie0/public_html/includes/classes/db/mysql/query_factory.php on line 189

Creat cvs file:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 24 bytes) in /home6/hillsie0/public_html/includes/classes/db/mysql/query_factory.php on line 393

Any ideas on how to fix this problem?


Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2
MySQL 5

Quote:

---

Originally Posted by WilpackPackaging

I just tried that and still nothing. No additional products were added.

I tried doing the reset then re-uploading the file and then doing the reset again. Still not working.

---

Okay... what is your default language? If it is not "1" for english, this also seems to cause problems. Are you running a multi-lingual store? If so, I think english still needs to be the default for ep to work correctly. I have not tested this, but this does come up from time to time.

Also. Jump into phpMyAdmin and check the databases manually to see if in fact NO data was imported.

stlnyc If you use OO and start with a fresh sheet (No data) and

> Insert
>Insert from Sheet

Choose the .txt file, then a new window opens with Fields,
Column Types - you can select the model column to open as a Column Type => Text
This should not change the format of your barcode number whether EAN, 2of5, or any other barcode format.

WilpackPackaging
Whats the :censored: about,
I am trying to be helpful it may save some one a lot of time, it was the original author (porter) of EP 1.2.5.4 who started this thread. The thing is that these new EP version work slightly different,
Version 1.2.5.4 is tried and tested (with a few know bugs) but it just works, these others seem to have bugs...
Sorry if I seem to have offended you ?

Ok, I still cannot get a EP file to open. In Excel, during the import all of the cells are jumbled but the barcode shows with the leading zero (as I want it to), and in OO the preview looks great but in the actual view the leading zero is gone but the other cells are all lined up.

stlnyc Any chance of a test file example ?

A test file can be found below. Each of the Item numbers listed are the items barcode and each one should start with a "0"

Without the zero, EP uploads the items as a new product, therefor duplicating the items currently in the database.

http://www.hillsideliquors.com/Full-EP2009.csv

Hi, is it possible to use absolute urls to images with easy populate? Thanks.

stlnyc By the looks of your test file its not OO or Excel which is your problem it is EP 1.2.5.5 csv as it looks as if it is stripping the '0' from the model field when it downloads the file from Zencart, if you open the file in just a text editor there are no leading '0', so it is not in the file to start with?

(Just a thought is the test file edited in OO or excel before saving or in a text editor, as if in OO or excel you will loose the '0' unless you open in the way i suggested earlier, if in a text editor (wordpad, gedit) it should remain original ?)

That test file was download through EP admin in ZC admin. I did edit the file a little, which maybe why it lost the zero. Here is my full file direct from my EP Temp Directory. And opening it in notepad shows the leading zeros.

http://www.hillsideliquors.com/tempE...Jun13-1705.csv