Database How 
Author: Jann M. S.
Visited 722,
Followers 2,
Shared 0
Website X5 pro says database integration.
I have a large ammount of data in excel, is it possible to create a database in Pro version, where assigned members can add data.
This data can be immediately read in predefined tables on the website, or must be updated so that it is all visual immediately
there is nowhere in help or tutorials that describe this. There is nothing at all about the database part itself and its function
Jann
Posted on the
But where did you read about this integration ? I am afraid you have misinterpreted.
There is no explanation because the integration with the DB is ONLY for some e-commerce features, for user registration, and for other features like "comments on db" , "mail-form on db" and statistics.
There is a "DBViewer" object that allows you to minimally interact with a DB MYSQL,
https://market.websitex5.com/it/oggetti/anteprima/371262fa-27c5-421a-9127-852da219d4
for all the rest you have to do everything by programming code.
Editing the data by users is very tricky, but if you want to do it, you could convert the excel file to CSV file and then import it via PHPMyadmin to MYSQL DB and use DBViewer to edit it.
Or use Google Sheets directly.
What Claudio suggests with GoogleSheet is a good and easy solution. You can set up people to have acces to the Google-account, so they can edit the sheet or sheets. And Google provides code to insert in a html-object on a X5 page.
The most powerful and flexible solution is a real database.
It requires some skills, like building websites does.
For web-building there is tools like X5 that makes it simple for almost everybody.
For database-solutions there is tools like AppGini https://bigprof.com/appgini/
It is easy to use and you can build even complex solutions without coding.
When the need is only one table, you should be able to make a solution in few hours - without any (or very little) knowledge in building databases.
With one table I guess that no coding should be needed.
You can specify access for different groups (create, edit, delete records) for different tables.
The AppGini is not free, but it has a very low price compared to othe database tools.
An old and simple example: http://www.eksempelsite.dk/side-4.html
It is a one-table solution integrated in X5 via an iframe.
Read about it and the try it (one month) - there is money-back guarantee.
Here another example on how to read db data
https://wsx5demo.afsoftware.fr/database.php
@Axel - specific users should be able to edit data - not only read.
@John,
You can configure that into scripts
@Axel - there seem not to be a login-function, so it will be for all. And when I tried to use edit or delete, an error was reported.
But if you can specify user access and you can specify which rights (create, edit, delete) users or user-groups have, then I think the scripts is really fine.
Look at here. Very powerful. Used into my demo.
https://www.gurusistemas.com/index.php
User acces can be done through WSX5 with private page and login/password configured.
Edit and delete does not works into the demo to avoid to destroy the DB
@Axel - It is indeed a powerful app. And highly configurable.
But using a private page is not enough for security. The page (the php-page used in the iframe) is not secured and could be found. And then used "directly".
But it should be possible to implement a secure-code in the script. Then the script could be "called" with the secure code as parameter. As the iframe definition is made on a secured php-page that should function.
I still recommend the "real" database solution that can be made with AppGini.
I know this is something that must be paid for, but it manages the problem with users and passwords in a secure way.
And it might end up to be easier to use, than make changes in a script.
@Jann M. S.- I suggest you try out some solutions and then make your desicision.
Let us know what you find is the solution for you.