Act 4.0 Migration to Google Apps

A client had a very old Act 4.0 system on a Windows XP Desktop. Act 4.0 will install on newer Windows (Windows 7) but it just doesn't run.

We have a copy of the original Act 4.0 database. The output is formatted for Google Contact as specified on https://support.google.com/mail/answer/12119?hl=en&ref_topic=3397492

Extracting Records

Super easy really,

 apt-get install libxbase2.0-bin
 emerge -av xbase
 pacman
 yum

Then use dumprecs to spew out the data

 dumprecs ACT/DATABASE/Main.dbf | grep -v 'Read Error' > rec.out

I like to filter out the Read Error noise.

Now this gives us a large plain text file, which we process with a perl script (http://edoceo.com/pub/code/act40.pl)