IMPORT RELATIONSHIPS

This action imports the contents of the comma delimited text file (CSV) that contains the relationships of the specified business object.

IMPORT RELATIONSHIPS OF Id() FROM ArithmeticOperation()

where Id() is the identifier of the business object to be imported and the ArithmeticOperation() is the expression identifying the name of the import file. The result of the arithmetic operation must be a string.

IMPORT RELATIONSHIPS OF PersonalSavingAccount FROM 'c:/mydocuments/psa.csv' 

The following option can be used with this action:

IN BATCHES OF IntegerLiteral()

If the action is likely to import many instances of the business object (hundreds or even thousands) their processing may take a while. In this case it is better to perform processing in smaller chunks (batches). After the processing of each batch finishes the results are immediately committed to the system and stored in the database. If the batch size is not specified the system will only commit the results once all instances have been processed.

For example:

IMPORT PersonalSavingAccount TO 'c:\mydocuments\psa.csv' IN BATCHES OF 100 

If IN BATCHES OF keyword is omitted the default batch size of 1000 is used.

See also the “Export and Import” section.