Scripting

Epicenter Server supports using VBScript to modify the contacts before they are distributed. Common uses for this function include:

  • Removing properties
  • Moving properties to a different field
  • Selecting contacts by content(especially on Hosted Exchange where you can't create address lists.)
  • Filtering fields (for example, some companies consider the Home Phone to be confidential.)
  • Removing pictures

Here's an example script to remove all contacts that have no company name.  This script must be named Fixup.vbs and should be placed in the same directory as Epicenter Server.exe. (Normally C:\Program Files (x86)\Connected Software\Epicenter Server)

Option Explicit
Dim c
Dim name
 
for each c in Contacts 
  name = c.GetProperty(amCOMPANY_NAME)
  if name = "" then c.Remove
Next

You can find a second sample script at this link. It will remove all contacts not in a category. This particular script is useful when your source address book is an Outlook contacts folder. (The GAL does not support categories.)
http://www.connectedsw.com/faq.php?faq=158

For more complex needs, please contact technical support for more information. There may be a customization charge, depending on your requirements.

The list of supported fields is as follows. (Some of them are for future expansion only and aren't actually supported by any email client, such as amGOVERNMENT_ID_NUMBER) Note that the quotes should be included for any fields that show quotes below. Several of these fields are not supported in the GAL, such as the Home Address fields.

amDISPLAY_NAME
amADDRTYPE
amEMAIL_ADDRESS
amCOMMENT
amCALLBACK_TELEPHONE_NUMBER
amGENERATION
amGIVEN_NAME
amGOVERNMENT_ID_NUMBER
amBUSINESS_TELEPHONE_NUMBER
amHOME_TELEPHONE_NUMBER
amINITIALS
amKEYWORD
amLANGUAGE
amLOCATION
amSURNAME
amPOSTAL_ADDRESS
amCOMPANY_NAME
amTITLE
amDEPARTMENT_NAME
amOFFICE_LOCATION
amPRIMARY_TELEPHONE_NUMBER
amBUSINESS2_TELEPHONE_NUMBER
amCELLULAR_TELEPHONE_NUMBER
amRADIO_TELEPHONE_NUMBER
amCAR_TELEPHONE_NUMBER
amOTHER_TELEPHONE_NUMBER
amTRANSMITABLE_DISPLAY_NAME
amPAGER_TELEPHONE_NUMBER
amPRIMARY_FAX_NUMBER
amBUSINESS_FAX_NUMBER
amHOME_FAX_NUMBER
amBUSINESS_ADDRESS_COUNTRY
amBUSINESS_ADDRESS_CITY
amBUSINESS_ADDRESS_STATE_OR_PROVINCE
amBUSINESS_ADDRESS_STREET
amBUSINESS_ADDRESS_POSTAL_CODE
amBUSINESS_ADDRESS_POST_OFFICE_BOX
amTELEX_NUMBER
amISDN_NUMBER
amASSISTANT_TELEPHONE_NUMBER
amHOME2_TELEPHONE_NUMBER
amASSISTANT
amHOBBIES
amMIDDLE_NAME
amDISPLAY_NAME_PREFIX
amPROFESSION
amPREFERRED_BY_NAME
amSPOUSE_NAME
amCOMPUTER_NETWORK_NAME
amCUSTOMER_ID
amTTYTDD_PHONE_NUMBER
amFTP_SITE
amMANAGER_NAME
amNICKNAME
amPERSONAL_HOME_PAGE
amBUSINESS_HOME_PAGE
amCOMPANY_MAIN_PHONE_NUMBER
amCHILDRENS_NAMES
amHOME_ADDRESS_CITY
amHOME_ADDRESS_COUNTRY
amHOME_ADDRESS_POSTAL_CODE
amHOME_ADDRESS_STATE_OR_PROVINCE
amHOME_ADDRESS_STREET
amHOME_ADDRESS_POST_OFFICE_BOX
amOTHER_ADDRESS_CITY
amOTHER_ADDRESS_COUNTRY
amOTHER_ADDRESS_POSTAL_CODE
amOTHER_ADDRESS_STATE_OR_PROVINCE
amOTHER_ADDRESS_STREET
amOTHER_ADDRESS_POST_OFFICE_BOX
amWEDDING_ANNIVERSARY
amBIRTHDAY
amLAST_MODIFICATION_TIME
amMESSAGE_CLASS
amENTRYID
"Mileage"
"BillingInfo"
"FollowUp"
"Categories" (Multivalued string, separated with semicolons)
"Email1Address"
"Email2Address"
"Email3Address"
"Email1Name"
"Email2Name"
"Email3Name"
"FileAs"
"User1"
"User2"
"User3"
"User4"
"HomeAddress"
"BusinessAddress"
"OtherAddress"
"WebPage"
"Email1AddressType"
"Email2AddressType"
"Email3AddressType"
"NetMeetingServer"
"UniqueNickname"
"OtherWebUrl"
"DefaultMailingAddress" (Integer)
"IPphone"