MySQL and an Admin Tool (e.g., phpMyAdmin) needs to be installed on a server. See also the tips for installation (German)
Please contact your IT service to clarify how to operate the database safely.
The provided MySQL/Maria database needs to be imported into the installed MySQL and the provided *.zip archive needs to be copied and unzipped in the respective host folder.
Navigation - General functions
As a user, you can also use the navigation buttons from your browser. There might be the request to 'resubmit the form', which you need to accept.
As an admin, that would not be recommended as resubmitting a form might lead to an error.
Cancel / Back
On top of each page a navigation button to previous page can be found:
Back
It cancels all changes done on that respective page.
Edit a row
In some of the views, the content is editable. You can find a blue underlined text in the column 'Edit':
Edit
After clicking on the link, a new view will open, where the details can be changed.
After changing, the button
needs to be pressed to save the changes in the database.
Upload / Download Files
In some of the views, files can be uploaded. You can find a blue underlined text in the column 'Upload / Download':
Upload
An uploaded file will get a revision number as extension of the filename.
If a file is already uploaded with the same name, it will get new revision number as extension of the filename.
In some of the views, files can be downloaded. You can find a blue underlined text in the column 'Upload / Download':
Download
A menu will pop up, where the file to download can be selected. The file will be downloaded to the download folder on your computer, which is same as the standard folder used by your browser.
Insert a row
In some of the views (e.g. when a list of projects is displayed), a row can be added to a table (e.g. to add a new project). You can find a button most probably at the bottom of a table, which needs to be pressed to insert a row in the database.
Main Navigation Menu at the bottom of each webpage
At the bottom of each page a navigation menu be found:
Startpage will you guide every time back to the main page.
Logout will delete the temporary Session File. It is not required to log out, as the temporary Session File will be also automatically deleted, when closing the webbrowser.
Contact is an optional page
Impressum is a legal requirement in Germany, when the webside is used in the www. It is not required when you use it in your internal network or via VPN.
Login
The database is accessed via WebBrowser, the interface is displayed below:
At the bottom of each page a navigation menu be found:
Startpage will you guide every time back to the main page.
Logout will delete the temporary Session File, which will be also automatically deleted, when closing the webbrowser.
Contact is an optional page
Impressum is a legal requirement in Germany, when the webside is used in the www. It is not required when you use it in your internal network or via VPN.
User profiles
There are three different kind of user profiles defined:
Admin
User
Manager
Different views will be displayed according the assigned profile.
Profile 'Admin'
The admin can
create, update or delete a user.
After login, the main menu is shown with the options for the respective profile.
Main menu option 'Create, update or disable user'
After pressing the button 'View', a table is shown with all user.
To reset the Password, press 'Reset'. The password is than reset to the standard password.
After pressing the button 'Edit', the respective user can be updated.
Profile 'User'
The user can
see pictures
see and download detailed datasheets and pictures
The respective menus are shown below:
When selecting 'Pictures' and pressing "View", the following view will open:
Here you can easily navigate through the images, which are stored in the database.
When selecting 'Data' and pressing "View", the following view will open:
Profile 'Admin'
The admin can
update the database and upload datasheets and pictures.
The respective menu is shown below:
When selecting 'Benchmark data' and pressing 'Update', the following view will open:
To update a row, press "Edit" and the updates can be done.
This can be done either line by line (press 'Edit' on the right side of a row) - recommended or by update the complete table (press 'Edit' on the top of the table) - only recommended for experienced user.
