EasyPopulate 4.0 Support Thread

[chadderuski]

Is there a way to make this work with this add-on?
MAP Pricing ( m.a.p ) : Add to Cart to See Price
http://www.zen-cart.com/downloads.php?do=file&id=66

If this mod only adds fields to the products table, then you should be able to use the User Defined Products Fields to add these to your import sheet. After installing the MAP mod, look at the products table or sql you used to modify the table for the field names. Then add these under the Configuration > EasyPopluate 4 :: User Defined Products Fields.

Separate the fields with a comma, but do not add spaces, for example: field1,field2,field3
Do not add quotes either.

Your sheet will then export with columns for these fields as: v_field1, v_field2, v_field3

Let me know how that works for you!
-chadd

[wtfbbq]

If this mod only adds fields to the products table, then you should be able to use the User Defined Products Fields to add these to your import sheet. After installing the MAP mod, look at the products table or sql you used to modify the table for the field names. Then add these under the Configuration > EasyPopluate 4 :: User Defined Products Fields.

Separate the fields with a comma, but do not add spaces, for example: field1,field2,field3
Do not add quotes either.

Your sheet will then export with columns for these fields as: v_field1, v_field2, v_field3

Let me know how that works for you!
-chadd

Thanks this worked!
For those who need the MAP mod integrated, the categories you need to add in the user defined box are: map_enabled,map_price

[zan_dude]

Hi Chad...

Firstly what a great extension EP is, I had got it set up on a server whilst i was testing out things and it was all working great.

I've now had to move over to a hosting package with siteground and have managed to install zen cart again no problem and was going to start again from scratch with everything.

When I re-installed EP (using your latest github version) for some reason I can't seem to get it to work correctly. I can see it at the bottom of the tools menu but everytime i try and do something in EP it takes me back to the admin login panel for some reason.

I know this has been documented before but i didn't even use the install sql feature to install it via the admin panel and can't see any rouge // in any of the configure.php files.

Is there anything else I can check here because it's driving me crazy as i've already tried a few things but to no avail, currently i've re-installed zen cart from scratch again and done the same for EP but it still doesn't work.

Currently with the hosting i've not transferred my domain name across yet so i'm having to access the site by ip address and noticed that in the url for that there is a ~ character which i was wondering if that had anything to do with the problem perhaps.

Unless there's a few more php files i can check for bad // ?

Any help would be greatly welcomed...

Thanks.
Matt

[chadderuski]

Hi Chad...

Firstly what a great extension EP is, I had got it set up on a server whilst i was testing out things and it was all working great.

I've now had to move over to a hosting package with siteground and have managed to install zen cart again no problem and was going to start again from scratch with everything.

When I re-installed EP (using your latest github version) for some reason I can't seem to get it to work correctly. I can see it at the bottom of the tools menu but everytime i try and do something in EP it takes me back to the admin login panel for some reason.

I know this has been documented before but i didn't even use the install sql feature to install it via the admin panel and can't see any rouge // in any of the configure.php files.

Is there anything else I can check here because it's driving me crazy as i've already tried a few things but to no avail, currently i've re-installed zen cart from scratch again and done the same for EP but it still doesn't work.

Currently with the hosting i've not transferred my domain name across yet so i'm having to access the site by ip address and noticed that in the url for that there is a ~ character which i was wondering if that had anything to do with the problem perhaps.

Unless there's a few more php files i can check for bad // ?

Any help would be greatly welcomed...

Thanks.
Matt

Hi Matt,

Did you install zencart using a cpanel auto-installer? If so, then you likely have some "fudging" going on in your configure.php files. You will need to check these to be sure the are correct. A common issue I've seen are extra // (double wacks) where there should only be one. This will break EP though not zencart for some reason.

I haven't tested zencart on a site using the ~ tilda, so you are in uncharted grounds there. No problem using just an IP though.

-chadd

[zan_dude]

Hi Matt,

Did you install zencart using a cpanel auto-installer? If so, then you likely have some "fudging" going on in your configure.php files. You will need to check these to be sure the are correct. A common issue I've seen are extra // (double wacks) where there should only be one. This will break EP though not zencart for some reason.

I haven't tested zencart on a site using the ~ tilda, so you are in uncharted grounds there. No problem using just an IP though.

-chadd

Hi,

I did the install by just copying the files into the right places with FileZilla and then going to tools > easypopulate4 at the bottom of the list and then having to press on install easypopulate by clicking at the top of the screen within the easy populate menu/module.

I'm just wondering if it could be the ~ character within the URL ? Is there any way I can verify this somehow. Unless there are more .php files to take a look inside with path errors?

In the configure.php insi admin includes I did notice the admin directory isn't specified like the other paths, it doesn't contain any // but it doesn't show a true path to the directory like the other dirs are.

Thanks,
Matt

[relish]

Separate the fields with a comma, but do not add spaces, for example: field1,field2,field3
Do not add quotes either.

Your sheet will then export with columns for these fields as: v_field1, v_field2, v_field3

Let me know how that works for you!
-chadd

Hey that worked . Just installed EP4 , hoping to use it to the fullest.

Thanks Chadd !

[scottj]

If this mod only adds fields to the products table, then you should be able to use the User Defined Products Fields to add these to your import sheet. After installing the MAP mod, look at the products table or sql you used to modify the table for the field names. Then add these under the Configuration > EasyPopluate 4 :: User Defined Products Fields.

Separate the fields with a comma, but do not add spaces, for example: field1,field2,field3
Do not add quotes either.

Your sheet will then export with columns for these fields as: v_field1, v_field2, v_field3

Let me know how that works for you!
-chadd

This is regards to the MAP Pricing mod. I followed your instructions by setting User Defined Field = v_map_enabled (which I confirmed in my SQL db as the correct field name). I download FULL-EP and it doesn't show up. I upload a CSV with a single record to test and I get the following output (but no change to the db or the product record):

Import Results

Filename: MAP_UL.csv

UPDATED! - Model: 806-1206 | 1 |

Finished Processing Import File

A "1" enables it, a "0" disables it. I'm trying to fully convert away from the old EP version which I had modded to do this. I've had no problems in the past uploading metatag fields with EP4.0 so I'm not sure if I'm missing something? There's no debug error found. I confirmed I can go into the product record manually and change it successfully. Any ideas? Thanks!
Scott

[mc12345678]

This is regards to the MAP Pricing mod. I followed your instructions by setting User Defined Field = v_map_enabled (which I confirmed in my SQL db as the correct field name). I download FULL-EP and it doesn't show up. I upload a CSV with a single record to test and I get the following output (but no change to the db or the product record):

Import Results

Filename: MAP_UL.csv

UPDATED! - Model: 806-1206 | 1 |

Finished Processing Import File

A "1" enables it, a "0" disables it. I'm trying to fully convert away from the old EP version which I had modded to do this. I've had no problems in the past uploading metatag fields with EP4.0 so I'm not sure if I'm missing something? There's no debug error found. I confirmed I can go into the product record manually and change it successfully. Any ideas? Thanks!
Scott

So, I left this message alone last night, because I didn't quite follow it and also thought perhaps the code author might jump in with an answer.

I haven't worked with that aspect of this plug-in (using the user defined fields; however, it may be helpful to see the "single line" data file for one thing (this would identify the fields that are being attempted to be added). That said, it seems that unless you have created a new file type to be able to upload with a filename prefix associated with MAP_UL, then there are several routines within the plugin that will not be activated. Additionally, it appears that the original code author provided direction related to the new fields being added to the products table. Were the new fields added to the products table or some different table? Also (and not to question your knowledge/understanding) the fields entered into the user defined fields, they are the actual field names that were added, not field1,field2,field3,etc... correct?

On the issue of the filename, it seems like the expectation (if the fields were added to the products table) that import to ZC should have the same prefix as the download file ("full...etc"). (Sorry at the moment have forgotten what the exact prefix is.)

Any of that help?

[scottj]

So, I left this message alone last night, because I didn't quite follow it and also thought perhaps the code author might jump in with an answer.

I haven't worked with that aspect of this plug-in (using the user defined fields; however, it may be helpful to see the "single line" data file for one thing (this would identify the fields that are being attempted to be added). That said, it seems that unless you have created a new file type to be able to upload with a filename prefix associated with MAP_UL, then there are several routines within the plugin that will not be activated. Additionally, it appears that the original code author provided direction related to the new fields being added to the products table. Were the new fields added to the products table or some different table? Also (and not to question your knowledge/understanding) the fields entered into the user defined fields, they are the actual field names that were added, not field1,field2,field3,etc... correct?

On the issue of the filename, it seems like the expectation (if the fields were added to the products table) that import to ZC should have the same prefix as the download file ("full...etc"). (Sorry at the moment have forgotten what the exact prefix is.)

Any of that help?

Thanks for the reply. The user defined field I added was v_map_enabled (I had a good chuckle... would've been funny had I added "field1") and the new MAP field *is* located in the products table. As I noted, I know just enough to be dangerous having modded the old EP1.2.5.4 for the MAP field. The contents of MAP_UL.csv test file was simply:

v_products_model | v_map_enabled
806-1206 | 1

As for the file name, this may be the most promising. I don't quite understand all that. I previously attempted to add about 100 new products using the Full-EPxxxx prefix and for whatever reason it deleted all the title/descriptions for the existing 10,000 products. Luckily I had a backup but understandably I've stayed far away from that prefix!

Without any mods I successfully upload metatag data using a CSV file called metatags_UL.csv (which is why I originally added EP4.0 since the old EP doesn't support metatag stuff). Thus I made the assumption, perhaps erroneously, that any file name will work if you just want to upload product fields without "triggering" any of the EP4.0 logic... logic which I readily admit I don't understand. References to it in the instructions were a bit ambiguous for me.

Thoughts?

[mc12345678]

Thanks for the reply. The user defined field I added was v_map_enabled (I had a good chuckle... would've been funny had I added "field1") and the new MAP field *is* located in the products table. As I noted, I know just enough to be dangerous having modded the old EP1.2.5.4 for the MAP field. The contents of MAP_UL.csv test file was simply:

v_products_model | v_map_enabled
806-1206 | 1

As for the file name, this may be the most promising. I don't quite understand all that. I previously attempted to add about 100 new products using the Full-EPxxxx prefix and for whatever reason it deleted all the title/descriptions for the existing 10,000 products. Luckily I had a backup but understandably I've stayed far away from that prefix!

Without any mods I successfully upload metatag data using a CSV file called metatags_UL.csv (which is why I originally added EP4.0 since the old EP doesn't support metatag stuff). Thus I made the assumption, perhaps erroneously, that any file name will work if you just want to upload product fields without "triggering" any of the EP4.0 logic... logic which I readily admit I don't understand. References to it in the instructions were a bit ambiguous for me.

Thoughts?

So to confirm, your database has a field name that begins with a v_? Or if you were to look in mySQLadmin would it be map_enabled?

The code automatically adds v_ as part of creating the CSV file.

So, it looks like the only way to get those fields out of ZC is to do a full export. To get them back in, it looks like you don't have to do a full import. At least there is some data loaded without that type of file...

But I think the real problem is that you have already prefixed the field with v_...