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

From Testiwiki
Jump to: navigation, search
(uploaded a new version of "File:Opasnet base connection.ANA": Model tested with several options and now it always works! This is now version 2.0. All descriptions were moved to file:Opasnet base connection.ANA (technical) and [[Uploading to O)
(technical edits)
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
[[Category:Opasnet]]
 +
[[Category:Opasnet Base]]
 
[[Category:Analytica tool]]
 
[[Category:Analytica tool]]
 
[[Category:SQL tool]]
 
[[Category:SQL tool]]
 
[[Category:Open assessment]]
 
[[Category:Open assessment]]
 
{{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 page relates to old versions of [[Opasnet Base (2008-2011)]] and its connections. For the current database version, see [[Opasnet Base]].
  
−
{{todo|OBC:n lataustapa 1 (copy-paste table) pitäisi koodata R:lle. Kuka osaisi?|Juha Villman}}
+
This model is an interface for uploading data to and downloading it from the [[Opasnet Base]]. For using the file, you need [[Analytica]] Enterprise.
  
−
==An improved web interface==
+
[[Uploading to Opasnet Base]] helps you understand what data could and should be updated to [[Opasnet Base]] and what the recommended data structures and formats are. For technical instructions how to use the current upload software, see [[Opasnet Base connection]]. For a general description about the database, see [[Opasnet Base]] and for technical details about the database, see [[Opasnet Base structure]]. For details about downloading data, see [[Opasnet Base UI]].
  
−
There is also a [http://base.opasnet.org 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.
+
'''Some key parts of OBC explained
  
−
The data is stored into the [[Opasnet base]] as two-dimensional tables, one for each data object (data objects can be either [[study|studies]] or [[variable]]s. For details, see the [[Opasnet Base structure|description of the database structure]]. For example, the data called [[Morbidity data for Europe]] consists of a table that is indexed by four [[index|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).
+
; Findid: This function gets an id from a table. It has the following parameters: '''in''': the property for which the id is needed. In MUST be unique in cond and it must contain index i. '''table''': the table from where the id is brought. The table MUST have .j as the column index, .i as the row index, and a column named 'id'. '''cond''': the name of the field that is compared with in. Cond must be text.
  
−
==Developmental needs==
+
;Textify: Changes a number to a text value with up to 15 significant numbers. This bypasses the number formatting problem that tends to convert e.g. 93341 to '93.34K'. If the input is null, the result is ''.
−
 
 
−
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.
 
−
::{{attack|1 |There is no need to store null values, because all missing values are null anyway.|--[[User:Jouni|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.
 
−
 
 
−
{{todo|Järjestelmää voisi muuttaa seuraavasti:
 
−
* Ensin ladataan obj-, act- ja loc-tiedot (explanations). Vasta sen jälkeen ladataan muut (observations: cell, loccell, res). Tämä edellyttää: a) kaikki loc-tietot kaikista ladattavista muuttujista käsitellään kerralla tai luodaan luuppi myös explanationsiin (edellinen parempi), b) kaikki lataustavat tuottavat standardimuotoisen Data_tablen.
 
−
* Replace/append pitää toimia kaikilla lataustyypeillä.
 
−
* Ind pitäisi erottaa omaksi taulukseen Obj:sta. Tämä kuitenkin vaatii niin paljon muutoksia, ettei siihen ryhdytä neuvottelematta Juhan ja Einarin kanssa. Alustavia valmisteluja kuitenkin tehdään halkaisemalla OBC:n Objects-taulu kahtia, Indices erikseen.
 
−
|Jouni, Juha Villman, Einari Happonen
 
−
|project=Opasnet}}
 
  
 
==See also==
 
==See also==
  
 +
* [[Opasnet Base Connection for R]]
 
* [[Opasnet Base]]
 
* [[Opasnet Base]]
 
* [[Opasnet Base structure]]
 
* [[Opasnet Base structure]]
 +
* [[Uploading to Opasnet Base]]
 +
* [[Opasnet Base UI]]
 
* Previous version [[:image:RDB connection.ANA]] and [[:image:RDB reader.ANA]] were only for either reading or writing data.
 
* Previous version [[:image:RDB connection.ANA]] and [[:image:RDB reader.ANA]] were only for either reading or writing data.
 
[[Category:Opasnet Base]]
 
[[Category:Opasnet Base]]
 
* [http://cs.stanford.edu/people/thathoo/rmysql.pdf Guidance document for RMySQL] (the MySQL database connection for [[R]] software.
 
* [http://cs.stanford.edu/people/thathoo/rmysql.pdf Guidance document for RMySQL] (the MySQL database connection for [[R]] software.

Latest revision as of 19:01, 10 April 2015


This page relates to old versions of Opasnet Base (2008-2011) and its connections. For the current database version, see Opasnet Base.

This model is an interface for uploading data to and downloading it from the Opasnet Base. For using the file, you need Analytica Enterprise.

Uploading to Opasnet Base helps you understand what data could and should be updated to Opasnet Base and what the recommended data structures and formats are. For technical instructions how to use the current upload software, see Opasnet Base connection. For a general description about the database, see Opasnet Base and for technical details about the database, see Opasnet Base structure. For details about downloading data, see Opasnet Base UI.

Some key parts of OBC explained

Findid
This function gets an id from a table. It has the following parameters: in: the property for which the id is needed. In MUST be unique in cond and it must contain index i. table: the table from where the id is brought. The table MUST have .j as the column index, .i as the row index, and a column named 'id'. cond: the name of the field that is compared with in. Cond must be text.
Textify
Changes a number to a text value with up to 15 significant numbers. This bypasses the number formatting problem that tends to convert e.g. 93341 to '93.34K'. If the input is null, the result is .

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
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
(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://www.opasnet.org/testiwiki/index.php?title=File:Opasnet_base_connection.ANA&oldid=35358"