File:Opasnet base connection.ANA
From Testiwiki
Opasnet_base_connection.ANA (file size: 80 KB, MIME type: application/xml)
Warning: This file type may contain malicious code.
By executing it, your system may be compromised.
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 50 | older 50) (10 | 20 | 50 | 100 | 250 | 500)| Date/Time | Dimensions | User | Comment | |
|---|---|---|---|---|
| current | 10:26, 21 August 2010 | (80 KB) | Jouni (talk | contribs) | Major simplifying revisions: lot of memory-saving improvements. Two input formats rejected. Intermediate nodes merged to save memory. Bugs corrected. |
| 19:30, 12 July 2010 | (92 KB) | Jouni (talk | contribs) | Now it is quick also with probabilistic data, as I changed while-do loop to for x[]:= b loop. In addition, the obs in a deterministic table is the row number, while before it was just zero. | |
| 13:42, 12 July 2010 | (92 KB) | Jouni (talk | contribs) | As expected, Cellrow node was too heavy with large data. This part was streamlined. Now it is quick and simple with deterministic data, but takes a long time with large probabilistic data (little memory need, though). | |
| 22:22, 11 July 2010 | (92 KB) | Jouni (talk | contribs) | Still some bugs found but it seems to work now. | |
| 05:05, 10 July 2010 | (107 KB) | Jouni (talk | contribs) | 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 Opasnet Base (method) and updated. | |
| 14:56, 9 July 2010 | (121 KB) | Jouni (talk | contribs) | Tested and now it works except bugs were found from W_Actobj and Cell, because they depend on uploaded tables and the update too fast. Maybe a static node in between solves this problem. | |
| 23:05, 8 July 2010 | (136 KB) | Jouni (talk | contribs) | Update finalised and first tests are successful. The code has become much simpler, it can even been understood by outsiders. | |
| 14:11, 8 July 2010 | (126 KB) | Jouni (talk | contribs) | Code streamlined. All different upload types seem to work to Data_table phase but not further. Added observise function to work with table-based prob data. | |
| 22:50, 7 July 2010 | (108 KB) | Jouni (talk | contribs) | Index info was rejected because it caused trouble with updating, was complex, and didn't bring anything essential. Some bugs removed. Should work now but haven't tested yet. Code starts to be simple and beautiful. Stuff moved to Old parts. | |
| 15:13, 7 July 2010 | (105 KB) | Jouni (talk | contribs) | Uploading part streamlined and corrected. Not all upload methods worked properly. There is still some problem. | |
| 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 | |
| 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. | |
| 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. | |
| 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 | |
| 22:44, 28 December 2008 | (341 KB) | Jouni (talk | contribs) | The test phase is not yet successful. Several write nodes need updates. An example model, Farmed salmon, is saved with this file. | |
| 23:28, 15 December 2008 | (239 KB) | Jouni (talk | contribs) | All tasks listed with previous version are completed. Now write part should work but haven't tested. Then, read part should be updated as well. | |
| 14:50, 15 December 2008 | (258 KB) | Jouni (talk | contribs) | Seems to work (almost). Tasks: Check Write_sett and Write_item. Make buttons for updating each table separately (is this needed for all tables?). Remove redundant attributes. Remove Old_parts. Think about updating procedure and make coherent. | |
| 23:49, 14 December 2008 | (251 KB) | Jouni (talk | contribs) | New model starts to get shape. All database queries are now in Buttons, and query results are static nodes. Not all write nodes work, but most are pretty good already. | |
| 16:56, 8 December 2008 | (150 KB) | Jouni (talk | contribs) | Large changes. Two thirds done. NOTE: this version does not work. |
- 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)
