Advanced Copy Fields Wizard

Advanced Copy Fields Wizard

Ever import an Excel spreadsheet into Act! and notice that you have data in the wrong fields?

For example, you put companies in the contact column and vice versa. Ever import or migrate data from another older version, or product, and find that a date field was entered using Text formatting and not date formatting? Now you want to move the data to a true date field. That’s where this tool comes in handy.

This Act! addon wizard will create a set of three additional menu items on the EDIT menu. These extra Copy/Replace/Swap menu items are an extension to the already great replacement tools provided by Act!. You will see Copy Extended, Replace Extended, and Swap Extended. Using these dropdowns, you can copy, replace or swap ANY type field with ANY other type field. That includes text-to-date, date-to-text, etc. If the fields you are swapping are different sizes, you will see an error alerting you to possible truncation of data.

If you copy a text field that has date entries into a date field, the wizard will do its best effort at pulling over the text as dates. It will use the underlying system date specifications that are enabled in your operating system.

Name Parts (First Name, Middle Name, Last name, Name Prefix, Name Suffix) can now be addressed as the source and target of a Swap or Copy operation, So it is now possible to swap the First name and Last Name of the contact among other useful operations.

New Feature: Advanced Editing of Contact and Company fields has recently been added. Insert/Append/Sub-string Replace and Remove actions are supported.  

Note: This wizard is only compatible with the desktop versions of Act! (not Act! Cloud/Web)