Difference between revisions of "File:Opasnet base connection.ANA"
From Testiwiki
(uploaded a new version of "File:Opasnet base connection.ANA": Update finalised and first tests are successful. The code has become much simpler, it can even been understood by outsiders.) |
(technical edits) |
||
| (11 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 | + | ''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== | ==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 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 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
- Opasnet Base Connection for R
- Opasnet Base
- 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.
- Guidance document for RMySQL (the MySQL database connection for R software.
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 | |
|---|---|---|---|---|
| 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 |
- 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)
