Pages

Friday, October 19, 2012

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. 


1 comment:

  1. Hi, I tried to use the where clause with domain_name but its not retuning appropriate value. Any help?

    I gave ,
    Domain_name='502399234'
    It created the CSV file but there were no rows.

    Thanks,
    Praveena

    ReplyDelete