dps.mef

Dsp.mef is a '.csv' export filter built on a one of basis for importing into a spreadsheet.

This format is designed for a spreadsheet, and displays the matter or client code grouped and summarised by the type of disbursement is several columns. The columns are specified a INI file named in the ExportIniFilePathName specified in the [export] section of the system INI file (PABX.INI or PARS.INI). Other settings including the page title, the Cost perpage (used if the UseCostPerPage=1) are also specified in that file in the [SubGroup] section as shown below.

There can be up to 8 columns of summarised data grouped by the type of export. The number specified in the ColumnXJobId, must correspond to one of the number in the following table, where X is a column number between 1 and 8 inclusive. Unused columns should be left blank. The column heading (using ColumnXHeading, )needs to be specified for each column even if the header is omitted.

Job Type	Number to use.
TELEPHONE	1
PRINT	2
PHOTOCOPY	4
FAX	8
SCAN	16
GENERAL	32
EMAIL	64
INTERNET	128
MAIL	256
COUR	512
TRAVEL	1024
TAXI	2048
ENTERTAINMENT	4096
ARCHIVERETRIEVAL	8192
ARCHIVESTORAGE	16384
CREDITCARD	32768

[SubGroup]

PageTitle = "Dynamic Property Services - Printing, Copying, Scanning Charges"

CostPerPage = 0.50

UseCostPerPage = 1

Column1JobId = 4

Column2JobId = 2

Column3JobId = 16

Column4JobId = 0

Column1Heading = "PHOTOCOPIES"

Column2Heading = "PRINTING"

Column3Heading = "SCANNING"

Column4Heading = "ADJUSTMENTS"

When exported The CSV file has header (unless omitted in the export settings below) that looks like this when using the setting above:

"Dynamic Property Services - Printing, Copying, Scanning Charges",,,,,,,,,

Month:,,Oct-09,,,,Cost per page,,$0.50,

,,,,,,,,,

,PHOTOCOPIES,,PRINTING,,SCANNING,,ADJUSTMENTS,,

PLAN NO.,NUMBER,AMOUNT,NUMBER,AMOUNT,NUMBER,AMOUNT,NUMBER,AMOUNT,TOTAL

And a body that contain as many rows as there are unique matter or client codes that looks like this:

76,446,$223.00,42,$21.00,#N/A,$0.00,,$0.00,$244.00

172,448,$224.00,39,$19.50,4,$2.00,,$0.00,$245.50

174,154,$77.00,61,$30.50,#N/A,$0.00,,$0.00,$107.50

General PMA.INI file settings

The MatterClientRelationship should be set to 1 (MUST_HAVE_MATTER) or 2 (MUST_HAVE_CLIENT).

[System]

PmaKey = 13

PMASystemLongName = "SpreadSheet"

PMASystemShortName = "SS"

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

WidthOfClientCode = 40

WidthOfMatterCode = 40

WidthOfGeneralCode = 40

ExportReportFormat

ExportReportFormat is found in the export section of the PMA.INI file. Setting ExportReportFormat will allow the following modifications to the export. ExportReportFormat is a bit field format, allowing multiple options by adding up the values in the ExportReportFormat column.

ExportReportFormat	Action
0	Default values, including australian date format (D-M-Y)
32	If the a field has the value "(None)" then the field is exported as blank.
64	Filter out all characters other than &'-./= and spaces, Alphabetical upper and lower case and Digits.
128	Add a carriage return and line feed to the end of the export file.
2048	Omit the header.