Import fields

Command group Flag affected Reversible Execute on client Platform(s)

Importing and Exporting YES NO NO All

Syntax

Import fields

(

Insert records

Update records

Indirect

][,

Disable messages

])

list-of-field-names

(Name1,Name2,...)

Types

Insert records	The command inserts new records
Update records	The command searches for existing records in the file and updates the records that it finds; data for which there is no matching record is ignored

Options

Indirect	If specified,the command uses the contents of the first field as the list of fields
Disable messages	If specified,the command does not open messages requiring a user response,and instead it writes a limited amount of information to the trace log

Description

Import fields imports the data for the list of fields from the current import file into the data file. It provides runtime access to the functionality of the import data dialog in the IDE. The command sets the main file for the import to the file corresponding to the first field in the list.

The Insert records option causes the command to insert new records for the data in the file being imported.

The Update records option causes the command to search for an existing record in the data file, for each record in the file being imported, and then update that record. Import records for which there is no matching record in the data file are ignored.

Example

# import from a csv file called myImport.txt in the root of your omnis tree

Calculate 
lImportPath
 as 
con(
sys(115),
'myImport.txt'
)

Set import file name 
[
lImportPath
]

Prepare for import from file 
Delimited (commas)

Import fields
 (
Insert records
)
 
fCustomers
.
Surname
,
fCustomers
.
FirstName

End import
Close import file

Command group	Flag affected	Reversible	Execute on client	Platform(s)
Importing and Exporting	YES	NO	NO	All