File:Opasnet base connection.ANA

From Opasnet
Jump to navigation Jump to search

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 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 (newer 50 | ) (10 | 20 | 50 | 100 | 250 | 500)
Date/TimeDimensionsUserComment
current10: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.
(newest | oldest) View (newer 50 | ) (10 | 20 | 50 | 100 | 250 | 500)

The following 3 pages use this file: