EasyPopulate 4.0 Support Thread

[schoolboy]

Also doing a script to convert your output to a turbo lister import file

Paul... this is very interesting and exciting! Would you make this mod available in the free add-ons at some point? I know there would be a lot of interest in it.

[Hasher]

Paul... this is very interesting and exciting! Would you make this mod available in the free add-ons at some point? I know there would be a lot of interest in it.

Well Im using Autoit to create this script and it works just fine but I think that anyone using it will need to edit it for their own purposes.

Also I am automating Excel to convert the CSV. As chadderuski says Open office is a better program . Autoit doesnt have great librarys for Open office as yet. Saying that I only have 100 products in my store at the moment so its not a great test but it is faultless in importing products.

Guess there is two important points .This script wont be perfect for everyone and I wont post in this thread as it will cause thread drift .Happy to start another thread

Going to improve it today as i only done a days work on it and I'm by no means a programmer.

If you have a larger file to test with that would be great. Also Im only interested in working with EP4 , not he legacy EP.

Paul

[chadderuski]

I will be working Dedicated CRON support.

Just a heads up, but I cannot promise as to when I'll get to it! I have another programmer that's interested in working on this too, so may-hap this will arrive sooner than later!
This is actually one of the reasons I've broken the script's files up into import/export so that it would be easier to make a direct call on the script like I've seen
some cron job do. I've never written a cron job before, so this is new territory for me.

Feel free to express your ideas. PM me if you have code to offer.

-chadd

[dkwwkd]

Hi, have zencart 1.5 installed and added EP4.0. Works fine however need to add in my extra fields I have planned for my new site so that they will be downloaded and uploaded via EP4.0. I had this working using the old EP (using info on thread 116061) however cannot get the old EP to work on zencart 1.5.

I have looked at the easypopulate_4_import.php and easypopulate_4_export to try and apply the same logic however the files are totaly different to the previous easy populate data. Presumably these would be the correct files to add in the extra field names.

Any assistance in the location to add extra code for the addition of my extra fields to enable ep4.0 to upload and download them automatically would be much appeciated. Even if its just which php files and line numbers.

Sorry if this does not make sence but have only just started with php code, websites and sql.

Many Thanks

[chadderuski]

Hi, have zencart 1.5 installed and added EP4.0. Works fine however need to add in my extra fields I have planned for my new site so that they will be downloaded and uploaded via EP4.0. I had this working using the old EP (using info on thread 116061) however cannot get the old EP to work on zencart 1.5.

I have looked at the easypopulate_4_import.php and easypopulate_4_export to try and apply the same logic however the files are totaly different to the previous easy populate data. Presumably these would be the correct files to add in the extra field names.

Any assistance in the location to add extra code for the addition of my extra fields to enable ep4.0 to upload and download them automatically would be much appeciated. Even if its just which php files and line numbers.

Sorry if this does not make sence but have only just started with php code, websites and sql.

Many Thanks

It's actually much easier than the old EP. What field names are you adding? And are they only in the products database?

[dkwwkd]

Thanks for quick responce, I have about 8 or 9 that I am adding. Yes they are all in the products database - the same table as product weight etc. some of them are product_pack, product_author, etc

[chadderuski]

Thanks for quick responce, I have about 8 or 9 that I am adding. Yes they are all in the products database - the same table as product weight etc. some of them are product_pack, product_author, etc

The main work is in the includes/functions/extra_functions/easy_populate_4.php file

Go down to the function ep_4_set_filelayout() function. You are going to add layout entries to the "full" case.

Look a the entries for:

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}

And a little further down:

$filelayout_sql = 'SELECT ....
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}

Basically you are going to create your own mod, and add your file layout and sql statements here.

You will need to define your mod in the easypopulate_4.php file, and then there are a number of additional edits to the easypopulate_4_import.php file.

If this is beyond your php knowledge, PM me a list of the field names as they appear in your products table and their field types. Verify them with phpMyAdmin.

But you should be able to puzzle it out easily enough... $ep_supported_mods[] is how I switch on entries for these mods. So they are found pretty easily.

-chadd