is it possible, to show only rows of a data table, which belongs to a wordpress user?
My data table have a column "username" with a string. In my wordpress installation i have also a user with the same string. Now i want to display only these data rows, which content the username string.
I want to use only one data table, which import a csv file or maybe as alternative a msql query.
yes, you understand me right. But the users should only see their entries, i don't editing possible.
Another problem is the source. I can get only a csv file from my client, which will uploaded every day on webspace. My table should import this file automatically. I understand it, that this is not possible with manually tables. It only works with linked files? Is this right?
You can then hide the edit button with the CSS so in that case they can not edit the file.
My suggestion is to enable Edit popup buttons and then use css to hide them. More information on this link.
Other question:
Yes, only linked files can be changed automatically and only if there are changes like adding more data ( rows) if someone adds new column or change the name of the already created column this can cause issues.
thanks for your advice. The css workaround only works with edit and new button, the delete button ist still there with this code:
.DTTT_button_delete {
display: none !important;
}
Any idea?
The manual datatable generate a table in the mysql database. Maybe it could be a solution, to make a sql dump import to this table and overwrite the inserts. For automation a cronjob with the mysql code for the dump could be the solution?
Can you please send me the link of that table so I can take a look.
When you create a manual table that table is saved in the database with all of the columns and data. The only way to overwrite that data is to manually change it in the database.
Hello,
is it possible, to show only rows of a data table, which belongs to a wordpress user?
My data table have a column "username" with a string. In my wordpress installation i have also a user with the same string. Now i want to display only these data rows, which content the username string.
I want to use only one data table, which import a csv file or maybe as alternative a msql query.
I don't find a solution until now :(
Hi markuszellner,
Thank you for your purchase.
As I understand you want to limit the users so they can only see and edit their own data.
If that is the case you can take a look at our documentation.
Hope this can help you out and correct me if I did not understand you correctly.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bodgan,
yes, you understand me right. But the users should only see their entries, i don't editing possible.
Another problem is the source. I can get only a csv file from my client, which will uploaded every day on webspace. My table should import this file automatically. I understand it, that this is not possible with manually tables. It only works with linked files? Is this right?
HI markuszellnerm
You can then hide the edit button with the CSS so in that case they can not edit the file.
My suggestion is to enable Edit popup buttons and then use css to hide them. More information on this link.
Other question:
Yes, only linked files can be changed automatically and only if there are changes like adding more data ( rows) if someone adds new column or change the name of the already created column this can cause issues.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan,
thanks for your advice. The css workaround only works with edit and new button, the delete button ist still there with this code:
Any idea?
The manual datatable generate a table in the mysql database. Maybe it could be a solution, to make a sql dump import to this table and overwrite the inserts. For automation a cronjob with the mysql code for the dump could be the solution?
Hi markuszellner,
Can you please send me the link of that table so I can take a look.
When you create a manual table that table is saved in the database with all of the columns and data. The only way to overwrite that data is to manually change it in the database.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Bogdan,
i found now a solution for all.
I can dump directly with a php script a new csv file in the database table.
Also i found a way to hide the delete button. Thanks for help.
HI markuszellner,
Glad to hear that you found a solution, good job.
I will note this in case someone else have a same request and also test it out with my team.
If you have any more questions feel free to open a new ticket, we will gladly help.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables