Re: Easy Populate support for Version 1.2.5.4
touchclothing What version of EP are you using ? I don't use a MAC so not the best to advise, but i am sure i have read it some where in this forum that MAC file formats cause problems with EP and tab separated files, hence the
Quote:
uncomment the line in the "configuration variables"
OK Found this:
Quote:
Originally Posted by
jimmysflyshop
We are using Zen Cart 1.3.8 which I believe is the current program. We have been using Zen Cart for the last few months and have just recently launched our site. We have all the latest programs for Zen Cart. During the building process I was using a PC. I have just purchased an Macbook, and installed Microsoft Office so that I would be able to use Easy Populate with Zen Cart. Everything works okay except for one issue.
My issue is that when I download and update the .csv file and try to import it back to Zen Cart it is not properly updated. The new information that I have entered and saved on the .cvs file is not imported into Zen Cart. When I save the file to be imported I save it as a .csv file. I get a message that the import was successful but I don't receive any messages about the site being updated like I do on my PC.
Am I missing something here? I know I can't be the only one using an Apple to run Easy Populate. Any help would be appreciated. Hopefully I have given you enough information to help me, if not let me know.
Quote:
Originally Posted by
rstevenson
I'm on Mac (OS X v10.4.11) and I too use Excel and EZ Populate, but not often so my memory is a bit rusty on this. I recall that I had some sort of problem using the Excel-created file directly. Since I have a programmer's editor (the excellent BBEdit, see barebones.com) it was easy and quick to open the file in my editor, save it again and then upload it. I never trust MS products to do things simply, so I wouldn't expect the Excel file to be a plain text file. There'll be some junk in it somewhere, I'm sure.
Rob
Re: Easy Populate support for Version 1.2.5.4
EP is not updating my images file name and path. Is the problem the "/" in the file path? I need to get this working ASAP, I have over 5000 itmes to input.
Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?
I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.
my images are all in images/products/123456.jpg and I have verified they are there.
My csv file looks like this:
Code:
v_products_model,v_products_imagev_products_model,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_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_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
yet when I upload and import the file I get images/no_picture.gif assigned to each item.
What am I missing?
JOhn ><>
Re: Easy Populate support for Version 1.2.5.4
Stuff4Toys As far as I was aware you will only get 'images/no_picture.gif' if no image is assigned to the product, so it would appear that the version you are using is not updating the database in someway properly.
When you edit the product manually is there a image assigned or is the image box empty.
Also I would try the Langer's version from Modhole as this is a tried and tested version that just works !
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
Stuff4Toys
EP is not updating my images file name and path. Is the problem the "/" in the file path? I need to get this working ASAP, I have over 5000 itmes to input.
Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?
I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.
my images are all in images/products/123456.jpg and I have verified they are there.
My csv file looks like this:
Code:
v_products_model,v_products_imagev_products_model,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_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_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
yet when I upload and import the file I get images/no_picture.gif assigned to each item.
What am I missing?
JOhn ><>
Its a problem with your directory. I think by default it chooses /images which means that your images should be in /images/products I think.
Re: Easy Populate support for Version 1.2.5.4
fsc09 EP takes the folder /images/ as default so their is no need to put this in the v_products_image, just the child folder to /images/. In this case that would be products/ - e.g products/33838.jpg.
What is strange, if EP had put the image in the 'products_image' you should not get 'images/no_picture.gif' appearing as ZC sees that the 'product_image' field is not 'null', therefore that is why I asked does the image details appear when you edit the product by ZC.
Re: Easy Populate support for Version 1.2.5.4
I am on Zen Cart v 1.3.8a
Does Easy Populate 1.2.5.5 work with that? The download page says it is for Zen Cart v 1.3.6
I just want to make sure as I am new to Zen Cart in the last month.
Re: Easy Populate support for Version 1.2.5.4
I uploaded quite a few products last night successfully. This morning I'm getting "Upload Complete", but nothing is being uploaded. I don't get the list of products added like I did last night - just the complete message (with temp file name, user filename, and size displayed). Any ideas?
Re: Easy Populate support for Version 1.2.5.4
Nevermind. I found it - I had saved the file as csv rather than txt (tab).
Re: Easy Populate support for Version 1.2.5.4
Referring to EP 1.2.5.5 csv2.
I installed this without a glitch following instructions in install.txt.
However, I was curious as to what the install.sql was doing in the install package.
I did not need this file to perform installation, did not use it.
I looked into the sql and saw it is intended for 1.2.5.4.
So, shouldn't it be removed from the install package for 1.2.5.5?
Re: Easy Populate support for Version 1.2.5.4
Will EP work with the MultiSite Module I have installed?