Command : Data import
Keyboard shortcut :
Icon :
This command allows for the importing of data in the text format (ascii) in order to rapidly enhance the current file. The document containing this data is called an 'importation document'.
Note : This command is only active on the list format.
The data import function is identical for all the files benefiting from this command, with the exception of the questionnaire file (see below in this chapter).
Data import modifies the current selection.
After an import, the latter contains only the newly created records.
 | Standard function mode
|
| Only the files Contact, Functions, Postal Standardisation, and Towns, benefit from this function.
|
|
|
| Certain characteristics of this dialogue are brought up in the paragraph "Introduction to Standard Dialogue".
|
|
|
| The importation document must be in text format.
|
| Note : Each component of data must be separated by the following ascii code 9 (tabulation) and each record by the ascii code 13 (carrier return).
|
|
|
| The structure of the importation document maybe different from that of the current table. It is sufficient to indicate to Prospect Tracking what the connection is between the fields of the current file and the information of the importation document.
|
| Note : It is not compulsory that all the fields have a connection. A field without a connection is ignored.
|
|
|
| The navigation buttons allows you to move within the importation document in order to verify that the correlation between the fields of the current table and the information to be imported is right.
|
| If the import document has a header (field designation), this correlation is easier to do.
|
| The option 'Ignore header' means that the line of the text file does not get imported. This option should only be used in the case where the first line of the importation file refers to the field.
|
| Saving/Opening a format
|
| If your import format is liable to be used frequently, it is advised to memorise and store the structure with the help of the 'Save' button.
|
| If your document is placed in the 'Import' file it will be automatically integrated in the list 'Open…'.
|
| Contact file features
|
| · | The 'Title' field indifferently accepts the following values in correspondence . (specified values between "):
|
| Mister 'Mister', 'M', 'A' or '1'
|
| Mrs 'Mrs', 'B', or '2'
|
| Miss 'Miss', 'C' or '3'
|
| Mister & Mrs 'Mister & Mrs, 'Mr & Mrs', 'D' or '4'
|
| · | If no country code has been affected on the Contact record during importation, the latter will affect the user country determined in the 'Preferences' file.
|
| · | You can also enhance the 'Index table' file by the bias of this import. Take note that your file should contain as many lines as the 'Index table' file has imported.
|
| Towns file features
|
| It is possible to choose if the process duplication should be activated or not through the 'Preferences' file.
|
| The non activation of process duplication allows the import of several 'Towns' records with an identical postal code. This principal helps to manage the cases where the same postal code represents several communes. (Distributing office and linked communes).
|