[thesite] Tips Database

Seth Bienek seth at sethbienek.com
Wed Jul 25 12:42:06 CDT 2001

Good, good, good..

Couple things..

Most of the email addresses (thelist.hdr_fromemail) have the brackets in them still.. Can we strip those in the parsing routine?  Also, some of the names (thelist.hdr_fromname) have quotes.

Also, starting with message number 11480 there is a shift in the way the date header is formatted.  I guess the difference is between the old .mbox file and the new?  Is it safe to assume that the current date format of the .mbox mail header will stay the same hereafter?

I would like it if the 'hdr_date' field were a date-time field - it would make it much easier to display and query the date of the messages.  And this may be asking too much -- the message headers have the date & time followed by the GMT offset - would it be possible to change the time on the emails to GMT time?  This would allow us to display the time in relation to the user's time zone (if available), or in relation to Evolt's time zone otherwise.

I can run a database process to fix all this stuff; could we make the changes to the perl script and DB for future imports?

One last thing (for rudy/dan/whoever) - now that the big big batch is done, we need some indexes on the table.  messageid (unique PK), header_messageid (not unique, null for older messages), hdr_inreplyto (not unique, null for original posts older messages), and hdr_fromemail (not unique, possible fk for members table?)

Thanks for putting up with all the pickiness Dean.. It's coming together nicely!


"If you're ever in an elite paratrooper group, on a secret mission, and your parachute doesn't open, I don't think anyone would blame you if you scream."  -Keith Sanvidge
Seth Bienek
Digitaris Technologies, Inc.
tel (972) 690-4131, ext. 103
fax (972) 690-0617
icq 7673959

> -----Original Message-----
> From: thesite-admin at lists.evolt.org
> [mailto:thesite-admin at lists.evolt.org]On Behalf Of Daniel J. Cody
> Sent: Wednesday, July 25, 2001 10:01 AM
> To: thesite at lists.evolt.org
> Subject: Re: [thesite] Tips Database
> doh.. give it a whirl now seth :)
> .djc.
> Seth Bienek wrote:
> >>all the posts are in thelist table like dean desc'd, use the 
> 'evolttest' 
> >>datasource
> >>
> > 
> > I get the following error when I try to access the table:
> > 
> > "ORA-00942: table or view does not exist"
> > 
> > Is it possible that the tabloe isn't there or that the DSN is 
> set up incorrectly?
> > 
> > Seth
> _______________________________________________
> For unsubscribe, archive, and options, go to:
> http://lists.evolt.org/mailman/listinfo/thesite

More information about the thesite mailing list