Re: Easy Populate support
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
Re: Easy Populate support for Version 1.2.5.4
My Debug data shows the following
Quote:
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???
Re: Easy Populate support for Version 1.2.5.4
[FONT=Arial]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.php1089
Warning: fwrite(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php1090
Warning: fclose(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php1091
[/FONT] on line on line on line [FONT=Arial]http://www.momandbabyboutique.ca/ser...ns/warning.gif Easy Populate support & development by langer. Donations are always appreciated to support continuing development: [email protected][/FONT] [FONT=Arial]http://www.momandbabyboutique.ca/ser...ns/success.gif 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.[/FONT] [FONT=Arial]http://www.momandbabyboutique.ca/ser...ns/success.gif File Full-EP2008Jun24-2210.txt[/FONT] successfully exported! The file is ready for download in your /temp/ directory.[FONT=Arial]
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
[/FONT]
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
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.
Re: Easy Populate support for Version 1.2.5.4
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:
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
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 :(
Re: Easy Populate support for Version 1.2.5.4
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:
Code:
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:
Code:
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?
Re: Easy Populate support for Version 1.2.5.4
I've re-ftp my files and tried again and I'm still getting the same errors:
Help!
Any ideas...
Erin
Quote:
Originally Posted by
erinl
[FONT=Arial]
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.php1089
Warning: fwrite(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php1090
Warning: fclose(): supplied argument is not a valid stream resource in /home/momandba/public_html/servlet/admin/easypopulate.php1091
[/FONT]
on line on line on line [FONT=Arial]
http://www.momandbabyboutique.ca/ser...ns/warning.gif Easy Populate support & development by langer. Donations are always appreciated to support continuing development: [email protected][/FONT] [FONT=Arial]
http://www.momandbabyboutique.ca/ser...ns/success.gif 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.[/FONT] [FONT=Arial]
http://www.momandbabyboutique.ca/ser...ns/success.gif File Full-EP2008Jun24-2210.txt[/FONT]
successfully exported! The file is ready for download in your /temp/ directory.[FONT=Arial]
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
[/FONT]
Re: Easy Populate support for Version 1.2.5.4
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
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
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