rswebmaster

Hi Peter, I am using the latest version of the plugin (3.0.0).
Thanks for the suggestion on the website link I am going to apply it.

What I would like to do is to publish all the fields (included ones in the modal window) in the same table with each column auto-sized based on its content. For example “Solidale” could have half size based on its content.

If I do this now, the table becomes unreadable due to the overlap between fields (see overlapping2 attachment). Right now it already happens on some rows with the column “Gara” and “Solidale” (see overlapping attachment).

The table looks worst if I browse it via mobile web browser.

you can find pictures here:
https://www.runalltogether.eu/zra2_mobile/
https://www.runalltogether.eu/zra2_overlapping/
https://www.runalltogether.eu/zra2_overlapping2/
https://www.runalltogether.eu/zra2_publisher_settings/

Regards
R

Hi Peter,
I have tried to use table option as you suggested and works fine using the Test Pubblication button.
While in the public page do not use this option as you can see here Calendario 2020 – https://www.runalltogether.eu/calendario-2020/
Any idea or suggestion how to fix it?

Regards
R

Thanks for the answer.
I have removed the checkboxes from settings. Now works.

May I ask you an additional parameter for configuring the DataTable?
The auto-width property value in order to have the cells dimensioned on its content otherwise there is an overlapping between columns in case of long text.

Regards
R

Hi Peter,
thanks very much for your quick reaction.

Just a couple of points:
– With the new plugin version is no more possible to modify the publisher data. Could you please check it?
– It also good to have the possibility to delete the publisher item (new enhancement).

Thanks in advance

Regards
Raf

Hi Peter,
I try to explain better what I mean.

I am managing a sports association and its subscribers, thanks to your plug-in.
So I have created a project called “RUN ALL2gether” that appear in the menu with a Manage subscriber menu item (Gestione soci in Italian).
Clicking on this menu item, a page to manage the subscriber appear.
The content of the related table will be displayed. From this page, I can Add New subscriber or edit the existing ones.

In this page, there is an action list that gives me the possibility to export all the table or any lines. But this creates an SQL insert statement.
This works fine for me that I have db skills, other contributors who can access this page would be independent to download data (only what displayed) in an Excel file.

Here, for my point of view, could be more helpful to have the export to Excel.

Menu screenshot – https://www.runalltogether.eu/wp-content/uploads/2019/05/RUNALL2gether_menu.png
Page screenshot – https://www.runalltogether.eu/wp-content/uploads/2019/05/RUNALL2gether_subscriber_lapge.png
Action list screenshot – https://www.runalltogether.eu/wp-content/uploads/2019/05/RUNALL2gether_action_list.png

Hi Peter
Thanks for your prompt reaction.
It is a very useful enhancement but could be also more productive to have this export also in the project pages exporting, for example, what listed in those pages.

Regards
R

Yes thanks your suggestion I was able to create the listbox.

Sorry for the offtopic, where should I log suggestions/enhancement for future versions?

Regards
R

Thank you Peter.
Very exhaustive answer.

Regards
R

Hi Peter,
unfortunately, I cannot update the MySQL version of my hosting.
I will try to create the table as you suggested.
Thanks for your support

Regards
R

Hi Peter,
running the script in the mySQL interface of my hosting (Aruba), I received the error message shown in the picture. I hope it helps.

https://www.runalltogether.eu/wp-content/uploads/2019/04/WP_DATA_ACCESS_import_error_SQL.png

Without the Primary key I am to create the table. Now I have deleted it.

Regards
R

Hi Peter,
I have created a blank .sql file format and copied and pasted your script.
When trying to import from Data Explorer section I receive the following error.
https://www.runalltogether.eu/wp-content/uploads/2019/04/WP_DATA_ACCESS_import_error-1.png
Could you please send the script file?

Regards
R

Hi Peter,
all the other table you listed were found, the only one not found is the wp261_wpda_menu_items table and its triggers as already mentioned.

Below some pictures, I hope it helps
https://www.runalltogether.eu/wp-content/uploads/2019/04/WP_DATA_ACCESS_err.png
https://www.runalltogether.eu/wp-content/uploads/2019/04/WP_DATA_ACCESS.png

I have tried to re-create the repository several times but there is always this issue.

Regards
R

Hi Peter,
the table wp261_wpda_menu_items is not found and two its triggers wp261_wpda_menu_items_before_insert and wp261_wpda_menu_items_before_update have not found.

I see only the button “Recreate WP Data Access repository”.
I have tried to re-create the repository several times but there is always an issue.

Regards
R