Gossamer Forum
Home : Products : DBMan : Customization :

Export to Excel mod

Quote Reply
Export to Excel mod
I've just finished testing an Export mod with my outdated browsers (IE3, IE4, NN3 and NN4). Was hoping that there are some interested parties willing to test with their browsers, especially IE5.

Use the Guest account and View option at www.public-knowledge.com/cgi-bin/dbman/db.pl .

I can post the mod if anyone is interested. It is fairly generic - exporting only non-admin fields.

Ideally I would like an Export Preview page that allows the user to select which fields to export. Any ideas here would be appreciated. I imagine another form in html.pl with checkboxes for allowed fields, then a loop to process this array, rather than the one I use now.
Code:
for (my $i =0; $i <= $#db_cols; $i++) {
if ($db_form_len{$db_cols[$i]} >= -1) {
# Export all non-admin fields (admin form length = -2)
print qq|<td width="$db_lengths{$db_cols[$i]}"> <$font>$rec{$db_cols[$i]}</font></td>|;
}
}

Maybe Carol can help here??? I have seen some of her other code wizardry.

Look forward to all comments and suggestions.




------------------
Don Mitchinson
Subject Author Views Date
Thread Export to Excel mod mitch 4096 Oct 4, 1999, 8:38 AM
Post Re: Export to Excel mod
mitch 3988 Oct 3, 1999, 9:08 PM
Post Re: Export to Excel mod
Eliot 4021 Oct 4, 1999, 8:53 AM
Post Re: Export to Excel mod
JPDeni 4014 Oct 4, 1999, 1:43 PM
Post Re: Export to Excel mod
mitch 4002 Oct 4, 1999, 7:27 PM
Post Re: Export to Excel mod
JPDeni 3996 Oct 4, 1999, 7:42 PM
Post Re: Export to Excel mod
Glen Payne 3989 Oct 5, 1999, 1:54 AM
Post Re: Export to Excel mod
mitch 4003 Oct 5, 1999, 4:11 AM
Post Re: Export to Excel mod
mitch 4044 Oct 5, 1999, 4:27 AM
Post Re: Export to Excel mod
Glen Payne 3997 Oct 5, 1999, 4:34 PM
Post Re: Export to Excel mod
mitch 3996 Oct 5, 1999, 6:19 PM
Post Re: Export to Excel mod
dse 4023 Jan 26, 2000, 11:54 AM
Post Re: Export to Excel mod
mitch 4006 Jan 26, 2000, 12:30 PM
Post Re: Export to Excel mod
mitch 3991 Jan 30, 2000, 9:02 PM
Post Re: Export to Excel mod
dse 3978 Jan 31, 2000, 6:23 AM
Post Re: Export to Excel mod
mitch 4001 Jan 31, 2000, 6:40 AM
Post Re: Export to Excel mod
dse 4025 Jan 31, 2000, 7:54 AM
Post Re: Export to Excel mod
dse 4050 Jan 31, 2000, 8:14 AM
Post Re: Export to Excel mod
dse 4005 Jan 31, 2000, 10:47 AM
Post Re: Export to Excel mod
dse 3984 Jan 31, 2000, 10:51 AM