Re: Export CTI

Mon, 24 Apr 2006 10:59:54 -0700

Title: RE: Export CTI
**
James,
 
I was actually writing a stored procedure involving related code when I read Mark's email... I was writing SQL and provided a SQL solution.  Yes, exporting from the reporting tool to csv (or xml) may be the preferred method in his environment. 
 
Stephen

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Monday, April 24, 2006 1:55 PM
To: [email protected]
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:[email protected]]On Behalf Of Heider, Stephen
Sent: Monday, April 24, 2006 10:31 AM
To: [email protected]
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:[email protected]] On Behalf Of Doornbos, Mark
Sent: Monday, April 24, 2006 1:21 PM
To: [email protected]
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___

Reply via email to