EXCEL Populate [Support]

[drewtracy]

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

[Happy1]

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

[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.

[AfterHouR]

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

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <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

[kabatza]

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!!!!!!

[triumph]

Hi people!

There is a new version here:

http://www.zen-cart.com/index.php?ma...oducts_id=1820

there is somebody test it ?

thanks

[rainestudios]

What was updated? Does it handle attributes now?

[rainestudios]

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.

[kabatza]

I'm just not willing to mess up my database any more.
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!

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

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!

[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.