EasyPopulate 4.0 Support Thread

Hi Guys

Been using EasyPopulate4 for some time now and its great ! Thanks to everyone involved for making such a great add on. Currently I am running EP v4.0.24

I have ebooks on my site so its downloads mainly. I got a few small issues that you might be able to help me with.

• Firstly after I full import a product I have to go to PHPMyAdmin and get change two values in the Products table . Those are:
  products_type
  products_virtual

Is there a way to access these thru EP4 so I don't have to manually edit?

If you look below I import v_products_virtual in my first file 'Full-EP2013.csv' I don't have an entry for products_type , could this affect it or could it be a issue with priority of which other entries go first?

• Second I am having trouble with some values used for downloading.The values I am having problems with importing are:

v_products_attributes_filename
v_products_attributes_maxdays
v_products_attributes_maxcount

Normally I import new products then export the detailed attributes files and edit them manually to add these 3 values and re-import again which does work. I split off Attrib-Download-EP2013.csv values from Attrib-Detailed-EP2013.csv to try and resolve this problem with no success.

Another problem is when I import the Attrib-Detailed-EP2013.csv file the browser screen stays blank and I have to use the back button. Everything seems to import fine except for v_products_attributes_weight_prefix and v_price_prefix which should be '0' but remain empty.

Below is the 4 files I use to import new products. They are in the order I import them

Full-EP2013.csv
v_products_model
v_products_type
v_products_image
v_products_name_1
v_products_description_1
v_products_url_1
v_products_name_2
v_products_description_2
v_products_url_2
v_specials_price
v_specials_date_avail
v_specials_expires_date
v_products_price
v_products_weight
v_product_is_call
v_products_sort_order
v_products_quantity_order_min
v_products_quantity_order_units
v_products_priced_by_attribute
v_product_is_always_free_shipping
v_date_avail
v_date_added
v_products_quantity
v_manufacturers_name
v_categories_name_1
v_categories_name_2
v_tax_class_title
v_status
v_metatags_products_name_status
v_metatags_title_status
v_metatags_model_status
v_metatags_price_status
v_metatags_title_tagline_status v_metatags_title_1
v_metatags_keywords_1
v_metatags_description_1
v_metatags_title_2
v_metatags_keywords_2
v_metatags_description_2
v_products_virtual

Attrib-Basic-EP2013.csv

v_products_model
v_products_options_type
v_products_options_name_1
v_products_options_name_2
v_products_options_values_name_1
v_products_options_values_name_2

Attrib-Detailed-EP2013.csv
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

Attrib-Download-EP2013.csv

v_products_model
v_products_attributes_filename
v_products_attributes_maxdays
v_products_attributes_maxcount

Thanks in Advance for any help.

Paul :)

Going to look into some of these a little more, but hopefully some of the below will provide at least a little assistance:
In the first "question" accessing fields that are in the products table that are not by default included in the EP4 import/export. The field name as seen in the products database should be added to the configuration menu for EP4. Enter it as is, not with the v_ associated with it, so in your case:

products_type,products_virtual

The associated data will at least appear and be read from the full data import file.

Somewhat brings us to question 2:

Each product can have multiple downloads, each download is an attribute, therefore yes, downloads need to be addressed as part of the attributes information.
As for splitting the files, possible, but EP4 works off of filename (typically up to and including EP) for some of the specific imports, and Attrib-Detailed-EP is one of those. If it is desired to then add Download after that, feel free...

As for anything ZC when a program goes all white screen, the following should be considered: http://www.zen-cart.com/content.php?124-blank-page

However, I do see that in your previous files you have 2 languages in use. Option names and option values are also language dependent and I thought on export EP4 made designation of that, so while there may be some "luck" that some/all of the information is transferred, it appears that the table for the Attrib-Detailed-EPxxx is missing at least:
v_products_options_name_1
v_products_options_values_name_1
v_products_options_name_2
v_products_options_values_name_2

As always, suggest exporting a file before creating some new one from the air... Once exported, then the data can be manipulated, but that way, one knows what comes out can go back in.

So not sure if addressed all your concerns/issues or not, but definitely know that we're gather quite a bit of information to be sure to include in the instructions that are so painstaking to put together...

Thanks for the reply mc12345678

Just so you know I updated to Easy Populate 4.0.28 - Beta 01-03-2015 and will be updating Zencart to 1.5.4 over the next few days

I do recreate an import file but I use Autoit scripting to make the files. Its a batch creation thing so I write small .ini files with the PDF file describing it. After that the script does most of the details automatically . Like file size , paths , variables etc. So its not tedious and the likely hood of errors is low

First question is how do add the column names to "configuration menu for EP4." . Where is this done as I cant see to find the place.

I did find I had a duplicate name in Attributes so I did remove that but it still goes blank on the import of Attributes. I did follow your link about bank pages but found nothing obvious.

Thanks Paul

Configuration->Easy Populate 4

Then Select: User Defined Products Fields

User Defined Products Fields

Thanks once again mc12345678

Ok great the config trick worked well :)

I managed to log an error on the screen going blank. This is what happened

[13-Jan-2015 01:44:58 America/Chicago] PHP Fatal error: Function name must be a string in /home4/hasher/public_html/zencart/FakeAdmin/includes/functions/extra_functions/easypopulate_4_functions.php on line 1107

Hope this helps

I realise that probably my files I am trying to import might help. They are attached

Thanks Paul :smile:

The files being used helped tremendously, otherwise would have been a lot of guessing... Here is what I found:

in the Full-EP2015.csv file, there were/are two copies of v_products_type which, fortunately the value in both of them is the same, but if it were different on import, this could cause an issue (Once in Column B, once in column AO (or column 2 and column 41)).
Nothing seemed wrong in Attrib-Basic-EP2015.csv; however,

as stated several times recently, text such as v_products_options_name is language specific, therefore requires a language identifier in order to import... This would have been seen on an export of the same file type.

While not every language needs to be uploaded on each upload, a language identifier is needed in order to upload the file with that column and in this case, is a required column to locate the attribute in the table(s). So both of the following need at least one language identifier:

v_products_options_name and
v_products_options_values_name

to be at least:

v_products_options_name_1 and
v_products_options_values_name_1

or could be:

v_products_options_name_1 and
v_products_options_name_2 and
v_products_options_values_name_1 and
v_products_options_values_name_2

in any order, but somewhere within the detailed file.

Ok So I deleted the v_products_type in column 41 and then tried a reimport and the EP-Full file caused a blank screen . Previously it was the Detailed file that causes blanks. It also caused the Import to fail. So I moved the v_products_type (column 2) to the end (column 40) and tried an import. It went blank screen again.

I did have v_products_options_name_1 ,v_products_options_name_2 and v_products_options_values_name_1 and v_products_options_values_name_2 in the EP-Attributes-Basic file. But I since moved them into the detailed file . So now I only have 2 import files.

Will pack it in for today and get some sleep. Thanks for your help mc12345678!

Basically, and I think this is in the first post of this thread, the suggestion is to export a file using the method you would like to import. Then, using the headers from that export, make the changes/incorporate the data you want to import. Also follow the formatting for example in categories, the default code uses a carat ^ to seaparate category names in a category^sub-cat1^sub-cat2 format. This can be changed in the code to be some other

With regards to the error now importing the full file, did the custom field entry in the admin page get modified to boot?

I'm not at a computer to troubleshoot, but seeing the times involved with posting am trying to leave behind some thought nuggets.

Hey mc12345678,

I seem to be on top of most of my problems sorted . I am only having troubles with when importing price_prefix and products_attributes_weight_prefix . Here is the SQL error. My csv has '0' for each value but it doesn't import.

MySQLi error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
price_prefix = '0',
products_options_sort_order ' at line 2
When executing:
UPDATE products_attributes SET
options_values_price = ,
price_prefix = '0',
products_options_sort_order = 0,
product_attribute_is_free = 1,
products_attributes_weight = 0,
products_attributes_weight_prefix = '0',
attributes_display_only = 0,
attributes_default = 0,
attributes_discounted = 1,
attributes_image = '',
attributes_price_base_included = 1,
attributes_price_onetime = 0,
attributes_price_factor = 0,
attributes_price_factor_offset = 0,
attributes_price_factor_onetime = 0,
attributes_price_factor_onetime_offset = 0,
attributes_qty_prices = '',
attributes_qty_prices_onetime = '',
attributes_price_words = 0,
attributes_price_words_free = 0,
attributes_price_letters = 0,
attributes_price_letters_free = 0,
attributes_required = 0
WHERE (
products_attributes_id = 499 AND
products_id = 502 AND
options_id = 1 AND
options_values_id = 1)

What is the significance of using a zero instead of a +? The ZC standard price_prefix of those two is, '+, -, or blank' does a value (number not a character) of zero mean something unique in your store?, if so, then may have to look up which line(s) to change to force the conversion to use a value instead of a string...

Hi, is there a way to import products and setting in csv file Product Qty Min/Unit Mix = Yes ?

thx

solo_400:

Hi, is there a way to import products and setting in csv file Product Qty Min/Unit Mix = Yes ?

thx

Yes, by including the field header of: v_products_quantity_mixed
for each value that is to have Product Qty Min/Unit Mix set to Yes, use the numerical value 1 in that row.

A value of 0 will set it to No.

If you would like that field to be included more often, ie on each export as applicable, then in the configuration for Easy Populate, add the following into the custom field section:
products_quantity_mixed

Then on export, the current value will be included, and then on import it will also be incorporated.

I have placed column v_products_quantity_mixed using value 1 after column v_products_quantity but after the import product has Product Qty Min/Unit Mix = No

solo_400:

I have placed column v_products_quantity_mixed using value 1 after column v_products_quantity but after the import product has Product Qty Min/Unit Mix = No

Maybe should have also asked: ZC version? Try a product with a value of 0? Also was the user defined field populated as described above. If not mistaken in one ZC version change they swapped the values. I verified in zc 1.5.1 that 1 was was yes, and 0 was no. It may be reversed in an older version.

What a crack ... I don't like when I can't understand .

-My version is 1.5.0
-I tried with 0 and 1 and no change

• I got mysql under query logging
  -When I import ( in this case by updating the already imported product.. result don't change when product is new ) I can see the sql log:

UPDATE products SET
products_price = '135.9',products_image = 'xxxx/xxxxxxx.pg',
products_weight = '0',
products_discount_type = '0',
products_discount_type_from = '0',
product_is_call = '0',
products_sort_order = '0',
products_quantity_order_min = '0',
products_quantity_order_units = '0',
products_priced_by_attribute = '0',
product_is_always_free_shipping = '0',
products_tax_class_id = '1',
products_date_available = NULL,
products_date_added = '2015-01-24 00:00:00',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = '1',
manufacturers_id = '56',
products_status = '1',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = '0' WHERE (products_id = '8917')

As we can see the column products_quantity_mixed is not present on update or insert ( I have also did a general search for this field in all module's files ) action. That's why is being imported with default 0 column value.

Am I doing something wrong here ?

Have you added the field into the configuration section of Easy Populate?

Admin panel->configuration->Easy Populate 4
Towards the bottom of the selections is a menu option similar to custom fields.
Click on it and a box should appear on the right side, if it has an edit button, select the edit button, otherwise enter: products_quantity_mixed

If there is already something there, then add a comma and then products_quantity_mixed without spaces....

If anything, that right now is what has been missed or not identified as being done.

And to provide understanding. The default install does not include the field products_quantity_mixed, so yes will default to whatever the database has as a default. In this case a zero. That said, eP4 was brilliantly written (not by me) to allow adding other fields that are in the products table to be appended.... This happens through the custom fields data entered in the admin.... If you search the code for custom you can find how/where it is used....

You totally zenned me :-) Thank you, it worked.

Now I have a more serious problem:

How can I tell EP4, after each product import to generate ceon_uri_mappings links ?

my_new_product
my_new_product/reviews
my_new_product/review
my_new_product/write-a-review

Please don't tell me after new 1000 products imported one must manually go on every product and press update in order to generate ceon uri mappings links.

thx

solo_400:

You totally zenned me :-) Thank you, it worked.

Now I have a more serious problem:

How can I tell EP4, after each product import to generate ceon_uri_mappings links ?

my_new_product
my_new_product/reviews
my_new_product/review
my_new_product/write-a-review

Please don't tell me after new 1000 products imported one must manually go on every product and press update in order to generate ceon uri mappings links.

thx

Let me see if I can zennly state it. Without venturing away from this site to obtain some additional software (maybe by following a link on this post/page), it would require a manual edit/save... I think beyond that I'm not allowed to publicly discuss it much further...