EasyPopulate 4.0 Support Thread

mrcastle:

My apologies, the answer is within the ZenCart posts but I didn't understand it the first time through. For anyone else trying to do the same thing, you select the category, and then use copy function. At the bottom of the screen you will see a "multiple categories link manager". As a suggestion, perhaps it might be easier to find this feature under the tools menu ? Anyways, it is a very clever app and (once you understand it) and it works without any problems. For myself, I was able to move hundreds of items into new categories just by entering the current category number and then the new category number to replace it with. As always, make SURE you backup your database using the backup wizard.

Yes, there is more than one way to accomplish something. That particular additional tool is accessible off of at least the tools/area of copying a product, when in the attributes controller with a product within a category "shown", or in the products price manager (found in the catalog menu).

Specifically to your issue if all product in question existed only in the miscellaneous and in the designated composer folder, then delete all rows in the file that had the miscellaneous category. Enter 7 in the products status field in the first row, copy that down to the end of the data, save the file (suggest modifying text towards the end so that still have the original file) upload and then import, would have been done. But glad that you found a way that didn't take too much time.

Can I do this https://www.zen-cart.com/showthread.php?222332-Solution-For-Product-Attributes-In-Shoe-Store-With-Bulk-Products through the help of easy populate? Thank you for the advice.

aurum.genesis:

Can I do this https://www.zen-cart.com/showthread.php?222332-Solution-For-Product-Attributes-In-Shoe-Store-With-Bulk-Products through the help of easy populate? Thank you for the advice.

Yes, but I suggest working with EP4 (or any such software) in a test environment first to understand what is needed and how it works. The hardest part of using EP4 is working with whatever editor to save the file in a suitable UTF-8 CSV format. EP4 simply provides the doorway between the database and the data file.

A couple of things would be needed/needed to be done to accomplish the described task: product added to store, attributes made to exist in the store and detailed information applied to all of those.

Take a moment to read through the instructions. There are a lot more concepts than just press button, watch action that are described.

I had a hard drive crash so I am installing zen cart with EasyPopulate 4.0 for some reason it will not import the csv file that I have as a backup (it was created by EasyPopulate 4.0 file name Full-EP2017Apr01-050757.csv).

I have one product and category in the database right now . Don't know if it's a file permission thing or what.

output from EP4....
header message: File Import Completed.

bottom of page message:
Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 4057016
Memory Peak: 4876000
Execution Time: 0.00025701522827148 seconds.

database not changed..

if someone could point me in the right direction I would be great full there is 1500 products to setup

Could you please provide the header row, the first row of data and the language information that is on the right side of the tools menu identifying the language number(s) applied to each language and as well the version of EP4 installed?

first the csv file was made by ep4 (exported) so everything there is right... silly me figured out that it was firewalld stopping things from working right... Lol fixed it and all 1500 products were imported without a problem...

I LOVE THIS ADDON!!!!!!!!!!!!!!!!!!!!!!!!!!!

hivtop:

first the csv file was made by ep4 (exported) so everything there is right... silly me figured out that it was firewalld stopping things from working right... Lol fixed it and all 1500 products were imported without a problem...

I LOVE THIS ADDON!!!!!!!!!!!!!!!!!!!!!!!!!!!
Glad that it got sorted out. Understandable that it was exported by EP4 and would be expected to import, but there are a few things that could have been different between the old database and "rebuilt" one that could have possibly caused an issue or at least warranted further review/discussion. :) but, alas it was something else. :)

Happy zenning!

Hi, I have a problem when I import a CSV-file using "EasyPopulate 4 Master", and I want to download the file, I get following error message:.
"Forbidden
You don't have permission to access /admin/temp/Full-EP2017Jun20-205456.csv on this server.
Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request."

Is it a server problem at my Webhost, or am I just doing something wrong?

I have installed Easy Populate many times in Zen Cart, and I have never had this problem before.
I do have to admit, that I am not sure if I have installed it correct, but no matter what, if I have installed it correct or not, I still never had the problem before, but by some reason I get the error now.
I would appreciate if someone could let me know if I have done the installation correct or not please, and if I have done it wrong, how should I do it then please?

The way I have installed it, is following:
I uploaded the unzipped content from the Admin floder to the Admin folder on the server, and i installed it in Admin, as it tell me to do. I created an empty "temp" folder in Admin at the server. I am not sure about the .htaccess file. I've tried to place it in the created "temp" folder, and I have also tried not to upload it at all. No matter if it is in the "temp" folder or not, the CSV-files get importet to my "temp" folder. Before I could also download the CSV-files to my computer without any problem, but now I get the error message.
I would appreciate very much if someone would take the time, and help me out with this problem please.

pubaolao:

Hi, I have a problem when I import a CSV-file using "EasyPopulate 4 Master", and I want to download the file, I get following error message:.
"Forbidden
You don't have permission to access /admin/temp/Full-EP2017Jun20-205456.csv on this server.
Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request."

Is it a server problem at my Webhost, or am I just doing something wrong?

I have installed Easy Populate many times in Zen Cart, and I have never had this problem before.
I do have to admit, that I am not sure if I have installed it correct, but no matter what, if I have installed it correct or not, I still never had the problem before, but by some reason I get the error now.
I would appreciate if someone could let me know if I have done the installation correct or not please, and if I have done it wrong, how should I do it then please?

The way I have installed it, is following:
I uploaded the unzipped content from the Admin floder to the Admin folder on the server, and i installed it in Admin, as it tell me to do. I created an empty "temp" folder in Admin at the server. I am not sure about the .htaccess file. I've tried to place it in the created "temp" folder, and I have also tried not to upload it at all. No matter if it is in the "temp" folder or not, the CSV-files get importet to my "temp" folder. Before I could also download the CSV-files to my computer without any problem, but now I get the error message.
I would appreciate very much if someone would take the time, and help me out with this problem please.

The .htaccess file that is included in: htaccess4AdminTempFolder should alleviate that issue. Because the temp folder is within the admin, and the admin .htaccess does not specifically permit .csv files to be downloaded, something needs to be added to permit that operation. Instead of the entire admin being able to access the .csv files, only the folder that contains the generated CSV files needs to have that permission and the included .htaccess file in that folder should permit that.

If it does not specifically resolve the issue, then model the commands within it similar to what is provided in your admin directory. The goal is to allow csv and txt files to be downloadable.

pubaolao:

Hi, I have a problem when I import a CSV-file using "EasyPopulate 4 Master", and I want to download the file, I get following error message:.
"Forbidden
You don't have permission to access /admin/temp/Full-EP2017Jun20-205456.csv on this server.

3 things to check.

1. Admin -> Configuration -> Easy Populate 4: Uploads Directory

• make sure it shows: temp/

2. /admin/temp/

• make sure permissions are 755 for the 'temp' dir.

3 /admin/temp/.htaccess file

• add the following at the bottom

# allow access to just *certain* necessary files:
<FilesMatch "(?i).*\.(csv|CSV|txt|TXT)$">
  <IfModule mod_authz_core.c>
    Require all granted
  </IfModule>
  <IfModule !mod_authz_core.c>
    Order Allow,Deny
    Allow from all
  </IfModule>
</FilesMatch>

I am using Zencart 1.5.5e with Easy Populate 4.0.36.ZC - 07-05-2016

I am trying to add attributes using the Detailed products attributes file, but I keep getting this error: > SKIPPED! - Attribute Entry on : - Not Found!

Here are the first two lines of my csv file:

v_products_attributes_id v_products_id v_products_model v_options_id v_products_options_name v_products_options_type v_options_values_id v_products_options_values_name v_options_values_price v_price_prefix v_products_options_sort_order v_product_attribute_is_free v_products_attributes_weight v_products_attributes_weight_prefix v_attributes_display_only v_attributes_default v_attributes_discounted v_attributes_image v_attributes_price_base_included v_attributes_price_onetime v_attributes_price_factor v_attributes_price_factor_offset v_attributes_price_factor_onetime v_attributes_price_factor_onetime_offset v_attributes_qty_prices v_attributes_qty_prices_onetime v_attributes_price_words v_attributes_price_words_free v_attributes_price_letters v_attributes_price_letters_free v_attributes_required v_products_attributes_filename v_products_attributes_maxdays v_products_attributes_maxcount
3699 331 EV101-11 1 Choose a Standard Phrase (Free) 0 1 I Love You 0 2 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0

I have named my file > Attrib-Detailed-EP-options.csv

The other half of the problem is that if I name the file anything else, it uploads and imports, but DOES NOT follow the option sort order that I entered. EP does it's own thing and assigns default sort orders on it's own. That is my main issue actually. Getting the default sort orders that I entered into the csv file to take hold.

wtashby:

I am using Zencart 1.5.5e with Easy Populate 4.0.36.ZC - 07-05-2016

I am trying to add attributes using the Detailed products attributes file, but I keep getting this error:

Here are the first two lines of my csv file:

I have named my file

The other half of the problem is that if I name the file anything else, it uploads and imports, but DOES NOT follow the option sort order that I entered. EP does it's own thing and assigns default sort orders on it's own. That is my main issue actually. Getting the default sort orders that I entered into the csv file to take hold.

Couple of things. Where's the commas within the csv file, though based on the success of the import/upload by renaming (meaning that the file will likely be treated as a full import type file) I am not being shown above the raw csv file data.

The other thing, with regards to the options_id, options_values_id, products_id, and products_attributes_id, where did these values come from for this and/or the other product in your file?

What is the setting for your primary key?

Do this version full support UTF8 and non-English?

Since I am using easy populate CSV, but download the csv open at Excel 2013, all Chinese text are "Monstor" Word ...

explorer1979:

Do this version full support UTF8 and non-English?

Since I am using easy populate CSV, but download the csv open at Excel 2013, all Chinese text are "Monstor" Word ...

Short answer, yes plugin supports UTF8, expects the import file to have been saved in a UTF8 format.

This module does fully support UTF8 and the only reported language to have difficulty has been Russian, otherwise there have been reports of Chinese and Japanese working. As to using Excel, well there is a "problem" with Excel in that it doesn't exactly store UTF8 formatted files (which this plugin expects). Open Office and similar programs support UTF8 file generation, but one needs to review the instructions applicable to the workbook program to be sure that the content of the generated CSV file is not technically different from the original (ie. open a file, do whatever is necessary to save the file with a different name in utf-8 format and then compare the text between any quotes to verify that the content is the same (may be single double quotes instead of double double quotes that's okay), if it is then the import should be fine.

I have seen Open Office though change a + or a - to an integer for some reason if the appropriate settings are not used when saving/exporting the content back to a csv file. That is the issue most troubling.

Hi,

I'm updating 20k+ products on a legacy site. The site is a zc139h and the client does not want an upgrade. So I downloaded and installed the latest version of EP4 a couple days ago, then hit a wall.

The problem is that zc139h uses iso-8859-1, but EP4 uses UTF8. The data on the site currently looks fine, but when exported funny characters show up ( Â ).

Converting the site to UTF8 is impractical. How hard would it be to convert EP4 to iso-8859-1?

I could revert to an early version of EP4, but I really, really need the ability to use product_id as the control.

Any thoughts would be deeply appreciated.

Feznizzle:

Hi,

I'm updating 20k+ products on a legacy site. The site is a zc139h and the client does not want an upgrade. So I downloaded and installed the latest version of EP4 a couple days ago, then hit a wall.

The problem is that zc139h uses iso-8859-1, but EP4 uses UTF8. The data on the site currently looks fine, but when exported funny characters show up ( Â ).

Converting the site to UTF8 is impractical. How hard would it be to convert EP4 to iso-8859-1?

I could revert to an early version of EP4, but I really, really need the ability to use product_id as the control.

Any thoughts would be deeply appreciated.
When say impractical to convert the site to UTF-8, not sure I follow. What has been the result of attempting to use the database converter db2utf8 on a backup of the database and the few file changes directed within?

As to a change to EP4, I believe the change needed would be in the main admin/easypopulate4.php file where the encoding is set to utf-8 and changing that to the encoding used on the site. Then when using open office following the recommended process to open and also save the file using the same encoding...

mc12345678:

When say impractical to convert the site to UTF-8, not sure I follow. What has been the result of attempting to use the database converter db2utf8 on a backup of the database and the few file changes directed within?

As to a change to EP4, I believe the change needed would be in the main admin/easypopulate4.php file where the encoding is set to utf-8 and changing that to the encoding used on the site. Then when using open office following the recommended process to open and also save the file using the same encoding...
See #28 ... before and after.

Thanks, DrByte. :)

@mc, I looked at the file and it seems changeable. Only, this line stumped me:
$zco_notifier->notify('EP4_COLLATION_UTF8_ZC13X');

Any chance you could take a look at the code and specify the changes needed?

I also found UTF-8 references (in notation) in two other EP4 files. Can that be ignored?

Feznizzle:

Thanks, DrByte. :)@mc, I looked at the file and it seems changeable. Only, this line stumped me:$zco_notifier->notify('EP4_COLLATION_UTF8_ZC13X');Any chance you could take a look at the code and specify the changes needed?I also found UTF-8 references (in notation) in two other EP4 files. Can that be ignored?That particular notifier that stumped you was added when notifiers were added to support expansion of the capability to support the bookx mod that was being developed by another zenner. It is only in "play" when being observed.Also, thank you DrByte for tieing the conversation together and not requiring reiteration. In my previous post, I HAD focussed on the database. After posting I thought about the files and other language that might have been also affected and at that time figured I would have to address it (but it was covered in that thread).Yes, can take a quick gander in a litle bit, but I think considering the situation that the change in the main file will correct the issue for this site.

Thanks, MC!

Would these changes do the trick?

if ($ep_uses_mysqli) {
  $collation = mysqli_character_set_name($db->link); // should be either latin1 or utf8
} else {
  $collation = mysql_client_encoding(); // should be either latin1 or utf8
}
if ($collation == 'latin1') {
  if (function_exists('mb_internal_encoding')) {
    mb_internal_encoding("iso-8859-1");
  }
}

if (($collation == 'latin1') && ((substr($project, 0, 5) == "1.3.8") || (substr($project, 0, 5) == "[B]1.3.9[/B]"))) {
  //mb_internal_encoding("iso-8859-1");
  $category_strlen_max = $category_strlen_max / 3;
  $categories_name_max_len = $categories_name_max_len / 3;
  $manufacturers_name_max_len = $manufacturers_name_max_len / 3;
  $products_model_max_len = $products_model_max_len / 3;
  $products_name_max_len = $products_name_max_len / 3;
  $products_url_max_len = $products_url_max_len / 3;
  $artists_name_max_len = $artists_name_max_len / 3;
  $record_company_name_max_len = $record_company_name_max_len / 3;
  $music_genre_name_max_len = $music_genre_name_max_len / 3;

  $zco_notifier->notify('EP4_COLLATION_UTF8_ZC13X');

}

Also, the reason I highlighted the reference to 1.3.9 is that the site I'm working on is a 1.3.9**h**. Should I change that as well?

Thanks again!