Marc,
I agree... using both would be trying. I also agree with the mail file vs DB, but my issue is really creating those mail files out of the Lotus DB. Granted it would be a repetitive function, but I thought as I'm already in the DB creating the file name, why not just dump the body of the message in there as well. If using files, I would think it would be wise to have seperate folders for each email account, which is another step in the conversion process.
Guess I'm hoping someone has been down this path and would have code to make this conversion! Ha!
Thanks for your input!
Jason Bailey
Senior Client / Server Developer
Alcott + Routon
615.346.5236
| Marc Lichtenfeld <[EMAIL PROTECTED]>
11/27/00 09:19 AM
|
To: inFusion Support List <[EMAIL PROTECTED]> cc: Subject: RE: [iMS] Shedding Lotus |
Jason,
For ease of use/development, I would recommend programming completely around one or the other but not both. Using both allows room for too many problems.
When developing, keep in mind that a database is best at sorting and searching thru data. If the mail text needs to be searchable, then entering them into the database is a good idea. However, if the data is just going to sit there, I feel that it is better to create the mail files and have a table in the database that has the file name.
That's my 2 cents.
Marc
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 9:52 AM
To: inFusion Support List
Subject: [iMS] Shedding Lotus
Greetings,
I've been working with iMS getting bulk mailing down (as I'm sure everyone that subscribes to this list is well aware :-) and am in the process of converting our company email to web based using iMS. The trick here will be porting over everyone's archived mail from our current mail server/client, Lotus Notes.
I know I can connect via ODBC to the Lotus DB, so pulling out the messages should be possible. I'm just wondering if I'll need to create a mail file for each of these archived messages (which could easily number in the thousands) or, because we plan on using SQL 7 as the DB behind iMS, storing all archived messages in SQL and using the file method of iMS for new messages.... OR, (and this is what I'm leaning towards) having iMS place all emails into the SQL DB and not using mail files.
Any input would be, as always, greatly appreciated!
Jason Bailey
Senior Client / Server Developer
Alcott + Routon
615.346.5236
