Transferring Report Data to other Software Packages
In addition to producing a printed report, all three SunSystems Financials report writers can produce a file of the extracted data, which can then be transferred to another software package, for example to spreadsheet or financial modelling software.
The transfer file only includes the standard report row details. It does not include headings, total rows, or transaction details.
To create a transfer file you choose a Transfer File Format in the report layout or format details.
What Transfer Formats are Supported?
You can produce a transfer file in any of the following formats:
| Format | Description |
| PRN | Print format |
| CDFQ | Comma delimited with quotes |
| 2020 | Suitable for 2020 |
| BDF | Bar delimited |
| SYLK | Suitable for SYLK single-byte languages (only) |
| CDF | Comma delimited |
| FCS | Financial Control System |
The transfer file is produced at the same time as the SunSystems report file.
The transfer file contains the detailed report lines but does not show column headings, page headings, total lines, or individual transactions.
Most transfer formats separate amounts using commas. When they are read into, say, a spreadsheet application, they appear as separate columns. Where the target application can accept textual descriptions in addition to amounts, descriptions are also present on each line. They describe each of the analysis levels printed on the report. On most formats, the descriptions precede the amounts on the line.