Easy Populate 1.2.5.4 support

elkbow:

lizar5-
How big's the file. Look under your "Server Version" and see if it says 127.0.0.1

That should be "Database Host" localhost -------

Server Date: 06/24/2008 00:34:44 Database Date: 06/24/2008 00:34:44
PHP Version: 4.4.8 (Zend: 1.3.0) PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 3,473 kB Database Index Size: 1,978 kB

if it has something to do with the database data size... i think my host has a limit of like 2 mb or something.... is there anyway to get around this if thats the case without contacting my host.... like uploading / copy pasting somewhere in phpmyadmin?

but theres a prob with this idea because the file is only 600kb as .txt file... unless its represented by "database data size" in which case im trying to upload 3 mb with 2 mb cap????

Can anyone please help me.

I have been looking around for help with the following error I received when trying to import a test.txt file.

Warning: fopen(/var/www/html/uploads/test.txt): failed to open stream: No such file or directory in /var/www/html/catalog/admin/includes/easypopulate/classes/eclipse/FileIterator.php on line 146

Warning File Import Failed! Primary index column p_products_id or c_categories_index_path missing from uploads file. Please consult the readme.html file for more information

The file was exported from Easy Populate and then I added 1 line and then uploaded the file and tried to import the file. The above error occurred. I tried to change the permissions on the files uploaded to see if that was a problem and the same error occurred. When I changed the permission on the file to "777" and tried, the same error occurred and the file then disappeared off the server.

Please can you assist with this problem.

Cheers

My Debug data shows the following

Product debris corresponding to the following product_id(s) cannot be deleted by EasyPopulate:
370:c0fcb6e4e2bc502d949be6d0f3b491a3
336:c8afefd20d349d32604dfdbf9c6817bd
290:1f79049c49bac2cf89601014c9ba4e86
334:11940a676c6ab31a3f81a0c28fa3731c
336:862e735e4bdddd3c5d7b684431b05d1c
400:85e02b1712ba498420c37c6687ca4318
344:0d1243b0038cbfd5f1c57ed6833f0b15
290:36ceadceb1048b9d30ab52b0ea56dcce
957:563816b8e55d0b53fcf89bf350c5b28d
326:3ae665e8592c677106965ae369fb4275
957:8e0008095ca1cc337f72705ccc1347e9
366:f2264ff4000970f5e2847680a934b6e0
316:a96e564be49545178c4435b1bb070b92
326:c247991421fa2ee5a9c74745c337e9e5
96:7f9f51ceea4104e758afb1070d6d2bb1
246:993508d90ae187c45031655c1bf7553b
914:ea5cd0dc80b8bf5359a550a407ff8f43
It is recommended that you delete this corrupted data using phpMyAdmin.

Is there a quick way (sql statement) to remove them???

I've just installed easypopulate. Everything went smoothly - it was in my admin-tools, when I clicked on install this is the error message I get:

Warning: fopen(/home/momandba/public_html/servlet/temp/Full-EP2008Jun24-2210.txt) [function.fopen]: failed to open stream: Permission denied in /home/momandba/public_html/servlet/admin/easypopulate.php****1089

Warning: fwrite(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php****1090

Warning: fclose(): supplied argument is not a valid stream resource in **/home/momandba/public_html/servlet/admin/easypopulate.php****1091

** on line on line on line Easy Populate support & development by langer. Donations are always appreciated to support continuing development: [email protected] Installation Successfull! A full download of your store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products. File Full-EP2008Jun24-2210.txt successfully exported! The file is ready for download in your /temp/ directory.
The file isn't in the temp folder as there are errors. I've looked through those lines 1089 - 1091 and I don't see any glaring errors.

I eager to begin using this mod. I would appreciate any help you can offer.

Erin
https://www.momandbabyboutique.ca/servlet

lizar5-:

Server Date: 06/24/2008 00:34:44 Database Date: 06/24/2008 00:34:44
PHP Version: 4.4.8 (Zend: 1.3.0) PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 3,473 kB Database Index Size: 1,978 kB

if it has something to do with the database data size... i think my host has a limit of like 2 mb or something.... is there anyway to get around this if thats the case without contacting my host.... like uploading / copy pasting somewhere in phpmyadmin?

It appears that the MySql does not reside on your store hosting server, rather than on an external server is why is says only 2mb Max Size. Local host would usually be 4mb. Did you try splitting the upload EP?

All else, go to phpmyadmin and dump the entire database of products and go back to EP and split the files. Backup prior and use the store manager to reset and optimize the database.

I have a bookstore with lots of attributes like binding, version, closure, red letter, etc.

I loaded Easy Populate did the config and everything went fine. I also took my access file with three products and changed to txt file and changed the header names with v_products_model format. I made sure to follow format even down to EOREOR at the end of each line. I did the load from my admin area and bottom said everything went fine with no errors. But, no products showed up.

Besides no products showing up - my other concern is additional attributes. I have so many attributes that are listed on my original file. I had to delete them to get the sample ones to work. Is there anyway to follow the file format for txt file with new names that fit my attributes, so they can be loaded? Or should I be using something else instead of Easy Populate?

Thanks,:wacko:

elkbow:

It appears that the MySql does not reside on your store hosting server, rather than on an external server is why is says only 2mb Max Size. Local host would usually be 4mb. Did you try splitting the upload EP?

All else, go to phpmyadmin and dump the entire database of products and go back to EP and split the files. Backup prior and use the store manager to reset and optimize the database.

i spoke to my hosting, they changed my limit and even regardless of my increased limit.. they say the file was small enough to be uploaded.. so thats not the issue :(

Hello everyone!

I managed to get Easy Populate installed without a hitch. I uploaded my set of products, but when I did so I recieved this error:

Warning: explode() [function.explode]: Empty delimiter in /home2/weargcom/public_html/smithwesson/elocin/includes/functions/extra_functions/easypopulate_functions.php on line 241

Warning: explode() [function.explode]: Empty delimiter in /home2/weargcom/public_html/smithwesson/elocin/includes/functions/extra_functions/easypopulate_functions.php on line 241

Warning: explode() [function.explode]: Empty delimiter in /home2/weargcom/public_html/smithwesson/elocin/includes/functions/extra_functions/easypopulate_functions.php on line 241

Warning: explode() [function.explode]: Empty delimiter in /home2/weargcom/public_html/smithwesson/elocin/includes/functions/extra_functions/easypopulate_functions.php on line 241

Additionally, I received this error in the output:

No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

The weird thing is, all products seem to have uploaded just fine. I have to make some minor tweaks, but everything seems to be working...

What does this mean?

I've re-ftp my files and tried again and I'm still getting the same errors:

Help!

Any ideas...

Erin

erinl:

I've just installed easypopulate. Everything went smoothly - it was in my admin-tools, when I clicked on install this is the error message I get:

Warning: fopen(/home/momandba/public_html/servlet/temp/Full-EP2008Jun24-2210.txt) [function.fopen]: failed to open stream: Permission denied in /home/momandba/public_html/servlet/admin/easypopulate.php****1089

Warning: fwrite(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php****1090

Warning: fclose(): supplied argument is not a valid stream resource in **/home/momandba/public_html/servlet/admin/easypopulate.php****1091

** on line on line on line Easy Populate support & development by langer. Donations are always appreciated to support continuing development: [email protected] Installation Successfull! A full download of your store has been done and is available in your uploads (temp) directory. You can use this as your 1st template for uploading/updating products. File Full-EP2008Jun24-2210.txt successfully exported! The file is ready for download in your /temp/ directory.
The file isn't in the temp folder as there are errors. I've looked through those lines 1089 - 1091 and I don't see any glaring errors.

I eager to begin using this mod. I would appreciate any help you can offer.

Erin
www.momandbabyboutique.ca/servlet

I am not a developer, so I can't cash in on this, but why, oh why doesn't someone take the initiative to build something, anything that will actually deal with editing attributes through a spreadsheet? I would likely pay some decent bucks to have this happen.

I installed ZenCart for several different clients - assuming that I'd be able to use EP to edit the hundreds (literally) of attributes in these stores and now it seems like there really isn't a tool to do this.

One client needs to up all their prices July 1. There is virtually no way (that I know of) to edit their attributes "offline" so that they can be uploaded and become effective on July 1 - or is there?

Any suggestions? Anyone?

Janelle

janellez:

I am not a developer, so I can't cash in on this, but why, oh why doesn't someone take the initiative to build something, anything that will actually deal with editing attributes through a spreadsheet? I would likely pay some decent bucks to have this happen.

I installed ZenCart for several different clients - assuming that I'd be able to use EP to edit the hundreds (literally) of attributes in these stores and now it seems like there really isn't a tool to do this.

One client needs to up all their prices July 1. There is virtually no way (that I know of) to edit their attributes "offline" so that they can be uploaded and become effective on July 1 - or is there?

Any suggestions? Anyone?

Janelle

Hi Janelle,

I do not use attributes but have played with them a little. If all of them are assigned within a store, and just need updating, then the option to download Model with Attributes in EP should get what you need. The one that I played with had three attributes and the final total was priced via the attributes chosen. It is a little cryptic but I figured it out after a couple of attempts. Depending on how the values were originally assigned, an incremental dollar amount may be needed, instead of the actual price.

Regards,
Dennis

Hi Dennis,

Thanks for your reply. I didn't find it cryptic, I found it impossible! Once you get past the first set of columns of products, it seems to start a new set of columns (but with the model numbers missing). Whether I open it in OpenOffice or Excel, I see this same oddness.

I'm wondering if someone could help me with some SQL though and maybe we can all figure out if this is the best way to go about this. After running this SQL, I propose to edit the resulting spreadsheet, to remove the products_description column and then to upload the products_attributes table with this new data.

Here's the SQL statement I've come up with - however, it limits the products_id to one (and there are three attributes on each of my products). If I'm not being clear, let me know. I'm really rusty with my SQL. Can someone help me fix it so that it returns all rows in products_attributes with the products description matched up?

Select A1.products_name, A2.*
From products_description A1, products_attributes A2
Where A1.products_id=A2.products_id
Group by A2.products_id

Thanks!

Janelle

Woops - thought I had it - more work needed.

Hi

I have installed easy populate 1.2.5.4 and it seems to work ok but when I go and download the "Model/Category tab-delimited .txt file to edit" it only gives me the model and there are no categories

v_products_model EOREOR
EML4032 EOREOR

It does not give any error and I cant seem to get a sample file to download. The other files download all fine

Please help

fakeDecoy:

Version 1.2.5.4 from 2005 is the last EP version, is that right? The Froogle feeder doesn't work - Google changed it to Google Products and changed almost all the required fields, and field names, a couple years ago. I modified some of the code last year, but it needs more work. Does anyone plan on working on it?

Anyone know about this? Is this the latest EP version, and will it be the last?

fakeDecoy : Google have changed the format of the feed since 1.2.5.4 was written and it will not work now. There is a new contr. for this which I believe works with XML, other wise you would need to edit the file to the new format, search in the download section.

navneet : Are you sure you have Cats. set up correctly ? Have you edited the EP file at all as it is only showing > v_products_model EOREOR as my unedited version gives me > v_products_model v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 EOREOR

**kburner **: Enter one product in a cat. via ZC and then download that file via complete download, edit/add products to that file and reload. EP will only work if there are product already in the database. OO and Office will only work with I think 255 columns which you can use up very quickly with EP, so you may need to use a different text editor.

**hbombza **: Check your version of EP Version 1.2.5.4 is the best that works out of the box !

**milobloom **: This is a known bug in 1.2.5.4 search this thread for details.

**erinl **: What version are you using ?

**xt0rt **: read your error 'Empty delimiter ' & 'No model field in record' it looks as if your upload file format is incorrect, the best way to test is download a complete file to start with and look at that alter a few things and then upload the new file, and I am sure that will work for you.

**janellez **: The problem with doing it via sql, ZC needs to update several tables at once, attributes are held in a different table to product details and ZC uses table ids not model name/numbers as references in the these tables,so when EP updates the db it queries the model number/ref to get the table id number and then inserts the data or updates the data by the table id's. Other than coding it yourself or seeing if EP Advance works better for you, you will just have to live with the present version.

scrat

I have not edited easy populate at all. I have the following layout

I have one product in category B and this category is in category A.
I also tried to add another product directly in category C

still the same

navneet : By default EP gives you 7 categories which should be showing in the header live in the download file whether you have 7 or not set up in ZC.
Did you upload your products via EP firstly ? as ZC does not like excepting uploads from EP unless there is a product and category already set up originally via ZC not EP. What Version are you using ? (Langer 1.2.5.4 from Modhole not ZC Downloads is the one to use! as the others seem to be buggy.)
What does your complete file give you ? is there 7 cats. in that ?