RE: Migration of mail data
Is there a reason you need it in the server. Depending on the size with that data you could Send it all to the server with a script and something like BLAT. Kevinm M WLKMMAS, UCC+WCA, CKWSE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adam Romain Sent: Wednesday, November 21, 2001 7:44 AM To: Exchange Discussions Subject: Migration of mail data Listers, I have a situation where I need to import a whole bunch of email data in to Exchange 5.5. or Exchange 2k, not fussy. The problem with the data is the way it is formatted, although I can have it hosed in to a SQL server/access database etc. then reformatted. The format of the data is as such: to field : xxx [3 char] from field : xxx [3 char] sent : xx/xx/xx [date format] subject : xx [16 char] message body : xxx [70char * 15 lines] I can open a message in plain text format, but I need a method for getting it in the the Exchange server, say through a PST, SQL databases etc Has anyone got any pointers ? Thanks in advance Adam ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Migration of mail data
I like the BLAT idea. Interesting. The reason I need it on the server/PST's is because I'm migrating a custom made UNIX system (written in COBOL) to Exchange server. I like the BLAT / Script train of thought. The file currently has 75000 records/or messages. Pure plain text, so that makes it a bit simpler. So I could have a script that uses BLAT or MAPIsend and hoses it in to the accounts ? -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 15:46 To: Exchange Discussions Subject: RE: Migration of mail data Is there a reason you need it in the server. Depending on the size with that data you could Send it all to the server with a script and something like BLAT. Kevinm M WLKMMAS, UCC+WCA, CKWSE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adam Romain Sent: Wednesday, November 21, 2001 7:44 AM To: Exchange Discussions Subject: Migration of mail data Listers, I have a situation where I need to import a whole bunch of email data in to Exchange 5.5. or Exchange 2k, not fussy. The problem with the data is the way it is formatted, although I can have it hosed in to a SQL server/access database etc. then reformatted. The format of the data is as such: to field : xxx [3 char] from field : xxx [3 char] sent : xx/xx/xx [date format] subject : xx [16 char] message body : xxx [70char * 15 lines] I can open a message in plain text format, but I need a method for getting it in the the Exchange server, say through a PST, SQL databases etc Has anyone got any pointers ? Thanks in advance Adam ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Migration of mail data
Yeah that would a no brainier.. I would just tell them all they lost there email : Kevinm M WLKMMAS, UCC+WCA, CKWSE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adam Romain Sent: Wednesday, November 21, 2001 7:54 AM To: Exchange Discussions Subject: RE: Migration of mail data I like the BLAT idea. Interesting. The reason I need it on the server/PST's is because I'm migrating a custom made UNIX system (written in COBOL) to Exchange server. I like the BLAT / Script train of thought. The file currently has 75000 records/or messages. Pure plain text, so that makes it a bit simpler. So I could have a script that uses BLAT or MAPIsend and hoses it in to the accounts ? -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 15:46 To: Exchange Discussions Subject: RE: Migration of mail data Is there a reason you need it in the server. Depending on the size with that data you could Send it all to the server with a script and something like BLAT. Kevinm M WLKMMAS, UCC+WCA, CKWSE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adam Romain Sent: Wednesday, November 21, 2001 7:44 AM To: Exchange Discussions Subject: Migration of mail data Listers, I have a situation where I need to import a whole bunch of email data in to Exchange 5.5. or Exchange 2k, not fussy. The problem with the data is the way it is formatted, although I can have it hosed in to a SQL server/access database etc. then reformatted. The format of the data is as such: to field : xxx [3 char] from field : xxx [3 char] sent : xx/xx/xx [date format] subject : xx [16 char] message body : xxx [70char * 15 lines] I can open a message in plain text format, but I need a method for getting it in the the Exchange server, say through a PST, SQL databases etc Has anyone got any pointers ? Thanks in advance Adam ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Migration of mail data
What the heck is that data?!?!? Anyway, you should be able to format it in such a way that you can import it into Outlook - take a look at Slipstick.com and see what Sue has as reference. MSDN might have something too. -- Roger D. Seielstad - MCSE MCT Senior Systems Administrator Peregrine Systems Atlanta, GA http://www.peregrine.com -Original Message- From: Adam Romain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:44 AM To: Exchange Discussions Subject: Migration of mail data Listers, I have a situation where I need to import a whole bunch of email data in to Exchange 5.5. or Exchange 2k, not fussy. The problem with the data is the way it is formatted, although I can have it hosed in to a SQL server/access database etc. then reformatted. The format of the data is as such: to field : xxx [3 char] from field : xxx [3 char] sent : xx/xx/xx [date format] subject : xx [16 char] message body : xxx [70char * 15 lines] I can open a message in plain text format, but I need a method for getting it in the the Exchange server, say through a PST, SQL databases etc Has anyone got any pointers ? Thanks in advance Adam ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Migration of mail data
you will lose the dates, however, because they are new messages at that point. You could also drop a properly formatted message into the IMC queues, which might keep the dates, but its hit or miss, and I can't remember the exact format it needs to be in. -- Roger D. Seielstad - MCSE MCT Senior Systems Administrator Peregrine Systems Atlanta, GA http://www.peregrine.com -Original Message- From: Adam Romain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:54 AM To: Exchange Discussions Subject: RE: Migration of mail data I like the BLAT idea. Interesting. The reason I need it on the server/PST's is because I'm migrating a custom made UNIX system (written in COBOL) to Exchange server. I like the BLAT / Script train of thought. The file currently has 75000 records/or messages. Pure plain text, so that makes it a bit simpler. So I could have a script that uses BLAT or MAPIsend and hoses it in to the accounts ? -Original Message- From: Kevin Miller [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 15:46 To: Exchange Discussions Subject: RE: Migration of mail data Is there a reason you need it in the server. Depending on the size with that data you could Send it all to the server with a script and something like BLAT. Kevinm M WLKMMAS, UCC+WCA, CKWSE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adam Romain Sent: Wednesday, November 21, 2001 7:44 AM To: Exchange Discussions Subject: Migration of mail data Listers, I have a situation where I need to import a whole bunch of email data in to Exchange 5.5. or Exchange 2k, not fussy. The problem with the data is the way it is formatted, although I can have it hosed in to a SQL server/access database etc. then reformatted. The format of the data is as such: to field : xxx [3 char] from field : xxx [3 char] sent : xx/xx/xx [date format] subject : xx [16 char] message body : xxx [70char * 15 lines] I can open a message in plain text format, but I need a method for getting it in the the Exchange server, say through a PST, SQL databases etc Has anyone got any pointers ? Thanks in advance Adam ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Migration of mail data
The data is from an in house custom mail system written in Cobol One way to avoid exchange, write your own mail system!! -Original Message- From: Roger Seielstad [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 16:06 To: Exchange Discussions Subject: RE: Migration of mail data What the heck is that data?!?!? Anyway, you should be able to format it in such a way that you can import it into Outlook - take a look at Slipstick.com and see what Sue has as reference. MSDN might have something too. -- Roger D. Seielstad - MCSE MCT Senior Systems Administrator Peregrine Systems Atlanta, GA http://www.peregrine.com -Original Message- From: Adam Romain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:44 AM To: Exchange Discussions Subject: Migration of mail data Listers, I have a situation where I need to import a whole bunch of email data in to Exchange 5.5. or Exchange 2k, not fussy. The problem with the data is the way it is formatted, although I can have it hosed in to a SQL server/access database etc. then reformatted. The format of the data is as such: to field : xxx [3 char] from field : xxx [3 char] sent : xx/xx/xx [date format] subject : xx [16 char] message body : xxx [70char * 15 lines] I can open a message in plain text format, but I need a method for getting it in the the Exchange server, say through a PST, SQL databases etc Has anyone got any pointers ? Thanks in advance Adam ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Migration of mail data
Use SMTP to mail it in If you are even a bit programming savvy, use Perl's text manipulation features to slice dice the email files as desired, then use the Net::SMTP module to send to the appropriate recipient. You might be able to use NT's native batch file tools to do the text manipulation you need, then you could use Blat.exe to do the SMTP transfer. Sounds like a fairly simple (read cheap) job, if you'd like to contract it out... -Original Message- From: Adam Romain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:44 AM To: Exchange Discussions Subject: Migration of mail data Listers, I have a situation where I need to import a whole bunch of email data in to Exchange 5.5. or Exchange 2k, not fussy. The problem with the data is the way it is formatted, although I can have it hosed in to a SQL server/access database etc. then reformatted. The format of the data is as such: to field : xxx [3 char] from field : xxx [3 char] sent : xx/xx/xx [date format] subject : xx [16 char] message body : xxx [70char * 15 lines] I can open a message in plain text format, but I need a method for getting it in the the Exchange server, say through a PST, SQL databases etc Has anyone got any pointers ? Thanks in advance Adam ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]
RE: Migration of mail data
Hey, in the early 80's I wrote a mail system in FORTRAN on the HP/1000 series computers. It was fairly limited, but had a pretty slick user interface (user name lookups based on soundex codes, check status of sent mail, etc). Then we bought a big HP unix mini (an 850 if memory serves) and we tried to move people to unix mail (elm perhaps?), but the users complained so much, I ended up porting my mail system to unix. It ended up being used for several years after I left. -Original Message- From: Adam Romain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 11:15 AM To: Exchange Discussions Subject: RE: Migration of mail data The data is from an in house custom mail system written in Cobol One way to avoid exchange, write your own mail system!! -Original Message- From: Roger Seielstad [mailto:[EMAIL PROTECTED]] Sent: 21 November 2001 16:06 To: Exchange Discussions Subject: RE: Migration of mail data What the heck is that data?!?!? Anyway, you should be able to format it in such a way that you can import it into Outlook - take a look at Slipstick.com and see what Sue has as reference. MSDN might have something too. -- Roger D. Seielstad - MCSE MCT Senior Systems Administrator Peregrine Systems Atlanta, GA http://www.peregrine.com -Original Message- From: Adam Romain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 10:44 AM To: Exchange Discussions Subject: Migration of mail data Listers, I have a situation where I need to import a whole bunch of email data in to Exchange 5.5. or Exchange 2k, not fussy. The problem with the data is the way it is formatted, although I can have it hosed in to a SQL server/access database etc. then reformatted. The format of the data is as such: to field : xxx [3 char] from field : xxx [3 char] sent : xx/xx/xx [date format] subject : xx [16 char] message body : xxx [70char * 15 lines] I can open a message in plain text format, but I need a method for getting it in the the Exchange server, say through a PST, SQL databases etc Has anyone got any pointers ? Thanks in advance Adam ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED] _ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin:[EMAIL PROTECTED]