Re: Easy Populate support for Version 1.2.5.4
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.
Re: Easy Populate support for Version 1.2.5.4
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
Re: Easy Populate support for Version 1.2.5.4
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
Re: Easy Populate support for Version 1.2.5.4
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 :)
Re: Easy Populate support for Version 1.2.5.4
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?
Re: Easy Populate support for Version 1.2.5.4
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
Re: Easy Populate support for Version 1.2.5.4
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.
Re: Easy Populate support for Version 1.2.5.4
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
Re: Easy Populate support for Version 1.2.5.4
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
schoolboy
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?
