How do I set Address Book criteria for integration?

 

When Sage Construction Project Center synchronizes your Address Book contacts, it retrieves all active company contacts, and any person contacts associated with those companies. If you have a large address book, you might want to set criteria in order to filter the number of contacts you upload. You can do this in the integration setup’s Additional Criteria area. This job reference explains how to enter criteria.

 

  • The criteria you enter for these fields are applied to the ODBC table names shown here.

 

SAGE ODBC QUERY - ADDITIONAL Companies Criteria Company Address Criteria C@mpany Contacts Person Address Criteria Save Tables to which criteria apply: ABM MASTER ABM MASTER ABM MASTER ABM MASTER COMPANY COMPANY PERSON ADDRESS (company addresses) PERSON COMPANY PERSON ADDRESS (person addresses)

 

Entries in the Company Address Criteria box are applied to:

ABM_MASTER__COMPANY_PERSON_ADDRESS where Address_Type <> 'Person business add'

 

Entries in the Company Contacts Criteria are applied to:

ABM_MASTER__COMPANY_PERSON_ADDRESS where Address_Type = 'Person business add'

 

  • When you enter criteria in any of the fields, the system appends the text you entered to its existing query. You’ll need to include AND or OR at the start of each string.

ODBC AND > —'Shipping AND Email_Address NOLL OP. Business_Fax IWLI_ AND state = save

NOTE: Initially, we recommend that you enter this criteria for the Companies Criteria:

AND (ABM_MASTER_COMPANY.Date_Stamp > CURDATE()-4)

This filters companies such that only those that have changed in the past 4 days are uploaded. You can change this criteria to something more suitable once you are ready for Sage Construction Project Center to upload all of your Address Book companies.

 

  • You can use the comparison operators = and <>. Do not use <= or >=.
  • For string values, use single quotation marks.
  • To set criteria for fields based on whether the value is empty, use NULL as the value. Do not use empty quotation marks, such as Type = ''.
  • Only person records whose company meets the criteria for the company and company address fields are evaluated against further criteria. For example, if you use this criteria in the Companies Criteria box:

AND Company_Name = 'Acme Solutions'

any persons who do not belong to Acme Solutions are not evaluated for uploading to the cloud, even if they meet all other person criteria.

  • Companies must have an address in order to be uploaded to the cloud, so if you enter this Company Address Criteria:

Address_Type = 'Shipping address'

companies who do not have a shipping address are not uploaded, and consequently their associated contacts are not uploaded.

 

 

Enter Address Book criteria

  • For the Additional Criteria area, enter criteria to filter companies and contacts.

 

OOOC Save NC Address_Type = 'Shipping address' Email_Address < > NULL OR gusiness_FaK < > NULL state — 'WA'

 

  • Click Save.
  • At the top of the window, click Request Synchronization to begin synchronizing your Address Book, standard cost code, and standard category lists.

uonez!umtpuks usanbaz as.eqnep 00? abes eq spit-nai suoneaue5J0 suo»e •bes