Zen Cart Logo
trapezoid-twopenny
Open navigation menu
Home Community Forum Plugins
Documentation
For Developers For Storeowners
Services Donate Get Started
Forums / All Other Contributions/Addons / EXCEL Populate [Support]

EXCEL Populate [Support]

Results 1 to 20 of 71
07 Dec 2010, 10:31
#2
mybiz9999 avatar

mybiz9999

Zen Follower

Join Date:
Jul 2010
Posts:
143
Plugin Contributions:
0

Re: EXCEL Populate [Support]

Great!
Thank you so much. it's possible to setup the master-category-id with it?
07 Dec 2010, 10:38
#3
advancewebsoft avatar

advancewebsoft

New Zenner

Join Date:
Dec 2010
Posts:
8
Plugin Contributions:
0

Re: EXCEL Populate [Support]

> it's possible to setup the master-category-id with it?
----------------
yes, it is possible. Find in excel.php

$products_fields = array('products_id' => 0,

here you can define columns which you see in Excel. Add master-category-id there.
07 Dec 2010, 23:20
#4
xcluzivbrand avatar

xcluzivbrand

New Zenner

Join Date:
Dec 2010
Posts:
2
Plugin Contributions:
0

Re: EXCEL Populate [Support]

Hi I think I finally got everything installed right but when I go to Catalog and then go to Easy Populate it takes me to a blank page? Any suggestions??
08 Dec 2010, 16:05
#5
advancewebsoft avatar

advancewebsoft

New Zenner

Join Date:
Dec 2010
Posts:
8
Plugin Contributions:
0

Re: EXCEL Populate [Support]

> Hi I think I finally got everything installed right but when I go to Catalog and then go to Easy Populate it takes me to a blank page? Any suggestions??
---------------------------
This is very strange. You can switch on errors to see error. Let me to know it.
You can contact our support and we'll install Excel Populate at your site.
10 Dec 2010, 17:04
#6
funna_21 avatar

funna_21

New Zenner

Join Date:
Dec 2010
Posts:
12
Plugin Contributions:
0

Re: EXCEL Populate [Support]

hi guys got an issue with EXCEL POPULATE . when i upload the spreadsheet with all the data completed upload is fine. but when i go to click populate a blank white screen appears.. can someone help me ?
12 Dec 2010, 21:53
#7
advancewebsoft avatar

advancewebsoft

New Zenner

Join Date:
Dec 2010
Posts:
8
Plugin Contributions:
0

Re: EXCEL Populate [Support]

Please switch on display errors option and let me to know errors.
13 Dec 2010, 00:48
#8
funna_21 avatar

funna_21

New Zenner

Join Date:
Dec 2010
Posts:
12
Plugin Contributions:
0

Re: EXCEL Populate [Support]

how do i switch on error display??
16 Dec 2010, 15:39
#10
hase avatar

hase

New Zenner

Join Date:
Nov 2009
Posts:
9
Plugin Contributions:
0

Re: EXCEL Populate [Support]

advancewebsoft:

I've developed Excel Populate for Zen Cart. Here it is
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1820

Main possibilities is add/edit/delete products via Excel file. This is advanced version of Easy Populate.

Excel Populate will be in Zen Cart addons soon


Hi,

believing, everything is installed properly, I can't get "Adding" or "Update" working.
error_reporting is turned on.
On one server I'm getting a blank page.

Regardless of how much memory is allocated, the myDEBUG-adm-xxx in in the cache-folder is showing:
PHP Fatal error: Allowed memory size of 142606336 bytes exhausted (tried to allocate 71 bytes) in /xxxxxxxxxx/admin/includes/excel/oleread.inc on line 133

On an other server populating an excel-file for adding returns to the filemanage page, but has done nothing.
No error at all, not even in the cache folder files.

On this server I did a test by editing the created file created by the tool to state it's an update. Accordingly to the instructions I put in the "PPL" (without quotation marks).

This happened:
Products and manufacturors remain untouched, but all the categories where set to "0"

What's going wrong?
Did I miss something?

Any help and advise appreciated.

I appologize for my faulty English, but it's not my mothertongue.
16 Dec 2010, 15:50
#11
hase avatar

hase

New Zenner

Join Date:
Nov 2009
Posts:
9
Plugin Contributions:
0

Re: EXCEL Populate [Support]

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=]
17 Dec 2010, 09:05
#12
kabatza avatar

kabatza

New Zenner

Join Date:
Dec 2010
Posts:
11
Plugin Contributions:
0

Re: EXCEL Populate [Support]

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 :blink:

I try again....same thing :cry:

Folder permissions are 777 as per instructions

Any sugestions :unsure:
17 Dec 2010, 13:14
#13
hase avatar

hase

New Zenner

Join Date:
Nov 2009
Posts:
9
Plugin Contributions:
0

Re: EXCEL Populate [Support]

kabatza:

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.
19 Dec 2010, 05:52
#14
kabatza avatar

kabatza

New Zenner

Join Date:
Dec 2010
Posts:
11
Plugin Contributions:
0

Re: EXCEL Populate [Support]

hase:

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.....:wacko:

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. :blink:

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.
19 Dec 2010, 09:43
#15
kabatza avatar

kabatza

New Zenner

Join Date:
Dec 2010
Posts:
11
Plugin Contributions:
0

Re: EXCEL Populate [Support]

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
:wacko:


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???? :unsure:
19 Dec 2010, 14:07
#16
kabatza avatar

kabatza

New Zenner

Join Date:
Dec 2010
Posts:
11
Plugin Contributions:
0

Re: EXCEL Populate [Support]

:oops:
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 ?
19 Dec 2010, 18:59
#17
hase avatar

hase

New Zenner

Join Date:
Nov 2009
Posts:
9
Plugin Contributions:
0

Re: EXCEL Populate [Support]

Hi,

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

I gave up testing EXCEL Populate and stick with the old Easy Populate.
22 Dec 2010, 23:42
#18
human1101 avatar

human1101

New Zenner

Join Date:
Dec 2010
Posts:
3
Plugin Contributions:
0

Re: EXCEL Populate [Support]

hase:

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
:frusty:

any help would be appreciated
29 Dec 2010, 19:53
#19
triumph avatar

triumph

New Zenner

Join Date:
Feb 2010
Posts:
36
Plugin Contributions:
0

Re: EXCEL Populate [Support]

Hi

Up! +1

If editor can check this please! :smile:
05 Jan 2011, 04:45
#20
drewtracy avatar

drewtracy

New Zenner

Join Date:
Jan 2011
Posts:
3
Plugin Contributions:
0

Re: EXCEL Populate [Support]

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