1 Getting Startet

This chapter describes the procedures involved in installing the application and getting started with dbTube. It includes the following:

1.1 Installing dbTube

The installation of dbTube is the easiest ever as all you have to do is to unzip the downloaded file and copy the ./javascript/backend/php_mysql/configuration.php_TEMPLATE file to ./javascript/backend/php_mysql/configuration.php.

The last thing that remains to do before starting with the usage of dbTube, is to configure the file configuration.php This is important because it sets up a connection between the PHP files of dbTube and the MySQL database that manages it.

<?php
#################################################
# ENTER Database Configuration here            #
################################################

# The IP address or name of your mySQL server
#
$db_server   = '<Server IP>';

# the user name to use for the db connection
#
$db_user     = '';

# and the password
$db_password = '';

# db instance to use
#
$db_instance = '';

# db table prefix.
# Only tables names startet with the prefix will be shown in the dbTube user interface.
# You can set the variable to "null" to enable all tables in the db.
#
#$table_prefix=null;
$table_prefix="any_";

# true = no commit in the database. This is usefull for test purpose
# false= all imports will be commited in the db.
#
$demo = true;
?>

configuration.php

From there on, you can create, edit and use dbTube import definitions.

1.2 Understanding the User Interface

The user interface consists of four Toolbars, such as the main Menu bar1, the Importer Panel2, the Object Panel3 and the Property Panel4. This section helps you get familiarized with these Toolbars and their functions.

main screen

1.2.1 Menu Bar (1)

The Menu bar includes the Home, Editor, Importer and Manual entry.

The Home contains the common description of dbTube.

Editor launchs the editor for the import definition editing component.

You can upload and import Excel sheets in the Importer area.

The Manual is where you are.

1.2.2 Importer Panel (2)

The Importer Panel includes entries to open, modify and save dbTube import definitions.

1.2.3 Object Panel (3)

You can drag&drop function blocks or database tables from this area into the working canvas.

1.2.4 Property Panel (4)

The property panel shows all related informations of the current select object in the canvas. This is the right place to change the property of the excel function block, database table or a connection.