EXCEL Populate [Support]

[hase]

As I can't edit my post I have to add here the error message on a white page doing the mentione testing:
Error on white page:
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 '' at line 1
in:
[select c.categories_id, cd.categories_name from shop_categories c, shop_categories_description cd where c.categories_id=cd.categories_id and c.parent_id=0 and cd.categories_name='Top' and cd.language_id=]

[kabatza]

Hi,

@hase
Have you actually managed to create an excel file but you cannot put it back after editing???

I have a fresh instaled version 1.3.9h with the following add-ons:
a)a custom template
b) backup_zc
c) Ckeditor
d) Excel populate

Excel populate seems to function ok up to the creation of the file....

"file xxxxxxxxxxxxxxxxxx.xls has been created" is displayed on top. but guess what? there is no file in the temp forlder

I try again....same thing

Folder permissions are 777 as per instructions

Any sugestions

[hase]

Hi,

@hase
Have you actually managed to create an excel file but you cannot put it back after editing???

Hi,

yes, I can create an excel file without having any problems, but "Populate from file" doesn' work at all.
Zen Cart version 1.3.9h

I don't have a clue, why you cannot find any file in renaimed_admin/temp.
Have you had a look at the cache folder? There might be a debug file showing some info.

[kabatza]

Hi,

yes, I can create an excel file without having any problems, but "Populate from file" doesn' work at all.
Zen Cart version 1.3.9h

I don't have a clue, why you cannot find any file in renaimed_admin/temp.
Have you had a look at the cache folder? There might be a debug file showing some info.

Hmmmmm.....

I will have to give it another go then.....
I did not check the cache folder....and I cannot do it now either, because I also installed easypopulate, and because i like to keep my installation clean.... I deleted it all and restored a backup.

It takes me ages to list things the normal way.....so I think I better give it another go now!

I will report back once I finish.

[kabatza]

OK.....here is what the debug file says:

[19-Dec-2010 08:23:17] PHP Warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/customers/mysite.com/mysite.com:/var/www/diagnostics:/usr/share/php) in /customers/mysite.com/mysite.com/httpd.www/my_admin/includes/excel/OLE/PPS/File.php on line 87

My host has safe mode off, but have open_basedir enabled.

The folders they allow are:

/customers/yourdomain.com/mysite.com, /usr/share/php

The following PHP are disabled disabled:
disk_total_space, diskfreespace, exec, system, popen, proc_open, proc_nice, shell_exec, passthru, dl, set_time_limit and the 5th parameter in mail().

Any way to work around this????

[kabatza]

I may confuse somebody .... so here is again what my host allows.

/customers/mysite.com/mysite.com, /usr/share/php

which looks fine to me.

but what is the "File()" in the debug file?

And more important how do I fix it ?

[hase]

Hi,

sorry, but I can't help with this issue.

I gave up testing EXCEL Populate and stick with the old Easy Populate.

[human1101]

Hi,

yes, I can create an excel file without having any problems, but "Populate from file" doesn' work at all.
Zen Cart version 1.3.9h

I don't have a clue, why you cannot find any file in renaimed_admin/temp.
Have you had a look at the cache folder? There might be a debug file showing some info.

I am also having this issue, i can export the xls file and upload it after editing it, but then when i click "populate from file" then "populate" nothing happens and no products are uploaded


any help would be appreciated

[triumph]

Hi

Up! +1

If editor can check this please!

[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/xxxxx...=start_cr_file. I followed the install instrutions and not sure what I did wrong. Thanks in advance.

Andy