Pcount.mif

This filter imports from the dbase formated PCounter data base using an ODBC connection using the FoxPro driver typically from a file called PPOPUP.DBF. This filter can also import employees from Active Directory.

Download and install the Visual Fox pro ODBC drivers (VFPODBC.msi) from the Microsoft web site., if running on a computer (XP onwards) that does not have them by default.

ImportFilterName needs to be set to "pcount.mif".

In the PABX.INI file in the [AutoImport] Section set AutoImportPrimaryLinkFilePathName = "C:\PCOUNTER". This location is the default location of the PPOPUP.DBF.

Alternatively, this item can be set to FILEDSN and a in the PMA.INI file in the [Import] section set ImportFileDSN to the full path and file name of a .DSN file containing a FILE DSN for the Fox pro ODBC Driver. Here is an example 'pcount_fp.dsn' file:

[ODBC]

DRIVER=Microsoft FoxPro VFP Driver (*.dbf)

UID=

Deleted=Yes

Null=Yes

Collate=Machine

BackgroundFetch=Yes

Exclusive=No

SourceType=DBF

SourceDB=C:\PCOUNTER

Effectively, this means the minimum settings are ImportFilterName (= pcount.mif) and ImportFileDSN, but make sure the file DSN specified in ImportFileDSN, uses a full path as well as the file name.

General PMA.INI file settings

The MatterClientRelationship in the PMA will decide the meaning of code and subcode in the pcounter database.

In the PMA.INI file the [System] section settings are:

PmaKey = 10

PMASystemLongName = "PCounter Printer Accounting for Windows"

PMASystemShortName = "PCCOUNT"

The PMASystemShortName is not currently being used, but is kept in for reference.

WidthOfClientCode = 20

WidthOfMatterCode = 20

WidthOfGeneralCode = 20

Clients/matters

The MatterClientRelationship in the PMA file is set to MATTER_FIND_CLIENT or is set to MUST_HAVE_MATTER and does not have a value that corresponds to MUST_HAVE_CLIENT then the primary link is matter.

Where the primary link is matter then the matter is read from the 'code' field and the client from the 'subcode'. The Matter Description is read from the 'descr' field. The Client Name will be blank.

Otherwise, where the primary link is client then the client is read from the 'code' field and the matter from the 'subcode'. The Client Name is read from the 'descr' field. The Matter Description will be blank.

The pages' field is not used.

Employees

If ImportReportFormat is 256 (or 512 or 1024 or 4096) then the LDAP import from active directory. See How the LDAP import works for importing users.