Data

The data-download (Ctrl + Shift + U) operation shows the data download form.

You can download the events, expressions, and capacity profiles in CSV format only.

The data-upload (Ctrl + U) operation shows the data upload form. You can upload capacity profiles, events, and expressions from local CSV files and MySQL, Oracle and SQLite databases.

Because of the Single Origin Policy, uploading from a database requires that the model and the database are in the same domain, see Same_origin_policy.

Model and databases must be in the same language.

Both for local CSV files and databases, uploading is synchronous.

After uploading, the events search button provides access to the database, for review and data quality checks. The search functionality requires that the database server runs adminer and that it is accessible on the intranet. The database search is not affected by the Single Origin Policy because the page with the data loads into a new browser window. Hence, you'll be able to search the databases regardless of the location of the model, even if the files are on your PC.

Some example upload forms are shown below.

For uploading data from a MySQL database:

• the protocol must be selected (HTTPS for secure communication)
• the server URL can be left empty
• username and password
• the database name and table name
• the path to the folder with the ARTIS PHP files, as /path/to/php/folder, relative to the website root directory, this folder is on the database server and the input should be provided by your database administrator
• (optional, for search only) the path to adminer.php, as /path/to/adminer.php, relative to the website root directory, this folder is on the database server and the input should be provided by your database administrator

For uploading data from an Oracle database:

• the protocol must be selected (HTTPS for secure communication)
• for Oracle only, the server URL must be supplied, even though the model and database are in the same domain, and the input should be provided by your Oracle database administrator
• username and password
• the database name and table name
• the path to the folder with the ARTIS php files, as /path/to/php/folder, relative to the website root directory. This folder is on the database server and the input should be provided by your database administrator
• (optional, for search only) the path to adminer.php, as /path/to/adminer.php, relative to the website root directory. This folder is on the database server and the input should be provided by your database administrator

For uploading data from an SQLite database:

• the protocol must be selected (HTTPS for secure communication)
• the server URL, username and password can be left empty
• the database name, that is the absolute path to the database, as /path/to/database.
• the table name
• the path to the directory with the ARTIS php files, as /path/to/php/folder, relative to the website root directory.
• (optional, for search only) the path to adminer.php, as /path/to/adminer.php, relative to the website root directory.

The paths to the directories and files on the database server should be provided by your database administrator.

Uploading data from a local CSV file is straightforward, by a file browser.

Regardless of the database system, the data tables have the same layout. The tables must not have any empty rows.

This screenshot shows a table with events from a CSV file.

This screenshot shows a table with expressions from an SQLite database.

This screenshot shows a table with capacity profiles from a CSV file.