Link to home
Start Free TrialLog in
Avatar of TechND
TechND

asked on

Need help Creating Script to extract email address info from data files.

I have a database of email accounts that will be moving from in house email to GMail. There are about 50 accounts. The current email system has no export function for address books. Clients would like to have their email address book info so they do not have to recreate it manually. The company sent the reply below on where the email addresses data is located for each account in the email programs database structure. The support tech suggested using something like Perl to create a script that will automatically extract just the email address portions. I don't do much scripting and don't know about how to go about this. Any help or pointers would be appreciated. The program is running on Mac OS X 10.4.

--------------------------------------------------------------------------------------------------

Thank you for the call today regarding the extraction of information stored in DataSet address books. So first, here is some documentation on DataSet address books in CGP.

Now I don't know what operating system they are running their CGP server on, but as an example, let's assume it OS X, and let's assume it's an account in the primary domain name 'josh@josh.mv' that creates the DataSet address book. Once the address book is created, a file will be created with the CommuniGate Pro base directory which is /var/CommuniGate/Accounts/josh.macnt/account.dst. The contents of that file will look something like this:

-----
{
addressbook =  {
  "#subset" =    {
    E684661343 =      {
      addressbook.Email = josh@josh.mv;
      modtime = 20130523152445;
     };
    E684661355 =      {
      addressbook.Email = joe@josh.mv;
      modtime = 20130523152506;
     };
    E684661358 =      {
      addressbook.Email = mike@josh.mv;
      modtime = 20130523152511;
     };
    E684661362 =      {
      addressbook.Email = karen@josh.mv;
      modtime = 20130523152516;
     };
   };
 };
}
-----

This is a simple, plain text file, that you could open with any text editor. So with a little data manipulation, you'd have the addresses.
ASKER CERTIFIED SOLUTION
Avatar of TechND
TechND

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial