Reporting4Act! includes an option for linking reports to Google Maps. This is possible with Act! versions 2005 and later, for records from the three main Act! entities: Contacts, Companies, and Groups. For each of these three, and for each Act! data provider, Reporting4Act! has a default list of fields to send to Google Maps. For example, with a link on a contact record, Reporting4Act! will have Google display a map using the fields Address 1, Address 2, City, State, Country, and Zip. However, you may wish to use a different set of fields, such as the Home Address fields.

To make this change, several items are available to be used in Reporting4Act!'s data.ini file. There are six available items total: one for each of the three entities, under each of the two Act! data providers. The items ContactFields, CompanyFields, GroupFields, 2010ContactFields, 2010CompanyFields, and 2010GroupFields are used in a [GoogleMaps] section of data.ini. The example below shows setting the ContactFields item to use the Home Address fields. There are a few important notes about this:

  • The first item in the list of fields must be the ID field for the record type in question. For this contact example the ID field is VRP_CONTACT."CONTACT CONTACTID"; it is VRP_COMPANY."COMPANY COMPANYID" and VRP_GROUP."GROUP GROUPID" for companies and groups, respectively, under the Act! 2005-2009 data provider. The ID fields for the Act! 2010+ provider are CONTACT.CONTACTID, COMPANY.COMPANYID, and GROUP.GROUPID.

  • The fields are listed using their real database names, rather than their English captions. To see these database names in Reporting4Act!, select the Options item from the Tools menu, and turn on the Display real table and field names checkbox.

  • In the example, the list of fields is broken into several lines for formatting reasons. In practice the ContactFields list must be a single line only.

      [GoogleMaps]
      ContactFields=VRP_CONTACT."CONTACT CONTACTID",VRP_CONTACT."CONTACT HOME ADDRESS 1",
      VRP_CONTACT."CONTACT HOME ADDRESS 2",VRP_CONTACT."CONTACT HOME CITY",
      VRP_CONTACT."CONTACT HOME STATE",VRP_CONTACT."CONTACT HOME ZIP CODE",
      VRP_CONTACT."CONTACT HOME COUNTRY"
    

© Keystroke.ca, 2023 • Updated: 01/18/22
Comment or report problem with topic