Difference between revisions of "Downloading your own data"

From InfoEx Help Information
Jump to navigation Jump to search
(→‎Step-by-step description)
(→‎Step-by-step description - Downloading from 'Download Operation Data' in the Cogwheel menu)
 
(11 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
{{Requirements|UserLevel=Operation Administrator and higher|Connectivity=Online only}}
 
{{Requirements|UserLevel=Operation Administrator and higher|Connectivity=Online only}}
  
−
This pages describes how to download your own data from the InfoEx for use in programs like Excel.
+
This page describes how to download your own data from InfoEx for use in programs like Excel.
  
 
==Background==
 
==Background==
−
To allow operations to make better use of the data they have entered into the InfoEx, we included an export functionality in the application. The report tables are downloaded as individual CSV (commas delimited) files that can be read by programs like Excel or Numbers. These files can be used for local archiving, research projects and case studies or end of season reports.
+
To allow operations to make better use of the data they have submitted to InfoEx, exporting is available. The report tables are downloaded as individual CSV (commas delimited) files that can be read by programs like Excel or Numbers. These files can be used for local archiving, research projects and case studies or end of season reports. Data can be downloaded via the reports function or 'Download Operation Data' in the cogwheel menu
  
−
{{Note|It is only possible to download reports that only include data of your own operation. InfoEx data files that include multiple operations require permission from the each of the included subscribers and can only be must be requested from the Canadian Avalanche Association|NoteWithImage}}
+
{{Note|It is only possible to download reports that only include data of your own operation. InfoEx data files that include multiple operations require permission from each of the included subscribers and must be requested from the Canadian Avalanche Association|NoteWithImage}}
  
 
See [[Downloading your location catalog as a KML file]] for information on how to download you own location catalog.
 
See [[Downloading your location catalog as a KML file]] for information on how to download you own location catalog.
  
−
==Step-by-step description==
+
==Step-by-step description - Downloading from reports==
  
 
{|class="TblSteps"
 
{|class="TblSteps"
Line 20: Line 20:
 
|class="StepNum" | 2.
 
|class="StepNum" | 2.
 
|Click on the location field above the tables and select your own operation in the operation tab of the location filter (see [[Restricting the locations included in an InfoEx report]] for more details.  
 
|Click on the location field above the tables and select your own operation in the operation tab of the location filter (see [[Restricting the locations included in an InfoEx report]] for more details.  
−
{{Note|It is only possible to expert a report if your operation is the one and only operation in the location filter.}}
+
{{Note|It is only possible to export a report if your operation is the one and only operation in the location filter.}}
 
|-
 
|-
 
|class="StepNum" | 3.
 
|class="StepNum" | 3.
Line 32: Line 32:
 
|class="StepNum" | 4.
 
|class="StepNum" | 4.
 
|Select the desired date range for your report by clicking on the date range field above the tables. Once you have selected the desired date range, wait for the data to appear.
 
|Select the desired date range for your report by clicking on the date range field above the tables. Once you have selected the desired date range, wait for the data to appear.
−
{{Note|If you have entered a lot of data into the InfoEx and you are querying the server for the entire season, you might not be able to download it all at once. If this happens, you can still download your information, but you will need to explicitly do it table by table. In other words, you will need to create individual reports with only weather observation, fiedl summaries, avalanche observations, ... and download them separately. See [[Specifying the tables to be included in an InfoEx report]] for more information on how to do this.}}
+
{{Note|If you have entered a lot of data into the InfoEx and you are querying the server for the entire season, you might not be able to download it all at once. If this happens, you can still download your information, but you will need to explicitly do it table by table. In other words, you will need to create individual reports with only weather observation, field summaries, avalanche observations, ... and download them separately. See [[Specifying the tables to be included in an InfoEx report]] for more information on how to do this.}}
 
|-
 
|-
 
|class="StepNum" | 5.
 
|class="StepNum" | 5.
−
|[[File:ExportButton.png|300px|thumb|right|Fig. 1: Export button]] Click on the export button (Fig. 1) in the top right corner above the report tables. This button is only visible of your account has operation administrator privileges and your report only contains data from your own operation.
+
|[[File:ExportButton.png|300px|thumb|right|Fig. 1: Export button]] Click on the export button (Fig. 1) in the top right corner above the report tables. This button is only available for operation administrators when your report only contains data from your own operation.
 
|-
 
|-
 
|class="StepNum" | 6.
 
|class="StepNum" | 6.
Line 41: Line 41:
 
|-
 
|-
 
|class="StepNum" | 7.
 
|class="StepNum" | 7.
−
|[[File:ExportConfirmMultipleFiles.png|300px|thumb|right|Fig. 3: Confirm export of multiple files]] Confirm in the yellow bar at the top of the browser window (Fig. 3) that you allow the site to download multiple files.
+
|[[File:ExportConfirmMultipleFiles.png|300px|thumb|right|Fig. 3: Confirm export of multiple files]] If prompted, confirm in the yellow bar at the top of the browser window (Fig. 3) that you allow the site to download multiple files.
 
|-
 
|-
 
|class="StepNum" | 8.
 
|class="StepNum" | 8.
 
|Open the downloaded files in a program like '''Excel''' or '''Numbers'''.  
 
|Open the downloaded files in a program like '''Excel''' or '''Numbers'''.  
 +
|}
 +
 +
==Step-by-step description - Downloading from 'Download Operation Data' in the Cogwheel menu==
 +
 +
{|class="TblSteps"
 
|-
 
|-
−
|class="StepNum" | 9.
+
|class="StepNum" | 1.
−
|If the date settings in your Excel are the same as on my computer, Excel has a hard time importing the MM/DD/YYYY format properly. The following formula can sort this all out for any dates included in the InfoEx. If you have a date value in cell A2, the formula is:
+
|Select your start and end dates.  
−
<code>=IF(ISBLANK(A2), "", IF(CELL("format",A2)="D1", DATE(YEAR(A2), DAY(A2), MONTH(A2)), IF(CELL("format", A2)="G", DATE(RIGHT(A2,4), LEFT(A2,2), RIGHT(LEFT(A2, 5),2)), "Error")))</code>
+
|-
−
 
+
|class="StepNum" | 2.
−
Use the above formula to calculate a new column of properly formatted dates. Copy the new column and paste its values into the the old date column. Once you have completed this task, you can properly sort the table according to date.
+
|Select the tables you would like to download and click on {{ButtonBlue|Download}}.
 
|-
 
|-
−
|class="StepNum" | 10.
+
|class="StepNum" | 3.
−
|You can use the following formula to get rid of the HTML code in the location column. If you a location value in cell B2, the formula is:
+
|A single csv file will be downloaded with all the data submitted by your operation. Open the downloaded file in a program like '''Excel''' or '''Numbers'''.
−
<code>=RIGHT(LEFT(B2,LEN(B2)-5), LEN(B2)-78)</code>
 
−
 
 
−
Use the above formula to calculate a new column of properly formatted locations. Copy the new column and paste its values into the the old location column.
 
 
|}
 
|}
  

Latest revision as of 09:26, 1 June 2017

REQUIREMENTS
Permission Operation Administrator and higher
Connectivity Online only

This page describes how to download your own data from InfoEx for use in programs like Excel.

Background

To allow operations to make better use of the data they have submitted to InfoEx, exporting is available. The report tables are downloaded as individual CSV (commas delimited) files that can be read by programs like Excel or Numbers. These files can be used for local archiving, research projects and case studies or end of season reports. Data can be downloaded via the reports function or 'Download Operation Data' in the cogwheel menu

NOTE It is only possible to download reports that only include data of your own operation. InfoEx data files that include multiple operations require permission from each of the included subscribers and must be requested from the Canadian Avalanche Association

See Downloading your location catalog as a KML file for information on how to download you own location catalog.

Step-by-step description - Downloading from reports

1. Start from one of the standard reports (Standard-Today or Standard-Yesterday).
2. Click on the location field above the tables and select your own operation in the operation tab of the location filter (see Restricting the locations included in an InfoEx report for more details.
NOTE It is only possible to export a report if your operation is the one and only operation in the location filter.
3. Adjust the report to your liking by
NOTE Make sure you add the Date column to all your tables if you are downloading data from multiple days.
4. Select the desired date range for your report by clicking on the date range field above the tables. Once you have selected the desired date range, wait for the data to appear.
NOTE If you have entered a lot of data into the InfoEx and you are querying the server for the entire season, you might not be able to download it all at once. If this happens, you can still download your information, but you will need to explicitly do it table by table. In other words, you will need to create individual reports with only weather observation, field summaries, avalanche observations, ... and download them separately. See Specifying the tables to be included in an InfoEx report for more information on how to do this.
5.
Fig. 1: Export button
Click on the export button (Fig. 1) in the top right corner above the report tables. This button is only available for operation administrators when your report only contains data from your own operation.
6.
Fig. 2: Confirm export
Confirm the tables you would like to export (Fig. 2) and click on Export.
7.
Fig. 3: Confirm export of multiple files
If prompted, confirm in the yellow bar at the top of the browser window (Fig. 3) that you allow the site to download multiple files.
8. Open the downloaded files in a program like Excel or Numbers.

Step-by-step description - Downloading from 'Download Operation Data' in the Cogwheel menu

1. Select your start and end dates.
2. Select the tables you would like to download and click on Download.
3. A single csv file will be downloaded with all the data submitted by your operation. Open the downloaded file in a program like Excel or Numbers.

Related documents

Customizing reports

[1] Click to watch a help video
[2] Click to watch a help video

Managing report templates

Viewing report templates

Map Layers

Charts

Functionality tested by

  • Feb 5, 2014: Pascal Haegeli
Retrieved from "http://infoexhelp.avalancheassociation.ca/index.php?title=Downloading_your_own_data&oldid=3355"