10-30-2012 08:43 PM
Running Act 11 w. Windows 7.
Trying to understand how exports/imports work - I want to export a few fields, change some data in the Excel spreadsheet, then import back into ACT. With the result being those contacts' records changed only in the fields that I changed in the spreadsheet.
I understand ACT can figure out if the import record is a duplicate through its GUID value (somehow).
Can a human see GUID values? Where are they in ACT?
Thanks in advance for any help.
10-30-2012 09:47 PM
What you're trying to do won't work with the ACT! import. You would need a third party importer like OakMerge.
10-31-2012 08:42 AM
If you are trying to change the contents of a field, does ACT 11 support looking up a select group of contacts and then changing the field contents, assuming it is not a memo field?
10-31-2012 02:58 PM
John - ACT! has a "mass" update tool on the Edit menu, you will see the three options at the bottom of the menu.
You create a lookup (doesn't matter which method you use) and then when you run the tool - sounds like in your case, you want Replace Field - it will replace the contents of the selected field (whether empty or not) with your value for every record in the lookup.
It will only do one field at a time, but it sure is much easier than exporting and importing to get there.
Just be sure you backup your database prior to beginning!
11-01-2012 11:38 AM
Here is a tool that can show you the GUID: http://www.exponenciel.com/actaddons/actaddon.aspx?ID=LT32