The connector for ACT! requires that ACT! be installed and operational on the OmniRush PC.
OmniRush connects to the database via ACT! API and (optionally) via ADO using either
Microsoft OLE DB Provider for MS SQL Server (aka Direct ADO)
ACT! OLE DB Provider for Reporting
The difference in using the two connectors is merging flexibility. The greatest flexibility and reliability is via a Direct ADO connection. However, at this time Best Software / ACT! does not release the username/password for the MSDE/MS SQL Server database. As a result, Direct ADO is only possible if you are able to obtain the MSDE/MS SQL password from Best Software.
Do not contact Z-Firm for information on SQL passwords.
Z-Firm is not able to provide this information. The only source of this
information is Sage Software or ACT! technical support.
|
Environment Topic |
Discussion |
|
PAD files |
The copy of ACT! on the OmniRush Server must be configured to open the production ACT! database on the network. Once you connect to the production database, a PAD file is automatically created on the OmniRush PC.
OmniRush uses ACT! PAD files to connect to the database. PAD files are created by ACT! when you connect to a database. PAD files are XML files containing information about the SQL server location and database name.
By default ACT! stores PAD files at "C:\Documents and Settings\%USER%\My Documents\ACT\ACT for Win 7\Databases\", where %USER% is the current Windows user (administrator”, “guest”, etc) |
|
ShipRush by Z-Firm, and other Z-Firm products that work with ACT! |
All Z-Firm products use the same ACT! plugin (see below for details). All Z-Firm applications can be installed concurrently on one PC or one network.
Generally, no action is required to manage the Z-Firm plugin, although it is your responsibility to uninstall (delete) the plugin if you uninstalling OmniRush. |
|
ACT! version support |
The OmniRush Family works with the ACT! 2005, 2006, and 2007 only. The OmniRush Family does not work with versions of ACT! prior to the 2005 version. |
|
ACT! Database |
Out of box ACT! fields can be renamed, but cannot be removed.
Specifically: The USER1-USER9 fields must exist, and have the stock field names. The following fields must exist:
ID FirstName LastName FullName COMPANYNAME LASTNAME MIDDLENAME FIRSTNAME FULLNAME HOME_LINE1 HOME_LINE2 HOME_LINE3 HOME_CITY HOME_STATE HOME_POSTALCODE HOME_COUNTRYNAME PERSONAL_EMAIL HOME_PHONE HOME_SUFFIX FAX_PHONE FAX_SUFFIX MOBILE_PHONE BUSINESS_EMAIL BUSINESS_PHONE BUSINESS_SUFFIX BUSINESS_LINE1 BUSINESS_LINE2 BUSINESS_LINE3 BUSINESS_STATE BUSINESS_CITY BUSINESS_POSTALCODE BUSINESS_COUNTRYNAME USER1 USER2 USER3 USER4 USER5 USER6 USER7 USER8 USER9 |
Note,