Importing from Act!

I had to convert many Act databases and this is the process I used. Hope it is helpful!


Act Database Pack And Re-Index:

1. Open Act Database
2. Under File menu choose Administration
3. Database Maintenance
4. Compress and re-index

Transfer into New Act! Database:

1. Create a new database
2. Choose Export Under the file menu
3. Point to the new database

Import Data into Maximizer:

1. Create a new Maximizer Database
2. Under File menu choose Import
3. Select Act! Database
4. Browse to the New Act! Databse file
5. OK
6. Choose the New Maximizer database to import into
7. OK

Rebuild Maximizer Database:
The purpose of this step is to ensure the data integrety of our converted Act! Data.

1. Close Maximizer
2. Start – Program files – Pervasive – Pervasive.SQL 2000 – Utilities – Maintenance
3. Options – Show information editor
4. Click the Load information button
5. Locate the Maximizer file called MXZC.MAX (this is located in the folder the Maximizer database was created in)
6. Select the file and click open
7. Click the Create file button
8. For file name change the MXZC.MAX to MXZC.NEW
9. Click OK
10. A message pops up saying file was created Click OK
11. Repeat steps 7 – 10 for the MXZN.MAX file (it is in the same location)
12. Exit the file Information editor by clicking the x
13. From the Data menu choose save
14. Browse to the file MXZC.MAX
15. Click Open
16. Copy and Paste the location from the MicroKernel file to the sequential file
17. In the Sequential file location change the extention from max to seq
18. Click the opion to Forward and backward
19. Click on the Execute button
20. When it is completed take note of the number of records
21. Click on close button
22. Repeat Steps 13 – 21 for the MXZN file
23. From the Data menu choose Load
24. Browse for MXZC.seq
25. Copy this path and paste into the MicroKernel file field
26. Then change the extension on the MicroKernel file field from seq to NEW
27. Click Execute
28. Repeat steps 23 - 27 for the MXZN file
29. Click the Close button
30. Exit from the b-trieve mantenaince utility
31. Locate the directory that contains the maximizer data files just created
32. Rename the MXZC.MAX to MXZC.old
33. Rename the MXZN.MAX to MXZN.old
34. Rename the MXZC.new to MXZC.MAX
35. Rename the MXZN.new to MXZN.MAX
36. Open Maximizer
37. Select File Close Addressbook folder
38. Select utilites backup addressbook folder
39. Select the database
40. Click OK
41. Select all files
42. Click backup
43. Select browse
44. Locate a directory on the network that can be accessed from the Maximizer administrator
45. click OK
46. Click OK
47. Click OK
48. When backup is complete click CLOSE
49. Click Cancel
Exit Maximizer

there is a new ACT import utility on website www.maximizer.com/support

Yep,

I'm afraid the Maximizer ACT import often gives up during the Notes import phase. You can try saving in an older ACT format which sometimes works.

As a result of this problem we've written our own quite neat converter that reads directly from an ACT database. All the old fields names and groups are transferred along with the contacts and their notes. The document/emails are not, but then these are not taken by the Maximizer conversion either.

If you like we can convert the data for you (it needs saved to ACT3 format which you can do from inside ACT). I'm afraid there would be a cost.

If you would like more details or a quote please email me at ian.wallace@cabc.co.uk

Ian Wallace
CABC

[QUOTE]Originally posted by Jfielding:
[B]I am trying to import from Act! into Maximizer about 1900 contact records.


I had the same problem with my company, all that you do is re create your act database
i did it by starting a new database calling it "temporary" set up contact record "temp name and company", then on Act goto file: data exchange: import, copy from the damaged database (or one you want to import to maximizer) and then copy everything it will take 10 minutes and you have to wait as when a duplicate enry is found it will prompt you what you would like to do with it. Once this done, import to maximizer and all is well, I did not however copy apointments and notes well so this i did from my palm and told palm to overwrite maximizer and with address book I set up from hotsync setup "do nothing" this then worked!!!!!!!