MS Excel - Revision history

Gityerfix at 06:24, 6 August 2008

2008-08-06T06:24:05Z

Gityerfix at 19:02, 26 July 2008

2008-07-26T19:02:15Z

Gityerfix at 21:51, 25 July 2008

2008-07-25T21:51:26Z

Gityerfix at 14:03, 18 July 2008

2008-07-18T14:03:22Z

Gityerfix at 13:12, 5 July 2008

2008-07-05T13:12:45Z

Gityerfix at 13:11, 5 July 2008

2008-07-05T13:11:57Z

Gityerfix at 11:24, 2 July 2008

2008-07-02T11:24:11Z

Gityerfix: MS Excell moved to MS Excel: Excel is the proper name

2008-07-02T11:22:01Z

MS Excell moved to MS Excel: Excel is the proper name

BrianM at 08:22, 2 July 2008

2008-07-02T08:22:28Z

BrianM: New page: Below is a list of steps to extract data from ServiceDesk and export to MS Excell file. Please note that this extracts data directly from the MDB (ServiceDesk database) via simple query th...

2008-07-02T08:09:39Z

New page: Below is a list of steps to extract data from ServiceDesk and export to MS Excell file. Please note that this extracts data directly from the MDB (ServiceDesk database) via simple query th...

New page

Below is a list of steps to extract data from ServiceDesk and export to MS Excell file. Please note that this extracts data directly from the MDB (ServiceDesk database) via simple query through a data source.

'''WARNING''': Continous running of such queries that run long or return too much data can bring cause performance issues on users logged on to the application.

1. Open a new clean Excel file

2. Go to Data -> Import External Data -> New Database Query

3. Select the fields you need and run the query (''link tables if you have to'')

4. Export to Excel and save the file (''If you already have the query somewhere, just follow the steps and instead of selecting the fields, you simply paste your query and run it then save the results to an excel spreadsheet'')

Next time you want to run the same query to get the updated data, you simply do the following:

1. Open the Excel file from the previous steps

2. Go to Data -> Refresh Data (This will run the query and return the new data to the spreadsheet)

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Reporting]]
 {{Global Header}}

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Reporting]]
-<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+{{Global Header}}
-To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+{{Global Announcement}}
 == See Also ==
 [[Exporting From DB to Excel]]

← Older revision		Revision as of 21:51, 25 July 2008
Line 1:		Line 1:
		+	__NOTOC__
	[[Category:Reporting]]		[[Category:Reporting]]
		+	<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
		+	To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

		+	== See Also ==
	[[Exporting From DB to Excel]]		[[Exporting From DB to Excel]]
−
−
−
−
−
−	~~----~~
−	~~<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>~~
−	~~To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>~~

@@ Line 8: / Line 8: @@
 ----
-<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
 To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

← Older revision		Revision as of 13:12, 5 July 2008
Line 2:		Line 2:

	[[Exporting From DB to Excel]]		[[Exporting From DB to Excel]]
		+
		+
		+
		+
		+
		+	----
		+	<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
		+	To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

@@ Line 2: / Line 2: @@
 |-
 | width="50%" align="left" style="vertical-align:top;" |
-*[[Exporting data from ServiceDesk to Excell file]]
+*[[Exporting From DB to Excel]]

← Older revision	Revision as of 11:22, 2 July 2008
(No difference)

@@ Line 1: / Line 1: @@
-Below is a list of steps to extract data from ServiceDesk and export to MS Excell file. Please note that this extracts data directly from the MDB (ServiceDesk database) via simple query through a data source.
+{| width="100%"
+|-
-'''WARNING''': Continous running of such queries that run long or return too much data can bring cause performance issues on users logged on to the application.
+| width="50%" align="left" style="vertical-align:top;" |
+*[[Exporting data from ServiceDesk to Excell file]]
-. Open a new clean Excel file
-−
-. Go to Data -> Import External Data -> New Database Query
-−
-. Select the fields you need and run the query (''link tables if you have to'')
-−
-. Export to Excel and save the file (''If you already have the query somewhere, just follow the steps and instead of selecting the fields, you simply paste your query and run it then save the results to an excel spreadsheet'')
-−
-−
-Next time you want to run the same query to get the updated data, you simply do the following:
-−
-−
-. Open the Excel file from the previous steps
-−
-. Go to Data -> Refresh Data (This will run the query and return the new data to the spreadsheet)