After the outline dimensions are built, data can be loaded into the database through the API. The data load can be done by using a data file or a SQL source together with a rules file, by loading a free-form data file, or by loading free-form data a record at a time.
To load by using a rule with either a data file or an SQL source, use EsxImport(). Pass valid rules and data file object definitions as arguments. To load a free-form data file without a rules file, simply pass a NULL rules file object definition.
To load data a record at a time, call EsxBeginUpdate() with the Unlock argument set to FALSE, and then call EsxSendString() with each record of data to be loaded. This method avoids the need to lock the blocks being updated. This mechanism should be used only for batch data loading. Do not use this mechanism in multi-user situations. The lack of locking can compromise data integrity.
Note also that each record sent to the server by this method must have a terminating newline character at the end of each row.
For detailed descriptions of all these functions, see EssImport, EssBeginUpdate, EsbImport, and EsbBeginUpdate.
See API Libraries.