Difference between revisions of "File:Opasnet base connection.ANA"
From Testiwiki
(outdated developmental needs removed) |
(technical edits) |
||
| (24 intermediate revisions by 3 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. | ||
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 | |
|---|---|---|---|---|
| 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)
