Easy Populate 1.2.5.4 support

Thanks, Chad....I do use OO but only because I'm more familar with Excel do I use it also. However, I am transitioning to OO as each time I load (import!) my ul file into Excel Excel adds (each time) quotemarks to many of my product descriptions. After awhile it reached a point my descriptions were a mess. I searched out an application that would remove them all from my descripts (ported the descripts to Word to do this). Only problem now is I have no inch marks (quotes) at the end of my product sizes but no biggie unless I can find an app that will selectively put them back just on my dimensions. I noticed single quotes (aposthro's) will really cut a description short if they're used. Same thing applies to the product name if they're used in the name.

EZ is quite finicky about a lot of things. My entire list (2000+) wouldn't import even though EZ said it uploaded ok. Found that the fields containing the EOREOR had a leading space at the beginning of EOREOR. Once I removed that space my list ported fine.

All in all EZ is pretty cool for large product lists. Still learning all it's quirks.

Earnest,

You may want to experiment with text encoding on import into both excel and OO. They both default to different encodings. This can be a real pig-sticker if you use copywrite and trademark symbols. I use inch mark in descriptions without issue, but don't rember is I have apostrophes.

The one thing about OO is that on export of a tab-delimited file, it properly encapsulates each field. Excel with not do this, but "intelligently" skip quote encapsulation. I've seen this cause problems, but my situation may be further complicated as I am predominately working on mac these days.

Phazie's CSV version (his original, not the later mods that have problem issues) may be worth a look. It does have a bug or two like 1.2.5.4, but I found it workable.

-cj

When I first started experimenting with EZ all my product descripts had a quote at each end. I ported the list to Zen and not one descript showed (all blank). No biggie as I had just installed my store and was setting it up. All the other product attributes such as price, quantity, etc. came through fine. So quotes (inch marks) don't work for me. Neither do trademark or copyrights. I had one product containing the word "cafe" with the accent mark above the letter 'e'. All I got in Zen was the caf.... so in my case I have to be very careful in what my names and descripts contain. Using a small shareware application that does global character adding and removing in MS Word documents I just copy and paste my name and descript columns into a temporary Word document and I've been able to remove most of these types of characters quickly in a listing of over 2000 products. As an example, I just replace a quote mark with in. for inch and it works OK.

To save re-uploading all my images again if I'm playing with EZ and EZ deletes them (using the status=9 function) or I have to remove categories and products through my own EZ blunder I temporarily rename my images directories first. Example: images to tempimages, images/large to tempimages/templarge, etc. Zen admin squawks that it can't find those folders but it's only temporary. Once I'm finished with my category/product editing I rename them back to their original directory names and all my images are retained and I'm saved from FTPing them all over again.

I think I have EZ fine-tuned for my needs now, now that I understand what it accepts (and doesn't).

Rod
http://earnest-enterprises.com

Hi, i'm looking for some folks who want to more actively develop/cleanup this module? is anybody interested? You can chat with me here.http://speeqe.com/room/[email protected]/

It's just a web interface to a standard xmpp/jabber/gtalk mutliuser chat room, so feel free to join with a regular client as well.

I am currently committing to a local git repository and would love to share some of my changes with people :)

I just installed what looks like the newest version of EP 1.2.5.7b

This is the Easy Populate CSV version.

It all installed fine, and the directions dont seem to really explain how to start except to download the complete CSV file.

So I assumed one had to first click the create complete CSV file?? Upon doing this i got this error.

Quote:

---

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/fusionsp/public_html/******/easypopulate.php on line 852
Success File Full-EP2009Dec17-0909.csv successfully exported! The file is ready for download in your /tempEP/ directory.
Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

---

I looked at the log file and it shows this.

Quote:

---

MySQL error 1054: Unknown column 'p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS' 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_weight as v_products_weight,
p.products_last_modified as v_last_modified,
p.products_date_added as v_date_added,
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,
p.products_status as v_status,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status, p.EASYPOPULATE_CONFIG_CUSTOM_FIELDS as v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS FROM
products as p,
categories as subc,
products_to_categories as ptoc
WHERE
p.products_id = ptoc.products_id AND
ptoc.categories_id = subc.categories_id

---

Is this how I should have started doing the upload? If so, what does this error mean?

I am trying to prepare a ZC site for adding products via Easy Populate.\

I have set up all of the various product categories, but only have added a handful of actual products in a couple of different categories, manually.

When I export the CSV file via EP, only the categories that contain products are seen. The categories that lack products are not in the CSV file.

Is this normal? Do I have to add at least one product in each category before exporting? Or am I missing something?

TIA

Quote:

---

Originally Posted by pixelwrangler

I am trying to prepare a ZC site for adding products via Easy Populate.\

I have set up all of the various product categories, but only have added a handful of actual products in a couple of different categories, manually.

When I export the CSV file via EP, only the categories that contain products are seen. The categories that lack products are not in the CSV file.

Is this normal? Do I have to add at least one product in each category before exporting? Or am I missing something?

TIA

---

Empty categories will not be included in the file... normal behaviour.

Secondly...I just tried to click on the download complete CSV file and it took me to this??

Quote:

---

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/fusionsp/public_html/*****/easypopulate.php on line 852

Warning: Cannot modify header information - headers already sent by (output started at /home2/fusionsp/public_html/****/easypopulate.php:852) in /home2/fusionsp/public_html/****/easypopulate.php on line 1200

Warning: Cannot modify header information - headers already sent by (output started at /home2/fusionsp/public_html/****/easypopulate.php:852) in /home2/fusionsp/public_html/***/easypopulate.php on line 1201

Warning: Cannot modify header information - headers already sent by (output started at /home2/fusionsp/public_html/****/easypopulate.php:852) in /home2/fusionsp/public_html/****/easypopulate.php on line 1205

Warning: Cannot modify header information - headers already sent by (output started at /home2/fusionsp/public_html/****/easypopulate.php:852) in /home2/fusionsp/public_html/***/easypopulate.php on line 1209
v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p roducts_url_1,v_specials_price,v_specials_last_modified,v_specials_expires_date, v_products_price,v_products_weight,v_last_modified,v_date

---

Rather use EP 1.2.5.4

See my WIKI:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

Quote:

---

Originally Posted by schoolboy

Rather use EP 1.2.5.4

See my WIKI:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

---

ok but the csv version doesnt have a uninstall sql? any directions as to how to properly remove a mod? My old template had sooo many extra useless mods that i couldnt figure out how to get rid of.

And if i dont get rid of this, how do i install the older version?

Quote:

---

Originally Posted by fusionsp

ok but the csv version doesnt have a uninstall sql? any directions as to how to properly remove a mod? My old template had sooo many extra useless mods that i couldnt figure out how to get rid of.

And if i dont get rid of this, how do i install the older version?

---

It looks like the csv version creates the same dbase tables as 1.2.5.4 so there's no need to do a SQL uninstall.

All you need do is remove the php FILES, and you do this via your FTP program.

In the left frame (local drive) open up EP CSV version module admin folder and see what sub-folders and files are there (something like includes, then inside that, boxes, extra_datafiles, functions, languages.

In the right frame (remote server), navigate to the identical folders and simply delete the "macthing" php files that are appearing in your left frame for EP-csv. Do not delete the FOLDERS on the server... just the EP files inside them...

In other words, you are using the ORIGINAL module files on your local drive as a GUIDE to see what must come off your server.

------------------------------------------------------------------

EP 1.2.5.4 comes with a admin and a temp folder when you unzip the mod download. There are some EXTRA FILES there, but ignore them.

NB: you do NOT need to run the install.sql file unless you have problems getting EP to auto-run it later. See the readme... EP 1.2.5.4 ONLY needs the "admin" folder ftp'd... nothing else

Now... if you already have a folder called "tempEP" on your server (that was being used by the CSV version), you can keep it there, or re-name it to just temp.

(If you keep it as tempEP, you'll LATER change/check the EP configuration in your shop admin panel to make sure you have the correct name specified.)

--------------------------------------------------------------------

If you have re-named YOUR SERVER's admin folder to something else, then remember to re-name the "admin" folder in ep to the same name.

So, you will have this scenario on your FTP program, with EP 1.2.5.4 in the left frame and your server in the right frame

LEFT . . . . . . .| RIGHT
admin . . . . . | admin
temp . . . . . . | cache
install.txt . . . | editors
install.sql . . . | email
license.txt . . .| extras
readme.txt . . | includes

... just ftp the admin folder on the left, to the right, by clicking the right-facing arrow in the FTP console.

Then... follow my WIKI tutorial on Easy Populate.

How do you replace the line breaks in an excel spreadsheet with <br /> tags? I'm trying to do an edit/replace but the line breaks are not visable in excel.

I'm trying to import descriptions with Easy Populate but having problems with excell formatted text.

Thanks

Has anyone found a solution to this issue? I've been searching and have not been able to find any.

To clarify the problem:

You have old items in your database and are uploading updates to those items. the Date added column auto updates to todays date. Hence making all old items appear new and show up under new products side box.

I use zen-cart 1.3.8a
and ez populate 1.2.5.4

thanks in advance

Michael C.

Quote:

---

Originally Posted by pritchb

How do you replace the line breaks in an excel spreadsheet with <br /> tags? I'm trying to do an edit/replace but the line breaks are not visable in excel.

I'm trying to import descriptions with Easy Populate but having problems with excell formatted text.

Thanks

---

http://www.zen-cart.com/forum/showthread.php?t=144306 (See my post #4)

A few notes converning CSV files:

A number of people are having issues with CSV files (phazie's version, and the latter hacks to it) so I just wanted to relay a few notes from what I've noticed in my own work.

Working with CSV files is convenient ... you download your CSV file, and double-click it to edit ... then click "save" and upload... WRONG!!

You cannot just click "save". You must use "save as" and from the drop down box and select "CSV Windows". Just clicking "save" will put the file in microsoft's version of a CSV file, and this will not import correctly into EP!

Now, lets say you use OpenOffice to edit the CSV... look at the import window on open. Most people just click through and are fine. HOWEVER, if you have any special characters like (R) (C) tm the degree symbol, you must make sure your character set matches your data. OO will default to UTF-8 ... but most websites (in the US) will be Western ISO-8859-1. If you try to upload UTF-8 data to an western iso-8859-1 website, you will get "funky characters". This has to do with your databases and what collation they are in.

You can check your database collation by going into your phpMyAdmin and picking the products database, then "structure". You will see a "Collation" column. This in most cases will be latin1_swedish_ci which is compatible with iso-8859-1.

This perhaps sounds complicated, but it really isn't ... it's just a matter of knowing what your databases is going to export (say you typed descriptions in the zencart admin) or what type of data your vendor supplier is giving you.

HTML also has special characters that you can use in place of the extended characters. So, for the (R) registered symbol, you can use the HTML equivalent &reg; There are HTML equivalents for (R) (C) tm the degree symbol and more. Just google it.

Also. There is a big difference between normal single and double quotes and SMART QUOTES. Be sure you use the standard " and not the smart quote equivalent for your delimiter!

If you want to use a lot of special symbols and smart quotes, I recommend using OpenOffice.

Exporting CSV data from OO:
Once your data is ready, you select "save as" from the main menu, "Text CSV (.csv)" from the File type drop menu AND check "edit filter settings". You need to make sure you have the proper Character set selected!!! For CSV file, you would use the comma for your Field Delimiter and for TAB delimited files (aka .txt files for 1.2.5.4) select {TAB}.

The nice thing about OO is it will properly delimit every field with " (or what ever you choose). Excel will NOT do this!!!! It tries to be smart and in the end often causes problems.

Now the clincher. These notes are very pertinent if you are using a MAC. I have not verified on the PC yet, but I imagine everything would still apply. I think the CSV files on Windows normally export as "CSV Windows" but have not had a chance to check this. Windows users have it a bit better because they don't have the Mac end-of-line recognition problem that some mac users have encountered.

Hope this info helps!

Oh. Just remembered. If you look at your text data and see a lot of funky characters, try changing your font to Lucidia Sans Unicode. This is a good way to see if your data is in UTF-8.

i downloaded the .csv file that had the products i had inputted manually, added new products to the list (in Excel), saved as .csv and tried to upload the new list. it goes through all of the old products fine but stops at the new items with a SQL error.

" An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer" at the top of the screen.

The first item were the error occurs says "ADD NEW PRODUCT FAILED! - Model: WCA4540 - SQL error. Check Easy Populate error log in uploads directory".

i have checked to make sure that the new item looks the same (column-wise) in Excel as the previous entry (old product) but i can't see anything that would stop it there. any help would be appreciated. :lookaroun

Quote:

---

Originally Posted by meandk0610

i downloaded the .csv file that had the products i had inputted manually, added new products to the list (in Excel), saved as .csv and tried to upload the new list. it goes through all of the old products fine but stops at the new items with a SQL error.

" An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer" at the top of the screen.

The first item were the error occurs says "ADD NEW PRODUCT FAILED! - Model: WCA4540 - SQL error. Check Easy Populate error log in uploads directory".

i have checked to make sure that the new item looks the same (column-wise) in Excel as the previous entry (old product) but i can't see anything that would stop it there. any help would be appreciated. :lookaroun

---

if you have any non-empty cells after the last column you can get this behavior. check your .csv file with a text editor like notepad to see it still is correct. And also note my previous post above.

All else fails, attached some of the offending data so we can see it.

Version: 1.3.8 no upgrade
Previously installed add-ons: ez seo, stock by attribute
OS: Linux

:::PROBLEM:::
The below Warnings and Fatal error keeps occurring. I can login into the admin area just fine, only when I try accessing the EasyPopulate Module. eg(when i go to admin=>tools=>easypopulate, and CLICK)

eg(http://www.*************.com/admin/easypopulate.php)
it gives me those follow lines of error....
----------------------------------------------------------
Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0

Fatal error: Unknown: Failed opening required '/******/******/public_html/admin/easypopulate.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in Unknown on line 0
----------------------------------------------------------

:: MY CURRENT STATE OF MIND ::
I was going to create my own script, but do to my time constrant, i figure zencart should have an addon for this use, but I cant get this one to work. Now after burning many hours of trying to get this to work, I'm now on a even tighter time constrant and now asking you fellow Zenners for some assistants.

:: THE QUESTIONs ::
Have anyone ran into this same PROBLEM and have found a SOLUTION?
what exactly is the problem, the error is point me to line 0 but all i see is "<?php " ???


THANKS AHEAD OF TIME FOR ANY ASSISTANT

Quote:

---

Originally Posted by cvue

Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0

Fatal error: Unknown: Failed opening required '/******/******/public_html/admin/easypopulate.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in Unknown on line 0

---

Sounds like a folder/file permissions issue. Is your admin folder set to 755 and easypopulate.php set to 644?

Ok, so I use ep on a few of my sites. Just loaded it, to a new site and when I try and run it, I get database errors when I try an download the complete .csv files. Ideas?


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 811

Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1156

Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1157

Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1161

Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1165
v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p roducts_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_p roducts_price,v_products_weight,v_date_avail,v_date_added,v_products_quantity,v_ manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v _categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v _tax_class_title,v_status,v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS,v_metatags_product s_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_s tatus,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v _metatags_description_1

Quote:

---

Originally Posted by Crunch

Sounds like a folder/file permissions issue. Is your admin folder set to 755 and easypopulate.php set to 644?

---

:: PROBLEM SOVLED!!! ::

WOW!! YOU'RE BRILLIANT!!
That would of been one of the last thing i would to think of. I didn't know that would create such a big hassle!!!

THANKS so much for the fast response!!! I'll definitely learned what to look for next time i have this problem!!!!

:: THANKS!! ::

:: stlnyc's PROBLEM ::

Quote:

---

Originally Posted by stlnyc

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 811

---

I ran into this same problem but instead of "on line 811" mine was "on line 852", this must mean that we are using a different script, or version. So this might not be it, but could be. the similarity that caught my eye was this line

Quote:

---

v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS

---

on the last WARNING LINE

:: MY THOUGHT ::
In my situation, I figured it was a Sql problem so I checked the "ep_debug_log.txt", and it was. It seems that the PHP code was trying to pull information from the database, and the database could not find it, or did not have.
ep_debug_log.txt

Quote:

---

MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
INSERT INTO products SET
products_model = 'MG200MMS' ,
products_price = '299.99' ,
products_image = 'matrox/mg200mms.gif' ,
products_weight = '23' ,
products_tax_class_id = '1' ,
products_date_available = '' ,
products_date_added = '2003-11-03 12:32:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '31' ,
master_categories_id = '2' ,
manufacturers_id = '1',
products_status = '1',
metatags_title_status = '',
metatags_products_name_status = '',
metatags_model_status = '',
metatags_price_status = '',
metatags_title_tagline_status = '' , EASYPOPULATE_CONFIG_CUSTOM_FIELDS=''

---

:: MY SOLUTION ::
What I did, was: went into MyPhpAdmin, Hard-Delete the easy-populate CONFIGURATION data (I DON'T RECOMMEND DOING THIS IF YOU'RE NOT FIMILAR WITH MYSQL)

Then did a zencart=>admin=>easypopulate=> INSTALL again. That fixed my problems.

AS FOR THIS CODE ERROR

Quote:

---

Originally Posted by stlnyc

Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1156

Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1157

Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1161

Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1165
v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p roducts_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_p roducts_price,v_products_weight,v_date_avail,v_date_added,v_products_quantity,v_ manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v _categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v _tax_class_title,v_status,v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS,v_metatags_product s_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_s tatus,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v _metatags_description_1

---

This is just trying to send information, but cant because the first error created a kind of roof or top, to where this information cannot process through.

I HOPE THIS HELPS!! I wanted to help show more then just the answer but what and why, so next time it will be easier to troubleshoot errors.

Hi

Strange question - is there a way to only update products not add new ones?

EP uses the product's MODEL NUMBER as the key identifier for its operations.

So if you have a product in the database with Model Number 12345, and let's say it is priced at $10.95...

Now, you want to UPDATE that product (perhaps along with 100 others) to show a new price...

You do an EP download file of all your products.

Open in a spreadsheet.

Delete ALL records that you do not want price changes.

Keep only the 100 products you DO want price changes

Put NEW VALUES into v_products_price cells

SAVE as Tab-delimited.

IMPORT into database via EP

EP will UPDATE those products, to show their new prices.

Search the WIKI for Easy Populate to see my tutorial

Hello everyone,
I currently have 1.2.5.5. CSV installed but it's not functioning. I would like to remove this version and install the more reliable 1.2.5.4 but I get the following error when I use langer=remove:

Warning Easy Populate Configuration Missing. Please install your configuration by clicking here:

When I do click there I get the following:

1062 Duplicate entry 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' for key 'unq_config_key_zen'
in:
[INSERT INTO zen_configuration VALUES ('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'tempEP/', 'Name of directory for your uploads (default: tempEP/).', 45, '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.', 45, '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)', 45, '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).', 45, '3', NULL, now(), NULL, NULL), ('', 'Custom Products Fields', 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS', '', 'Enter a comma seperated list of fields to be automatically added to import/export file(ie: products_length, products_width). Please make sure field exists in PRODUCTS table.', 45, '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).', 45, '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.', 45, '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).', 45, '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).', 45, '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).', 45, '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)', 45, '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.

Any help would be appreciated...Thank you!!

Quote:

---

Originally Posted by kcb410

1062 Duplicate entry 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' for key 'unq_config_key_zen'

---

:: MY THOUGHTS for kcb410 ::

From what it sounds, there seems to be some values in the MySql database that is missing. So when (http://www.....com/admin/easypopulate.php) goes to read the stored data, it outputs
"Warning Easy Populate Configuration Missing. Please install your configuration by clicking here:"
By clicking that will run the Sql installation step, where this creates the data stored into your MySql Database. Since you already have a version install you will need to remove the data that was stored when you use the installation of 1.2.5.5. CSV. Now I haven't used Easy Populate to much, but I create php scripts that communicates with a MySql Database. IN ANOTHER WORDS, I'm not sure if Easy Populate has a feature to remove these VALUES out of the database.

:: BUT WHAT I WOULD DO ::
If you are familiar with PhpMyAdmin (LOCATED IN CPANEL), you can go into that back-end and remove the CONFIGURATION KEYS manually.
*I DO NOT RECOMMENDING DOING THIS IF YOU'RE UNFAMILIAR WITH MYSQL DATABASE STRUCTURE*
removing other data can really screw your entire database up.
The process is quite simple:
- To do this, go into your PhpMyAdmin, find the Database you have set for your Zen-Cart Store and CLICK on that name.
- Then find the CONFIGURATION table (if you have a prefix on during the Zencart installation it would like this ex[ pre_configuration ]) and CLICK it.
- then you have to go to the very last configuration keys
NOTE: on mine, it only shows from 1-30, but if you look carefully you can see that there is somewhere around +500 value stored in that one TABLE
- What I do is CLICK( configuration_id ) until the table is ordering the numbers in descending order ex.(500, 499,498,497... etc)
- from here if you look down the (configuration_key) column you will see a bunch of values starting with (EASYPOPULATE_ ... .. .) those will be the ONLY keys you want to delete.
- once deleted you can re-CLICK the button that started all this fuss.

THE "Warning Easy Populate Configuration Missing. Please install your configuration by clicking here:"

:: MY CONCLUSION ::

I'm not sure if that will work for you or not, but those are the steps i would take to a problem such as yours.

I hope this information helps.

Quote:

---

Originally Posted by schoolboy

EP uses the product's MODEL NUMBER as the key identifier for its operations.

So if you have a product in the database with Model Number 12345, and let's say it is priced at $10.95...

Now, you want to UPDATE that product (perhaps along with 100 others) to show a new price...

You do an EP download file of all your products.

Open in a spreadsheet.

Delete ALL records that you do not want price changes.

Keep only the 100 products you DO want price changes

Put NEW VALUES into v_products_price cells

SAVE as Tab-delimited.

IMPORT into database via EP

EP will UPDATE those products, to show their new prices.

Search the WIKI for Easy Populate to see my tutorial

---

Hi

That is simple enough, thanks schoolboy. The problem is that if I have 100 products and the new pricelist that I receive had 200 products. I don't want to search through the other 100 looking for the update. I just want to be able to update only those that already exist.

The OSC one just had update button.

Any ideas?

I've searched the forum but either I'm missing it or just haven't found it yet, still looking but thought I'd go ahead and post it and maybe someone could send me the forum link or might be able to help.

Just installed EP v1.2.5.4 and it's showing under my tools menu but when I click on it I get this error message. Can anyone point me in the right direction for an answer?

"Fatal error: Call to undefined function tep_not_null() in /home/electric/public_html/admin/includes/classes/table_block.php on line 33"

Thanks
Jim

Quote:

---

Originally Posted by cvue

:: stlnyc's PROBLEM ::


I ran into this same problem but instead of "on line 811" mine was "on line 852", this must mean that we are using a different script, or version. So this might not be it, but could be. the similarity that caught my eye was this line

on the last WARNING LINE

:: MY THOUGHT ::
In my situation, I figured it was a Sql problem so I checked the "ep_debug_log.txt", and it was. It seems that the PHP code was trying to pull information from the database, and the database could not find it, or did not have.
ep_debug_log.txt


:: MY SOLUTION ::
What I did, was: went into MyPhpAdmin, Hard-Delete the easy-populate CONFIGURATION data (I DON'T RECOMMEND DOING THIS IF YOU'RE NOT FIMILAR WITH MYSQL)

Then did a zencart=>admin=>easypopulate=> INSTALL again. That fixed my problems.

AS FOR THIS CODE ERROR


This is just trying to send information, but cant because the first error created a kind of roof or top, to where this information cannot process through.

I HOPE THIS HELPS!! I wanted to help show more then just the answer but what and why, so next time it will be easier to troubleshoot errors.

---

Do you have a little more information about this? I am getting the exact same error, but I do not know enough about SQL to know how to fix it. Please let me know. Thanks.

I'm not sure I know enough about it to try your recommendation but I'll go slow and try it.

Thanks

Well I killed EZ Populate. I manually deleted the product from my store using PHPmyadmin and now it states I have 6 partially undeleted products. The click here to fix button doesn't fix it, and I can no longer upload my TSV. Sometimes it gives me a blank screen and is just done and sometimes it gives me 'Warning: explode(): Empty delimiter. in /home/content/s/o/o/sooter5ipper/html/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241'

Anybody out there go through this already. I read relative posts but none seem to have the answer.

Thanks in advance for your time.

Adam

i seem to be having issues with easy populate.
i think i may not be installed correctly.
i get this error

Warning: file(/home/content/43/5511843/html/irestore/temp/full.txt) [function.file]: failed to open stream: No such file or directory in /home/content/43/5511843/html/irestore/admin/easypopulate.php on line 1223

this one as well.

Warning: Invalid argument supplied for foreach() in /home/content/43/5511843/html/irestore/admin/easypopulate.php on line 1301

Suggestions....and help...

1.) Someone PLEASE fix the EP code so that if a product Manufacturer is set to '-none-' that the field will stay 'null' instead of picking the Manufacturer next in line...:oops:

2.) I am having an issue with EP NOT displaying ANY category names beyond 2 levels. Admin config is set to the default of 7.

For Example:

Womens - Shoes - Heels
Womens - Shoes - Flats

all products in either of those categories, in EP only show

Womens - Shoes

as the category names.

Thus meaning that I cannot even use EP..:cry:

I have just had my website re-config'd and now starting on a clean slate. I have not uploaded anything into my site, wanting to make sure everything is running smartly before this happens. I have loads of zipped files/images which need to be uploaded and I see that EP 1254 was recommended as being the most stable. In my "dummy" shop I ftp'd file across as was recommended. When uploading the install_sql thru admin tools, this error comes up:


1062 Duplicate entry 'EASYPOPULATE_CONFIG_TEMP_DIR' for key 2
in:
[INSERT INTO zen_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.

what does it mean I would have liked it to have worked for me, from the write ups I have read people can;t live without it.

Read the README and INSTALL files!!!

Quote:

---

** If for some reason the config install fails, you can upload the SQL file provided using Admin -> Tools -> Install SQL Patches

---

You don't need to run the SQL file (UNLESS there is some issue with the self-install)

After FTP of the "admin" folder, just go to your admin console TOOLS >>> Easy Populate

Upon entering the screen for the first time, look right at the top of the screen.... Just click the install link provided...

Thanx for that, its amazing what you think you read, when you haven't. (it was there all the time, was just looking in the wrong place!

Hello, I cant find where to start a new thread? Anyway, I have installed Google Base Module. I autenticate it fine and then click upload, then it says

product with id 0 ( ...) returned error status
reason:
detail:

Can anyone help with this? I can find anywhere to change the Product ID to 0 to start it off, im not sure? Have I got an old module? Please help i want my products in Google Shopping, thank you guys :frusty:

Hi

I have installed 1.2.5.4 and managed to download a tab delimited file which I then adapted for an upload. The NEW product appeared in the database but not in the store. In Zen admin, the category which I uploaded the NEW product to shows that it now has 1 product in it, but will not show it.

No error messages received ...

Any ideas?


Gillian

Is that NEW product ACTIVE or INACTIVE?

Call it up in the admin product add/edit screen and see if it is enabled or disabled.

In Easy Populate, the column governing this STATUS is v_status...

v_status = 0 (product is added to the database but is DISABLED) hidden from view in the webshop
v_status = 1 (product is added to the database and is ENABLED) visible in the webshop and regarded as in stock.
v_status = 9 (Product will be DELETED from the database along with its image(s)). Usually used to remove discontinued products.

Hi

Status was set to 1.

In Admin > categories it shows 1 of 1 active

but when I click on the category to go into it,there are no products there. It is in the database but just isn't showing up in admin > categories > 2 seater benches nor is it showing up in the store online.

I did add some additional fields (which I have in the product_table) which appeared in the tab delimited file (but without any data in them though they have data inputted in these fields. I wonder if there could be some problem with this?

Any help gratefully received.

Gillian

Aah ... I have found a potential problem.

I have some new fields added -

product_measurements
product_materials
product_technical
product_maintenance

so I followed the info on this thread about what to do if you have a new_field

HOWEVER

The new fields that I have added are in the product_table but the info on adding a new_field showed the info in product_description_table. Do you think this might be causing a problem?


Gillian

Hi

I managed to solve my previous problem by going through the easypopulate.php file and inserting the added fields beside the field it was next to in the product_table.

I now have another problem. I uploaded some products which appear in the store and in the admin - in the category view. However, when I try to go into the individual product to amend it, I see nothing and get the following error:

Warning: reset() [function.reset]: Passed variable is not an array or object in /homepages/46/d92464838/htdocs/Store/adam6u3pq0/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /homepages/46/d92464838/htdocs/Store/adam6u3pq0/includes/classes/object_info.php on line 30


The object_info file is as follows:

class objectInfo {

// class constructor
function objectInfo($object_array) {
//this line should be added, but should be tested first:
// if (!is_array($object_array)) return;
reset($object_array);
while (list($key, $value) = each($object_array)) {
$this->$key = zen_db_prepare_input($value);
}
}
}
?>


What do I need to add to this to get the products to be revealed in the categories / product info listing in the Zen Admin.

It would be very much appreciated if someone would point me in the right direction ....

Gillian

Hi All

Managed to solve the above problem by going into the product_extra_fields table via phpmyadmin and adding the product id for each of the new products. Then they just appear ...

It seems that for every problem, there is a very simple answer ... you just have to know what it is ...

Hope my post here helps someone solve the same problem.

All the best


Gillian

Hi all. I have moved server and when I upload new files to the tempEP directory they are not being detected by easy populate where I clcik the import button. Also it lists files there that are not actually there anymore.

Hey is it a good idea to use Easy Populate when you use 2 languages on your website? Is it supported?

Hi, I am trying to install easy populate...but I don't get a link on the admin menu. I tried the link /easypopulate.php?langer=install did not work. I get Fatal error: Call to undefined function ep_chmod_check() in /.../easypopulate.php on line 218. what does this mean? Thanks.

Quote:

---

Originally Posted by kenny724

Hi, I am trying to install easy populate...but I don't get a link on the admin menu. I tried the link /easypopulate.php?langer=install did not work. I get Fatal error: Call to undefined function ep_chmod_check() in /.../easypopulate.php on line 218. what does this mean? Thanks.

---

Run through wiki, url below, making sure installed as per
instructions given
http://www.zen-cart.com/wiki/index.php/Easy_Populate

Quote:

---

Originally Posted by kenny724

Hi, I am trying to install easy populate...but I don't get a link on the admin menu. I tried the link /easypopulate.php?langer=install did not work. I get Fatal error: Call to undefined function ep_chmod_check() in /.../easypopulate.php on line 218. what does this mean? Thanks.

---

The temp folder that was FTP'd to your server during EP install has permissions that are too strict... The folder should be CHMOD 777 (0777).

The php lines say:

Code:

---

$chmod_check = ep_chmod_check($tempdir);
        if ($chmod_check == false) {
                // no temp dir, so template download wont work..
                $messageStack->add(EASYPOPULATE_MSGSTACK_INSTALL_CHMOD_FAIL, 'caution');
        } else {
                // chmod success

---

I really need som Easy Populate support for Version 1.2.5.7

have tried installing it, pretty sure I've followed instructions but its just not happening. Trying to remove all the files but need to know how to get rid of the sql as I have 3 lots of easypopulate on my config dropdown menu now.

Sorry.....

Quote:

---

Originally Posted by michellewardley

I really need som Easy Populate support for Version 1.2.5.7

have tried installing it, pretty sure I've followed instructions but its just not happening. Trying to remove all the files but need to know how to get rid of the sql as I have 3 lots of easypopulate on my config dropdown menu now.

Sorry.....

---

Replied at your other post i.e.
http://www.zen-cart.com/forum/showth...d=1#post843949

I'm not sure if anybody else has had this problem as I couldn't find any posts here that would help me.

I have been using Easy Populate (the free version) and it has been really great for me. The only issue that I've been having is an image issue. It seems that some of the products that have image file names that are similar but not the same are getting mixed up after I have loaded my file into my cart.
For example, product #1 has an image file name that is 1338.jpg and product #34 has an image name that is 138.jpg or 133.jpg

When you look at the products in my zencart they have shared pics with eachother. I even use the _01.jpg system and _LRG.jpg system as suggested.

Is there anyway to prevent this from happening?

Schoolboy, would you know what I need to do maybe?

TIA
Lisa

Nothing to do with EP - everything to do with the way ZC "assesses" the relationship between a product's MAIN image, and any ADDITIONAL images...

Have you heard of this happening before?

It's standard zencart behaviour...

Do some forum searches on ADDITIONAL IMAGES - NAMING CONVENTION - or look in the FAQ/TUTORIALS for more info.

Thanks Schoolboy, I hope I don't have to start from scratch again...:frusty: Live and learn I guess....
Cheers
~L~

Quote:

---

Originally Posted by jvoce

For anyone who was interested in adding the product sort order through EP here's how I finally did it.

Adding Product Sort Order:
1) Open Admin/easypopulate.php
2) Insert following:
Line 389: 'v_products_sort_order'=> $iii++,
Line 457: p.products_sort_order as v_products_sort_order,
Line 601: p.products_sort_order as v_products_sort_order,
Line 1290: 'v_products_sort_order',
Line 1439: p.products_sort_order as v_products_sort_order,
Line 1848: sort_order,
Line 1917: products_sort_order,
Line 1931: '".zen_db_input($v_products_sort_order)."',
Line 1965: '", products_sort_order="'.zen_db_input($v_products_sort_order) .

I hope this helps! :D

---

Hello,

I am using Easy Populate 1.2.5.7.csv and I use EP mostly for creating categories and subcategories so I always use option "Download Model/Category .csv file to edit" and that csv document contains these coulmns:

'v_products_model'
'v_categories_name_1'
'v_categories_name_2'
...etc till 'v_categories_name_7'

and thats OK but I need also one more column 'Sort order' so I could order categories and subcategories exactly as I need/want.

Searching thorugh forum all I found this post (quoted) above and I made all corrections in easypopulate.php but unfortunatly I always get error mesage on first line 389? I pretty sure I done everything good:huh: This is error message I always get:

"Parse error: syntax error, unexpected T_DOUBLE_ARROW in /home/mysite/public_html/admin/easypopulate.php on line 389"

Any help is appreciated!:wink:

Anyone have a quick solution to setting a default category so you can import items without a category defined?

Thanks

just wondering if putting v_width v_height etc as columns will allow me to import product dimensions for postage calculation in OzPost successfully?
quote from ozpost config text
"The products database will have 3 new fields added (length, height, width) when you install this module."

Looking for help:

I'd like a column that sets the minimum quantity to .1 and not 1 by default.

Anyone have a v code or can I set this up for a folder in the ZC settings? We sell Fabric in multiples of .1 of a meter for example.

Quote:

---

Originally Posted by michellewardley

just wondering if putting v_width v_height etc as columns will allow me to import product dimensions for postage calculation in OzPost successfully?
quote from ozpost config text
"The products database will have 3 new fields added (length, height, width) when you install this module."

---

If the module adds the new fields to the PRODUCTS table, then you will be able to include these in Easy Populate...

BUT...

... first you will have to modify easypopulate.php to recognise the additional fields:

http://www.zen-cart.com/forum/showthread.php?t=116061

Tread cautiously... and backup the original file first

Hopefully I have all of the details... I have Zen Cart 1.3.8a installed and have installed all of the files for Easy Populate Advance2.75a-Zen-Cart 1.2. When I go to Tools, Easy Populate, Browse to Upload EP File for Import, select the file and hit Insert into db, the screen just flashes for a minute, clears and then reloads the easypopulate.php screen. This same thing happens when I try to import from the temp directory as well. My temp directory is set to 777. The export functions does the same thing, the screen just flashes and reloads. There are no files in the temp folder either. I am confident my cvs file for import is correct.

If anyone can tell me what I am doing wrong and why it will not import the file I would appreciate it,
Matt

Quote:

---

Originally Posted by shopkepr

Hopefully I have all of the details... I have Zen Cart 1.3.8a installed and have installed all of the files for Easy Populate Advance2.75a-Zen-Cart 1.2. When I go to Tools, Easy Populate, Browse to Upload EP File for Import, select the file and hit Insert into db, the screen just flashes for a minute, clears and then reloads the easypopulate.php screen. This same thing happens when I try to import from the temp directory as well. My temp directory is set to 777. The export functions does the same thing, the screen just flashes and reloads. There are no files in the temp folder either. I am confident my cvs file for import is correct.

If anyone can tell me what I am doing wrong and why it will not import the file I would appreciate it,
Matt

---

Cardinal error... WRONG version of EP. You must use EP 1.2.5.4

it actually worked fine! and shows up in my product descriptions. All good.

I'm really considering purchasing Easy Populate Advanced but the site isn't that informative of what it can do with respect to attributes/options with different prices and product codes and image swatches. Can anybody who uses it give me more detail?

Also, why are people complaining about support? Is there none? It says that you get a year of support with your purchase,,,, where did Langer go? Did somebody take over for him or did he just disappear?

Thanks
Lisa

Quote:

---

Originally Posted by cdnbride

I'm really considering purchasing Easy Populate Advanced but the site isn't that informative of what it can do with respect to attributes/options with different prices and product codes and image swatches. Can anybody who uses it give me more detail?

Also, why are people complaining about support? Is there none? It says that you get a year of support with your purchase,,,, where did Langer go? Did somebody take over for him or did he just disappear?

Thanks
Lisa

---

I paid for the EP Advanced last summer had problems and was never able to get it working. Whoever controls that website should stop selling the product!!! or say on the site that there is no support and you're on your own if you buy it.

I have a lot of attributes with my products and have struggled to get EP (I've tried every version) to handle attributes in any reliable way.

Sorry for being so negative!!

kcb410- I have gotten myself comfortable with the free version so I thought that maybe the advanced would seem similar in how it works etc. Are you using EP Advanced now or just the free version. If I knew how to get my attributes done with the free version I would do it, I just don't want to give myself any unnecessary headaches. Its been a real learning curve since I started, I didn't even know how to make a spreadsheet 6 months ago! lol

Quote:

---

Originally Posted by cdnbride

kcb410- I have gotten myself comfortable with the free version so I thought that maybe the advanced would seem similar in how it works etc. Are you using EP Advanced now or just the free version. If I knew how to get my attributes done with the free version I would do it, I just don't want to give myself any unnecessary headaches. Its been a real learning curve since I started, I didn't even know how to make a spreadsheet 6 months ago! lol

---

I abandoned EP Advanced shortly after I paid for it! I currently use EP 1.2.5.4. but I believe I was using the 1.2.5.5 CSV version when I did the bulk of my uploading. I used the free version for my attribute uploads. I did approximately 1300-1500 products in small groups of 100-200 products. I encountered many issues and errors, I would classify it as immensely frustrating!! but I'm basically done.

Do you have a lot of products to add?

I also use Store Manager by MagneticOne but it doesn't provide a solution for bulk attribute uploading.

Quote:

---

Originally Posted by kcb410

I abandoned EP Advanced shortly after I paid for it! I currently use EP 1.2.5.4. but I believe I was using the 1.2.5.5 CSV version when I did the bulk of my uploading. I used the free version for my attribute uploads. I did approximately 1300-1500 products in small groups of 100-200 products. I encountered many issues and errors, I would classify it as immensely frustrating!! but I'm basically done.

Do you have a lot of products to add?

I also use Store Manager by MagneticOne but it doesn't provide a solution for bulk attribute uploading.

---

Well, I've got about 3000 products that have attributes (the rest are just a straight upload) and I can't stand the thought of adding them all manually. I'm on a Mac so I find that sometimes things work for others that don't work the same for me.

Can you tell me if it works basically the same way as the free version? Or will I have to start over by learning a whole new way of doing everything again?

Quote:

---

Originally Posted by cdnbride

Well, I've got about 3000 products that have attributes (the rest are just a straight upload) and I can't stand the thought of adding them all manually. I'm on a Mac so I find that sometimes things work for others that don't work the same for me.

Can you tell me if it works basically the same way as the free version? Or will I have to start over by learning a whole new way of doing everything again?

---

It's similar....you wouldn't be starting over as far as learning goes.
Easy Populate Advanced will probably be a waste of your money.....but I'm a little bitter.:censored:

quick question schoolboy....

does easy populate have a sql reset option? just seem like people are running into that problem, and i figure i should ask someone more knowledgeable with this MOD before i go ahead and add a SQL reset option to this module, it just seem like many others are running into the same problems I was, and MANUALLY REMOVING seems to be quite troublesome for some.

if needed,I'll can just write up a function to remove those CONFIGURATION KEYS out of the DB, and allow them to re-install those keys...

Thanks,

cvue

Hello I have copied the admin folder files into my zencart admin folder...but i cant see any easy populate option in admin...
am i doing something wrong?

Hi
I'm new to all this and have been reading lots of posts to find answers and I have found lots of useful stuff but not for my problem.
I just installed zen cart 1.3.8a and easy populate 1.2.5.5 and am having trouble importing about 2500 products. I'm breaking the file up as low as 300 products and am importing from the temp directory. I keep getting an error like this;

ADD NEW PRODUCT FAILED! - Model: 1845 - SQL error. Check Easy Populate error log in uploads directory

I don't see an uploads directory. Where is supposed to be?
Any help is appreciated.
Tony

Quote:

---

Originally Posted by cvue

quick question schoolboy....

does easy populate have a sql reset option? just seem like people are running into that problem, and i figure i should ask someone more knowledgeable with this MOD before i go ahead and add a SQL reset option to this module, it just seem like many others are running into the same problems I was, and MANUALLY REMOVING seems to be quite troublesome for some.

if needed,I'll can just write up a function to remove those CONFIGURATION KEYS out of the DB, and allow them to re-install those keys...

Thanks,

cvue

---

In the 1.2.5.4 version, you will see a file install.txt in the module main folder.

That tells you how to do a proper INSTALL and/or UNINSTALL.

Quote:

---

Originally Posted by tonyhord

I don't see an uploads directory. Where is supposed to be?
Any help is appreciated.
Tony

---

I think this is the uploads folder in images/uploads

It is used for practical reasons of writeability (permissions) in a safer area of your setup.

I am trying to import some products, and I have a product file which I have split into seperate tab delimited files.
The first imports without any problems.
The second though brings up the following error:-
Warning: explode() [function.explode]: Empty delimiter in /home/marauder/public_html/testshop/admin/includes/functions/extra_functions/easypopulate_functions.php on line 247
This is at the top of the page, before the admin menu.

Then, where it shows the added/updated items it shows the message on the failed lines 'SKIPPED! - Model: 157 - Category name(s) too long (max. 32)'
This is not correct as the categories all added together total 13 characters (including spaces).

Any help would be great, as I am trying to start using Zen Cart instead of Prestashop and this is my only real holdup!

By the way, I've increased the limit for the categories to 52 characters, and then 102 characters but no difference to the problem...

Hi Everybody

Just wondering if somebody would know how I can put a range of prices on a product (this question is not about attributes)?
I have some products that have several prices depending on what options a customer will choose so I would like for those to show on the product page ie: $3.49 - $9.99
When I put the price range on my EP spreadsheet it will only show the first dollar amount on my site.

Thanks
Lisa

The field for price is purely a NUMERICAL VALUE and must remain as such... no alpha characters allowed, because this value is used to calculate (using arithmetic formulae) a large number of things in your webshop.

You are wanting to add a LINE OF TEXT, explaining the range of pricing available and this HAS TO BE part of your product description as this is where such TEXT STRINGS can be included.

Quote:

---

Originally Posted by darkmarauder

I am trying to import some products, and I have a product file which I have split into seperate tab delimited files.
The first imports without any problems.
The second though brings up the following error:-
Warning: explode() [function.explode]: Empty delimiter in /home/marauder/public_html/testshop/admin/includes/functions/extra_functions/easypopulate_functions.php on line 247
This is at the top of the page, before the admin menu.

Then, where it shows the added/updated items it shows the message on the failed lines 'SKIPPED! - Model: 157 - Category name(s) too long (max. 32)'
This is not correct as the categories all added together total 13 characters (including spaces).

Any help would be great, as I am trying to start using Zen Cart instead of Prestashop and this is my only real holdup!

---

The first "error" is not that serious - it usually relates to incorrect date formatting in columns such as date_added, etc. This typically happens when you import the txt file into MS Excel, which then sees a date and does its own formatting (another Bill Gates conspiracy). Later, you "save as" a TXT file, but the original formatting for date has been altered.

The second error is a fault within the EP upload file you are using (the .txt file).

Find out the line at which the upoload renders SKIPPED and re-examine it using a PLAIN TEXT EDITOR.. Don't re-open it in MS Excel or other spreadsheet program.

Quote:

---

Originally Posted by darkmarauder

I am trying to import some products, and I have a product file which I have split into seperate tab delimited files.
The first imports without any problems.
The second though brings up the following error:-
Warning: explode() [function.explode]: Empty delimiter in /home/marauder/public_html/testshop/admin/includes/functions/extra_functions/easypopulate_functions.php on line 247
This is at the top of the page, before the admin menu.

Then, where it shows the added/updated items it shows the message on the failed lines 'SKIPPED! - Model: 157 - Category name(s) too long (max. 32)'
This is not correct as the categories all added together total 13 characters (including spaces).

Any help would be great, as I am trying to start using Zen Cart instead of Prestashop and this is my only real holdup!

---

Any more of an idea on this issue?

Quote:

---

Originally Posted by schoolboy

The field for price is purely a NUMERICAL VALUE and must remain as such... no alpha characters allowed, because this value is used to calculate (using arithmetic formulae) a large number of things in your webshop.

You are wanting to add a LINE OF TEXT, explaining the range of pricing available and this HAS TO BE part of your product description as this is where such TEXT STRINGS can be included.

---

Thank you Schoolboy, I was hoping that you were around here somewhere. That is an easy fix and I guess if I had sat here long enough and thought about it, I would have been able to figure that one out.
Cheers!
Lisa

Quote:

---

Originally Posted by darkmarauder

Any more of an idea on this issue?

---

Langer - the guy who wrote easy Populate - Says what I just said:

http://www.zen-cart.com/forum/showpo...&postcount=286

I just deleted the two date columns, same error...

Can I decide which of the columns I chose to use when uploading via EP ?

I want to be able to add images and the description manually.

I just want to use these;

v_products_model
v_products_name_1
v_products_url_1
v_products_price
v_products_weight
v_products_quantity
v_manufacturers_name
v_categories_name_1
v_categories_name_2
v_categories_name_3
v_tax_class_title
v_status (set to 0)
EOREOR


Can I just use these and remove the rest, or will it through up a hissy fit ?

Quote:

---

Originally Posted by Mike_Dean

Can I decide which of the columns I chose to use when uploading via EP ?

I want to be able to add images and the description manually.

I just want to use these;

v_products_model
v_products_name_1
v_products_url_1
v_products_price
v_products_weight
v_products_quantity
v_manufacturers_name
v_categories_name_1
v_categories_name_2
v_categories_name_3
v_tax_class_title
v_status (set to 0)
EOREOR


Can I just use these and remove the rest, or will it through up a hissy fit ?

---

This should be fine... bearing in mind that v_status = 0 means that the product will be "disabled" in the store (rendered "invisible", but the product data retained in the dbase.)

Quote:

---

Originally Posted by schoolboy

This should be fine... bearing in mind that v_status = 0 means that the product will be "disabled" in the store (rendered "invisible", but the product data retained in the dbase.)

---

Thanks..

I'd want the status at 0, so I can then go though and add images and proper descriptions and set them live as I go.

I am still pretty new to zencart.
Version 1.3.8, Not upgrading
Addons. MSRP, Bulk Atributes Controller, Easypopulate, fedex is installed, trying to set up origin based shipping. All addons added in last 2 weeks.
Premium5a template was originally installed.

I have checked FAQ area and searched for the error.
I am trying to intsall a new version of easy populate. This is for the origin based shipping module.

I am receiving the following error:

Fatal error: Call to undefined function ep_datoriser() in /home/your_store/public_html/admin/easypopulate.php on line 1757

Found a reference to this in this thread changed my date format to yyyy/mm/dd. I am still receiving the error.

Any help would be appreciated. Thanks

Quote:

---

Originally Posted by slafrenier

I am trying to intsall a new version of easy populate. This is for the origin based shipping module.

---

Easy Populate does not have any relationship with shipping modules/data. It is for product data only.

When I go to "Split EP file" I keep getting this error

Warning: fopen(/home/pleasure/public_html/zencart/zencart/temp/zencart.txt) [function.fopen]: failed to open stream: No such file or directory in /home/pleasure/public_html/zencart/zencart/admin/easypopulate.php on line 1126

Warning: fgets(): supplied argument is not a valid stream resource in /home/pleasure/public_html/zencart/zencart/admin/easypopulate.php on line 1129

Warning: fgets(): supplied argument is not a valid stream resource in /home/pleasure/public_html/zencart/zencart/admin/easypopulate.php on line 1141

Warning: fclose(): supplied argument is not a valid stream resource in /home/pleasure/public_html/zencart/zencart/admin/easypopulate.php on line 1168

Hello All;

I have installed EP and cannot find what is the next step after uploading my product data files through admin.

I have set up my spreadsheet according to all the directions, and have uploaded the file successfully. But I get a warning after uploading the file:

Warning: explode() [function.explode]: Empty delimiter in /home/lovejon1/public_html/lovejonesboutique-toys.com/admin/includes/functions/extra_functions/easypopulate_functions.php on line 247

Im not sure what this exactly means. Is there anyone that can help me solve this issue, as well as explain to me what are the next steps I should follow after I have uploaded the files.

Thank you,
Joann Garcia
www.lovejonesboutique.com
ZC 1.3.8

Hi LovejonesBoutique

This is the same error as I was getting when I first started using Easy Populate.
If you hear anything, or solve this, please post back on here as I'm still struggling!

Warning: explode() [function.explode]: Empty delimiter in /home/lovejon1/public_html/lovejonesboutique-toys.com/admin/includes/functions/extra_functions/easypopulate_functions.php on line 247

In the EP Functions file, let's look at the content between lines 225 and 273 -:

PHP Code:

---

function ep_datoriser($date_time) {
    global $ep_date_format; // d-m-y etc..
    global $ep_raw_time; // user's prefered time (eg for specials to start) if no time in upload
    
    $raw_date_exist = preg_match("/^([0-2]0[0-9]{2}-[0-1][0-9]-[0-3][0-9])( [0-2][0-9]:[0-5][0-9]:[0-5][0-9]$)?/", $date_time);
    if (!$raw_date_exist) {
        // not raw... we can only assume it is an excel date..
        // separate dates from times
        $exist_time = preg_match("/^2?0?[0-9]?[0-9][\.\/-][0-3]?[0-9][\.\/-]2?0?[0-9]?[0-9] ([0-2]?[0-9]:[0-5][0-9]).*$/", $date_time, $excel_time); // no seconds..
        $exist_date = preg_match("/^(2?0?[0-9]?[0-9][\.\/-][0-3]?[0-9][\.\/-]2?0?[0-9]?[0-9]).*$/", $date_time, $excel_date);
        //echo $excel_time[1] . '<br >';
        //echo $excel_date[1] . '<br ><br />';
        // if (!zen_not_null($exist_date)) // we fail to get a date! error msg rqd, and/or substitute action??
        
        // check for which of 3 possible date separators we have..
        // this sucks, I know... but it works for now
        if (zen_not_null(strpos($excel_date[1], '-'))) $separator = '-';
        if (zen_not_null(strpos($excel_date[1], '.'))) $separator = '.';
        if (zen_not_null(strpos($excel_date[1], '/'))) $separator = '/';
        
        //echo 'separator is: ' . $separator . '<br />';
        $format_bits = explode('-', $ep_date_format);
        $date_bits = explode($separator, $excel_date[1]);
        foreach ($format_bits as $key => $bit) {
            $$bit = $date_bits[$key]; // $y = 05 or 2005, $m = 09 or 9, $d = 03 or 3 for eg. Can only work if d,m,y order from excel is same as config
            $$bit = strlen($$bit) < 2 ? '0' . $$bit : $$bit; // 4 is now 04 for eg. - expand this as a rudimentary check - should never occur on $y var
            $$bit = strlen($$bit) > 2 ? substr($$bit,-2, 2) : $$bit; // 2005 is now 05 - expand this as a rudimentary check - should only occur on $y var
            //echo $$bit . '<br />';
            // another rudimentary check could be for $m vals > 12 = error too!
        }
        // create default raw time... if user left space off, put it on..
        if (substr($ep_raw_time,0, 1) != ' ') $ep_raw_time = ' ' . $ep_raw_time;
        // is it really a raw time? if not, make it midnight..
        $exist_raw_time = preg_match("/ [0-2][0-9]:[0-5][0-9]:[0-5][0-9]/", $ep_raw_time); // true if is raw time
        $ep_raw_time = zen_not_null($exist_raw_time) ? $ep_raw_time : ' 00:00:00';
        
        // if time supplied from excel, use it instead..
        $ep_raw_time = zen_not_null($exist_time) ? ' ' . $excel_time[1] : $ep_raw_time;
        
        //echo '<br />'.$ep_raw_time . '<br />';
        $raw_date = '20' . $y . '-' . $m . '-' . $d . $ep_raw_time; // needs updating at the end of the century ;-)
        //echo $raw_date . '<br /><br />';
    } else {
        // the date is raw, so return it
        $raw_date = $date_time;
        //echo $date . ' is raw...<br />';
    }
    return $raw_date; 


---

You will see they manage the DATE functions.

So if you get the error (at the top) and the line referred to is between 225 and 273, then there is something wrong in the FORMAT of a date in your TXT file.

Typically, we use a SPREADSHEET program to manage our TXT files. While this makes life easier in most respects, spreadsheets have a habit (expecially MS Excel) of making radical assumptions about the content parsed into the sheet.

If it sees what look like a DATE, it will re-format that into the default date format.

If you have configured your EP to render DATE as YYYY : MM : DD , then it will write it as follows in a date field:

2008-02-01 08:16:01 (where 16:01 is the time).

Now you import this into Excel and it is likely to do the following:

1/2/2008

Then when you SAVE AS TXT, it probably retains this formatting - or could even go haywire and render it as something else...

So even though your sheet is now TAB DELIMITED TEXT, the format of the DATES is incompatible with EP.

If you start out with EP date formatting as
2008-02-01 08:16:01

You need to ensure it STAYS as
2008-02-01 08:16:01

When I try an access the tempEP directory, I get a 403 forbidden error. I checked the error logs and I can see the following error "(13)Permission denied: /domains/y/o/website/public_html/tempEP/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable". I have checked and there isn't a .htaccess file in that folder and there wasn't one included on the easy populate installation zip file. Can anyone help?

Quote:

---

Originally Posted by computoz

When I try an access the tempEP directory, I get a 403 forbidden error. I checked the error logs and I can see the following error "(13)Permission denied: /domains/y/o/website/public_html/tempEP/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable". I have checked and there isn't a .htaccess file in that folder and there wasn't one included on the easy populate installation zip file. Can anyone help?

---

What type of SERVER are you on? (windoze - linux ???)

What VERSION of Easy Populate (tempEP is not the foldername for 1.2.5.4

Hi, I managed to fix it by chmoding the directory correctly, thanks for the response though.

You will see they manage the DATE functions.

So if you get the error (at the top) and the line referred to is between 225 and 273, then there is something wrong in the FORMAT of a date in your TXT file.

Thanks for your response Schoolboy, I figured this much as I began to research this topic. However, my spreadsheet contains no date columns. Would I have to format the following columns with numbers in excel, or in EP.

My columns which contain numbers are:
v_products_model
v_products_weight
v_products_price (formatted in excel as currency)

This may seem like a silly question, but if I'm uploading images via EP then do those images need to already reside on the server side (eg do I have to FTP them across before hand) or will it use the images that are in the images directory on my local test site.. ??

eg if I have (for example) widgets/widgets.jpg (which is from the image directory locally), will it upload it, or would I have to have that directory and file already FTP'd to the server ??? :unsure:


Cheers,
Mike

Quote:

---

Originally Posted by Mike_Dean

This may seem like a silly question, but if I'm uploading images via EP then do those images need to already reside on the server side (eg do I have to FTP them across before hand) or will it use the images that are in the images directory on my local test site.. ??

eg if I have (for example) widgets/widgets.jpg (which is from the image directory locally), will it upload it, or would I have to have that directory and file already FTP'd to the server ??? :unsure:


Cheers,
Mike

---

Answered my own question with a test... It must already reside on the server.. which come to think of it, seems obvious...

Actual image FILES (the jpeg files themselves) reside in the IMAGES forder(s) and get to the server via FTP, or when you ADD a product in the admin console and upload its image.

The image name in Easy Populate is the DATABASE REFERENCE - a record of the NAME and LOCATION of the image. It is little more than a "label" that the software uses to locate the image associated with a product.

It is used (for example) in compiling <img src> paths via the php, in order to create suitable HTML for bring that image "into play"...

Hi,

I am using Zen Cart 1.3.8a and Easy Populate 1.2.5.4.

I have all of my products loaded OK.

Here is my problem.

My inventory changes everyday,

I sell products and get more in.
I do not only sell through my store.
I sell on ebay and through other sites in
my niche.

My problem is I update a spread sheet to keep track of
everything, but that means adding and subtracting products
from that spread sheet.

If I could just use that spread sheet to make my file for the
Easy Populate upload that would be fine, but if I understand
correctly the old inventory doesn't clear out when you upload
new inventory. So that would be a mess.

With the volume that I do it would be very hard to track
what's still in stock, what's out of inventory and what's new
on different spread sheets. I am dealing with a few thousand part numbers.

Any thoughts would be very very welcome. :smile:

I guess it comes down to...is there an easy way to update the store on a regular basis
with a new upload of all of my inventory every time?

Thanks.