Gossamer Forum
Home : Products : DBMan : Customization :

ID/File-Upload/Excel Mod Problem???

Quote Reply
ID/File-Upload/Excel Mod Problem???
Bout three weeks ago I changed my DBMAN's "ID" to "AlumniID", which fixed my Excel Mod problem. Now today, I'm seeing my AlumniID go incrementally from 196 to 197 to 1981 to 1985. (The 1981 and 1985 also equals the Year Grad field I have in my alumni database) The additional problem is that with the 1981 and 1985 AlumniID, the file-upload doesn't work with 1981.jpg and 1985.jpg
Is it perhaps a Y2K thing? Do I need to wicker my .cfg or html.pl in the area of file upload?
Quote Reply
Re: ID/File-Upload/Excel Mod Problem??? In reply to
Did you change your $db_key_track variable to "AlumniID"?

Also, did you by chance an additional field in the db_def hash and forgot to add the field to your existing database?

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------




Quote Reply
Re: ID/File-Upload/Excel Mod Problem??? In reply to
$db_key='AlumniID'
$db_key_track=1

posn 0 of db_def simply changed from 'ID' to 'AlumniID'

In html.pl sub html_record_form I've got
Code:
print qq|
<TABLE WIDTH="450" CELLPADDING=0 CELLSPACING=0 BORDER=1 BACKGROUND="http://www.flash.net/~murgnam/ll1.gif">
<TR><TD ALIGN="Right" VALIGN="TOP"><$font>AlumniID:</FONT></TD>
<TD VALIGN="TOP">
<INPUT TYPE="TEXT" NAME="AlumniID" SIZE="3" VALUE="$rec{'AlumniID'}" MAXLENGTH="5"></TD></TR>
...

and in sub html_record_long I've got

Code:
# <-- Start of record display -->

my $font_color = 'Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399';

print qq|
<TABLE WIDTH="500" CELLPADDING=0 CELLSPACING=0 BORDER=1 ALIGN=CENTER BACKGROUND="http://www.flash.net/~murgnam/ll1.gif">
<tr><td valign="top" rowspan="3">|;
# to close off a previous print qq| statement
$ALLOWED_EXT =~ s/\\.//g;
$ALLOWED_EXT =~ s/\$//g;
@extensions = split (/\Q|\E/o,$ALLOWED_EXT);
GRAPHIC: foreach $extension (@extensions) {
if (-e "$SAVE_DIRECTORY/$rec{$db_key}.$extension") {
print qq|<img src= "$SAVE_DIRECTORY_URL/$rec{$db_key}.$extension">|;
last GRAPHIC;
}
}
print qq|</td>
<TD COLSPAN="15">Title:</TD>
<TD COLSPAN="10">$rec{'Title'}</TD>
...

Note in the long format I "don't" have AlumniID, as that only confuses the alumni -- just need it for my purposes ... but then, I "guess" that could be my problem?


Quote Reply
Re: ID/File-Upload/Excel Mod Problem??? In reply to
Oopss..I messed up the variables.

Sorry about that.

Not posting the AlumniID in the long display should NOT be affecting the problem. Try putting it in the long display routine with only admin being able to view it. See if that makes a difference.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------




Quote Reply
Re: ID/File-Upload/Excel Mod Problem??? In reply to
Eliot,

It's like we thought. Even with adding the AlumniID to the long display and making it admin only I still go from 196 to 197 to 1986 to 1987 etc.

That said, I simply d/l my default.count changed from 1986 to 199 and re-uploaded. My test addition pulled up record 200, which is the design ... but did I really fix it?

We'll see I guess.

Thx 4 the help tho, :-)

JR