File:Opasnet base connection.ANA
This page is a method.
The page identifier is Op_en2676 |
|---|
| Moderator:Nobody (see all) Click here to sign up. |
|
Give your opinion to the peer rating of the content of this page. |
| Upload data
|
This model is an interface for uploading data to and downloading it from the Opasnet base. This file is an editable version of a web interface. For using the file, you need Analytica Enterprise. For using the web interface, you only need a web browser (Mozilla Firefox recommended).
An improved web interface
There is also a web interface for downloading only; this interface produces raw data tables that you can copy-paste to an external software. However, some pieces of data are very large, and you may experience downloading the data, or handling the data afterwards. Therefore, there is a need to improve the interface. The improvement needs are described in this chapter.
The data is stored into the Opasnet base as two-dimensional tables, one for each data object (data objects can be either studies or variables. For details, see the description of the database structure. For example, the data called Morbidity data for Europe consists of a table that is indexed by four indices: Year, Sex, Age, and Country. Indices define the specifics of a particular observation. In addition, there is one parameter (morbidity), which is the field that contains the observations (values of interest).
Often, the user is only interested in a part of the data, e.g. one year of observation, one country, and maybe a few age groups. So, there should be an interface that shows the data in the Opasnet in a few steps, when a user selects a data object.
- The user is shown the list of uploads (versions) of the data object. The default is the newest upload, but the user should be able to choose an older one as well. This is based on the query that is shown on the metadata box as "List of uploads".
- The user is shown the list of indices and locations (possible values). The user can choose any combination of locations with tick boxes beside each location.
- The user is shown a two-dimensional table of data with indices and parameters as fields, and observations as rows. This can then be copy-pasted to other programs. Alternatively, a comma separated file (CSV) is created and a Save as dialog box appears. Now the "The newest upload" link does something like this but does not allow for selecting locations, and the output format is not optimal for copy-pasting data into another software.
- In cases where the data is given as distributions instead of point estimates, the data can also be downloaded as a sample file of distributions.
See also
- Previous version image:RDB connection.ANA and image:RDB reader.ANA were only for either reading or writing data.
File history
Click on a date/time to view the file as it appeared at that time.
(newest | oldest) View (newer 10 | older 10) (10 | 20 | 50 | 100 | 250 | 500)| Date/Time | Dimensions | User | Comment | |
|---|---|---|---|---|
| 21:07, 9 February 2010 | (185 KB) | Jouni (talk | contribs) | Data tables streamlined. A few bugs and temporary solutions corrected. | |
| 04:57, 4 February 2010 | (96 KB) | Jouni (talk | contribs) | Formatting of the form improved. Old nodes deleted. No changes in actual computation. | |
| 12:00, 13 January 2010 | (195 KB) | Jouni (talk | contribs) | {Outdated code} from within code removed. A bug in reader part removed. Act_id index added to reader so that all actions within a series are explicitly shown. | |
| 09:30, 13 January 2010 | (196 KB) | Jouni (talk | contribs) | Several bugs corrected. Now seems to work OK. In addition, act.series_id moved to actobj.series_id because it is object-specific. | |
| 14:39, 12 January 2010 | (196 KB) | Jouni (talk | contribs) | The complete model was updated to reflect the updated Opasnet Base structure (with act and actobj, and without objinfo etc). Reading from the Base works fine, also uploading mostly but some untracked errors occur. The user sees little change. | |
| 12:44, 19 October 2009 | (55 KB) | Jouni (talk | contribs) | A few bugs corrected. Tested the connection and it works. Still need to think about the usage of Object_info/Method cell, and Data_table/Obs column. Note! This is a zip file. | |
| 16:34, 17 October 2009 | (55 KB) | Jouni (talk | contribs) | Copy-paste data table, Analytica table, and multi-variable model all work now. The model seems to be ready, but the actual connection must be tested. Note! This is actually a zip file. | |
| 04:47, 19 September 2009 | (171 KB) | Jouni (talk | contribs) | Corrected a bug in Analytica_node. Added features for multi-variable uploads, but not ready yet (see Variable_info and Ch_var). | |
| 20:13, 28 August 2009 | (169 KB) | Jouni (talk | contribs) | Input node for anacode added. Results are handled as numbers if possible, otherwise text. | |
| 13:35, 28 August 2009 | (273 KB) | Jouni (talk | contribs) | Small changes with Res and Resinfo |
- You cannot overwrite this file.
File usage
The following 3 pages link to this file:
- File:RDB connection.ANA (file redirect)
- File:RDB reader.ANA (file redirect)
- File:Transferring to result database.ANA (file redirect)
