> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # Contact table > Bulk update contact table Contact fields. Key constants are in `BulkUpdateSystem.ContactFieldValueKeys`. Contact

FieldValueKeys

OperationTypes

Expected Field Values

Affected Properties

AddInterests

addItems

Values Count = 1…n

Values\[n] = (int) InteresItemtId

Selects each interest.

Interests

RemoveInterest

removeItems

Values Count = 1…n

Values\[n] = (int) InteresItemtId

Deselects each interest.

Interests

AssociateId

SelectOne

Values Count = 1

Values\[0] = (int) AssociateId

Associate

Business

SelectOne

Values Count = 1

Values\[0] = (int) BusinessIdx

Business

Category

SelectOne

Values Count = 1

Values\[0] = (int) CategoryIdx

Category

OrgNr

Set

Values Count = 1

Values\[0] = (string) OrgNr

OrgNr

Number1

Set

Values Count = 1

Values\[0] = (string) Number1

Number1

Number2

Set, Clear, SearchAndReplace, RegEx

Values Count = 0 to 7

Set: Values\[0] = (string)

Clear: Clears value

SearchAndReplace:
Values[1] = searchString
Values\[2] = replaceString
Values\[3] = options

RegEx:
Values\[4] = expression
Values\[5] = replace with
Values\[6] = options

Number2

Name

Name

Department

Department

StreetAddressAddress1

StreetAddress.Address1

StreetAddressAddress2

StreetAddress.Address2

StreetAddressAddress3

StreetAddress.Address3

StreetAddressZipCode

StreetAddress.Zipcode

StreetAddressZipCity

StreetAddress.City

StreetAddressCounty

StreetAddress.County

StreetAddressState

StreetAddressState

PostalAddressAddress1

PostalAddress.Address1

PostalAddressAddress2

PostalAddress.Address2

PostalAddressAddress3

PostalAddress.Address3

PostalAddressZipCode

PostalAddress.Zipcode

PostalAddressZipCity

PostalAddress.City

PostalAddressCounty

PostalAddress.County

PostalAddressState

PostalAddress.State

Stopped

Set

Values Count = 1

Values\[0] = (int) 0 or 1
0 = unChecked
1 = Checked

Xstop

ContactNoMail

Set

Nomailing

ContactCountry

SelectOne

Values Count = 1

Values\[0] = (int) CountryId

Country

Url

Add, Remove, ReplaceWith, Clear, SearchAndReplace, RegEx

Values Count = 0 to 8

Add: if value doesn’t already exist

Values\[0] = (string) value
Values[1] = (string) descr

Remove: only one needs to match

Values\[0] = (string) value
or...
Values[1] = (string) descr

ReplaceWith:
locates row with Rank =1 and updates it, removes all others. Updates using:

Values\[0] = (string) value
Values[1] = (string) descr

Clear: Clears all existing rows

SearchAndReplace:
works on value only, not description.

Values\[2] = searchString
Values\[3] = replaceString
Values\[4] = Search Option

RegEx:
works on value only, not description.

Values\[5] = expression
Values\[6] = replace with
Values\[7] = search options

Urls

Email

Emails

Phone

Phones

Fax

Faxes
See [User-Defined Fields][1]. [1]: ./user-defined-fields ## Related topics - [contact table](/en/database/tables/contact.md) - [OwnerContactLink table](/en/database/tables/ownercontactlink.md) - [Get Table Right By Contact Ownership](/en/api/reference/restful/agent/sentry_agent/get-table-right-by-contact-ownership.md) - [contactinterest table](/en/database/tables/contactinterest.md) - [freetextindex table](/en/database/tables/freetextindex.md) - [selectionmember table](/en/database/tables/selectionmember.md)