Database function in the bluetronix CMS – manage, edit, and export articles
In this tutorial, you will learn how to efficiently manage, edit, and export articles using the database function in bluetronix CMS. Even large amounts of data can be easily structured, searched, and automatically backed up.
Introduction to the database function
In this tutorial, you will learn how to work with the database function. In edit mode, you can open the database table in the display view using the blue database icon. There, you can see all the articles and edit or duplicate them if needed, in order to quickly create similar articles.
Working in record view
In the record view, you can specifically search for certain criteria, sort records, and decide how many articles to display at once. To switch to record view, click on the desired article and select Edit record or Edit at the bottom. You can enlarge the window for better visibility.
Edit articles and add content
In record view, you can write longer texts for individual articles, have them revised by AI, or generate them automatically. Additionally, you can swap images and add extra detail images. You can switch between records and continue editing immediately.
Use quick editing
You can also adjust articles using the quick edit button. A click on Edit immediately opens the record view, where you can specifically make changes to an article.
Access databases via the main menu
You can also access your database tables via the main menu. Click on Database ⯈ Database for Tables. In the lower area, you will find all available tables, such as your blog or shop database.
Understand view and edit mode
The display view is suitable for browsing and sorting records, but changes cannot be made directly there. In the edit view, you will see a tabular representation – similar to Excel – and can change data directly or add new articles.
Excel export and import
Records can be easily exported. Select your shop table and export it as a TXT or CSV file. You can edit this file in Excel and then import it back. During import, you decide whether to replace existing records or to add new articles.
Efficiently manage large volumes of data
By default, 50 records are displayed per page. If your shop contains more items, you can call up more pages via the page navigation at the top. This way, you can efficiently edit even very large datasets with several million articles.
Execute your own MySQL commands
For developers, there is an advanced option to execute their own MySQL commands directly. Further information can be found in the video MySQL Records for Developers.
Automatic backup and recovery
All databases are automatically backed up seven days a week. If an error occurs during export or import, you can always restore a backup – for example, to reset the shop table to yesterday's state.
Tip: Regularly back up your database, especially before major changes or imports.
Conclusion
The database system is designed to be simple and efficient – similar to an Excel table. Even without prior knowledge, you can search, edit, export, and import data. Even large inventories can be organized and managed reliably in this way.
FAQ
what customers often ask us
How do I open the database table in editing mode?
In editing mode, you can open the database table via the blue database icon in the display view. There you can see all the items in your shop and edit or duplicate them directly if you want to create similar items.
How does the record view work?
In the record view, you can search by specific criteria, sort records, determine the number of displayed records, and edit each item individually. To do this, click on the desired item and select Edit Record or Edit at the bottom.
What can I edit in the record view?
In this view, you can write descriptions, improve or generate text using AI, swap images or add additional detail images. You can switch between records and continue your editing without leaving the view.
How do I use quick editing?
Using the Quick Edit button, you can adjust items directly. Clicking on Edit opens the record view, where you can make changes to individual items.
How do I access the database through the main menu?
You can also access your databases through the main menu: Click on Database ⯈ Table Database. Your available tables will be displayed below, such as Blog or Shop.
What is the difference between display view and editing view?
In display view, you can view, search, and sort records, but you cannot make changes. In editing view, you see a tabular representation – similar to Excel – and can directly adjust entries there.
Can I export and re-import records?
Yes. You can export your shop table as a TXT or CSV file, edit it in programs like Excel, and then re-import it. During import, you decide whether to replace existing records or add new items.
How many records can I display at once?
By default, 50 records are displayed per page. If you have more items, you can navigate to additional pages using the page navigation at the top. This way, you can efficiently manage large inventories with millions of records.
Can I run my own MySQL commands?
Yes, there is an additional option for developers to run their own MySQL commands directly. You can find more details in the video MySQL Records for Developers.
How are my databases secured?
All databases are automatically backed up daily. If an error occurs during export or import, you can restore a backup at any time – for example, to reset your shop table to yesterday's state.
What makes the database system so easy?
The system works similarly to an Excel spreadsheet. You can easily manage, search, edit data, and even import existing item lists from other programs. This gives you full control over your shop data without needing programming skills.