Database Viewer functionality and documentation
Автор: Laszlo A.Hi Everybody!
Generally, I am satisfied with X5, except exactly the main motif I bought it: visualizing data grids. The only (for 12 credit) available component is Database Viewer which a very basic, could say primitive one. I see, for many years many users are asking for a more performant one, however, new versions are coming one after other without any change in this regard.
My main complaint with Database Viewer is the lack of documentation. Except for the few lines, you can read when you buy it, no explanation for the setting up, the options, and the error codes at least. This is very annoying because you must "explore" it before can use it. So my, first question is, who built this component, who is the author? And, since we are paying clients, why we couldn't address our questions directly to him/her, instead to waste our time digging the forum for sparse bits of useful info?
My second question is why we are still waiting for years for an X5 performant component having much more functional and customization possibilities (like Google DataTable, even DataCharts)? I am sure, many users are waiting for them, even if will cost correspondingly. I seriously plan to build myself these components.
My third (actual, concrete) problem is this: I have a website (hosted on a2hosting.com, recommended by Incomedia) where on one page want to show a data table. Succeeded to link the Database Viewer to the hosted MySQL database, imported the CSV file, it is appearing correctly on the page. But any try to edit it manually (meaning alter cells value, add or delete rows from the page) produces error messages and does not work, as you could try yourself here:
http://omniainnumero.com/self-service.php
While it is clear this is a write access problem (I am accessing the database through this page by a guest account but with all privileges), I don't know how to solve it. Hope somebody could help me.
Thank you in advance,
Laszlo
Hello Lazlo
Try look at this post : https://helpcenter.websitex5.com/ru/post/190089
It seems that your table is not quite OK.
Try creating the table manually, and then import the data. Then also create a key field ( auto increment ).
If a table has no key-field, then it cannot be edited in the database viewer, and also if you edit a record in the Mysql control panel, you will probable get a warning for every update you make.
To test the viewer, you could create a page with a mail-form. Specify that the data is to be stored in the datybase.
You give the table a name.
Then make some posts in the mail-form.
You also create a page ( or use the same page ) where, you insert the database viewer object.
You set up the databease viewer, to look in the table created by the mail-form.
This way you can test that all is functioning.
Kind regards
John S.
Автор
Hello John!
Thank you for your reply. Indeed adding a primary key to the table (in phpMyAdmin) helped. A good documentation must contain this important thing. Hopefully, the coming database viewer will handle this problem too. Thank you very much for your help.
Best regards,
Laszlo