Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Customization :

Spreadsheet Format Display

Sep 26, 2006, 10:24 PM
dianarae
User (120 posts)
Sep 26, 2006, 10:24 PM
Post #1 of 8
Views: 5368
Shortcut
Quote Reply
Spreadsheet Format Display
Can the MOD Spreadsheet Format Display be used on the user friendly html.pl?
Diana Rae
Sep 27, 2006, 6:19 AM
JPDeni
Veteran / Moderator (8669 posts)
Sep 27, 2006, 6:19 AM
Post #2 of 8
Views: 5259
Shortcut
Quote Reply
Re: [dianarae] Spreadsheet Format Display In reply to
I'm assuming both mods are from my site (there are other mods, written by other people, that I don't know much about.) If so, yes, they certainly can. The changes for the spreadsheet display are all below the

# < -- End page text -->

bits in the subroutines in the user-friendly html.pl file.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Sep 27, 2006, 8:44 AM
dianarae
User (120 posts)
Sep 27, 2006, 8:44 AM
Post #3 of 8
Views: 5294
Shortcut
Quote Reply
Re: [dianarae] Spreadsheet Format Display In reply to
Thank you JPD. I'll give it a go.Smile
Diana Rae
Sep 27, 2006, 10:07 AM
dianarae
User (120 posts)
Sep 27, 2006, 10:07 AM
Post #4 of 8
Views: 5264
Shortcut
Quote Reply
Re: [dianarae] Spreadsheet Format Display In reply to
Code:
Note: In each of the header cells, replace # with the field number
# of the field that is associated with that header -- in both places within each line.

Am I right in assuming that replace # with the field number # of the field that is associated with that header is the # the in the .cfg file? For instance:

'ID' => [ 0, 'numer', 5, 255, 1, '', ''],
'Name' => [ 1, 'alpha', 25, 255, 1, '', ''],
'Officer' => [ 2, 'alpha', 0, 8, 0, '', ''],
Diana Rae
Sep 27, 2006, 10:12 AM
JPDeni
Veteran / Moderator (8669 posts)
Sep 27, 2006, 10:12 AM
Post #5 of 8
Views: 5250
Shortcut
Quote Reply
Re: [dianarae] Spreadsheet Format Display In reply to
Yes. :)


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Sep 27, 2006, 11:02 AM
dianarae
User (120 posts)
Sep 27, 2006, 11:02 AM
Post #6 of 8
Views: 5256
Shortcut
Quote Reply
Re: [JPDeni] Spreadsheet Format Display In reply to
JPD,

I do so hate to be a pain. I have spent 2 hours last night and now 3 hours today trying to do this mod. I have very carefully installed it, taken it out, reinstalled it over and over and keep getting an error. Frown

Each time I start from scratch just to make sure the database works with the orignal html.pl and it does. After I make the changes I get: DBMan encountered an internal error. Please enable debugging to view. Debugging is enabled, but shows nothing.

The error message in my domain log only says:

[Wed Sep 27 09:37:36 2006] [error] mod_gzip: TRANSMIT_ERROR:104
[Wed Sep 27 10:51:57 2006] [error] mod_gzip: TRANSMIT_ERROR:104

This is my html.pl (in text form). If it isn't a lot of trouble do you think you could take a look when you have time to see where I am making my mistake?

http://www.newoutriders.com/rosterdb/htmlpl.txt
Diana Rae
Sep 27, 2006, 11:11 AM
JPDeni
Veteran / Moderator (8669 posts)
Sep 27, 2006, 11:11 AM
Post #7 of 8
Views: 5273
Shortcut
Quote Reply
Re: [dianarae] Spreadsheet Format Display In reply to
Found it. :)

You have

Code:

sub html_record {
# --------------------------------------------------------
# How a record will be displayed. This is used primarily in
# returning search results and how it is formatted. The record to
# be displayed will be in the %rec hash.
sub html_record {
my (%rec) = @_;



Take out one of the

sub html_record {

lines -- either one -- and you'll be fine.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Sep 27, 2006, 11:20 AM
dianarae
User (120 posts)
Sep 27, 2006, 11:20 AM
Post #8 of 8
Views: 5279
Shortcut
Quote Reply
Re: [JPDeni] Spreadsheet Format Display In reply to
As ALWAYS you are the BEST!

Thank you sooo much. :)
Diana Rae