Easy Populate 1.2.5.4 support

[notageek]

Hi. I uploaded by FTP my test cart developed on my WAMP server for Zen Cart version 1.3.9f. Easy Populate 1.2.5.4 was in the cart, and some test products were in the cart. However, the products disappeared, and when I first tried to use Easy Populate to import products, it prompted me to install. I pressed the install link it offered and a message stated it installed successfully.

I tried to import products but was unsuccessful. However, after a period of time, the product categories showed up in my Zen Cart online, but with no products. At time of the failed install, Easy Populate had stated:

New Product Failed. SQL error. Check Easy Populate error log in uploads directory.

First, after checking for hours for the location of the uploads directory and what it actually meant to check that directory, I found that under Admin>Configuration>Easy Populate, there is a menu that names the Uploads Directory as "temp"; the admin screen gave the option to edit the name of the uploads directory.

I went to my online temp directory by going by FTP to my www/temp directory, and downloading the file called "ep_debug_log.txt" to my computer and opening the file in my wordprocessing program.

Now, I have the following error message repeated for days and days of uploads:

[QUOTE]
MySQL error 1054: Unknown column 'p.products_UPS' in 'field list'
When executing:
SELECT
p.products_id as v_products_id,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_price as v_products_price,
p.products_UPS as v_products_UPC,
p.products_ISBN as v_products_ISBN,
p.products_weight as v_products_weight,
p.products_date_added as v_date_added,
p.products_date_available as v_date_avail,
p.products_tax_class_id as v_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
subc.categories_id as v_categories_id
FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
p.products_model = 'CDASK101' AND
ptoc.categories_id = subc.categories_id
</QUOTE>

There is one of these messages for each of the 6 products in my test upload, with the second to last line changing for the product number for each product.

The heading on my spreadsheet correctly states v_products_UPC, not UPS.

1. Where could this "UPS" be coming from?

2. In trying to make Easy Populate work, I installed the .sql patch for Easy Populate, and it created a duplicate "Easy Populate" in my Admin>Configuration>list, although it then recognized it would be a duplicate entry and stopped itself from installing.

How may I remove the empty Easy Populate listing in Configuration? I find no extra line in the configuration table in PHPMyAdmin to delete.

3. Thank you to Dr. Byte who pointed out to someone in this forum the $ in the price column, which keeps reappearing in my tables. Also, thanks to Dr. Byte for pointing out that the numerals 0, 1, and 9 are used for inactive, active, and delete status. I find my product source uses the word Active, and am changing that as a precaution for making Easy Populate work, although it worked in my test server.

Notageek

[elkbow]

notageek,

Try this:

Go back and delete all the files you installed for EP and reinstall this version 1.2.5.4 from here.



http://www.zen-cart.com/archived_con...s/admin-tools/

Make sure it's 1.2.5.4 you use. It's more stable.

[notageek]

Thanks, elkbow. I'll give that a try. I am using 1.2.5.4, and it does work fine on my WAMP test server.

I just have no clue how it could suddenly seem to mistake UPC for UPS in the error message:

MySQL error 1054: Unknown column 'p.products_UPS' in 'field list'
When executing:
SELECT
. . . .
p.products_UPS as v_products_UPC,
. . . .

That seems such a wild deviation that it seems correct to uninstall and reinstall. I will let you know what happens.

Notageek

[notageek]

Hi. I tried to reinstall easy populate 1.2.5.4 but have been unsuccessful.

I initially removed each easy populate file from my site. I then went into PHPMyAdmin and removed the easy populate file from the configuration_group and configuration tables.

I reinstalled by FTP. I checked Configuration, and it still showed a duplicate entry for easypopulate, one of which gave the admin screen and the other of which had no admin screen.

I checked my PHPMyAdmin tables and there was no easypopulate file in either the configuration_group or configuration table, so I went ahead and installed the sql patch, via the upload method. That apparently worked, but gave me the following error:

1062 Duplicate entry 'EASYPOPULATE_CONFIG_TEMP_DIR' for key 2
in:
[INSERT INTO zc_configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL), ('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', last_insert_id(), '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'), ('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, NULL), ('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large uploads (default: 300).', last_insert_id(), '3', NULL, now(), NULL, NULL), ('', 'Maximum Category Depth', 'EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS', '7', 'Maximum depth of categories required for your store. Is the number of category columns in downloaded file (default: 7).', last_insert_id(), '4', NULL, now(), NULL, NULL), ('', 'Upload/Download Prices Include Tax', 'EASYPOPULATE_CONFIG_PRICE_INC_TAX', 'false', 'Choose to include or exclude tax, depending on how you manage prices outside of Zen Cart.', last_insert_id(), '5', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Make Zero Qty Products Inactive', 'EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE', 'false', 'When uploading, make the status Inactive for products with zero qty (default: false).', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Smart Tags Replacement of Newlines', 'EASYPOPULATE_CONFIG_SMART_TAGS', 'true', 'Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).', last_insert_id(), '7', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Advanced Smart Tags', 'EASYPOPULATE_CONFIG_ADV_SMART_TAGS', 'false', 'Allow the use of complex regular expressions to format descriptions, making headings bold, add bullets, etc. Configuration is in ADMIN/easypopulate.php (default: false).', last_insert_id(), '8', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'), ('', 'Debug Logging', 'EASYPOPULATE_CONFIG_DEBUG_LOGGING', 'true', 'Allow Easy Populate to generate an error log on errors only (default: true)', last_insert_id(), '9', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Consequently, there are no easypopulate tables in my SQL database, but I have the duplicate "easypopulate" listing in my configuration menu, and can go to the uploads directory.

Is there a way to remove the second appearance of easypopulate in my configuration listing? Of course, easy populate is correctly listed separately under tools, but this is just an empty title under the top configuration list in admin. Maybe this is what is causing the "duplicate entry."

Thanks for any comments.

Notageek

[elkbow]

notageek,

I need to ask you where you are getting that SQL statement?

When EP is uploaded to your server, you will get a note at the top of the page under your administration/tools/Easy Populate.
It will ask you to install EP.

As per install instructions NOTE #5:

5) Go to Admin -> Tools -> Easy Populate. If prompted to install Easy Populate, click on the
link provided. Otherwise, type in your browser address bar ?langer=install after /easypopulate.php
(eg. YOUR_ADMIN/easypopulate.php?langer=install). If you wish to remove and re-install the default
config settings, type ?langer=remove after /easypopulate.php
(eg. YOUR_ADMIN/easypopulate.php?langer=remove) and begin this step again.

There should not be any reason to install a SQL. Also I only have Easy Populate in the database at "configuration_group".

There is no EP in the configuration table on my systems.

Let me know

[outeredge2]

notageek,

I need to ask you where you are getting that SQL statement?

When EP is uploaded to your server, you will get a note at the top of the page under your administration/tools/Easy Populate.
It will ask you to install EP.

As per install instructions NOTE #5:

5) Go to Admin -> Tools -> Easy Populate. If prompted to install Easy Populate, click on the
link provided. Otherwise, type in your browser address bar ?langer=install after /easypopulate.php
(eg. YOUR_ADMIN/easypopulate.php?langer=install). If you wish to remove and re-install the default
config settings, type ?langer=remove after /easypopulate.php
(eg. YOUR_ADMIN/easypopulate.php?langer=remove) and begin this step again.

There should not be any reason to install a SQL. Also I only have Easy Populate in the database at "configuration_group".

There is no EP in the configuration table on my systems.

Let me know

Elkbow & Notageek,

From what I can tell that is not correct. You may need to install the SQL patch (and I belive it says to copy and paste the text instead of doing a search and upload). It is easier for the system.

'** If for some reason the config install fails, you can upload the SQL file provided using Admin -> Tools -> Install SQL Patches' (This is under the Important section on the instructions, the last point)

As for where EP is located. EP should apear in 2 sections if correctly installed, admin/configure and admin/tools. Well I should put it that on all of my stores this is where it shows up.

Admin/configure is where you will be able to change any settings you need.
Admin/tools is where you go to do your uploading and changes when using a txt file.

Hope that helps.

[notageek]

Elkbow,

Where did the SQL statement occur?

The 1062 error message occurred after I uploaded the install.sql this second time on its own blank screen.

Previously when I was receiving the failed upload message I uploaded the install.sql. That is when I first received the 1062 error and also the second title "easy populate" appeared under admin/configuration, but did not have a menu page, whereas the first one had the admin menu that states you can edit and change the name of the uploads directory, etc.

Was there an install message?

I looked for an install message, but found none or must have missed it. I completely missed trying the browser approach to install. I also missed trying to "remove the default configuration settings" by typing the remove message into the browser. I guess I should have tried that as well.

What was in my PHPMyAdmin tables?

In my WAMP setup, my configuration_group table has a group number for Easy Populate of 31; when I enter that value as the group number in a search on the configuration table, it lists the following entries:

configuration_key configuration_value
EASYPOPULATE_CONFIG_TEMP_DIR temp/
EASYPOPULATE_CONFIG_FILE_DATE_FORMAT m-d-y
EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME 09:00:00
EASYPOPULATE_CONFIG_SPLIT_MAX 300
EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS 7
EASYPOPULATE_CONFIG_PRICE_INC_TAX false
EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE false
EASYPOPULATE_CONFIG_SMART_TAGS true
EASYPOPULATE_CONFIG_ADV_SMART_TAGS false
EASYPOPULATE_CONFIG_DEBUG_LOGGING true

It was my understanding that putting these in the configuration table is what makes a menu available in the admin>configuration menu. That's what was accomplished with my define_main_page_lower module being placed there.

It looks like I should remove everything and try to reinstall again. I must have forgotten to check to see if the removal of everything removed the double entry in the config>admin menu, and then put it back when I performed the install.sql upload.

Thanks for your comments and for looking at this.

Notageek

[notageek]

Elkbow,

You will be pleased to hear that my Easy Populate successfully imported my 6 test products after the last fix.

However, I now have 3 easy populate titles listed under admin>configuration. I would dearly love to eliminate the two extra appearances, but am afraid to try the langer remove command in the browser.

I suppose I could just ignore them. Apparently the second one didn't disappear when I uninstalled, and the third one appeared the second time I ran the install.sql. I hope to understand this some day.

No tables have appeared in my PHPMyAdmin for Easy Populate. Somehow, I miss those tables. Were they completely non-functional?

Notageek

[JimmyV]

p.products_UPS as v_products_UPC,

Notageek you have a typo in the original file causing the problem the above statement should read on or other not combo

p.products_UPC as v_products_UPC

or

p.products_UPS as v_products_UPS

That is why you are getting conflicts those tables don't go together

[elkbow]

Outeredge2 & notageek:

From what I can tell that is not correct. You may need to install the SQL patch (and I belive it says to copy and paste the text instead of doing a search and upload). It is easier for the system.

The above statement I find to have never used:::

first this is 1.2.5.4 from Langer. The most simple form of Easy Populate. This is not 1.2.4.6, or 7, or what ever.

The instructions for 1.2.5.4 clearly state this. Plus in 9 carts I have running I have never needed to upload a SQL statement for Easy Populate. The install function appears at the top of the page when tools/Easy Populate is opened.

Here are the instructions:

1) Change the name of the "admin" directory in this package to suit your zencart installation
2) The temp folder is configured to reside in your store directory. If you store is not in the
site root (eg. /mystore/) then the temp directory must also go in this directory.
3) If you want to re-name the uploads (temp) folder, ensure that you configure Easy Populate to
reflect this change after installation
4) Upload all files in their respective directories.
5) Go to Admin -> Tools -> Easy Populate. If prompted to install Easy Populate, click on the
link provided. Otherwise, type in your browser address bar ?langer=install after /easypopulate.php
(eg. YOUR_ADMIN/easypopulate.php?langer=install). If you wish to remove and re-install the default
config settings, type ?langer=remove after /easypopulate.php
(eg. YOUR_ADMIN/easypopulate.php?langer=remove) and begin this step again.
6) Go to Admin -> Configuration -> Easy Populate, and configure the upload directory if you have
changed it from default. Also, ensure that the correct date format is set for your upload files.
7) If this mod gives you more time with your family or friends, and/or less customer headaches, please
consider a donation to paypal AT portability DOT com DOT au to ensure this module is continually supported and improved