Export methods
Calm can export records in the following formats:
NaturalTab or comma separated
XML
Natural export method
If you choose the Natural export method, Calm exports records in the following format:
:RecordType
-FieldName
Text
Text
-FieldName
Text
-FieldName
-FieldName
Text
For example, two of the Actor records in the sample database might be exported thus:
:Actor
-Name
Kim Basinger
-YearOfBirth
1954
-Films
(1981) Hard Country
(1982) Mother Lode
The Man Who Loved Women ~ Domino
(1985) 9½ Weeks
(1987) Blind
Date ~ Nadia
Nadine ~ Nadine
Hightower
(1988) My Stepmother is an Alien
(1989)
Batman ~ Vicki Vale
-Nationality
American
-Notes
:Actor
-Name
Sharon Stone
-YearOfBirth
1958
-Films
(1980) Stardust Memories
(1985) King Solomon's Mines ~ Jessie
(1987) Allan Quatermain and the Lost City of Gold
Total
Recall ~ Lori Quaid
(1991) Basic Instinct ~
Catherine
(1993) Sliver
-Nationality
American
-Notes
Tab & Comma separated export methods
If you choose the tab separated or comma separated export methods, Calm exports records with one record per line and either a tab character or comma between fields. The contents of each field are enclosed in quotes if they contain a tab or comma. Any new lines within a field are converted to \r\n. For example, two records from an address database might be exported in comma separated format as:
Kim Stone,19 Domino Rd,Oxford,OX99
4NH,UK
Sharon Quaid,58 Gold St,Oxford,,UK
Note: It is important that these type of exported records are of an identical format – each record will need exactly the same number of fields in the same order.
So, remember it is possible that:
- extra fields have been added to individual records.
- there are different record formats within a database.