EasyPopulate 4.0 Support Thread

[mc12345678]

Never assume...you know what they say. That was the issue, I had not followed the proper naming convention. When I do, it works! Imagine that.

Follow-up question. Is there a way to export/import an product with attributes in one file? As it stands, it's two steps and two files currently.

Well, it got me thinking, thought perhaps after the last issue that was discussed in the instructions and overlooked would have prompted reading the instructions.

Yes it is possible, but is it truly desireable?
Small example, table 1 has two fields. One is the primary key, the other is the data. Table 2 also has two fields, one field is the primary key, the other is a data field but that field represents rows of data. So:
T1:
f1, f2
1, x
2, y
3, z
4, w

T2:
F1, F2
1, a,b,c
2, d,e,f
3, a,b,c
4, g,h,i

Now the resulting table (spreadsheet) for combining the two:
F1(f1), f2,F2split
1, x, a
1, x, b
1, x, c
2, y, d
2, y, e
2, y, f
3, z, a
3, z, b
3, z, c
4, w, g
4, w, h
4, w, i

Now, which one of these scenarios is easier to address, understand, and not necessarily make a mistake? Also, to accomplish the same functionality as existing, every upload of the attributes would require all attributes to be included every time in their entirety otherwise the absence of an attribute row would cause deletion of that attribute. Further, on each row every piece of data would have to be compared against the applicable table(s) for existence then update or add the additional data applicable. Sure alternatively can bring information into memory and do a comparison from that perspective instead of a sql statement for each evolution with the applicable data eventually applied with an appropriate sql statement.

This particular approach becomes resource and time intensive. If you have looked back a few pages you'll see that there is an add-on to EP4 to support the product type bookx. That code takes an approach like this. The individual that worked hard to put it together. Thing is, as anticipated because of taking this "do it all at once" approach the processing is slow. At one point the thought was expressed that it is somehow ZCs fault, but it has nothing to do with ZC as one can see in review of the EP4 code EP4 more directly interfaces with mySql than it does with ZC and ZC doesn't "control" mySql, just interfaces with it.

The approach that chadderuski took in development of EP4 more closely matches the original database tables and is why such large bulk changes can be made so quickly. There is a "trade-off" of using this approach. For onsey, twosey updates, it may not be worth the effort to split the input to such simple tables and it may be more worth doing the update within ZC. But in mass quantities, EP4 is a huge savings.... just sayin'

[hamagawa]

The first time when I access .../easypopulate_4.php, it show this.


Then I edit easypopulate_4.php and remove line 100.


And the pages is working now.



What wrong actually? Any solution to solve this other than I remove line 100?
Thank you.

[mc12345678]

The first image didn't provide any useful information to diagnose the problem, but having removed the require for the language file and seeing the results of removing the language's load line, it would appear that you're missing the language file in the admin/languages/YOUR_LANGUAGE/ directory...

Also, the code could be written to check for the existence of the language file and if not found default to the English language like other aspects of ZC. I'll add that to the list of changes for the next change.

[AZComp]

I am trying to import a file I exported just to test and which I click import I just get a blank page. I have tried searching this thread but I was unabel to find a similar problem.


Install of Zen Cart and easy populate are both freshly installed yesterday

Contents of the file are as such
for some reason I cannot attach the file so sorry this is the only way I can figure how to display it.

v_products_model	v_products_type	v_products_image	v_products_name_1	v_products_description_1	v_products_url_1	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_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
RM1-1043-000B	1		RM1-1043-000B	HP LaserJet 4345mfp Fuser Assembly					0	0	0	0	1	1	0	0		4/22/2016 16:18	50		Printers & Printer Parts	--none--	1	0	0	0	0	0

Thank you in advance!

[mc12345678]

From where did you obtain the EP4 fileset?

Is the information above copied from the file itself (.csv file) or from your data sheet editor?

A blank screen should result in an error log being generated in the logs directory. Feel free to post the contents, but also be sure to obscure your admin folder name (replace with admin).

[AZComp]

I downloaded from github p[age


the error in log is

[22-Apr-2016 18:10:35 UTC] PHP Fatal error: Call to undefined function mb_strlen() in /chroot/home/azcompu1/azcomputing.co/html/XXXXX/easypopulate_4_import.php on line 950

The information is pulled from the csv file created by an export

From where did you obtain the EP4 fileset?

Is the information above copied from the file itself (.csv file) or from your data sheet editor?

A blank screen should result in an error log being generated in the logs directory. Feel free to post the contents, but also be sure to obscure your admin folder name (replace with admin).

[mc12345678]

Would that be from the page referenced in the first post of this thread? If so, good. :) I'm working on a few changes and let's me know that it is a stable version being reported.

Interesting that the last report of a mb_ related function didn't include any issue with that function, but might as well do something to address it.

If you open admin/easypopulate_4_import.php then search for:

if (mb_strlen($v_products_name[$l_id]) > $products_name_max_len) {

Replace with:

if ((function_exists('mb_strlen') && mb_strlen($v_products_name[$l_id]) > $products_name_max_len) || (!function_exists('mb_strlen') && strlen($v_products_name[$l_id]) > $products_name_max_len)) {

This way, if mb_strlen exists, the comparison will be made using a multi-byte string length function, and if not then the length will be determined by the standard strlen function.