Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Extraction FROM Service Desk

SOLVED
Go to solution
Highlighted
Declan Weir
Occasional Contributor

Data Extraction FROM Service Desk

Hi all,
I know theres a lot of documentation about Data Exchange in the Admin Guides but its all related to Data Extraction from a 3rd party source and importing INTO service desk. Can anyone advise me on the best way to extract data FROM Service Desk into CSV or XML for example?
3 REPLIES
Vasily Kamenev
Honored Contributor

Re: Data Extraction FROM Service Desk

Hi
1. ACES
2. the same as any import, but soure for ODBC your SD db.

Vasily
Patryk Gajewski
Acclaimed Contributor
Solution

Re: Data Extraction FROM Service Desk

Hi,

Even an easier way would be to create a view with all the information you need. Next select all records and copy them(Ctrl C), next "paste special" in Excel and choose "as text".

You can also choose file -> export in the menu which will allow you to export the whole view(or a part of it) you are in at that moment. This option is enabled in of the service packs.

Hope this helps.

Cheers!
Declan Weir
Occasional Contributor

Re: Data Extraction FROM Service Desk

Thanks guys. That worked perfectly Patryk, thanks.
//Add this to "OnDomLoad" event