06-10-2011 01:04 AM
I'm trying to clear out over 30,000 records from ACT Version 10, leaving only about 300 records.
We have a number of custom fields, one of them being a simple tick box for 'Live Company'. Staff have gone through their live records and ticked the relevant ones. These are the ones to keep.
I have run a Lookup / Other Fields and selected 'Live Company' - I then set criteria to False and click OK. This brings up 118 records - I know that this should show at least 30,000 records so am baffled. If I run the lookup with True it brings up the correct results - However, I need the false option to be able to delete the required data.
Hope someone can help.
06-10-2011 06:11 AM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
06-10-2011 06:28 AM
Thanks Greg - I was looking at the empty database option, but was a little nervous.
Both your suggestions look sensible - Thanks for the quick reply! I'll try the 'sort' option first but if, as you say, it starts to take an age will go for the export option.
06-11-2011 07:57 PM
02-08-2012 10:21 AM
I just got ACT Pro 2012. upon first sync with phone my contact which are around 5,000 went to 15,000+. There are a bunch of duplicates. Some are duped 5x others 2x. I have been going through and deleting the duplicates. I have been doing in blocks of 500 but now I just did one with 2,000 in a block and my computer has been deleting records for 30 minutes. Any way to cut down the time? Should I just tag all of the duplicates then delete and let the computer figure out?
02-09-2012 12:27 AM