Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
XML.Import.Work
Performs import.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
XML | 5.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XML.Import.Work" )
Parameters
none
Result
Returns OK or error.
Description
Performs import.Normally we do import on idle while a script pause. But on server this does not work.
You can call this method in a loop to do the inserts for the import.
But it will not create the tables and fields required for import.
If you call XML.Import.Work manually, you may not need a script pause, except if fields and tables should be created.
Changed in version 11.3 to use per thread data, so multiple scripts on server can do imports independently. Please make sure you call all JSON.Import functions on the same script, so they can access their own local dataset and not interfere with other scripts doing imports.
We use SQL to create records, so you can check FM.ExecuteSQL.LastErrorMessage and FM.ExecuteSQL.LastSQL after the import for SQL errors.
Examples
Import on server:
Set Variable [$text; Value:MBS("Text.ReadTextFile"; "/Users/cs/Desktop/test.xml"; "UTF-8")]
Set Variable [$r; Value:MBS("XML.Import"; $text; ""; "")]
Set Variable [$text; Value:""]
If [MBS("IsError") = 0]
Set Variable [$total; Value:MBS("XML.Import.Total")]
Loop
Set Variable [$work; Value:MBS("XML.Import.Work")]
Set Variable [$status; Value:MBS("XML.Import.Status")]
Exit Loop If [$status ≠ "Working"]
End Loop
End If
See also
- FM.ExecuteSQL
- FM.ExecuteSQL.LastErrorMessage
- FM.ExecuteSQL.LastSQL
- IsError
- JSON.Import.Work
- XML.Import
- XML.Import.Errors
- XML.Import.Status
- XML.Import.Todo
- XML.Import.Total
Example Databases
Blog Entries
This function checks for a license.
Created 10th November 2015, last changed 2nd February 2023