Re: Export CTI

[Doornbos, Mark]

Title: RE: Export CTI

**

Thanks James and Stephen. Perfect!

 

mjd

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: April 24, 2006 12:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: Export CTI

**

Stephen:

Why do it the hard way?  Use the Reporting tool and export to a .csv file from the SHR:Categorization form.  Import that file to Excel.

James McKenzie

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Heider, Stephen
Sent: Monday, April 24, 2006 10:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: Export CTI

**
Mark,

Using SQL Server 2000's SQL Query Analyzer:

SELECT AppSchema + CHAR(9) + Category + CHAR(9) + Type + CHAR(9) + Item
FROM SHR_Categorization
ORDER BY AppSchema, Category, Type, Item

Run, Select all, Copy, then Paste into a blank Excel sheet.

Stephen

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Doornbos, Mark
Sent: Monday, April 24, 2006 1:21 PM
To: arslist@ARSLIST.ORG
Subject: Export CTI

**
Hi fellow listers,

What are the steps to export CTI's to an excel spreadsheet?

Thanks.
mjd

__20060125_______________________This posting was submitted with HTML in it___    __20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___