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:export [2022/09/13 18:15] – external edit 127.0.0.1a_f:a:export [2025/06/12 03:59] (current) – Change to AwareIM aware_support3
Line 1: Line 1:
-{{tag>Actions Action_List Business_Objects Process}}+{{tag>Index Action Action_List Business_Object Process}}
 ====== EXPORT ====== ====== EXPORT ======
  
Line 7: Line 7:
  
 ''EXPORT'' (Id() | StringLiteral()) ''TO'' ArithmeticOperation() [ ''FOR UPDATE'' ] [ ''EXCLUDE RELATIONSHIPS'' ] [ ''EXCLUDE BINARY'' ] [ ''USING'' ArithmeticExpression () ] [ ''APPEND'' ] ''EXPORT'' (Id() | StringLiteral()) ''TO'' ArithmeticOperation() [ ''FOR UPDATE'' ] [ ''EXCLUDE RELATIONSHIPS'' ] [ ''EXCLUDE BINARY'' ] [ ''USING'' ArithmeticExpression () ] [ ''APPEND'' ]
-[ ''ENCODING'' ArithmeticExpression ()] +[ ''ENCODING'' ArithmeticExpression ()] [ ''USE ATTRIBUTE LABELS'' ] [ ''SKIP COLUMN DESCRIPTIONS'' ] [ ''EXPORT ATTRIBUTE FORMAT'' ]
  
 where Id() is the identifier of the business object to be exported, StringLiteral() is the name of the query to be exported and the ArithmeticOperation() is the expression identifying the name of the export file. If the file doesn’t exist it will be created. The result of the arithmetic operation must be a string.  where Id() is the identifier of the business object to be exported, StringLiteral() is the name of the query to be exported and the ArithmeticOperation() is the expression identifying the name of the export file. If the file doesn’t exist it will be created. The result of the arithmetic operation must be a string. 
 +
  
 ===== Example ===== ===== Example =====
Line 15: Line 16:
 <code aim>EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv' </code> <code aim>EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv' </code>
  
-If the name of the business object is used, the instances available in the current context will be exported. If the name of the query is used //**Aware IM**// will run the query and export the results. If the query has attributes to display defined, only those attributes will be exported. Query names have to be enclosed in apostrophe. User defined queries are also supported.+If the name of the business object is used, the instances available in the current context will be exported. If the name of the query is used //**AwareIM**// will run the query and export the results. If the query has attributes to display defined, only those attributes will be exported. Query names have to be enclosed in apostrophe. User defined queries are also supported.
  
 There are several options that can be used with the action: There are several options that can be used with the action:
Line 44: Line 45:
  
 The default encoding is UTF-8. The default encoding is UTF-8.
 +
 +<code aim>EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv' USE ATTRIBUTE LABELS </code>
 +
 +The header of the file containing column descriptions will be exported and instead of attribute names labels of the attributes will be exported
 +
 +<code aim>EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv' SKIP COLUMN DESCRIPTIONS </code>
 +The header of the file containing column descriptions will not be exported
 +
 +<code aim>EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv' EXPORT ATTRIBUTE FORMAT </code>
 +The header of the file containing column descriptions will be exported and the header of a Date, Timestamp, Duration and Number attributes will have the appropriate format included in the description of the column.
  
 See also the “[[docs:2000_concepts:0900_prod_feats:0600_export_import|Export and Import]]” section. See also the “[[docs:2000_concepts:0900_prod_feats:0600_export_import|Export and Import]]” section.
  • Last modified: 2022/09/13 18:15