Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
12.1
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
13.4
Statistic
FMM
Blog
Inserts records based on tab/return separated text.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
FM FMSQL | 5.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
InsertFileName | The file name of where the insert table is inside. Can be empty to look for the table in all files. | Get(FileName) | |
InsertTableName | The name of the table to insert record into. Can be ID of table, so we lookup name by ID. Can be result of GetFieldName() function as we remove field name automatically. |
"Assets" | |
FieldNames | A list of field names for the insert. Empty entries in the list are ignored. Can be ID of field, so we lookup name by ID. Can be result of GetFieldName() function as we remove table name automatically. |
"Model" | |
Text | The text to import in TSV format. This means tab character between fields and newline character for new records | "Bob Miller 12345 New York" | |
FieldName... | Additional field to set with the import. Can be ID of field, so we lookup name by ID. Can be result of GetFieldName() function as we remove table name automatically. |
"Model" | Optional |
FieldValue... | A field value to use for setting the field in the parameter before. Data type of parameter must match the data type of the field. |
"Test" | Optional |
Returns number or error.
Import records from text:
Delete All Records [No dialog]
Set Variable [$fields; Value:"FirstName¶LastName¶City"]
Set Variable [$r; Value:MBS("FM.InsertRecordTSV"; ""; "Contacts"; $fields; Import::ImportText)]
Import some contacts with passing import ID/timestamp:
MBS( "FM.InsertRecordTSV"; "Contacts.fmp12"; "Contacts"; "FirstName¶LastName¶City"; $tsv; "ImportID"; $importID; "ImportDate"; Get(CurrentHostTimeStamp))
This function checks for a license.
Created 8th September 2015, last changed 29th January 2023
FM.InsertRecordQueryIgnoreDuplicates - FM.InsertSetUpdateProgressDialog