EasyPopulate 4.0 Support Thread

[Kevin205]

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.

[mc12345678]

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.

[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?

[mc12345678]

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.)

[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

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]

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.)

[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.)

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.)