Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Outlook archive to Gossamer, lessons learned

Quote Reply
Outlook archive to Gossamer, lessons learned
I'm not 100% sure this topic relevant so if this is posted in the wrong spot, I trust others to move it.

Should any of you ever need to transfer an e-mail archive to your Gossamer forum, maintained in MS Outlook (2002, 2000, 98, or even Express), I offer the following.

While you can export delimited data in a variety of handy formats from Outlook, you cannot export date and time fields for messages. This would seem to be a colossal oversight on Microsoft's part, but that's the way it is.

I spent too much time today researching ways to force this data from Outlook, third party solutions and so forth. Finally, at the bottom of a semi-related KB article, I discovered this. Yes it is true that you cannot export date and time information from an Outlook PST - but you can IMPORT all the information you would ever want from within Access.

After beating my head against the table and crying "why, why?", I completed a very painless import and obtained an impressive table full of glorious data. Access handles PST files like butter on Britney Spears. Tonight my db guru dude will incorporate some 17,000+ messages into our database and we will continue on as if this whole thing had never happened.

For those of you who knew this already, my bloody forehead laughs in your general direction.Mad

Last edited by:

HeavyBombers: Apr 10, 2002, 2:53 PM
Quote Reply
Re: [HeavyBombers] Outlook archive to Gossamer, lessons learned In reply to
Very good suggestion! I remember struggling with moving someone from Outlook to another client, and couldn't get the dates out of the emails either. Took me quite a while to get a workaround.


Gossamer Threads Inc.
Quote Reply
Re: [Alex] Outlook archive to Gossamer, lessons learned In reply to

We're still working on this import from my Outlook e-mail archive to Gforum. It's actually been done but removed already, lots of e-mail crap we needed to filter out and the line feeds got munged.

Did you run into a problem where the "From" and "Name" fields from the Outlook PST were the same? In many of these, all we're seeing is the display name and not the actual e-mail address.

At first I thought it might be tied to display names from the outlook address book, but that did not pan out.

Otherwise will have to tackle the PST programatically - ugh.
Quote Reply
Re: [HeavyBombers] Outlook archive to Gossamer, lessons learned In reply to
Found a solution here: http://www.genusa.com/utils/pmseu.htm

You have to have CDO installed, which isn't done by default, but after that it worked like a charm. Some tweaking by the programmer guy and we should be rockin' and rollin'.