EasyPopulate 4.0 Support Thread

Hi Stellarweb,

I've been reading through what you guys have been doing to try and solve your problem. I've of the mind that we should take a phpMyAdmin full sql backup and try to restore that into another site's testing database. This should tell us if we have:

1. code related issue
2. database related issue
3. server related issue.

not everything would be perfect for this test since you might have other mods installed, but it may help to diagnose your issue.

Did you attempt to install zencart in a new sub-directory, install only EP4 and test?

Happy dance! The site has Ultimate SEO URL's installed and one of the files includes/classes/db/mysql/query_factory.php is what was causing the problem. Unfortunately, since this mod has not been updated yet for 1.5.3, I have to use that file for the USU to work. So I set up an admin area in a separate folder that ties into the current database and EP works fine! Not the greatest solution, I am sure, but the best I know of for now until USU gets updated.

chadderuski:

Hi Stellarweb,

I've been reading through what you guys have been doing to try and solve your problem. I've of the mind that we should take a phpMyAdmin full sql backup and try to restore that into another site's testing database. This should tell us if we have:

1. code related issue
2. database related issue
3. server related issue.

not everything would be perfect for this test since you might have other mods installed, but it may help to diagnose your issue.

Did you attempt to install zencart in a new sub-directory, install only EP4 and test?

stellarweb:

Happy dance! The site has Ultimate SEO URL's installed and one of the files includes/classes/db/mysql/query_factory.php is what was causing the problem. Unfortunately, since this mod has not been updated yet for 1.5.3, I have to use that file for the USU to work. So I set up an admin area in a separate folder that ties into the current database and EP works fine! Not the greatest solution, I am sure, but the best I know of for now until USU gets updated.

BTW, at this time Ultimate SEO URL's is not considered compatible with ZC 1.5.3 or at least hasn't been updated to be compatible. The latest author has a BETA version in testing, but the ZC site version does not yet include the revisions that were made to integrate with the latest database handling and other changes to the "common" core files. (Discovered this last part by performing a merge with the latest ZC 1.5.3 files to see what was different/needed.) Haven't looked as to why these replaced files caused the result(s) that we saw, but certainly did not support proper operation of ZC 1.5.3 to use the files of an older version of ZC (Files from ZC 1.5.1 and below that manage/interact with the database require updating to work under ZC1.5.3)

When I export Model/Price/Qty (PriceQTY-EP) through EP4; it pulls 14 duplicates records with the same "v_products_model". When I check table zen_products, there are only 14 unique of those products_model!

What could cause this?

Kevin205:

When I export Model/Price/Qty (PriceQTY-EP) through EP4; it pulls 14 duplicates records with the same "v_products_model". When I check table zen_products, there are only 14 unique of those products_model!

What could cause this?

Without reviewing the code for tht specific query, if the product(s) are linked then this is the likely cause. That would not be identifiable from looking at the product(s) table.

mc12345678:

Without reviewing the code for tht specific query, if the product(s) are linked then this is the likely cause. That would not be identifiable from looking at the product(s) table.

That's it. It is pulling the additional 14 records from the linked products.

Thank you.

Kevin205:

That's it. It is pulling the additional 14 records from the linked products.

Thank you.

Glad to help. It does raise the question of if there is any value in the query returning all linked products/if there is enough information available in the query response to modify it to return a distinct result?

That said, for uploading, you can keep the entire list of duplicates present, just realize that the last entry is the one that will "stick". Not ideal for processing time, but the microseconds involved and the additional queries to the database, mmay be shorter in time than the editing/filtering involved on each export.

I created custom text fields using phpMyAdmin. I added the field names under Admin>Configuration Management>Easy Populate 4>user Defined Fields making sure to include a comma without any spaces between each field name. I then went through the steps to import the data from the newly created fields. EP 4.0 indicated that all of the records were updated without any errors; but, when I went into phpMyAdmin to confirm, I discovered that none of the custom data was imported. What am I missing?

FoodSourceDirect:

I created custom text fields using phpMyAdmin. I added the field names under Admin>Configuration Management>Easy Populate 4>user Defined Fields making sure to include a comma without any spaces between each field name. I then went through the steps to import the data from the newly created fields. EP 4.0 indicated that all of the records were updated without any errors; but, when I went into phpMyAdmin to confirm, I discovered that none of the custom data was imported. What am I missing?

1. Into which table(s) were custom fields entered?
2. When populating the configuration field was the v_ incorrectly included or was it correctly removed. Ie. products_id (correct) instead of v_products_id (incorrect)
3. Which import/export type was performed? (Btw, the field(s) should also export if all things are correct for the applicable data dump.)

mc12345678:

If you are trying to export an additional field that is located in your products table and you are using EasyPopulate ver 4, that is not the way to do it. If you look in the admin panel, configuration, Easy Populate 4. There is a custom field text box. In that text box, enter the field name which appears to be products_price_w. Then on export/import that field will populatein both directions. If you need more than one field added, then separate the field(s) with a comma.

Thank you. I went to admin panel > config > EP and added products_price_w. It worked perfectly :)

nesum18:

Thank you. I went to admin panel > config > EP and added products_price_w. It worked perfectly :)

Glad that worked out for you! And thank you for reporting back.

Hi MC:

I imported the data into the product table.
The "v_" was not included.
I used the FULL-EP template. The CSV file that I created and used was formated ( a ##############) of the FULL-EP "Complete Products (with Metatags)" under "Product & Pricing Export/Import Options:"

I have included a screenshot of the user defined fields as entered in the 1.5.3 ZC Configuration and a screenshot of the the fields as named and listed in the database. Not sure what is the best format to use, therefore I chose "TEXT" as the field type; since, all I am trying to do is provide additional product information for each product. BTW. I was able to successfully install TPP 1.10. I thought that I would import the data from the custom data fields and then try to figure out how to get TPP to show the custom product field data in tabs. So I need to figure out what I am doing wrong.

AJ

mc12345678:

1. Into which table(s) were custom fields entered?
2. When populating the configuration field was the v_ incorrectly included or was it correctly removed. Ie. products_id (correct) instead of v_products_id (incorrect)
3. Which import/export type was performed? (Btw, the field(s) should also export if all things are correct for the applicable data dump.)

FoodSourceDirect:

Hi MC:

I imported the data into the product table.
The "v_" was not included.
I used the FULL-EP template. The CSV file that I created and used was formated ( a ##############) of the FULL-EP "Complete Products (with Metatags)" under "Product & Pricing Export/Import Options:"

I have included a screenshot of the user defined fields as entered in the 1.5.3 ZC Configuration and a screenshot of the the fields as named and listed in the database. Not sure what is the best format to use, therefore I chose "TEXT" as the field type; since, all I am trying to do is provide additional product information for each product. BTW. I was able to successfully install TPP 1.10. I thought that I would import the data from the custom data fields and then try to figure out how to get TPP to show the custom product field data in tabs. So I need to figure out what I am doing wrong.

AJ

Okay, so two things still, after adding some datato atleast one product through whatever means you have (say myphpadmin) try exporting the data, modifying what needs to be then importing it again.

In parallel with that, what is the filename that you have for your current import file? (Don't need the path, just the filenaame.)

Here is the file info:

Added a new "test" product through the ZC Admin>Catalog. Exported the file using EP 4.0. I noticed that all the fields exported including the user defined / custom product fields but they were empty. Yet they are listed under Tools>Easy Populate 4.0.

I noticed that the information that I entered in one of the custom product fields of the test product that I created actually imported. (I entered the data into the custom product field using phpMyAdmin.)

mc12345678:

Okay, so two things still, after adding some datato atleast one product through whatever means you have (say myphpadmin) try exporting the data, modifying what needs to be then importing it again.

In parallel with that, what is the filename that you have for your current import file? (Don't need the path, just the filenaame.)

FoodSourceDirect:

Here is the file info:

Added a new "test" product through the ZC Admin>Catalog. Exported the file using EP 4.0. I noticed that all the fields exported including the user defined / custom product fields but they were empty. Yet they are listed under Tools>Easy Populate 4.0.

I noticed that the information that I entered in one of the custom product fields of the test product that I created actually imported. (I entered the data into the custom product field using phpMyAdmin.)

Been a while since I have looked through the various exceptions, but as provided that filename is not the format expected by EP4 to process the records into the database. Take note of the filename format of the exported file. When you said that one "imported" from what was entered in myphpadmin, did you mean that one exported? (From database to the csv file.)

Hi MC:

This is weird. I looked at the file that I exported from Easy Populate 4.0 and noticed that a v_ was inserted at the beginning of each of the column header names of the custom product fields. Did phpMyAdmin do that or did Easy Populate? Could that be the problem.?

FoodSourceDirect:

Hi MC:

This is weird. I looked at the file that I exported from Easy Populate 4.0 and noticed that a v_ was inserted at the beginning of each of the column header names of the custom product fields. Did phpMyAdmin do that or did Easy Populate? Could that be the problem.?

The headings of the exported csv file are prepended with v_ and that same prefix is expected upon upload. Unfortunately, those that become familiar with that information, tend to also include it in the customized list. So there is no problem that it exists in the csv file and is an indication that the code is processing.

Still unsure if your issue has been resolved. The only other thing I can think of at the moment if it hasn't is that the database manipulated in myphpadmin is not the same as referenced in the admin/EP4 which wouldn't be unheard of when bouncing back and forth between the variious locations.

Attachment #14450Yes. I typed information into the "product_information" custom product field from within phpMyAdmin. Then under Product & Pricing Export / Import Options, I chose Complete Products with Metatags to export my products. A look at the exported file revealed that the data that was typed using phpMyadmin was exported.

**
Product & Pricing Export/Import Options:

**Complete Products** (with Metatags)

**The attachment is very interesting.

FoodSourceDirect:

Attachment #14450Yes. I typed information into the "product_information" custom product field from within phpMyAdmin. Then under Product & Pricing Export / Import Options, I chose Complete Products with Metatags to export my products. A look at the exported file revealed that the data that was typed using phpMyadmin was exported.

**
Product & Pricing Export/Import Options:

**Complete Products** (with Metatags)

**The attachment is very interesting.

Interesting indeed, (if I was able to open it). I highly suggest you rename your admin directory right now. It is included in the posted link. :/

mc12345678:

Interesting indeed, (if I was able to open it). I highly suggest you rename your admin directory right now. It is included in the posted link. :/

Hi MC:

Something you said gave me a tip. I changed the beginning of the name of my csv file from FULL to Full and pre-pended the custom product field names in my csv file I created with "v_", redid the upload and it worked... Thanks