Easy Populate 1.2.5.4 support

jmebright What you are really asking for is a custom app. to search one file and populate another, Yes anything is possible, and this is quiet simple to do with very little knowledge of script writing, I would suggest you have a look at 'Python' its a great OO programming language and very easy to learn(pickup) with lots of free on-line tutorials (both text and video's to help)

Kristina Use version 1.2.5.4 from Modhole !!! (it just works with out any major issues) - other than that if you really want to use your version check your file format against the original download.
Always a good test, download a complete file and edit the file leading the header and just one product and try uploading again and see what happens. If you search this thread you will see that these .csv version of this module have many bugs, some people seem to have good results but if you just want a tried and tested version use version 1.2.5.4.

Thanks for the input. I'll try it again with version 1.2.5.4.
BTW, I'm using microsoft excel to modify the file. But I've also tried it with Notepad and it didn't work there either. So I'll try 1.2.5.4.
Thanks again.

Thanks - switching to version 1.2.5.4 worked like a charm. :clap:

...now I just have to get all my data in the right form, yikes!

I'm using microsoft excel to modify the file. But I've also tried it with Notepad and it didn't work there either
:no:
USE OPEN OFFICE..FREE from
http://www.openoffice.org/

awhfy99:

I have found that this can be caused if a product is deleted and was in a shopping cart or visa-versa, the user is deleted and he had items in his cart.

So a good place to start is in zen_customers_basket (or zen_customers_basket_attributes), hopefully you might see it there.

If not, try to remember what was deleted shortly before you saw the error pop up. If it was a category, try zen_product_to_categories, etc. It's kinda like playing Sherlock Holmes in the db!

Thank you! This was exactly my problem. I just truncated each of those tables and viola! no more annoying errors!

I just installed 1.2.5.4 and it seems like a really good program. I can downloads data fine, but I can only upload if I place file in temp folder manually and in the zen cart admin menu EP is calling itself "BOX_TOOLS_EASYPOPULATE". Have I mis-installed something, or is this normal. Thanks in advance!

I have install the Easy Populate adn I am getting this error:

Warning: array_flip(): The argument should be an array in /home/content/m/o/r/morristech/html/giftshop/admin/easypopulate.php on line 1328

Can someone help me on this?

right now I have 1.2.5.4 installed but I just bought 3.0.3 advanced can I just upload and install the files over the 1.2.5.4

dp-web:

Hi, I'm using Easy Populate and I am experiencing a strange problem when trying to use the 'Models/Attributes' part of the plugin.

I wait and end up with a Internal 500 server error.

I set the max time on the 'My Store > Admin Set max_execution_time for processes' to something very large (from 60 to 6000) but still no luck.

It doesn't work on either of the 'Stream txt file' or the 'Create txt in temp/ directory' settings.

The strange bit is I can use the 'Complete' txt part no problems.

Any ideas why only the Model/Attributes part is broken and not the complete database (its the attributes I want to download!)?

The store only has around 3-4000 items in it - is there a limit to what it will happily export? Or is the problem with the server (timeout length etc)?

Thanks,
dp

I am having this exact same problem and really need help sorting it out. I've contacted my host and they are just telling me that they are uncertain as to why this is happening. They aren't offering me a solution...yet.
Can somebody out there tell me what they think I should do to fix this?
Thanks (o:
Cdnbride

tom50 Re-check your install, I think you have missed a .php file from the FTP.

bkeaton What version are you using ? (Money on, that you are not using v1.2.5.4)

touchclothing Read the Readme.txt file and run the uninstall http(this will remove the database configs for EP) and then remove all the EP 1.2.5.4 .php files as the install.

cdnbride What version are you using ? (Money on, that you are not using v1.2.5.4)

Scrat

I'm using 1.3.8a

My cart says that I'm using the current version, should I be using something different?

I have just less than 5000 products, my hosting service has told me that they think this is happening because

"The max_execution_time we have set globally on our servers is 30 seconds."

"since there is so much data involved, it is taking the MySQL server longer to retrieve it all than is allowed by our timeout values. Since this is a shared server, there isn't any way to increase that value. The only way to increase that value would be for you to upgrade your account to a VPS or a dedicated server. Since you would be (from our point of view) the only customer on the server, we'd set it up however you wish."

Cdnbride

cdnbride:

Scrat

I'm using 1.3.8a

My cart says that I'm using the current version, should I be using something different?

I have just less than 5000 products, my hosting service has told me that they think this is happening because

"The max_execution_time we have set globally on our servers is 30 seconds."

"since there is so much data involved, it is taking the MySQL server longer to retrieve it all than is allowed by our timeout values. Since this is a shared server, there isn't any way to increase that value. The only way to increase that value would be for you to upgrade your account to a VPS or a dedicated server. Since you would be (from our point of view) the only customer on the server, we'd set it up however you wish."

Cdnbride

Sorry I'm using Easy Populate 1.2.5.4 with Zencart 1.3.8a (that makes more sense)

cdnbride Not your ZC version - the version of EP you are using (eg 1.2.5.4, 1.2.5.5, 1.2.5.6, 1.2.5.7, 3.03(com.))

Scrat

I'm using Easy Populate 1.2.5.4

Cdnbride

cdnbride Have you checked your folder permissions of your /temp folder, as usually ever with a large database EP should download to the /temp folder.
If this is a server issue than maybe it is a good idea to have a look for another host,

HTTP Error 500 Internal server error
is a 'catch-all' error generated by the Web server. Basically something has gone wrong, but the server can not be more specific about the error condition in its response to the client. In addition to the 500 error notified back to the client, the Web server should generate some kind of internal error log which gives more details of what went wrong. It is up to the operators of the Web server site to locate and analyse these logs.

Also where did you download your version from ?

I had a successful installation of my easy populate 1.2.5.4.

I uploaded my products via txt file and everything was successful.

All information appears in the product set-up page except there is no product image.

Product images appear for those products uploaded prior to installing easy populate. Despite having all correct product links and my images in the correct folders, the only way images appear is after uploading through the set-up page.

Is there some setting adjustment that needs to be made for images to appear without having to upload in set-up page?

Hi Scrat

Okay, first of all I am really really new to all of this so please bear with me. I looked in the /temp folder and there is no easy populate there. I have gone into my public_html/admin and found my easypopulate.php, which the permissions seem to be set at 644 and the attributes controller is set at 755. Would one of these files be what you are referring to? I am only having problems trying to "Download Model/Attributes tab-delimited .txt file", everything else seems to download. One thing I have noticed is that if I click on the "Create Model/Attributes tab-delimited .txt file in temp dir" and then I download the file to my computer is that when I try to open it in Excel (as that is what I've used for all of my .txt file creating) I get an error that says "File not loaded properly"

I also don't think that it is a server thing because the Full File from "Download Complete tab-delimited .txt file to edit" downloads without a problem every time. I would think that the Model/Attributes file would be smaller and less complex than the full data file, therefore the statement that my host support team made about the file possibly being a lot of data doesn't seem right, kwim?

I installed EP through the Fantastico on my Cpanel.

Cdnbride

808helmets Easiest way to check your products is download a 'complete' file and check the image details and compare working ones to non working ones... also make sure that the folder names are the same as in the image details (E.g images/folder1 against images/Folder1 ) as ZC we see this as two different folders not the same best way use just lower case or upper case but not both.

cdnbride Its not a problem, we all started one day with very little knowledge but all becomes clearer with time :clap:.

Firstly I have no knowledge of what version 'Fantastico' uses and where that originates from.

As for permissions, you need to check that your temp FOLDER permissions are set right (I have mine set to 0755) because if this is not set correctly it would mean that any files sent to this folder may not be allowed to save into this folder because the permissions disallow it.(also there is no EP .php files in this folder as it is a temp folder for temp files)

Generally version 1.2.5.4 works pretty well (some know bugs) and usually errors of this nature are due to server issues. Most cheap hosting really set levels low as they can have say 2000 sites on one server so imagine if every site tried to up load 5000 products at once this would kill the server so they set levels for each user to stop this happening, another example is that they limit the users of the mysql database so only 12 people can connect to the database at once (12 customers - the 13th gets a server busy error page) so again it does not kill the server.

I would have a look at the easypopulate.php file and see if it is this version by comparing the one you can download from modhole.

Scrat:

808helmets Easiest way to check your products is download a 'complete' file and check the image details and compare working ones to non working ones... also make sure that the folder names are the same as in the image details (E.g images/folder1 against images/Folder1 ) as ZC we see this as two different folders not the same best way use just lower case or upper case but not both.

cdnbride Its not a problem, we all started one day with very little knowledge but all becomes clearer with time :clap:.

Firstly I have no knowledge of what version 'Fantastico' uses and where that originates from.

As for permissions, you need to check that your temp FOLDER permissions are set right (I have mine set to 0755) because if this is not set correctly it would mean that any files sent to this folder may not be allowed to save into this folder because the permissions disallow it.(also there is no EP .php files in this folder as it is a temp folder for temp files)

Generally version 1.2.5.4 works pretty well (some know bugs) and usually errors of this nature are due to server issues. Most cheap hosting really set levels low as they can have say 2000 sites on one server so imagine if every site tried to up load 5000 products at once this would kill the server so they set levels for each user to stop this happening, another example is that they limit the users of the mysql database so only 12 people can connect to the database at once (12 customers - the 13th gets a server busy error page) so again it does not kill the server.

I would have a look at the easypopulate.php file and see if it is this version by comparing the one you can download from modhole.

Hi Scrat

I have checked the temp folder permissions and it is set at 0755 so tonight I will compare the .php files to see if they are the same. I thought that I picked a good hosting company but again this is pretty new to me so maybe I haven't. I would say who it is if I knew that I was permitted to here. Not sure what the rules are with forums like this so that is why I hadn't said in the first place.
I will be back once I look at those .php files.

Thanks again
Cdnbride

cdnbride:

Hi Scrat

I have checked the temp folder permissions and it is set at 0755 so tonight I will compare the .php files to see if they are the same. I thought that I picked a good hosting company but again this is pretty new to me so maybe I haven't. I would say who it is if I knew that I was permitted to here. Not sure what the rules are with forums like this so that is why I hadn't said in the first place.
I will be back once I look at those .php files.

Thanks again
Cdnbride

Firstly:
EP 1.2.5.4 was never known for its reliability regarding the upload of attribute data - and remember, it claimed to upload only option names and values - not how they may have been assigned to products. For this feature, only the Commercial Version (3) of EP has the capacity to do full attribute uploads. (And even then, its reliability is questionable.)

Secondly:
There is NO NEED to change FILE PERMISSIONS. They should be the default of 644. Permissions of the TEMP folder could be 755, and if this causes issues, then 777 is probably required. What I do is change the temp folder to 777 ONLY WHILE I do EP uploads/downloads. Then I take it back to 755.

Thirdly:
To establish if it is EP that is causing the problem, do a TEST upload with a few test products. (It should not have a problem writing a complete DB download to the temp folder - I do this routinely on stores with upwards of 8000 - 9000 products.)

Fourthly:
Never use "fantastico" to install anything - particularly not a module. EP has SEVERAL files to upload. ALL go into admin. There is nothing on the catalog side of the store:

Here is the directory/file TREE for the EP 1.2.5.4 module:

admin (folder)
|includes (folder)
|......|boxes (folder)
|...........|extra_boxes (folder)
|...............|easypopulate_tools_dhtml.php (file)
|
|......|extra_datafiles (folder)
|...........|easypopulate_filenames.php (file)
|
|......|functions (folder)
|...........|extra_functions (folder)
|...............|easypopulate_functions.php (file)
|
|......|languages (folder)
|...........|english (folder)
|.............|easypopulate.php (file)
|.............|extra_definitions (folder)
|................|easypopulate.php (file)
|
|_easypopulate.php (file)
|
temp (folder)

NOTE: I trust you realise that while some files have the same NAMES, their purpose and function is determined by where they are LOADED in the folder tree. Files of similar names are NOT interchangeable!