EasyPopulate 4.0 Support Thread

So first thing is that the product (at least as shown in this one record) does not have a products_model assigned to it. Not a requirement in all situations, but in a default install, products_model is the primary key. Blank means don't do anything with it. Appears would be good to have notification of that situation/issue.

So... what can be done to at least restore the product? Go back to the original state of the database and as far as EP4 is concerned, adjust the configuration settings to use the primary key of products_id. Then export the product within that category to use that data for recreation of the product to have the exact same products_id that it previously had. NOTE this is one place where care and understanding about the condition and status of the destination database must be taken and known. You don't want to also mess up a product that already exists.

Now, as to the true "recreation" of the category (which appears to be the original intent), will also need to export category files in addition to the product files provided above.

The process followed so far is expected to simply create the place holder for the category. But the category will have nothing really in it. No category description for example. Further, because there are at least two languages involved, will want to be sure that the appropriate information is carried in each of the languages within the category...

Thank you for your quick reply! Setting the primary key to product_id makes everything work as expected. I will have to check whether problems arise with existing product_ids. Not sure whether ID's are recycled, but if not there should not be a problem because the source DB is a backup of the destination DB. I will continue on this tomorrow.

Thank you for the tip about recreation of the categories too. I didn't figure that would be necessary.

v1.5.7b PHP7.3 Easy Populate 4.0.36.ZC (mc12345678 version)

I have 1 issue below, as well as one question below.

I am receiving similar myDEBUG errors as the one indicated on previous page relating to line 661 - thrown when generating a Full EP request - the file is produced no problem at all so it appears it is not detrimental to function - my error however refers to a number of instances and different line numbers as per example below (truncated the error log - it continues further alternately with errors in line 655 and 651 - so is the fix the same for the different lines as it is for 661?;

[16-Feb-2021 17:00:09 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/dazzlers/easypopulate_4.php:281]
#2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 281.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE1 - assumed 'ORDERSEXPORT_LINK_SAVE1' (this will throw an Error in a future version of PHP) in /dazzlers/easypopulate_4.php on line 605.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE1B - assumed 'ORDERSEXPORT_LINK_SAVE1B' (this will throw an Error in a future version of PHP) in /dazzlers/easypopulate_4.php on line 606.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE2 - assumed 'ORDERSEXPORT_LINK_SAVE2' (this will throw an Error in a future version of PHP) in /dazzlers/easypopulate_4.php on line 607.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE3 - assumed 'ORDERSEXPORT_LINK_SAVE3' (this will throw an Error in a future version of PHP) in /dazzlers/easypopulate_4.php on line 608.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/dazzlers/easypopulate_4.php:655]
#2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 655.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/dazzlers/easypopulate_4.php:661]
#2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 661.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/dazzlers/easypopulate_4.php:655]
#2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 655.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/dazzlers/easypopulate_4.php:661]
#2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 661.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/dazzlers/easypopulate_4.php:655]
#2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 655.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /dazzlers/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/dazzlers/easypopulate_4.php:661]
#2 require(/dazzlers/easypopulate_4.php) called at [/dazzlers/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /dazzlers/easypopulate_4.php on line 661.

QUESTION

Can this plugin produce the complete url for images rather than the shortened version (e.g. earrings/clip-on-earrings-527.jpg is produced but needs to be https://www.dazzlerscliponearrings.com.au/images/earrings/clip-on-earrings-527.jpg) this is required so I can create a Google Merchant Center feed - if it can, then how can I make any mods to get this result?

cheers,
Mike

mc12345678:

Problem is... the current github version of admin/easypopulate_4.php doesn't contain the word sizeof which in the previous report of the issue was identified as being on line 661...

Line 661 currently reads:

<?php That's all.

mc12345678:

Macht nichts. Sie sollten der Software von: https://github.com/mc12345678/EasyPopulate-4.0 benutzen. Es gibt ein versionnen autocheck, Sie deaktivieren muessten. Normalerweisse, hat webchills information daran.

shags38:

v1.5.7b PHP7.3 Easy Populate 4.0.36.ZC (mc12345678 version)

I have 1 issue below, as well as one question below.

I am receiving similar myDEBUG errors as the one indicated on previous page relating to line 661 - thrown when generating a Full EP request - the file is produced no problem at all so it appears it is not detrimental to function - my error however refers to a number of instances and different line numbers as per example below (truncated the error log - it continues further alternately with errors in line 655 and 651 - so is the fix the same for the different lines as it is for 661?;

[16-Feb-2021 17:00:09 Australia/Sydney] Request URI: /admn/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/admin/easypopulate_4.php:281]
#2 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /admin/easypopulate_4.php on line 281.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE1 - assumed 'ORDERSEXPORT_LINK_SAVE1' (this will throw an Error in a future version of PHP) in /admin/easypopulate_4.php on line 605.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE1B - assumed 'ORDERSEXPORT_LINK_SAVE1B' (this will throw an Error in a future version of PHP) in /admin/easypopulate_4.php on line 606.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE2 - assumed 'ORDERSEXPORT_LINK_SAVE2' (this will throw an Error in a future version of PHP) in /admin/easypopulate_4.php on line 607.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE3 - assumed 'ORDERSEXPORT_LINK_SAVE3' (this will throw an Error in a future version of PHP) in /admin/easypopulate_4.php on line 608.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/admin/easypopulate_4.php:655]
#2 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /admin/easypopulate_4.php on line 655.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/admin/easypopulate_4.php:661]
#2 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /admin/easypopulate_4.php on line 661.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/admin/easypopulate_4.php:655]
#2 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /admin/easypopulate_4.php on line 655.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/admin/easypopulate_4.php:661]
#2 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /admin/easypopulate_4.php on line 661.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/admin/easypopulate_4.php:655]
#2 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /admin/easypopulate_4.php on line 655.

[16-Feb-2021 17:00:10 Australia/Sydney] Request URI: /admin/index.php?cmd=easypopulate_4, IP address: 121.45.84.235
#1 sizeof() called at [/admin/easypopulate_4.php:661]
#2 require(/admin/easypopulate_4.php) called at [/admin/index.php:11]
--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /admin/easypopulate_4.php on line 661.

> 
> **QUESTION**
> 
> Can this plugin produce the complete url for images rather than the shortened version (e.g. earrings/clip-on-earrings-527.jpg is produced but needs to be https://www.dazzlerscliponearrings.com.au/images/earrings/clip-on-earrings-527.jpg) this is required so I can create a Google Merchant Center feed - if it can, then how can I make any mods to get this result?
> 
> cheers,
> Mike
Please see the first sentence of the above first post, then please follow the link in the second post (yes, written in what I would say is broken German as I seriously doubt it had all of the correct grammar and words).

As to the full path to images, the question would be does it need to be autogenerated to have that or could it be generated after download as part of providing the file to the associated service?

Currently, there is not a full auto-generation step in the code, but it could be incorporated. Recommendation would be to produce an additional field in the file so that the data of the original field could still be properly used. 

Ohh, and lastly, would recommend changing the folder name for your admin and as necessary/appropriate may need to do the same in your store's .htaccess if you have generated one and it contains the current admin folder name in it.

mc12345678:

Please see the first sentence of the above first post, then please follow the link in the second post (yes, written in what I would say is broken German as I seriously doubt it had all of the correct grammar and words).

As to the full path to images, the question would be does it need to be autogenerated to have that or could it be generated after download as part of providing the file to the associated service?

Currently, there is not a full auto-generation step in the code, but it could be incorporated. Recommendation would be to produce an additional field in the file so that the data of the original field could still be properly used.

Ohh, and lastly, would recommend changing the folder name for your admin and as necessary/appropriate may need to do the same in your store's .htaccess if you have generated one and it contains the current admin folder name in it.

Your broken German is a lot better than mine :smile: I went to your GitHub and downloaded your latest version - thanks for that.

So your post encouraged me to research how I could add the 'prefix' of the first section of the url to make the image url complete - perservered and found a solution on StackOverflow - so I learned something very valuable - so no need for the full url to be generated by the plugin for just this purpose.

cheers,
Mike

p.s. hopefully others may find this useful - how to add full url to generated 'part' image url

here is the process I used in the original download Excel file;

1. select all cells in column with image url
2. in Home go to 'format cells' in graphic at top towards the far right
3. click for dropdown box to show then click format cells in drop down box
4. in box that appears click on custom
5. at RH site in the empty box below the word 'type' simply type the full url minus the part that is already generated in this format "https ://www.your_full_ url_ segement_ to_ADD_ to_generated_product_url"****@ - (url segment in " followed by @ - no space) and click OK
6. that code should now be in all entries making a complete url - that code will remain in 'custom' for future use

for OpenOffice Calc

1. select all cells in column with image url
2. in menu tabs select 'format cells'
3. in box that appears on LH side click User Defined
4. in the empty box near the bottom simply type the full url minus the part that is already generated in this format "https ://www.your_full_ url_ segement_ to_ADD_ to_generated_product_url"****@ - (url segment in " followed by @ - no space) ... then click OK
5. that code should now be in all entries making a complete url - that code will remain in 'user defined' for future use (note that when used again it will automatically show up as 'text' but you need to scroll up and select 'user defined' then click OK (otherwise it simply adds text and not in the right format)

shags38:

Your broken German is a lot better than mine :smile: I went to your GitHub and downloaded your latest version - thanks for that.

So your post encouraged me to research how I could add the 'prefix' of the first section of the url to make the image url complete - perservered and found a solution on StackOverflow - so I learned something very valuable - so no need for the full url to be generated by the plugin for just this purpose.

cheers,
Mike

p.s. hopefully others may find this useful - how to add full url to generated 'part' image url

here is the process I used in the original download Excel file;

1. select all cells in column with image url
2. in Home go to 'format cells' in graphic at top towards the far right
3. click for dropdown box to show then click format cells in drop down box
4. in box that appears click on custom
5. at RH site in the empty box below the word 'type' simply type the full url minus the part that is already generated in this format "https ://www.your_full_ url_ segement_ to_ADD_ to_generated_product_url"****@ - (url segment in " followed by @ - no space) and click OK
6. that code should now be in all entries making a complete url - that code will remain in 'custom' for future use

for OpenOffice Calc

1. select all cells in column with image url
2. in menu tabs select 'format cells'
3. in box that appears on LH side click User Defined
4. in the empty box near the bottom simply type the full url minus the part that is already generated in this format "https ://www.your_full_ url_ segement_ to_ADD_ to_generated_product_url"****@ - (url segment in " followed by @ - no space) ... then click OK
5. that code should now be in all entries making a complete url - that code will remain in 'user defined' for future use (note that when used again it will automatically show up as 'text' but you need to scroll up and select 'user defined' then click OK (otherwise it simply adds text and not in the right format)

Did your export file have anything populated in the v_products_url_1 field? I notice it looks like your sites use one of the SEO urls .... do you use Ultimate?

shrimp-gumbo-mmmhhh:

Did your export file have anything populated in the v_products_url_1 field? I notice it looks like your sites use one of the SEO urls .... do you use Ultimate?

Note that v_products_url_1 has nothing to do with a site having a URI rewriter. That field represents the uri that one chooses to have displayed with the product and is a field that is manually entered in the product's information page. Further that field is language dependent meaning one could provide a link to an english version of a site page for when displaying english or whatever page is desired for each other language supported by the site...

As far as export of the uri generated by a rewriter, if it uses zen_href_link to generate the uri, then it should be possible to retrieve the current uri when exporting the associated data while the configuration switch is turned on. The switch is to provide the uri for the product/category.

Again, short answer, all sites have the availability of v_products_url_, not just those with a uri rewriter. A uri rewriter will not force content to exist in that field. Further, remember that a field that ends with an underscore and a number represents a field that is language dependent and that the number represents the language_id for that language.

Thank you for the explanation!

Line #605 : "orders-full-ep"=>ORDERSEXPORT_LINK_SAVE1,

Line #606 : "orders-fullb-ep"=>ORDERSEXPORT_LINK_SAVE1B,

Line #607 : "orders-noattribs-ep"=>ORDERSEXPORT_LINK_SAVE2,

Line #608 : "orders-onlyAttribs-ep"=>ORDERSEXPORT_LINK_SAVE3

I am getting: --> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE3 - assumed 'ORDERSEXPORT_LINK_SAVE3' (this will throw an Error in a future version of PHP)
for these variables.... when I do a search through the ZC code I do not see them being called or used elsewhere.... do you think I could assign them some nominal value just to get them to not give a warning without something breaking?

--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /home/account/public_html/admin/easypopulate_4.php on line 655.

It looks like $files is an array so why is it still getting the warning?

    if ($dirhandle = opendir($upload_dir)) {
      $files = array();



          for ($i = 0; $i < sizeof($files);

okay, maybe the constant errors would be fixed by putting those in the

/home/account/public_html/admin/includes/languages/english/easypopulate_4.php

????

shrimp-gumbo-mmmhhh:

Line #605 : "orders-full-ep"=>ORDERSEXPORT_LINK_SAVE1,

Line #606 : "orders-fullb-ep"=>ORDERSEXPORT_LINK_SAVE1B,

Line #607 : "orders-noattribs-ep"=>ORDERSEXPORT_LINK_SAVE2,

Line #608 : "orders-onlyAttribs-ep"=>ORDERSEXPORT_LINK_SAVE3

I am getting: --> PHP Warning: Use of undefined constant ORDERSEXPORT_LINK_SAVE3 - assumed 'ORDERSEXPORT_LINK_SAVE3' (this will throw an Error in a future version of PHP)
for these variables.... when I do a search through the ZC code I do not see them being called or used elsewhere.... do you think I could assign them some nominal value just to get them to not give a warning without something breaking?

--> PHP Warning: sizeof(): Parameter must be an array or an object that implements Countable in /home/account/public_html/admin/easypopulate_4.php on line 655.

It looks like $files is an array so why is it still getting the warning?

    if ($dirhandle = opendir($upload_dir)) {
      $files = array();



          for ($i = 0; $i < sizeof($files);

shrimp-gumbo-mmmhhh:

okay, maybe the constant errors would be fixed by putting those in the

/home/account/public_html/admin/includes/languages/english/easypopulate_4.php

????

Looks like not using the version updated on github (have a few minor things to complete so that all language dependent imports will support the language designation (_en) instead of the old method of language_id "_1"). The location is: https://github.com/mc12345678/EasyPopulate-4.0. None of the described issues occur in that version.

Thank you! Will pull from there.

Just an update. Changed Specials Price to Null and the other error messages I received are gone. Works Great!

Updated records: 467
New Imported records: 35726
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 152789664
Memory Peak: 153206360
Execution Time: 574 seconds.

Would I be able to have these records load in more than just a second layer directory structure? Meaning could I have a main> posters> super heros> batman and have all those categories created on the load?

Thank you!

shrimp-gumbo-mmmhhh:

Just an update. Changed Specials Price to Null and the other error messages I received are gone. Works Great!

Updated records: 467
New Imported records: 35726
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 152789664
Memory Peak: 153206360
Execution Time: 574 seconds.

Would I be able to have these records load in more than just a second layer directory structure? Meaning could I have a main> posters> super heros> batman and have all those categories created on the load?

Thank you!
If your question is: is it possible to upload a product to a category structure that doesn't already exist and if so, does it matter how deep the category structure is? Then the answer is yes it is possible and no it doesn't really matter how deep. I mean, I'm sure there is some super long text iimitation...

For your category structure, the field: v_category_name_1
Would contain: main^posters^super heroes^batman if the first category is called main, a sub-category off of there being posters that has a sub-category of super heroes that has a sub-category of batman. Now.... NOTE capitalization, extra spaces and any other characters between each carat (^) are used in evaluating the category relationship. So Batman is different from batman from BATMAN. This is something covered in the readme.

Note also that when a category is created it has an empty description until the associated category data is imported.

I have found a couple of issues.

1. If not able to insert into the products table then a csv file should be created of items that were not able to be inserted. There should also be a note noting number of products issues in the outcome note and noting file to look at.
2. If not able to insert into the products_description then the record should be deleted from products and a csv file should be created of items that were not able to be inserted. There should also be a note noting number of products_description issues in the outcome note and noting file to look at.
3. If not able to insert into the meta_tags_products_description is not able to be inserted into then a csv file should be created of items not loaded meta_tags to be worked on. There should also be a note noting number of meta_tag issues in the outcome note and noting file to look at.

Thank you!

shrimp-gumbo-mmmhhh:

I have found a couple of issues.

1. If not able to insert into the products table then a csv file should be created of items that were not able to be inserted. There should also be a note noting number of products issues in the outcome note and noting file to look at.
2. If not able to insert into the products_description then the record should be deleted from products and a csv file should be created of items that were not able to be inserted. There should also be a note noting number of products_description issues in the outcome note and noting file to look at.
3. If not able to insert into the meta_tags_products_description is not able to be inserted into then a csv file should be created of items not loaded meta_tags to be worked on. There should also be a note noting number of meta_tag issues in the outcome note and noting file to look at.

Thank you!
Did you happen to scroll down the screen after performing an import?

To what file(s) are you referring when stating "noting file to look at"? At the completion of each import, there is some level of information provided. If an "insert" fails, that basically is a problem with the data that has been provided which for the most part likely can not be identified as "successful" or flagged for failure... Meaning, one may have to identify what has been successful to identify what didn't work.

As far some of the processes, it is possible that a message is not provided for one or another issues, for example I know that on a product import where products_model is the primary key, if the products_model field for a row is blank, there is no notification about any issue... Is it a problem? I say no, but that's because an empty products_model in that situation is expected and supposed to be skipped... I state some of that to try to further identify the expectational differences between early and experienced users.

mc12345678:

Did you happen to scroll down the screen after performing an import?

To what file(s) are you referring when stating "noting file to look at"? At the completion of each import, there is some level of information provided. If an "insert" fails, that basically is a problem with the data that has been provided which for the most part likely can not be identified as "successful" or flagged for failure... Meaning, one may have to identify what has been successful to identify what didn't work.

As far some of the processes, it is possible that a message is not provided for one or another issues, for example I know that on a product import where products_model is the primary key, if the products_model field for a row is blank, there is no notification about any issue... Is it a problem? I say no, but that's because an empty products_model in that situation is expected and supposed to be skipped... I state some of that to try to further identify the expectational differences between early and experienced users.

Thanks for your work on this. I realize this is not a paid job and these are just my suggestions for whosoever may want to update this module to make it more excellent.

Hello, yes I did scroll down the screen but this should really be spit out into a file with success and fail notices for each product.

"noting file to look at" if there was a file that contained those errors (it does not currently exists).

Hmmm... you cannot test to see if a sql insert was successful or not? Sorry, so easy to do with languages I have worked with just thought it would be easy in php also.

Thank you for having this working for us currently!

shrimp-gumbo-mmmhhh:

Thanks for your work on this. I realize this is not a paid job and these are just my suggestions for whosoever may want to update this module to make it more excellent.

Hello, yes I did scroll down the screen but this should really be spit out into a file with success and fail notices for each product.

"noting file to look at" if there was a file that contained those errors (it does not currently exists).

Hmmm... you cannot test to see if a sql insert was successful or not? Sorry, so easy to do with languages I have worked with just thought it would be easy in php also.

Thank you for having this working for us currently!
What is the setting you have under configuration->Easy Populate 4->'Debug Logging'? Has it been changed from the default of true?

If it is still set to true, then look at your list of files under 'This contains any other file. They will be processed like a full data file.' (The word They changes to this if there is only one file)

If there were "sql" errors while importing the data then there should be a file "ep_debug_log.txt" in that list. In that file is the query/queries that caused errors. Based on the associated information, the issue(s) should be locatable.

As far as logging the text that appears below the list of files, that is something that can be done using the EP4 function: write_debug_log_4($string) where $string is the text to be logged into the debug log.

So for example in admin/easypopulate_4.php towards the end where:
echo $display_output;
is present, then could add:

write_debug_log_4($display_output);

If want to make it dependent on the debug logging setting from above, then:

      if (EASYPOPULATE_4_CONFIG_DEBUG_LOGGING === 'true') {
        write_debug_log_4($display_output);
      }

May also then want to incorporate the 'specials' data within the area below that with:

      if (strlen($specials_print) > strlen(EASYPOPULATE_4_SPECIALS_HEADING)) {
        echo '<br />' . $specials_print . EASYPOPULATE_4_SPECIALS_FOOTER; // specials summary
        if ((EASYPOPULATE_4_CONFIG_DEBUG_LOGGING === 'true') {
          write_debug_log_4($specials_print . EASYPOPULATE_4_SPECIALS_FOOTER);
        }
      }

Remember this is open source so you can do with it what you will and while it has been made available for free download/use, it doesn't mean that there hasn't been some sort of funding by someone to someone at some time. Thankfully Chad Deruski did an outstanding job many years ago with development of so many features and options. As I understand it was developed to support his line of work and then at some point made available for others. He still makes an appearance once in a while.

Note though that you will need to clear that debug file periodically to prevent eating drive space.

Oh and as far as "testing" the SQL, sure two additional lines and some other potential "switch" could be added to the query in the extra_functions file, to perform a transaction that gets reverted, or explained, or an alternate store could be used/tested rather than one's live store (this is a preferred situation so that zero damage is done to one's live store).

I have a question about deleting products. My client does not use model numbers, so I've got the "Import/Export Primary Key" set to "blank_new".

In my csv:
v_products_model is left empty
v_products_id is 326001
v_status is 9

When importing this file, I get: NOT FOUND! - Model: 326001 - cant delete...

I tried setting "Import/Export Primary Key" to "products_id" and got the same thing.

I don't understand why it doesn't delete the product with 326001 as the id. I did confirm the product exists by looking in the database.

jeking:

I have a question about deleting products. My client does not use model numbers, so I've got the "Import/Export Primary Key" set to "blank_new".

In my csv:
v_products_model is left empty
v_products_id is 326001
v_status is 9

When importing this file, I get: NOT FOUND! - Model: 326001 - cant delete...

I tried setting "Import/Export Primary Key" to "products_id" and got the same thing.

I don't understand why it doesn't delete the product with 326001 as the id. I did confirm the product exists by looking in the database.
Good question, looks like may need some more information. Seems that the code being used may be a little dated, there had been an update to revise the text response to indicate the primary key setting (in this case would expect to see 'v_products_id' instead of - Model). Sure the update is/was in the language files to an extent, but...

So, information that may further help now that I've looked over the current processing "plan".

• Version number (and/or date downloaded) identified with the software?
• Any observer(s) listening to EP4_IMPORT_FILE_EARLY_ROW_PROCESSING that may have modified what could then be the global variable $continueNextRow to be set to a falsey value?
• Is debug logging turned on in the configuration settings? If so (default) then there should be some record in the generated debug .txt log in the EP4 main screen towards the "bottom" of the list of files. That is unless the admin/includes/functions/extra_functions/easypopulate_4_functions.php is old enough (pre Oct 3, 2016) to still have the typo of write_debug_log($string) instead of write_debug_log_4($string).
• Is there more than one product being deleted in the file, and does at least one other product delete successfully (presumably an earlier listed product)? For that matter is there more than one row of data in the file other than the header row?