Difference between revisions of "File:Opasnet base connection.ANA"
(todo added) |
Juha Villman (talk | contribs) (removed completed task) |
||
Line 4: | Line 4: | ||
{{tool|moderator=Jouni}} | {{tool|moderator=Jouni}} | ||
This model is an interface for uploading data to and downloading it from the [[Opasnet base]]. This file is an editable version of a [http://www.analyticaonline.com/24a/Client/AwpClient.aspx?inviteId=invite58&inviteCode=61143 web interface]. For using the file, you need [[Analytica]] Enterprise. For using the web interface, you only need a web browser (Mozilla Firefox recommended). | This model is an interface for uploading data to and downloading it from the [[Opasnet base]]. This file is an editable version of a [http://www.analyticaonline.com/24a/Client/AwpClient.aspx?inviteId=invite58&inviteCode=61143 web interface]. For using the file, you need [[Analytica]] Enterprise. For using the web interface, you only need a web browser (Mozilla Firefox recommended). | ||
− | |||
− | |||
{{todo|OBC:n lataustapa 1 (copy-paste table) pitäisi koodata R:lle. Kuka osaisi?|Juha Villman}} | {{todo|OBC:n lataustapa 1 (copy-paste table) pitäisi koodata R:lle. Kuka osaisi?|Juha Villman}} |
Revision as of 06:36, 24 June 2010
This page is a method.
The page identifier is Op_en2676 |
---|
Moderator:Jouni (see all) |
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. You can select slices from a variable.
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).
Developmental needs
Kehitettävää (by Erkki):
- A) Taulukkodatan syöttö on vielä epävarmaa, toimii välillä ja välillä ei, vailla selkeää johdonmukaisuutta. ==> Epävarma toiminta voisi Juhan mukaan viitata johonkin selain-/flash-/tms.-tekniseen fibaan.
- B) Parametrisarakkeissa olevan puuttuvan datan käsittely näyttää keskeneräiseltä, koska 'Null' ei nähtävästi kelpaa arvoksi lainkaan (ko. rivit jäävät kokonaan pois), ja 'Undefined'-arvot AWP muuntaa nolliksi, mikä johtaa harhaan.
- ⇤1 : There is no need to store null values, because all missing values are null anyway. --Jouni 11:57, 13 January 2010 (UTC)
- C) Kun menen katsomaan http://base.opasnet.org/, niin ko. study näkyy kylläkin pudotusvalikossa, mutta "post"-painikkeella ei palaudu mitään dataa. Juha varmaan fiksailee tuon kun ehtii.
See also
- Opasnet Base
- Opasnet Base structure
- 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 | |
---|---|---|---|---|
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. | |
12:51, 23 April 2009 | (267 KB) | Jouni (talk | contribs) | Some problems occurred because of textify function. They were corrected. | |
14:00, 22 April 2009 | (262 KB) | Jouni (talk | contribs) | Many improvements made: textify function added. Some read queries corrected. Write functionalities updated. Now writing seems to work well. | |
14:15, 2 April 2009 | (234 KB) | Jouni (talk | contribs) | Some technical problems corrected. | |
07:48, 1 April 2009 | (230 KB) | Jouni (talk | contribs) | The model was streamlined and hierarchy improved. Now the writer is on top. | |
21:12, 31 March 2009 | (232 KB) | Jouni (talk | contribs) | Now the model works, both data table and Analytica model! I removed the example data from the model. |
- 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)