Difference between revisions of "File:Opasnet base connection.ANA"
(uploaded a new version of "Image:Opasnet base connection.ANA": SD added to the W_cell node. For some reason, data does not upload to Ressec table. It did in the beginning of the session, so I must have made an erroneous change.) |
(uploaded a new version of "Image:Opasnet base connection.ANA": Still didn't find the bug to upload to Ressec. Upload_non_public_da works fine if Ressec is replaced with Res. Is this because of database level changes?) |
(No difference)
| |
Revision as of 03:43, 7 May 2009
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 | |
|---|---|---|---|---|
| 12:37, 8 June 2009 | (91 KB) | Jouni (talk | contribs) | Now the user interface is also updated. The model seems to work fine (except that W_loccell shows a benign warning about summing up text). A larger test phase should be started. This version should be called 1.0. | |
| 08:31, 8 June 2009 | (167 KB) | Jouni (talk | contribs) | Old parts removed. The new user interface under preparation, still looks messy. Base tables erased, therefore much smaller file size. | |
| 07:50, 8 June 2009 | (1.34 MB) | Jouni (talk | contribs) | Major restructuring: Only one node can be uploaded at a time. 2D data table is the basic for all data formats, also Analytica nodes are transformed into 2D. This simplifies the code a lot. This is intermediate version, lots of old stuff uncleaned. | |
| 20:48, 25 May 2009 | (175 KB) | Jouni (talk | contribs) | Reformatted the outline. Corrected node-based data table calculations. Deleted modules Additonal_parts, Additional_parts1, Table_format_for_input, and Dependency_graph. | |
| 13:03, 22 May 2009 | (1.15 MB) | Jouni (talk | contribs) | SD added to Cell and also some other improvements. | |
| 03:43, 7 May 2009 | (280 KB) | Jouni (talk | contribs) | Still didn't find the bug to upload to Ressec. Upload_non_public_da works fine if Ressec is replaced with Res. Is this because of database level changes? | |
| 14:45, 6 May 2009 | (280 KB) | Jouni (talk | contribs) | SD added to the W_cell node. For some reason, data does not upload to Ressec table. It did in the beginning of the session, so I must have made an erroneous change. | |
| 11:47, 30 April 2009 | (276 KB) | Jouni (talk | contribs) | A few bugs corrected in Doresult and Data_table. | |
| 22:01, 29 April 2009 | (275 KB) | Jouni (talk | contribs) | This version has such a data table mode that does not use edit tables for uploading the data, but a simple text field. This way, the bug preventing table pasting in the AWP can be overcome. | |
| 20:52, 23 April 2009 | (267 KB) | Jouni (talk | contribs) | Small bugs corrected. |
- 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)
