Syntax of a File to Import
A file to import must contain the necessary information for the recognition of files and cells into which data must be imported.
In addition to the imported data, the file may contain a header displaying the following three tags:
Document tag
This tag indicates the name of the client file containing the imported data and the location where it is saved.
Return tag
This tag indicates which client is affected by the import.
The only possible value for the "Return" tag is 0 (designates the trust).
Language tag
This tag indicates the language used to import data into the list boxes.
The possible values of the "Language" tag are:
- 0 (zero) to designate English; and
- 1 to designate French.
The heading containing the three tags is optional when data is imported into the current client's return but it is mandatory when data is imported into several client files.
Example of a heading
[C:\Documents and Settings\WK\Taxprep T3\Clients\Bill Smith Trust.308|0|0]
- "C:\Documents and Settings\WK\Taxprep T3\Clients\Bill Smith Trust.308" indicates that file Bill Smith Trust.308 must be saved to the Clients folder under C:\Documents and Settings\WK\Taxprep T3\;
- the 0 (zero) after the first separator " | "indicates that the data must be imported into the trust's return; and
- the 0 indicates that the import language for the items in the list will be English.
|
Notes:
|
Syntax of the part of the file containing data to import
The lines which follow the heading contain information about the data to be imported.
Each line must contain two columns:
- the first column contains the cell ID,
- the second column contains the value of the cell this year.
Import data into a multiple copy form
The number of the copy into which data must be imported must appear between brackets "[]" in the first part of the cell number.
Example: Line BEN.REPEAT[1].SIN1;"111 111 118" indicates that the SIN (111 111 118) will be imported into the first copy of Form Beneficiary Information (Jump Code: BENEF).
|
Notes:
|