Easy Populate 1.2.5.4 support

[elkbow]

Please read the title of this thread:

Easy Populate support for Version 1.2.5.4 namely Langer's version from Modhole not from ZC's download section.

The problem I am seeing is that with so many versions of EP floating about people are getting all sorts for issues and bugs and not being clear which version they are using.

Would it be an idea to start some new threads with the title of the versions of EP you are using ??

e.g
Easy Populate support for Version 1.2.5.4
Easy Populate support for Version 1.2.5.5.csv.2
Easy Populate support for Version 1.2.5.5
Easy Populate support for osc Version 2.77H

Just a thought

This is quoted from page 236 by Scrat,

It really looks like this thread should be seperated. There seems to be too many problems and questions refering to different versions of Easy Populate.

So far I have only used 1.2.5.4 on 5 stores, added and changed some field names, deleted unused download lines in the easypopulate.php file and uploaded anywhere from 52 products on one store to over 14,000 on other stores and have never had a problem uploading.

Perhaps someone will continue to a new thread for 1.2.5.5.csv.2 and keep it seperated from 1.2.5.4
I still consider 1.2.5.4 from Modhole to be the easiest and best version to use.

[touchclothing]

I'm not sure about this but, don't the import files have to be in a .csv format? Not .txt? I know they're very similiar (often considered to be the same thing, in fact) but that might be where the problem lies.

yea we have done it with both and nothing happens

[autoace]

Hi Zenners,

Preface, EPv1.2.5.4 from modhole.com

I had originally installed Easy Populate CSV v1.2.5.6 and then decided to go with EP v1.2.5.4 because it seems to be much more supported here in the forums and it has been mentioned that it is the most stable version.

So I contacted schoolboy because he seemed to have an in-depth knowledge of v1.2.5.4 and wanted his opinion on the matter. I liked his response and proceeded to uninstall EP CSVv1.2.5.6. Everything went well except for an MySQL error! So I contacted schoolboy, briefed him on the situation and he gave me the following advice/instructions to solve the error and it worked like a charm!

I told schoolboy that I was going to post this for anyone else who has done the same as I have done. So here it is, hope it helps.

Hi schoolboy,

I have installed EP v1.2.5.4 (from modhole) and am just about done, except I have one mysql error that I hope you can help me please fix.

I did delete the tempEP from the previous install and uploaded the temp folder from the EP v1.2.5.4. And then I ran the sql file in my phpmyAdmin because I noticed the different folder names (tempEP vs temp) for the temp folder. Any suggestions as to the fix. Should I just simply rename the temp folder to tempEP or is there something else I should do. I intend to post this on the forums as soon as I have it fixed in case anyone else has done what I did! Thank you for your help. MySQL error is....

Error

SQL query: Documentation

INSERT INTO configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL), ('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', last_insert_id(), '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'), ('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, NULL), ('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Us[...]

MySQL said: Documentation
#1062 - Duplicate entry 'EASYPOPULATE_CONFIG_TEMP_DIR' for key 2

-----------------
Thanks for your help.

My advice would be to remove everything associated with EP in your files, AND database, and start from scratch.

FILES:
Only in your Admin folder - EP does not exist in Catalog side of ZC.
Find all EP "php" files and delete them all.

DATABASE
BACKUP DB FIRST!

1) use phpMyadmin (or whatever your host provides) to edit your db:

in configuration_group - select browse - find easypopulate - (make note of the group ID) - delete that group ID

3) select configuration - then browse - sort by group ID - find the one that you need relating to EP. (there should be 10 different config. ID's for that group) - delete them all.

4) install EP 1.2.5.4 again via FTP.

5) There is usually NO NEED to run the SQL patch. After uploading the php files, go to ADMIN>>>TOOLS>>>EASY POPULATE.
There will be a message about installing in the header of your admin screen... click that. EP should install itself.
6. Go to ADMIN>>>CONFIGURATION>>>EASY POPULATE and administer settings. Read my WIKI for advice.

7. EP should now be functional.

Thanks schoolboy, worked like a charm. Your step by step was was absolutely excellent. Thank you!

[touchclothing]

any ideas I will take anything

I have just installed 1.2.5.4 and when I go to to upload my file its says
Upload Results

File uploaded.
Temporary filename: /tmp/phpx2tMDF
User filename: lynyrdskynyrd.txt
Size: 17635

Upload Complete

But nothing shows up in my store what am I doing wrong
touchclothing is offline Report Post Reply With Quote

Can I get some help on this !!!!!!

[elkbow]

Can I get some help on this !!!!!!

I'm not sure what your file (txt) looks like, but does it have EOREOR on the end and each item has a unique product model number.

Also what about seperate catagories?

[schoolboy]

Can I get some help on this !!!!!!

Have you used EP successfully in the past with your website?

[chadderuski]

Can I get some help on this !!!!!!

1) What version of EP are you using? REALLY important to know this!
2) Did you have any products in your store to start with?
3) Each product MUST have a unique v_products_model AND you must have at least 1 master category.
4) What is your default language? If it is not english = 1, people have had problems.
5) Have you checked you databases using phpMyAdmin? You can browse the products database to see if anything loaded.
6) Did you set up your temp file location to be writeable?

There are a lot of things that can go wrong with EP (all the versions), but most of them are simple to fix, and generally user error.

However, if you are populating a new empty store database for the first time, you often need to go into Admin -> Tools -> Store Manager and run "Update All Products' Attribute Sort Orders" and "Update ALL Products Price Sorter".

You should really do that after every upload anyway. I have found cases where it seems the indexes do not update correctly (I also use quick updates, and this is very evident when checking new data after upload as the Master Category id's get jazzed up for some reason.)

Seriously: First time EP users need to enter a few products with categories throught the Zencart Admin and THEN do a first download. You can then use this as your template for your other products. You'll still need to manually upload your images too.

Hope this helps.

Find the EP FAQ ... it is quite well written and very helpful.

[chadderuski]

One other thing! If you have not installed the Admin Backup MySQL tools, you should! And you should have a backup before any attemps at uploading products from any version of EP.

Through no fault of EP, it is quite easy to jazz up your store with mistyped category names, funky dates, etc. etc.

[chadderuski]

Oh, forgot one! Also in Admin -> Tools -> Store Manager run "Reset ALL Products Master Categories ID"!

[Rob-adrenalfuel]

Am I missing something?

bought the advanced easy populate a few days ago from the zencartbuilder site but not received anything - was expecting to be sent a direct download link or something?

Is the big man away or someat? I don't want to sound impatient but I've a week of being laid up sick ahead of me and would like to have a good crack at finishing my zen cart build