Gossamer Forum: Products: DBMan: Customization: Where's the export to excel mod?

Sep 25, 2005, 8:29 AM

peter01

Novice (15 posts)

Sep 25, 2005, 8:29 AM

Post #1 of 4

Shortcut

Where's the export to excel mod?

Hi,

Has anyone here got a copy of the original export to excel mod lying around? It's not in the resource center on this site, and the link to the original file by the maker itself in Lois's FAQ is outdated. In this forum there are several threads about it, but none of them actually contains the complete instructions.

Thansk in advance, peter

Sep 25, 2005, 8:53 AM

JPDeni

Veteran / Moderator (8669 posts)

Sep 25, 2005, 8:53 AM

Post #2 of 4

Shortcut

Re: [peter01] Where's the export to excel mod? In reply to

There's an attached .txt file to a post in this topic -- http://www.gossamer-threads.com/...orum.cgi?post=285074 -- by LoisC.

JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.

Sep 25, 2005, 9:34 AM

peter01

Novice (15 posts)

Sep 25, 2005, 9:34 AM

Post #3 of 4

Shortcut

Re: [JPDeni] Where's the export to excel mod? In reply to

Thanks a lot, JPD!

Sep 25, 2005, 4:04 PM

peter01

Novice (15 posts)

Sep 25, 2005, 4:04 PM

Post #4 of 4

Shortcut

Re: [peter01] Where's the export to excel mod? In reply to

Hi again,

After some fiddling it's working like a charm. For what it's worth: I wanted a link to the excel export on the view_results pages. As far as I could see, there are more people that want this. This works (put it somewhere in sub view_success in html.pl):

Code:
  $xl_url = $ENV{'QUERY_STRING'};  
$xl_url =~ s/view_records/export_records/;  

 print qq|  
<a href="$db_script_url?$xl_url" target=_blank>Excel</a> |;

Works for me. Perhaps others may find it useful.

thanks again and cheers, peter

Last edited by:

peter01: Sep 25, 2005, 4:05 PM