Cornell University



Exporting data from the system:To Export using Excel link:From the room or facilities search page enter your search criteriaFrom the search results page select the “Export Search Results Excel” link:Select the “Save File” radio button and click OKThis will save the file where ever your browser defaults to saving downloads.If your browser does NOT default to the desk top and you want it to, follow the instructions below:Mozilla: Go to the Tools menu, and open options in the main tab. In the downloads section select “Save files to” and browse to your desktop or the folder where you would like your downloads to go. Click OKDouble click on the file to open, or open it through the application.In next window “The file you are trying to open….” Select “Yes” – the file should open.To Export using XML link:From the room or facilities search page enter your search criteriaFrom the search results page select the “Export Search Results to SML link:Select the “Save File” radio button and click OKTo open XML document, open Excel applicationGo to the big navigational circle (upper left hand corner), and pull down and select “Open”.Browse to the file, select it, and click “Open”.In the Open XML window “As an XML table” should already be selected. Click OKNext dialog box “The specified XML source…” click OK, file should open with colored rowsSpecial Notes:The net area field comes in as a data type field “Text” and will not add. Select the column of numbers under the net area title, and right click and select convert text to number.When you sum the column select the numbers as well as one blank field below the last row (otherwise XML with think this column of numbers wants to be a table of some kind.Room types come in as a data type field “General” without leading zeros. These can be converted to Text using the number type in the Excel home tab. The zeros would then have to be manually added ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download