This operation transfers the data of proposals and other text documents from the database into MS Word (.doc) files through template *(.dot)* files and using key strings formed according to certain syntax rules. The transfer to Word file is started using Transfer to MS Word option located in the right mouse button menu of the document or the related slip lists. The predefined .dot templates of the Word application are used for the transfer.
The File Name field of the Transfer to File window is used to specify the name of the target file, and the location where it will be saved. The Word Template field is used to select the predefined .dot file to be used for the transfer.
Key Strings
The building blocks of the transfer are key strings. The key strings are divided to two groups depending on the type of data:
Keyword: Used for the transfer of a single field. The template structure is:
<KS>SIMGE#ALANISMI#FILTRELISTESI<\KS>
Key list: Used for table/list transfers containing more than one field. The template structure is:
<KS>SIMGE#ALANISMI#LISTETURU#SÜTUNLISTESI#FILTRELISTESI<\KS>
The shape of the key strings is similar to XML label structures. The start and end of a string is specified with certain tags. The starting tag is <KS> and the end tag is <\KS>. The information about the transfer is placed between these two tags. The first two variables are mandatory, while the others are optional. The variables are separated by#. Information provided may partially vary depending on the word or list transfers.
Word Transfer Transaction
The variables required for word transfer are:
The letter indicating the transfer type W ~ Mandatory
Keyword field name ~ Mandatory
Filter info ~ Optional
Example 1:
<KS>W#DESC<\KS>
Only the mandatory variables are used in this keyword. The optional filter variable is not used. The first variable indicating that the string type is word is separated with# from the second variable indicating the field name.
Example 2:
<KS>W#DESC#CODE$$aaa<\KS>
In this keyword, the optional filter variable is used along with the mandatory variables.
List Transfer Transaction
The variables required for list transfer are:
The letter indicating the transfer type L ~ Mandatory
Key list field name ~ Mandatory
List type ~ Optional
Column List ~ Optional
Filter info ~ Optional
Example 1:
<KS>L#TRANSACTION<\KS>
Only the mandatory variables are used in this key list. As a result, all data (all columns and lines) is transferred by being separated with commas and semicolons.
Example 2:
<KS>L#TRANSACTION#1#CODE&DESC#DATE$FICHEDATE&TIME$$123456<\KS>
In this key list, the optional variables are used along with the mandatory variables. Here the third variable indicates the transfer will be a table, the fourth variable indicates that the CODE and DESC columns will be transferred, and the last variable indicates that the data of which the DATE field is the same with the FICHEDATE and the TIME field is 123456 (hour,minute,second) will be transferred.
List Type
Indicates the list transfer type. The first option is used if a preference is not specified. There are two types of lists:
Free list: The data is transferred sequentially with commas. A semicolon is inserted after each line of the list. The variable value of the free list is 0.
Table list: The data is inserted into a table consisting of lines and columns. The variable value of the table
list is 1.
Column List
This variable can be used if the columns of the information to be listed are required to be limited in list transfer transactions. The field names to be used are separated with &. All columns are transferred if no preference is specified.
Filter List
The filter usage is the same for both types of key string (word and list). The filters may contain more than one element separated with &. Filter elements are separated with a $ sign. The filters are not applied if a preference is not specified. A filter element consists of three sections:
The field name of the filter element ~ Mandatory
The name of the field where the value will be read ~ Optional
Filter element value ~ Mandatory
Example 1:
CODE$$aaa&DESC$$AAA.
This filter obtains a CODE=aaa and DESC=AAA data. The second variable is not used.
Example 2:
CODE$SPECODE&DESC$$AAA.
This filter obtains a CODE=SPECODE and DESC=AAA data. Instead of providing a value for the CODE field, the value is taken from another field in the same section.
Usage Rules
- No other MS Word applications must be opened during the transfer. If an application is opened before the transfer, it shouldn't be activated.
- Maximum 5000 letters can be used in a key string.
- The key string variables are order-dependent. If the next field will be used without using the preferred field, "#" sign must be used for the unused field. The string can be terminated without # sign if a new variable will not follow the last one.
- "#", "&" and "$" special characters are reserved for the key string, and should not be used for data.
- The data in hierarchical dependency (such as header-line relation) must be transferred in separate layers. Therefore, the fields to be used in filtering can only be selected from the transferred layer.