Community
Showing results for 
Search instead for 
Do you mean 
Reply

Removing data from Name prefix field.

Bronze Elite Contributor
Posts: 1,430
Country: United_Kingdom

Removing data from Name prefix field.

Because of integration problems with another programme my client would like a separate field to hold Name prefix in. I created this and copied all existing Name prefixes into the new field. Does anyone know of a way of bulk deleting the existing ACT Name prefix data?

Nickel Elite Contributor
Posts: 935
Country: USA

Re: Removing data from Name prefix field.

[ Edited ]

Not sure of why the need do this based on brief info?

but check out

ACT! / Edit / Replace Field ( perform a lookup first )

Note: There is already a ACT! "Name Prefix" field.

Take daily backups of your ACT! databases + personal files b4 making any major changes. 

- cheers - FSB Smiley Happy

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
Bronze Elite Contributor
Posts: 1,430
Country: United_Kingdom

Re: Removing data from Name prefix field.

Thanks for the above but of course as this is a system field and part of the contact field it does not show  an option in edit replace hence post on here.

Nickel Elite Contributor
Posts: 935
Country: USA

Re: Removing data from Name prefix field.

I see your delima now.

But there may be hope ?

ACT! / File / Save Copy / Save empty copy .. to create a new database.

Then, Import data from old db into new one BUT do Not Map the Name Prefix field ?

 Or try to Map your New field to the system field in new database as you are importing.

I'm not 100% certain that you will be able to do this with a system field but it wouldn't take long to find out.

Else;

There may be a ACT! Add-on that would allow you to modify a system field in this way? Smiley Happy  FSB

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
Bronze Elite Contributor
Posts: 1,430
Country: United_Kingdom

Re: Removing data from Name prefix field.

Thanks again for the suggestion.

 

Have created an SQL access link via SA log on to the ACT SQL Tables. (Testing on a backup)

 

Going to explore direct edit of the sub table that holds the name prefix first.