Easy Populate 1.2.5.4 support

marksu:

Anyone solved the isue with attributes.txt file having too many columns to import to excel?

marksu
I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
TIA

Hi,

I'm really trying my best to understand easy populate but I'm not doing to well. After 1 month of messing around with it I have to ask you guys for help on it.

I have zencart version 1.3.7. because that's supported by the dutchlanguage pack. I have created categories in the dutch language but have no products added. The products I want to add come from another site made with shop2date (by databecker) and are made in xml. files

Now the first thing I run into is that I can not get it installed. Not from zencart admin and not by directly typing the mysql thing. I read something about turning the dutch of? But I don't know how to do it. Also would that make me loose my categories (I have over 75 of them!).

Also do I install the files from easy populate right if I put them in c:\xampp\htdocs\zen ? And the register globals in which php.ini should I turn them on (because there are several when running it on pc)

Thank you in advance for helping... sorry being such a noob

Juliet van Ree

This is what it looks like by the way, in zen admin

I just don't know what to do now.

Hi somewhere in this huge thread, someone mentioned a problem with uploaded products not producing a product page. I can't find that particular post but is here.

What happens when I use easy populate to upload new products, the upload works to a point where you can view the new products in the product listing, but when you click the product to open the product page, I get "page not found".

Does anyone have any idea what will cause this??

Help would be appreciated..

I also still have this problem regarding the attributes .txt file as mentioned in post above & below!

I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.

P.S using zen version 1.3.8a

TIA

I have the purchased version of Easy Populate. I want to know is it possible to define the category meta tages with EP. These are the fields i used for products:

v_metatags_title_en, v_metatags_keywords_en, v_metatags_description_en

Will it work for categories?

heavenlynights:

I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
TIA

It seems there is no real answer, at least not one I could find here.

Another way to add attributes is to add them direct to your database via phpmyadmin. I have tried this and it works fine.

My store is live but not 'released' as such, ie, it's brand new I haven't advertised it and it has no traffic so it's ok to mess around with things. What I did is this.

Go to your database via phpmyadmin and click on the products_attribute table then the export tab. Select csv for MS Excel and select put field names in first row, select zipped then click go. Save to your computer when asked.

I only had a few products added to my DB so it was easy to see what was required when editing the spreadsheet, when you have finished editing delete the row with field names and save as a .csv

Putting it back is basically the export procedure in reverse. Go to the products_attributes table and click the import tab then browse to your saved .csv file, then click the csv option in the format of imported file box and be sure to change the field terminated by ; to , (semi colon to comma) there are other options for 'replace table data with file' this will replace all the data within the table, and ignore duplicate rows. I usually select replace table data.

This has worked fine for me, it worked fine with oscommerce too. Two rules.

1. BACK UP FIRST
2. Never forget rule 1.

Impact-Flies:

It seems there is no real answer, at least not one I could find here.

Another way to add attributes is to add them direct to your database via phpmyadmin. I have tried this and it works fine.

My store is live but not 'released' as such, ie, it's brand new I haven't advertised it and it has no traffic so it's ok to mess around with things. What I did is this.

Go to your database via phpmyadmin and click on the products_attribute table then the export tab. Select csv for MS Excel and select put field names in first row, select zipped then click go. Save to your computer when asked.

I only had a few products added to my DB so it was easy to see what was required when editing the spreadsheet, when you have finished editing delete the row with field names and save as a .csv

Putting it back is basically the export procedure in reverse. Go to the products_attributes table and click the import tab then browse to your saved .csv file, then click the csv option in the format of imported file box and be sure to change the field terminated by ; to , (semi colon to comma) there are other options for 'replace table data with file' this will replace all the data within the table, and ignore duplicate rows. I usually select replace table data.

This has worked fine for me, it worked fine with oscommerce too. Two rules.

1. BACK UP FIRST
2. Never forget rule 1.

Thanks Impact. Much appreciate your assistance. This will save me a lot of time..

Do you use easy populate for adding products? if so do you have the same problem regarding no product page created?

TIA

heavenlynights:

Thanks Impact. Much appreciate your assistance. This will save me a lot of time..

Do you use easy populate for adding products? if so do you have the same problem regarding no product page created?

TIA

I added just 6 products with EP to start with to a sub category and they all uploaded fine to the correct place and all display ok, providing everything is added to the correct columns I wouldn't expect to have a problem (?) adding a lot at one time.

One thing I should of mentioned in my previous post about attributes.

When you download the DB table and open it with Excel or Calc the format is a little different to what you get from the EP attribute download.

In column A is attributes ID, this (it seems) has to be a different number for every line and the number has no bearing on the product ID in column B. In column B you have your product ID number and that column can have repeats of the ID number due to the same product have several attributes, so the same product with several attributes would look a little like this in column A & B

A___________________B
products_attributes_id products_id
1___________________1
2___________________1
3___________________1
4___________________1

So product #1 has four separate attributes.

If your store is live it would be prudent to set up a test category with a handful of products and add attributes to these before trying it on live products. BACK UP the table first so if anything goes wrong you can restore the back up and put everything back to how it was.

I am also having an issue importing the attributes.txt file into excel. too many columns. does anyone have a resolution for this problem.
Use Open Office, instead of excel.. works fine.
http://www.openoffice.org/

I do use Calc from Open Office. The file seemed to edit ok but the attributes never got added when I restored the file. Perhaps I did something wrong but it seems a lot of people have trouble getting the attributes side of EP to actually work.

Impact-Flies:

I added just 6 products with EP to start with to a sub category and they all uploaded fine to the correct place and all display ok, providing everything is added to the correct columns I wouldn't expect to have a problem (?) adding a lot at one time.

One thing I should of mentioned in my previous post about attributes.

When you download the DB table and open it with Excel or Calc the format is a little different to what you get from the EP attribute download.

In column A is attributes ID, this (it seems) has to be a different number for every line and the number has no bearing on the product ID in column B. In column B you have your product ID number and that column can have repeats of the ID number due to the same product have several attributes, so the same product with several attributes would look a little like this in column A & B

A___________________B
products_attributes_id products_id
1___________________1
2___________________1
3___________________1
4___________________1

So product #1 has four separate attributes.

If your store is live it would be prudent to set up a test category with a handful of products and add attributes to these before trying it on live products. BACK UP the table first so if anything goes wrong you can restore the back up and put everything back to how it was.

Thanks impact for that, I only uploaded 3 new products to test and this is where i came across the glitch. Haven't tried since, no point till I get a fix for it.

misty - Use Open Office, instead of excel.. works fine.
http://www.openoffice.org/

Thanks misty - visited site, says that it doesn't support all platforms as yet. do you know if windows Vista is one of those non supported platforms? Doesn't mention the platforms not supported.

TIA

marksu:

Anyone solved the isue with attributes.txt file having too many columns to import to excel?

marksu
view thread:
http://www.zen-cart.com/forum/showpost.php?p=550192&postcount=1509

Thank you so much for the tip to use OpenOffice! It was so great to finally see actual columns of data!!!

HOWEVER, my column headings don't match up with the data after the first few. I have been deleting thru the admin panel unnecessary Option Names with their corresponding Values to try to reduce the downloaded file size. So I tried manually realigning the file headings with their data but say there should be "16" attribute values for one name, the headings only seem to have three of them. Totally messed up.

Has anyone ever seen columns being out of synch like that? I noticed it in Excel too with what little I could see of the columns.

zencart 1.3.7

Thanks misty - visited site, says that it doesn't support all platforms as yet. do you know if windows Vista is one of those non supported platforms? Doesn't mention the platforms not supported.
http://wiki.services.openoffice.org/wiki/WindowsVista
Thank you so much for the tip to use OpenOffice! It was so great to finally see actual columns of data!!!
HOWEVER, my column headings don't match up with the data after the first few.
Did you download test file which contained several of your existing products
so you could obtain template, with correct Esy Populate headers, to work with?

Did you download test file which contained several of your existing products so you could obtain template, with correct Esy Populate headers, to work with?

Here's the scenario:
I use ezpop to create the attributes txt file
I use OfficeOrg to open the txt file
I search the txt file for "options_id" to see if the attached id # in the header is the same as the option # for the data included in that column. They don't match.
I look at the Option Names in the Admin Panel and notice that certain Option Names have been deleted (by me). Well, those same Option Name Id #'s are the ones that are missing from the data in the downloaded attribute text file - as you would expect. HOWEVER, the column headers STILL INCLUDE THE DELETED OPTION NAMES AND VALUES!!!

I restored my zencart to a recent backup to realign the options but it wasn't enough. I can try restoring to a system backup that was done a few days earlier.

**Is it "forbidden" to delete option names??? **(no products associated but yes, there are some values.) Maybe I should have deleted the values first and then the Option Name to clear out the db better?

I price by attribute quite a bit so this is so frustrating!!! Any help would be enormously appreciated.

thanks,
zencart 1.3.7

Madelina said - You may also need to select "Reset ALL Products Master Categories ID" in the admin ->tools -> store manager ... and "Update ALL Products Price Sorter" doesn't hurt either.

Wow, I was hoping this would fix my attributes file with mismatched headers and data for deleted Option Names but to no avail.

chadderuski:

KittieMD & Margecc:
EPA is supposed to support attributes, although I cannot personally verify this. Check langer's site. Attributes do not work in EP 1.2.5.4.

What??? Am I to understand that EP's Attribute file is garbage?

I couldn't get it to work either and after seeing the statement that you have quoted above,

EPA is supposed to support attributes, although I cannot personally verify this. Check langer's site. Attributes do not work in EP 1.2.5.4.

I gave up trying and used the database method, that did work :smile:

If you are having problems with products not showing then I would check to see that the category relations are correct, you can't add a product to a category that has sub categories, you have to add the product at the 'end of the line' so to speak.

Just installed this mod.I am getting the following errors when attempting to upload the EP (.txt) file and I get them both from browsing from my own computer as well as loading them from the temp file on the server. My temp folder chmod is set to 777. I am on an apache server.

Warning: file(/home/bidesign/public_html/youngslugs/webstore/temp/Full-EP2008May03-0707.txt) [function.file]: failed to open stream: No such file or directory in /home/bidesign/public_html/youngslugs/webstore/admin/easypopulate.php on line 1201

Warning: Invalid argument supplied for foreach() in /home/bidesign/public_html/youngslugs/webstore/admin/easypopulate.php on line 1301

Line 1201 starts with -$readed=
// get the entire file into an array
$readed = file(DIR_FS_CATALOG . $tempdir . $file['name']);
}

Line 1301 starts with - foreach
// now we string the entire thing together in case there were carriage returns in the data
$newreaded = "";
foreach ($readed as $read){
$newreaded .= $read;
}

I downloaded the included template file from this mod and used its format. Any help would be greatly appreciated.

Thanks,

Luck38

Is the temp folder in your webstore directory? I would check to see that all the folders and files are in the correct place, the error seems to suggest that it's calling for a file/folder that can't be found.