EasyPopulate 4.0 Support Thread

[mc12345678]

Thank you for your help. I have just a handful of linked products of about 18K products.

I went to User Defined Products Fields field in admin->configuration->Easy Populate 4 and entered the field name master_categories_id. When I went back to easy populate I noticed a new file 210 in size called Values-EP2015Mar08-084448.csv.

When I download Complete Products (with Metatags) I get the message "an error occurred while processing this directive". Tried to reload and I have 2 different size easy populate files. I am guessing that is because of the file size.

The Export URI with Prod and or Cat setting worked great! I was able to download the text file with URLs.

So, a little confused, but...

Are there any unresolved issues at this time? Do you still get an error when using the Download Complete Products (with Metatags)?
Files do not just get randomly created, so how did Values-EP2015Mar08-084448.csv get created? (Notice the filename includes a timestamp basically.. So should be able to closely figure out the issue.)

If an error occurred when selecting the Complete Products (with Metatags) link, a debug file should have been created in your download files section of EP4... Please post/provide the contents of that file except do not expose your admin directory.

Yes size reports the filesize, the two different files should also have two different filenames...

But really trying to ensure to identify any issues with the base product. I just installed it on a ZC 1.5.3 system and hadn't come across any unexpected issues yet..

[keith z]

Are there any unresolved issues at this time? Yes I still need to remove the unwanted linked items in the product category list.

Do you still get an error when using the Download Complete Products (with Metatags)? Yes the same error message comes up but I can download the file just fine if I use the browser back button.

Files do not just get randomly created, so how did Values-EP2015Mar08-084448.csv get created? (Notice the filename includes a timestamp basically.. So should be able to closely figure out the issue.) Don't know what to do with this file. Here is the text of the file Values-EP2015Mar08-084448.csv:

v_products_options_values_id v_language_id v_products_options_values_name v_products_options_values_sort_order
0 1 TEXT 0
1 1 http://home1/my domain.com/download/C_8752_8752KFT_-_2M-70988-E 10

If an error occurred when selecting the Complete Products (with Metatags) link, a debug file should have been created in your download files section of EP4... Please post/provide the contents of that file except do not expose your admin directory. - NO debug file is present.

Yes size reports the filesize, the two different files should also have two different filenames... Yes

[mc12345678]

Are there any unresolved issues at this time? Yes I still need to remove the unwanted linked items in the product category list.

So if you know what category the linked product(s) are to stay in, then I think there is even a SQL query back a few pages to address removing the product from the linked category, otherwise, the first thing to do is to make sure that the product's master_categories_id is set to a value that the product is expected to remain under, then to remove the product from the category(ies) (products_to_categories table) that it is not supposed to be related.

Do you still get an error when using the Download Complete Products (with Metatags)? Yes the same error message comes up but I can download the file just fine if I use the browser back button.

If an error occurred when selecting the Complete Products (with Metatags) link, a debug file should have been created in your download files section of EP4... Please post/provide the contents of that file except do not expose your admin directory. - NO debug file is present.

Confused... When is the error identified? Please read the questions carefully and respond appropriately. Is an error generated when selecting: Complete Products (with Metatags), or when selecting: Download?
If the error is from selecting: Download, then the following more than likely applies:
Okay, so this is when clicking on the file to actually download it, not to generate the file so that it can be clicked on to download... More than likely as reported recently, the temporary file that is being used is in a sub-directory not in the admin folder... The instructions suggest pointing the temporary directory (download directory) into the admin folder, and further identifies that when the folder is in the admin directory that the .htaccess file for the admin directory may need some modification to permit download of the csv from the menu. (File download would always be possible via ftp, though that also complicates things a little.)

Files do not just get randomly created, so how did Values-EP2015Mar08-084448.csv get created? (Notice the filename includes a timestamp basically.. So should be able to closely figure out the issue.) Don't know what to do with this file. Here is the text of the file Values-EP2015Mar08-084448.csv:

v_products_options_values_id v_language_id v_products_options_values_name v_products_options_values_sort_order
0 1 TEXT 0
1 1 http://home1/my domain.com/download/C_8752_8752KFT_-_2M-70988-E 10

This file basically can be used to identify the sort order of the option values that are provided.. It's use is fairly limited and is basically for viewing only as the screen of EP4 indicates... If you don't need the file(s) anymore it/they can be deleted, though the above issue of where the folder is located may need to be addressed...

[mc12345678]

So if you know what category the linked product(s) are to stay in, then I think there is even a SQL query back a few pages to address removing the product from the linked category, otherwise, the first thing to do is to make sure that the product's master_categories_id is set to a value that the product is expected to remain under, then to remove the product from the category(ies) (products_to_categories table) that it is not supposed to be related.

Not sure how familiar you are with phpmyadmin, but the following sql would identify any product that is listed in two or more categories:

SELECT ptc. * , p.master_categories_id AS mci
FROM  `prefix_products_to_categories` ptc,  `prefix_products` p
WHERE p.products_id = ptc.products_id
AND p.master_categories_id != ptc.categories_id

where prefix_ should be replaced with whatever DB_PREFIX is in your includes/configure.php file... If the DB_PREFIX is '' then simply remove prefix_ leaving behind all the rest...

Once more information is known about either which product(s) to keep or which category(is) are to be untouched, then the above can be modified... Suggestion is to continue using the above as a SELECT query until the result(s) identify the row(s) that are to be deleted... Then substitute everything up to the FROM statement with DELETE so that it would read DELETE FROM...

[mc12345678]

Not sure how familiar you are with phpmyadmin, but the following sql would identify any product that is listed in two or more categories:

SELECT ptc. * , p.master_categories_id AS mci
FROM  `prefix_products_to_categories` ptc,  `prefix_products` p
WHERE p.products_id = ptc.products_id
AND p.master_categories_id != ptc.categories_id

where prefix_ should be replaced with whatever DB_PREFIX is in your includes/configure.php file... If the DB_PREFIX is '' then simply remove prefix_ leaving behind all the rest...

Once more information is known about either which product(s) to keep or which category(is) are to be untouched, then the above can be modified... Suggestion is to continue using the above as a SELECT query until the result(s) identify the row(s) that are to be deleted... BACKUP FIRST----->Then substitute everything up to the FROM statement with DELETE so that it would read DELETE FROM...

Added a cautionary note... The database should be saved before running such a delete query, just in case...

[hivtop]

what I'm using:
zen-cart-v1.5.4-12302014
EasyPopulate-4.0-master
Minimum Order
MSRP_Display_1_for_ZC_4
responsive_sheffield_blue_2.0.templete

ALL was working Great for about 8 months, I've done 2-3 updates per month of almost 4,000 products with this Great Addon.... did a major update of products from a downloaded csv file via EP4 with openoffice cal...

Problem is... On some, only parts of the product descriptions were updated.. most died mid word.. there are NO special characters, No html coding in some that dies and even ones that worked before didn't work this time...

any hints where to start looking for a fix would be Greatly appreciated...

William

Remember if it's not fun, Don't do it...

[mc12345678]

Although stated that using easypopulate-4.0-master, that doesn't provide the version number associated with the install which could be important in relation to what is happening.

My guess though from the provided information is that when importing the single file that contains what looks like ~4,000 rows of data, is that the import timed out and only what had been transferred to that point survived/was written. When such an issue occurs there are several options made available by the software (though some servers may not support all built in options). For one, the import file can be split at a pre-determined number of rows per file. (this is one that is an option that is not so server dependent). The timeout period can be extended for EP4 as well as for ZC; however, some server configurations may not respect the request to extend those durations.

The other possibility is that the content of these descriptions includes characters (however non-special they may be) that need to be escaped such as quoted content. Or perhaps as experienced above the file was not saved as utf8 and therefore some of the character codes while not exactly "special" were incompatible with the character set used by EP4.

Then there is the debug.txt file that may exist in the EP4 file storage directory. If it is present, then at some point since it was last removed there was a problem with an import file. Recommendation would be to download it for temporary keeping, delete the file from the server and attempt to import a "trouble" file and see if it gets generated again. If so, then address that issue.

As to version information again, when in the tools->EP4 window the upper left area should identify a version number. Please provide that for information.