Difference between revisions of "File:Opasnet base connection.ANA"

From Testiwiki
Jump to: navigation, search
(todo added)
(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|Asennatko ODBC:n Markon koneeseen ja kannettaviin, jotta saadaan OBC toimimaan muualtakin kuin minun koneelta.|Juha Villman}}
 
  
 
{{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 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).

TODO: {{#todo:OBC:n lataustapa 1 (copy-paste table) pitäisi koodata R:lle. Kuka osaisi?|Juha Villman|}}


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

File history

Click on a date/time to view the file as it appeared at that time.

(newest | oldest) View ( | ) (10 | 20 | 50 | 100 | 250 | 500)
Date/TimeDimensionsUserComment
05:40, 31 March 2009 (762 KB)Jouni (talk | contribs)An intermediate version that combines the two input formats: Analytica model and data table. Works for Analytica model, but a lot to clean still.
11:58, 27 March 2009 (745 KB)Jouni (talk | contribs)European morbidity data included as an example of data formatting.
12:26, 25 March 2009 (322 KB)Jouni (talk | contribs)New part added for uploading data tables. Now this works, but the model uploading (with several variables) is not updated. This version requires a password and it only works from within THL.
06:02, 7 January 2009 (154 KB)Jouni (talk | contribs)The model passed all functionality tests. Now it is ready for test use. Farmed salmon model was removed from the file.
07:05, 6 January 2009 (291 KB)Jouni (talk | contribs)Now the Reader works beautifully and it is simple. But there is still some strange problems with Write buttons. Otherwise this is almost ready for production use.
13:51, 31 December 2008 (259 KB)Jouni (talk | contribs)I looked at the reader but it does not work yet. In addition, some functions seem extremely complex. It cannot be that difficult.
06:34, 31 December 2008 (345 KB)Jouni (talk | contribs)Finally it works! Problems with Sample1 were corrected, and now memory demand is much lower. Now it should be tested well and documented. Update Read part.
22:14, 30 December 2008 (364 KB)Jouni (talk | contribs)Now it should work except something strange with Sample1. Also, sampling does not result in a real sample but a series of mid values.
18:15, 30 December 2008 (361 KB)Jouni (talk | contribs)I realised that tables Loc and Roww should be merged and locations should be organised by index, not by dimension. After this version, I'll change the model accordingly.
14:40, 29 December 2008 (353 KB)Jouni (talk | contribs)Some progress done but not finished yet. I drew a graph to show dependencies between tables. The buttons are now updated and the first ones work. Still some problems with Write_item and Write_sam. A new write table created: Sample1. When this works, there
(newest | oldest) View ( | ) (10 | 20 | 50 | 100 | 250 | 500)
  • You cannot overwrite this file.

The following 3 pages link to this file:

Retrieved from "http://opasnet.org/testiwiki/index.php?title=File:Opasnet_base_connection.ANA&oldid=16126"