Next Topic

Previous Topic

Home

Book Contents

Book Index

dps.mef

Topic creation date:2009-11-17

For version 2.12.25 onwards

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.
 
 

------------------------------