EXCEL Populate [Support]

I reinstalled the folders and files and now it generates the file, or so it says it does, I just cannot find it now. My FTP client that I use is able to seachr all the files and folders for me and it came up empty when I told it to search the file it said it created. Is there a code in it that I may need to change? Once again, thank you in advnace.

Andy

When trying to import the file (using the generated Excel file as the source and adding my rows without ID's and entering PPL in cell A1) the file returns the message: HTTP 500 Internal Server Error.

The Excel Populate routine looks exactly what I am looking for...just can not get it to work.

The cache file references errors with line 27 and 138 and 133 but do not see anything in the file that would cause the error(s).

Uninitialized string offset: 2199023255040 in /.../includes/excel/oleread.inc on line 27

Undefined index: in /.../includes/excel/oleread.inc on line 138

PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 71 bytes) in /.../includes/excel/oleread.inc on line 133

The module works with an error. I could ignore the error but would like to remove it.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Clothing' and cd.language_id=1' at line 1
in:
[select c.categories_id, cd.categories_name from categories c, categories_description cd where c.categories_id=cd.categories_id and c.parent_id=0 and cd.categories_name='Men's Clothing' and cd.language_id=1]
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.

When I try and open the downloaded file in excel, I get the following error.

• <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error004880_01.xml</logFileName> <summary>Errors were detected in file 'C:\Users\AfterHouR\Downloads\products_###############.xls'</summary>
• <additionalInfo> <info>Excel recovered your formulas and cell values, but some data may have been lost.</info> <info>Excel found errors that may cause some recovered data to be put in the wrong cells. Please check your recovered data carefully.</info> </additionalInfo> </recoveryLog>

Any help would be appreciated.

Kind Regards
AfterHouR

axxess:

The module works with an error. I could ignore the error but would like to remove it.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Clothing' and cd.language_id=1' at line 1
in:
[select c.categories_id, cd.categories_name from categories c, categories_description cd where c.categories_id=cd.categories_id and c.parent_id=0 and cd.categories_name='Men's Clothing' and cd.language_id=1]
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.

dont use this add-on.....it is full of bugs and is not even working at 50%

You can add manufacturers and new categories but you cannot delete them as shown in the manual.....
if put a "D" in the manufacturers url the result is a "D" added in the url and thats about it.

With the products:
It cannot modify my products and it does not delete them either if i put PPL in the ID label it just returns with this :

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Clothing' and cd.language_id=1' at line 1
in:
[select c.categories_id, cd.categories_name from categories c, categories_description cd where c.categories_id=cd.categories_id and c.parent_id=0 and cd.categories_name='Men's Clothing' and cd.language_id=1]
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.

This is mentioned above by another user too:

having a look in my products after, one is missing its category and its now lost "not visible" anywhere in zen cart.

Dont use! it messes your product list!!!!!!

Hi people!

There is a new version here:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1820

there is somebody test it ?

thanks

What was updated? Does it handle attributes now?

step #3 of installation requires a few lines added to this file:

ADMIN_FOLDER/includes/boxes/catalog.php

I don't have this file. I do have catalog_dhtml.php though.

I'm just not willing to mess up my database any more. :wacko:
Because of this add-on I have now items appearing in the front end of my shop but don't exist in the admin, and even worse don’t appear in the easypopulate csv file either, so I cannot delete them! :frusty:

People, backup your database before use this, and restore it after even though it may look like everything is OK. It will not be! :no:

Plus it is not useful at all without the attributes and the rest
Easypopulate instead works just fine with MS excel and with open office.

Don’t waste your time! This contribution is far from ready....it should not be here!

Hi,
I tested this mod too.
ZC 1.3.9h with few mods - Ceon uri, Lightbox, Additional product fields ...

1. Excell export work fine. There is xls file created with correct time stamp.
2. Excell import - part of it works:

• when ID column heading is changed to PPL, upload file and click on populate - SQL error appears:
  1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Clothing' and cd.language_id=1' at line 1
  in:
  [select c.categories_id, cd.categories_name from categories c, categories_description cd where c.categories_id=cd.categories_id and c.parent_id=0 and cd.categories_name='Men's Clothing' and cd.language_id=1]
  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.

• when you hit BACK button you will see that there is products out of any category. The problem is that there is in database, in table Products field "master_category_id", but excel populate sending value to field "category_id". SQL script stops. Only first product in list is particularly added.

• there is no record in table "products_to_categories" - this is the reason for invisible products, located out of any category. If you try to add manual field in table "products_to_categories" product appears.

3. DO NOT try to rename defined categories_id to master_categories_id. Everything in DB goes wrong... You can add additional def "master_categories_id" in excell.php

I'll try to rewrite defs in excell.php. There is need of additional $products_to_categories, I thing... If someone can help, this will be good. I'll share the solution when I have it.

drewtracy:

When I click on Generate, I get a 500 error page. this is what is in the address bar with the admin directory xx out ......http://www.tracysjewelry.cz.cc/xxxxxxxx/excel.php?action=start_cr_file. I followed the install instrutions and not sure what I did wrong. Thanks in advance.

Andy

The problem can be because you have to use 64bit version. Please download latest addon

Oscommerce version of Excel Populate used at many different stores. It tested many times. One of store used it to work with 84 000 products. Other to work with 34 000 products.

Zen Cart version is new and free. It does not tested many times. I used it several times for my clients without problems.

I know possible problems:

1. Slow server or many limitations for hosting. If you have lots of products then please generate and populate part of products at once.

2. 64bit server . Please use correct includes/excel/ folder.

3. BACKUP database before populate!!! This is very important.

Thanks for everybody.

I have a question regarding the links column. The links column gives the name of the image only (i.e. photo.jpg.) Is there a way to make it insert a url in front each image name. Basically here it is.

Have In Links Colunmn: photo.jpg.
Need By Default In Links Column: https://www.example.com/images/photo.jpg.

Thank you for your help.

• New Guy

HI

I started a new thread because I didn't know this one was here. Please can you take a look and offer some advice.

http://www.zen-cart.com/forum/showthread.php?p=1026231#post1026231

Regards

John

I am really annoyed with excel populate. I have succesfully exported my products etc and then imported into a fresh install. When I go into a product none of the details are there. If I cancel the detail remains as per the import. I can view all the detail in the online store. If I change the Qty and update it loses all the detail apart from the price and SKU. Help

Hi

I am having a installation problem I think with Excel populate.

I followed the instructions and the option Excel Populate comes up in the catalog options in the admin control panel, but I just get an error message saying The requested URL /zc_admin/FILENAME_EXCEL.php was not found on this server, when I click on it.

I wasn't that sure about step 4 on the readme install guide. I created a file called filenames.php the contents of which are:

and added it to the zc_admin/includes directory

Any ideas as it looks like it will be really useful.
thanks
colin

Hi kmbi,

Did you find any solution to this? If so please share. I have just tried installing this and come up to a similar problem. I should have searched the forum first!

Thanks in hope!

Tyron

kmbi:

Hi,
I tested this mod too.
ZC 1.3.9h with few mods - Ceon uri, Lightbox, Additional product fields ...

1. Excell export work fine. There is xls file created with correct time stamp.
2. Excell import - part of it works:

• when ID column heading is changed to PPL, upload file and click on populate - SQL error appears:
  1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Clothing' and cd.language_id=1' at line 1
  in:
  [select c.categories_id, cd.categories_name from categories c, categories_description cd where c.categories_id=cd.categories_id and c.parent_id=0 and cd.categories_name='Men's Clothing' and cd.language_id=1]
  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.

• when you hit BACK button you will see that there is products out of any category. The problem is that there is in database, in table Products field "master_category_id", but excel populate sending value to field "category_id". SQL script stops. Only first product in list is particularly added.

• there is no record in table "products_to_categories" - this is the reason for invisible products, located out of any category. If you try to add manual field in table "products_to_categories" product appears.

3. DO NOT try to rename defined categories_id to master_categories_id. Everything in DB goes wrong... You can add additional def "master_categories_id" in excell.php

I'll try to rewrite defs in excell.php. There is need of additional $products_to_categories, I thing... If someone can help, this will be good. I'll share the solution when I have it.

Fantastic installed on second attempt. The first was my bad, you know how sometimes you think you know what you just read...:blush:

Did get one little error message up in excel said on opening the file. pop-up window saying

File error: data may have been lost.

Will try some changes and additions-> up-load and redownload the file see if it happens again.

Unless this is a know issue of course

Other than that Thank you and have a good christmas :bigups:

when posting new products it would be great if you guys can explain how to install the products step by step and put out a youtube video on how to use it.it really help us newbies out.....thanks

i just added it into my admin folder where easy populate is dont know if it did anything

Hi to all, I am having problem with excel populate. My store is in Bulgarian and when I export my products to a xls sheet I get only "Креатинът д" it seems that there is some kind of a problem with the encoding, but I cannot find how to fix it... I tried to import to Open Office then save as CSV with UTF-8 format but still nothing :frusty: , can you please help me!

Thanks