04-29-2008 02:58 PM
04-29-2008 05:09 PM
i don't think there is a way to make contacts inactive, but what you can do is create a new database and import all the inactive contacts into this new database
04-29-2008 07:01 PM
I think I have an idea that will work for you. Define a field and name it record status. Create a drop down list inside of the field and add in "active" and "inactive". Then go out into the layout designer and add this field to the portion of the conact layout that you would like it to appear. Whenever you want to mark a record as inactive just select "inactive" in the drop down menu.
Whenever you would like to do a mailing you can do an advanced query and tell the look up to not include in all records that do not contain "inactive".
That is one way that you can easily do the things that you would like without having to go through the trouble of running multiple databases.
ACT! Sales Supervisor
08-04-2008 07:17 AM
FOR A SAGE EVANGELIST:
I have a database with 200,000 contacts. 50,000 are not useful to me at this time, so i have archived them with an export to a text file, and i now want to delete these contacts in the original database. I have repeatedly tried to delete these 50,000 contact records from the database but Act freezes up. It spends hours processing the request, and ultimately generates a diarrhea of error messages. During this enormous digestive process MYSQL is running full out, using 1gigbyte of RAM. I end up spending 15-30 minutes cleaning up the error messages and forcing Act to shutdown, then do a full PC restart. Having gone through 3 cycles of this, and having lost many hours, I'm now looking for an alternative. My current plan is to export the 150,000 records i want to keep, reimport them into a virgin database, then delete the old database.
I would have thought that deleting records from a database would be one of the most fundamental (and fastest) tasks a database can perform.
Any suggestions on how to accomplish this without having to create a new database?
08-06-2008 07:47 AM
08-06-2008 08:09 AM
Thanks for your response.
This is what i ended up doing...batches of 5000-10000 vs. all 50000 at once. It was still a slow process.
The 50000 i was deleting all contained a blank email field. Email was also my "unique"/duplicate-checking field. Prior to my first attempt to make the 50000 deletions, I had disabled duplicate checking to avoid incurring 50000 duplicate-check events during deletion.
In the end, I set a different field (contact field) as the unique field for duplicate checking (and I left dup-checking set on), and this seemed to facilitate the deletion process. It doesn't make a lot of sense, but I figured it wouldn't hurt to isolate the "unique" field from the field that was being used to create the selection for which i was making deletes.
08-06-2008 03:00 PM
My reply is to Tkittle:
What I have done (because I have wanted to retain access to defunct records for the same reasons) is to mirror the ID/Status with a leading "X". So that the ID/Status Architects would also have X-Architects, Employees would also have X-Employees.
The beauty of that is that you don't have to physically open another database.
If it's say an X-Prospect and you get a call, all of their info is right there.
AND, the X throws them alphabetically to the bottom of the list!
(That way you don't have to scroll through them all the time!)
10-23-2014 03:10 PM
Hello, I am trying to perform this task that you have suggested to creat a drop down for active/inactive customers. I am still learing with ACT 16.0.291.0.HOTFIX5. Can you please let me know how to "define a field" so I can make a start on your suggestion? Not sure where to look! Thank you