CSV Export from OTM

There will be several occasions when you might have to export the data from OTM.

Look at the steps to follow for exporting CSV Data.

1.Navigate to Business Process Automation -> Data Export -> CSV Export

2.OTM asks what you want to export

exportWhat	You can select either exportTable – One table at a time exportTableSet – All tables in a table set exportQueryResults – All records in a SQL Query
outputDestination	You can export to Browser A remote OTM instance A file on your OTM Server
runInBackground	If you select ‘Yes’, this process will run in background and then output will be emailed to you. For that in 2nd step you need to provide your email address and SMTP host.
useSelectList	If you select ‘Yes’, you will be able to select specific records which you want to export.

3. Click on Run Button

4. Assuming that you selected ‘exportTable’, you can select a table from the drop down list.

5. Optionally you can write a condition. [No Need to use ‘where’; For eg: domain_name = ‘ABC’. ]

6. Click on Run & Copy the records into Notepad which are available in comma separated format.

7. Save the notepad with CSV extension.