Databases


The database system is used to create and edit database tables. As usual, tables and data records can be easily edited online here. An import and export function is available for importing large amounts of data.

The database administration

You can find the database administration in the edit mode of your homepage at DB -> Database administration.

In the upper part a new database table can be created. To do this, enter the desired database name and click on Create. In the lower part, the already existing database tables are displayed, for example the database �shop�.

To edit the table, click next to the database name on edit.

 The database tables �shop�, �forum� and �gaestbuch� do not have to be created manually in the database administration. These are automatically created when the modules are installed. See Chapter Modules.

The Table View

In the table view, all data records (50 pieces per page) are displayed in table form. The Table View allows you to quickly change multiple records simultaneously.

In the edit mode of your homepage, click on DB -> Database administration and click next to the database name, for example �shop�, on edit. The data records are loaded in the table view.

Database Table View

*Save database

*cutting

Copying

*insertion

*Import via the clipboard

*Export via the clipboard

Previous page
      Page selection (step size 50)

Next page
Create new record
Edit record
Delete record
Delete entire record list
Insert column
column settings
Delete column
Search

Edit fields

Click in the desired field (the field is bordered in red) and enter a text. To switch between fields, you can also use the cursor keys (1 2).

Delete row contents, delete column contents

Click on the row number on the left side, for example record number 5 (the field will be colored orange). Now press the delete keyto delete the record.

To delete a column, click on the column name (the field is colored orange) and click on the delete key.

Copy line contents, copy column contents

Click the line number of the line you want to copy. In the menu, choose Copying. Now click on the line number in which the contents are to be inserted and choose the *insertion Symbol. Column contents are copied in the same way. To do this, click on the column name.

Insert, delete, change column

Click on the column name after which the new column is to be inserted. Choose a Insert column.

Enter a column name and specify the type. The column type defines the MySQL type and helps to fill the database later. For example, the type HTML with connection to the editor or the type Image with connection to the image management is displayed. Confirm with Save.

To delete the column, click on the corresponding column name and on Delete column.

To change the column settings, click on the column name and on the column settings Symbol. For example, change the column name or type and save the settings.

 Inserting, deleting and changing the columns can lead to modules such as shop, forum, guestbook etc. no longer being executed correctly. Do not simply change the column names in the shop, since further adjustments are necessary in the PHP code of the shop pages.

Edit record

The data records can be changed in the table view. For larger texts and the use of the fill functions, the dataset view is more suitable. To do this, click on a data record and on the Edit record Symbol.

The record view

The record view displays all columns of a record on a page in a clear form.

To fill in a field, click in the corresponding field and enter a text. With the tab key you can simply switch to the next field.

*Save database

*cutting

Copying

*insertion

Previous record
      Data record selection � Enter the data record number here to select a specific data record

      amend

*Next record

Search

     The option ID One Steps causes the ID to be increased by 1 when the next data record is selected.

     will be. Without this option, the next record found will be displayed.

Editor � Filling help for type HTML, switches to the HTML editor for the field
Image management � Filling help for type images, switches to image management
Document management � Filling out help for type document, switches to document management
Link � Filling out help for type Link, opens the link window

Import and export via clipboard

Importing and exporting via the clipboard is a useful way to copy records from and to other programs. Here in the example some data sets are to be copied to Excel via the clipboard.

To do this, open DB -> Database administration and click next to the database name �shop� on edit.

Now click on the export Symbol. Start Excel and click on the menu item Edit -> Paste. The contents, for example prices and descriptions, can now be changed in Excel.

 The import and export via the clipboard always copies only the data records that are displayed in the table view (50 pieces). If you want to import or export more than 50 records, the chapter Import database or Export database helpful.

To import the changed data, select all rows (max. 50) and all columns in Excel (for the database �shop� this is 19 columns, in Excel up to column �S�). Click in the menu on Edit -> Copy. Switch to the bluetronix software and click on the Import Symbol. Save the database table with one click on Save.

 Always enter URL�s for images, links and documents with complete URL. For example http://www.bluetronix-demo.de/Bilder/Artikel_1.jpg. Do not use spaces, umlauts or special characters in the URL�s. Permitted are a-Z, 0-9, and the characters �_�, �-�, �.�.

Import database

With the import function, large amounts of data can be conveniently imported into the database. Files in CSV and TXT format can be imported.

 It is important for the import that the columns in the import file match those in the database. Compare the table headers in the table view with the columns in the Excel file. Even if columns do not contain any values, these must be included for the import.

In the following example, an article file from Excel is to be imported into the shop database. The columns were adjusted in Excel according to the columns in the database. The header line with the column names was deleted.

Step 1 - Save file as CSV in Excel

In Excel, click on File -> Save as, enter a file name and select as file type CSV (Separator separated *.csv). Click on the Save. Confirm any notes with OK and YES.

Step 2 - Import the file in the database administration

Start in the edit mode of your homepage DB -> Import database.

Click on the symbol  document management. To upload the import file click on Search, select the appropriate file on your local PC and click on Opening. Start the upload with a click on File Upload.

Now select the file (by clicking on the file name) and click on File Insert.

Now define the target database (in our example the database �shop�). The option �bestehende Records löschen� causes all existing records to be deleted before the import. If this option is left empty, the records to be imported are added to the existing ones.

To start the import click on Import. Depending on the amount of data, the import may take a few minutes. Once the import is complete, you can control the action in the Table View. The import of a TXT file works analogously.

Export database

This function can be used to export large amounts of data in CSV or TXT format.

Open in edit mode of your homepage DB -> Export database. Select the desired database from the list and specify the file format (for example, CSV). Click on the Export. Confirm the hint window with OK. After the export has been completed, click on Save fileto save the file to your local PC. In the File window, click Save.

Start Excel and choose File -> Open. Select as file type Text files (*.csv). Click in the file window on your file (it will be marked grey) and on Opening. The file is then loaded into Excel.

MySQL Command Entry

MySQL Command Entry allows advanced users to perform actions on records in addition to Table and Record View functions. For example, to delete multiple records that fulfill a specific condition, etc. You can find this function in edit mode on your homepage at DB -> MySQL command input. Further information about MySQL can be found on the Internet under the keyword MySQL.

Homepage Software Chapter selection
CMS