EasyPopulate 4.0 Support Thread

mc12345678:

Ahh, okay I think (and am still trying looking into it) that the salemaker issue was resolved in 4.0.31, but there is still a minor issue or two to post to that. Meanwhile I have 4.0.32 prepped, but I want to test it a little more before publishing. Have a few different things going on and don't want to negatively impact any users...

Hmm... Took a quick look at 4.0.31 and maybe the one thing missing is the longstanding error in the import file that there is one occurrence of $v_manufactureres (notice that misspelt) which occurs at the admin log entry line (1020) for when the manufacturers (notice correctly spelt) name is updated.. This is something that has existed since the first inclusion of the ZC 1.5.4 functionality... Only caught in the last month or so... 10-11 months of not being noticed...

There are a few other minor things (do not affect functionality) that would be nice to include there, but they are in 4.0.32 which is as I said just around the corner...

I am using zen cart 1.5.1.

I have uploaded the easypopulate 4.0. If I upload the extras for 1.5 my admin crashes. If I leave it off the site stays up.

When I try to upload I get a blank white screen. I am trying to upload a download product listing from another zen cart 1.5.4 that I have.

The database tables in 1.5.1 all start wtih zen_, for 1.5.4 they all start with zc_. I believe this is the problem, does anyone agree?

dspeak35640:

I am using zen cart 1.5.1.

I have uploaded the easypopulate 4.0. If I upload the extras for 1.5 my admin crashes. If I leave it off the site stays up.

When I try to upload I get a blank white screen. I am trying to upload a download product listing from another zen cart 1.5.4 that I have.

The database tables in 1.5.1 all start wtih zen_, for 1.5.4 they all start with zc_. I believe this is the problem, does anyone agree?

The database prefix does not affect EP4, a blank screen wiill generate a log file, check your /logs directory for myDEBUG files. http://www.zen-cart.com/content.php?124-blank-page Post the most recent but obscure your admin directory path. The extras folder for the admin loads a definition to allow the menu option to appear on your admin panel.

What else do you have installed on this system? Please include the answers to the posting tips questions.

Thanks for quick reply.

Nothing else installed, this is a clean installation.

Here is the log file:

[22-Dec-2015 14:38:09 America/Phoenix] PHP Fatal error: Call to undefined function zen_record_admin_activity() in /home/content/XX/XXXXXXX/html/XXXadminXXXXXX/easypopulate_4_import.php on line 976

Thanks again.

dspeak35640:

Thanks for quick reply.

Nothing else installed, this is a clean installation.

Here is the log file:

[22-Dec-2015 14:38:09 America/Phoenix] PHP Fatal error: Call to undefined function zen_record_admin_activity() in /home/content/XX/XXXXXXX/html/XXXadminXXXXXX/easypopulate_4_import.php on line 976

Thanks again.

Still need more info: version of EP4, PHP.

Missing at least one file: admin/includes/auto_loaders/config.zc154_compatibility.php

Or possibly:
Includes/init_includes/init_zc154_compatibility.php

Or the file(s) look like they are there, but not fully loaded/stored.

Hi there,

I am new to both Zen Cart and Easy Populate 4. I have installed EP4 which is working fine, however when i attempt to download a selected file via Zen Cart 1.5.4 i get "404 (Page Not Found) Error". When i look in my admin/temp folder (which is assigned in the configuration) the file is there and i can download it from my file browser.

John

allmart:

Hi there,

I am new to both Zen Cart and Easy Populate 4. I have installed EP4 which is working fine, however when i attempt to download a selected file via Zen Cart 1.5.4 i get "404 (Page Not Found) Error". When i look in my admin/temp folder (which is assigned in the configuration) the file is there and i can download it from my file browser.

John

When you say you can download from your browser, but at the same time that you receive a 404 error, could you please elaborate or explain the difference? As for your settings. If the configuration option was set to use the admin directory, then all that is needed for the path is to enter the subdirectory within the admin directory. No where should the admin directory need to be typed in. Which means if I were to ask for the information that is typed into the temp folder text box, the only path information that should be present in that box is related to temp.

allmart:

Hi there,

I am new to both Zen Cart and Easy Populate 4. I have installed EP4 which is working fine, however when i attempt to download a selected file via Zen Cart 1.5.4 i get "404 (Page Not Found) Error". When i look in my admin/temp folder (which is assigned in the configuration) the file is there and i can download it from my file browser.

John

mc12345678:

When you say you can download from your browser, but at the same time that you receive a 404 error, could you please elaborate or explain the difference? As for your settings. If the configuration option was set to use the admin directory, then all that is needed for the path is to enter the subdirectory within the admin directory. No where should the admin directory need to be typed in. Which means if I were to ask for the information that is typed into the temp folder text box, the only path information that should be present in that box is related to temp.

@allmart, I'm still interested in addressing the issue, but need to understand what it is (if it still is occurring). Haven't heard anything back, so would you mind clarifying the issue, identifying what was done to resolve it, and if not resolved perhaps can assist with resolution/prevention? Would really appreciate the feedback.

Uploaded EP4 4.0.32 to https://github.com/mc12345678/EasyPopulate-4.0, with download available from here.

One "issue" identified in trying to make it possible to import the categories/categoriesmeta files without all columns/fields included that if the description field of the applicable file is not included then a SQL error is expected at this time. I realize this is probably the field most desired to be removed if any are, but in developing that code, it looked "too easy". :) a better/appropriate process used for or similar to the products description needs to be incorporated.

Welcome testing and identification of other issues.

Change log:
4.0.32 02-08-2016. Updated for PHP 7.0 compatibility.
Corrected use of verifying that constant is in use and needs to be defined.
Completed incorporation of the German Language version of EP4 which allows for
EP4 to now be translated to other languages. Assistance always welcome!
Converted from storing web page data via $_GET to $_POST operations. Retrieval of files
is still by $_GET when selecting the download link(s) as well as links to generate
new files to modify unless the dropdowns at the top of the screen are used. This
also was a change away from using $_REQUEST to $_POST offering stricter
control of data transport.
Added checks in files that are "required" to validate that the file is being run from within
ZC by verification of a constant being defined.
Incorporated numerous notifiers to support expandability. (A BookX addon is in development by a
third party andwill be looked at for easy incorporation to minimize the effort of it
and other plugins being incorporated.)
Transitioned import queries to using bindVars to minimize errors that introduced by adding to the
code and to better handle the data being imported. This is also in support of packaging
EP4 as a downloadable plugin on the zen cart site.
Revised the Product Description table modification process for updates allowing any of the fields
or a combination of any of the fields to not be included in the update file, though the
base fields necessary would be the products_id (internally identified if not directly
provided), and the language_id which is identified off of the languages installed to ZC.
This also made improvements to the use of the short product description that was added
by chadd.
Added ep4_curly_quotes operations to several of the import fields.
Updated the sql install to clarify the areas affected by some of the settings.
Modified how categories were updated somewhat similar to how products/products Description
were affected; however, it does appear that additional work is necessary with that section
unfortunately as absence of the categories_description with the categories_name in place
will cause a SQL error because of an extra comma before the WHERE statement. :/
Similar process for category metatags was incorporated and has the same issue as categories and needs
to incorporate the processing added to product description updating to prevent a SQL error
if metatags_description is not included in the import.
Corrected an existing issue with short description for products that did not properly account for
a language identifier.
Moved additional file for ZC 1.5.x into the main file path instead of being an additional file/folder
with which to contend. Software remains functional on pre-1.5.x with appropriate action taken
to install that version's needed file(s).
Generated a module file to support the filelayout instead of having it within an additional function
file as a function. This was to support adequate incorporation of notifiers without making
the functions file a class of its own and other work arounds.

Okay, have corrected this:

One "issue" identified in trying to make it possible to import the categories/categoriesmeta files without all columns/fields included that if the description field of the applicable file is not included then a SQL error is expected at this time. I realize this is probably the field most desired to be removed if any are, but in developing that code, it looked "too easy". :) a better/appropriate process used for or similar to the products description needs to be incorporated.

Still welcome testing of the updates and identification of any issues.

Sorry but i am new at this and would hope for your consideration.
I am using ZC 1.5.4 and EP4 latest version. I am able to import and export the product_upc field but can't figure how to display it in my products/catalog page. i was successful with Group pricing.

Thanks,

Sorry for not getting back to you sooner. To clarify, the problem that i have is when i access the tools-EP4 in Zen Cart...after a csv file is created either by import or export, i have the option to to split/import/delete or download file, if i select the latter (download) i receive a 404 error with the correct address of the file in my temp folder displayed in the browser window. However i am able to open the file with my FTP in the exact same location. Although it is indicated that "page not found", it is clearly visible and accessible through FTP in my temp folder.

allmart:

Sorry but i am new at this and would hope for your consideration.
I am using ZC 1.5.4 and EP4 latest version. I am able to import and export the product_upc field but can't figure how to display it in my products/catalog page. i was successful with Group pricing.

Thanks,

Good to hear that in and out is working. Does help to identify the specific version to which you are referring. (For immediate assistance and for others in the future reviewing the thread for similar "issues").

The products_upc field is something that is added to the products table by some other process... EP4 allows updating/modifying it because it recognizes that it is in the database. Because 1) that field is not something created by EP4, 2) it was added by some other process/program, and 3) that there is no issue with interfacing it using this plugin. Technically it is something to address elsewhere in the forum. (The plugin that added the field, or a new thread.) But, that's no reason to not at least provide some more info to possibly be directed elsewhere.

Am curious about which version of EP4 is in use to validate operation.

allmart:

Sorry for not getting back to you sooner. To clarify, the problem that i have is when i access the tools-EP4 in Zen Cart...after a csv file is created either by import or export, i have the option to to split/import/delete or download file, if i select the latter (download) i receive a 404 error with the correct address of the file in my temp folder displayed in the browser window. However i am able to open the file with my FTP in the exact same location. Although it is indicated that "page not found", it is clearly visible and accessible through FTP in my temp folder.

Ohh, that's ok (time between). That is because csv (and as necessary) txt files are not by ZC default files permitted to be accessed by the uri. The installation instructions indicate that the .htaccess file would need to be modified/created to support that.

For example, in the admin directory (if the files are stored somewhere off of the admin directory) there is an .htaccess file that contains the following line:
[CODE][<FilesMatch "(?i).*.(php|js|css|html?|ico|otf|jpe?g|gif|webp|png|swf|flv|xml|xsl)$">/CODE]
In ZC 1.5.4 anyways.

This line needs to be updated to include csv and txt (or better to duplicate the .htaccess file to the new directory and have only csv and txt referenced) to allow download of those files from the browser.

So it could become:
[CODE][<FilesMatch "(?i).*.(php|js|css|html?|ico|otf|jpe?g|gif|webp|png|swf|flv|xml|xsl|csv|txt)$">/CODE]
If so changed in the admin file, then all sub-directories that "use" that file will also be permitted to access csv and txt files... It is this reason that for "security" sake, that only the applicable folder should have those permissions.

That help?

Thank you for your prompt reply and solution...Problem solved!!!

EP4 version is 4.0.32, any direction to resolution is appreciated.

allmart:

Thank you for your prompt reply and solution...Problem solved!!!

allmart:

EP4 version is 4.0.32, any direction to resolution is appreciated.

Is there anything still needed to resolve? Sequence of posts suggests no and yes, respectfully. :)

Thanks for your help, I have yet to learn how to implement a UPC field to display in my admin product/category page and in the description of product on it's web page but that is not an EP4 issue and will search elsewhere.

Thanks again

allmart:

Thanks for your help, I have yet to learn how to implement a UPC field to display in my admin product/category page and in the description of product on it's web page but that is not an EP4 issue and will search elsewhere.

Thanks again

Numinix Product Fields might help, it may also come with more than desired/needed, but that's what a development site is for so that you can try something and make adjustments/modifications to get it "right".

Or there is:
UPC/ISBN Product Fields

And other options appear by searching the plugins on UPC...

After reading all this thread because I am working with EP 4.0 again after a couple of years. I am trying to do exactly what the other poster is wanting (make my defined fields show up) .. Think I will try to the Numunix Plugin thanks for pulling me out of a fog :-)

It did, however bring back what is now a fond memory (nightmare then). Back when I was adding code like mad to OSCommerce.. oh yes, many moon ago! I came upon a young EP, and I needed extra fields and I needed them to show. I wrote all the code in the templates for it to display and everything. Man am I getting lazy these days! ... LOL.. Just thought I would share.