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.
Hi, I tried to use the where clause with domain_name but its not retuning appropriate value. Any help?
ReplyDeleteI gave ,
Domain_name='502399234'
It created the CSV file but there were no rows.
Thanks,
Praveena