Mode indicators
- Last UpdatedFeb 27, 2025
- 1 minute read
The mode indicator determines whether the data is inserted, updated, deleted, or ignored. Valid values for the mode indicator are:
|
Value |
Description |
|---|---|
|
update: |
If the line being imported corresponds to an existing entity in the database, the entity is updated with the contents of the line in the file. If the entity does not exist in the database, it is inserted. |
|
insert: |
If the line being imported corresponds to an existing entity in the database, that entity is left unmodified in the database. Only non-existing database entities are added when this value is specified for the mode indicator. |
|
delete: |
If the line being imported corresponds to an existing entity in the database, that entity is deleted; otherwise, nothing is done. |
|
ignore: |
The line in the text file is essentially ignored. This is useful for skipping portions of the text file when importing. |
The very first line in the text file must be a valid mode indicator; otherwise, the importer reports an error and stops importing the file. Mode indicators can appear anywhere in the file and remain effective until the next mode indicator or the end of the file is encountered.