Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
a_f:a:import_relationships [2022/09/01 01:23] – removed - external edit (Unknown date) 127.0.0.1a_f:a:import_relationships [2023/05/09 01:37] (current) – sean
Line 1: Line 1:
 +{{tag>Index Action Action_List Process Business_Object}}
 +====== IMPORT RELATIONSHIPS ======
 +
 +This action imports the contents of the comma delimited text file (CSV) that contains the relationships of the specified business object. 
 +
 +===== Syntax =====
 +
 +''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. 
 +
 +===== Example =====
 +
 +<code aim>IMPORT RELATIONSHIPS OF PersonalSavingAccount FROM 'c:/mydocuments/psa.csv' </code>
 +
 +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:
 +
 +<code aim>IMPORT PersonalSavingAccount TO 'c:\mydocuments\psa.csv' IN BATCHES OF 100 </code>
 +
 +If ''IN BATCHES OF'' keyword is omitted the default batch size of 1000 is used.
 +
 +See also the “[[docs:2000_concepts:0900_prod_feats:0600_export_import|Export and Import]]” section.
 +
 +