Detcms.mif

Topic creation date:2010-03-29

detcms.mif is a bespoke filter for NSW DET.

This filter takes 4 input files that are a combination of user and cost centre information, and pre-loads the data in these files into an temporary SQLITE Database. While in the pre-load phase the normal stop and control actions cannot b performed.

The filter then proceeds to operate normally to proceed the database and extract COSTCENTRE CODE (Client), EMPLOYEE and PERMISSION (activity) information.

General PMA.INI file settings

[System]

PmaKey = 15

PmaSystemNotes = "Created manually for ParsInCn"

PMASystemLongName = "DETCMS"

PMASystemShortName = "DETCMS"

UseEmployeeCode = 0

MatterClientRelationship = 2

The Import section must specify following entries:

[Import]

ImportFilterName = "detcms.mif"

ImportIniFilePathName = "C:\MT_PARS\Apps\filter.ini"

ImportIniFilePathName contains a the location for a file that should be named FILTER.INI. This file has a section named 'MultiFile'. There are four required entries. [MultiFile]

UserImportFileOne = "C:\MT_PARS\data_in\Staff.ati"

UserImportFileTwo = "C:\MT_PARS\data_in\ActiveDirectory.csv"

UserImportFileThree = "C:\MT_PARS\data_in\CostCentretable.csv"

UserImportFileFour = "C:\MT_PARS\data_in\wesxver1test.csv"

UserImportFileOne contains the existing monitor STAFF.ATI file.

UserImportFileTwo contains a list of lattice and logins, in the format:

Lattice_ID,DETSystemUserName

UserImportFileThree contains cos centre information in the following format. Note the leading and trailing quotes.

"Cost Centre,Description,Department"

UserImportFileFour contains links from lattice (user) to up to six cost centres in the following format:

Lattice_Id,Primary_cost_centre,Cost_Centre1,Cost_Centre3,Cost_Centre4,Cost_Centre5

The primary cost centre becomes the default for that user.

The AutoImport section in PARS.INI must have the following entries:

[AutoImport]

AutoImportEmployeeFilePathName = "PRELOAD"

AutoImportPrimaryLinkFilePathName = "PRELOAD"

AutoImportActivityFilePathName = "PRELOAD"

[Descriptions]

ClientTypeName = "Cost Centre"

EmployeeTypeName = "Employee"

ActivityTypeName = "Permission"

ImportReportFormat

As this is a bespoke filter there are no options.