How do I export database users from one database to another?

Question: How do I export database users from one database to another?
 
Product Details: 
Product Family:  Act!
Product:  Act! Pro, Act! Premium
Version: 2010 and later
 

---

Answer: 
 
Important Note: Before proceeding with the steps in this article, it is strongly recommended that you create a backup of both the source and the destination databases. For information on creating backups, refer to the following knowledgebase article:
 
How to back up and restore an Act! database

 
 

1. Login to the source database
2. Click Lookup &gt Other Fields…
3. Under Field, choose Is User
4. Under Operator, choose Equal To (=)
5. Under Value, choose True
6. Click OK
7. Click File &gt Export…
8. In the Export Wizard Welcome screen, click next
9. On the Specify Destination page, ensure Act! Database is chosen
10. Click Browse…, then browse to the destination database, select it, then click Open
11. Enter the Admin or Manager User Name and Password for the destination database, then click Next
12. Under “What kind of records would you like to export?”, select Contact records
13. Under “Which records do you want to export?”, select Current lookup
14. Click Next
15. In the Contact Map screen, compare the “Map this Field” column on the left with the “To this Field” column on the right
16. If any rows do not have the same field on the left as the right, click the right field, then click the drop-down to select the correct field from the list for each field that is missing from the right column
    
    Note: You can only map a field to one other field. Selecting the field again in this list will blank or remove the first selection. Leaving a field blank on the right column will result in data from the corresponding source field not getting imported
     
17. Click Next
    
    Note: If you chose more than one option in step 7, you will have the mapping dialog box for each option you chose.
     
18. On the Specify Merge Options screen, click Contact…
19. Under If source records match destination records, click the first drop-down on the list and choose what you wish to do for that type of record:
    
    • Replace with newest
      
    • Merge
      
    • Replace with Source
      
    • Do not change
      
    
    
20. Repeat step 19 for additional drop-downs in this list as needed
21. Under If source records do not match destination records, click the first drop-down and choose what you wish to do with that type of record:
    
    • Add
      
    • Do not add  
    
    
22. Repeat step 21 for additional drop-downs in this list
23. Click OK, then click next
24. Click finish to begin the export
25. If desired, change the following settings:
    
    • Include attachments
      
    • Confirm each match
      
    • Include other user’s public activities
      
    
    
26. Click Next, then click Finish to begin the export
27. Once the export has finished log into the destination database
28. Click Tools &gt Manage Users…
29. Create new users from the Contact records of the users from the source database. For information on creating users, refer to the following knowlegbase article:
    
    How to create and manage database Users in Act!