EXPORT action

The EXPORT action exports existing instances of the specified business object or results of running a query into a comma delimited text file (CSV file). For example:

EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv'

EXPORT ‘My Query’ TO 'c:/mydocuments/psa.csv'

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.

There are several options that can be used with the action:

1. If the FOR UPDATE keyword is specified the ID attributes of the business objects will be written into the export file. If such a file is later imported into the system, the system will look for the objects with the specified ID’s and modify them rather than insert the new ones. If the FOR UPDATE keyword is not specified the ID attributes of the objects will not be written into the export file and if such a file is later imported into the system, each record in the file will create the new instance of the business object. For example:

EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv'FOR UPDATE

2. If EXCLUDE RELATIONSHIPS keyword is specified any relationships that the exported object has with other objects will not be written into the output file. By default all relationships are exported. For example:

EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv' EXCLUDE RELATIONSHIPS

3. If EXCLUDE BINARY keyword is specified any binary attributes that the exported object has (such as Pictures and Documents) will not be written into the output file. By default all binary attributes are exported. For example:

EXPORT PersonalSavingAccount TO 'c:/mydocuments/psa.csv' EXCLUDE BINARY