From ebert@pe-muc.de Wed Jan 26 17:12:03 2000
Date: 26 Jan 2000 12:30:26 +0100
From: R. Ebert <ebert@pe-muc.de>
To: keystone-users@homeport.org
Subject: [keystone-users] [HOWTO] convert PTS/mSQL to keystone/postgres

1) First create a dump of the existing PTS database and save the file.

        msqldump pts > /tmp/pts.dump


2) Convert all ^M^J by a single ^M

        emacs /tmp/pts.dump
        M-x replace-regex ^M^J ^M
        C-x C-s
        C-x C-c


3) run the attached perl script which will generate proper insert
   statements for projects, tasks, and followups

        pts_to_ks.pl < /tmp/pts.dump > /tmp/keystone.insert


4) load the converted data

        psql keystone
        keystone=> \i /tmp/keystone.insert


5) renumber all followup/child numbers from within keystone.  Select
   Other->Maint->Update and confirm with Yes.


6) Verify that the data was converted properly


The script does not convert people or contact information.  We
reorganzied the people info in the keystone database which made
automatic conversion from PTS useless.


        Rolf
        ebert@pe-muc.de
