So everything was working fine. I would make a finally test, so i created a new spreadsheet with different data connected to an user id.
What i did:
I go to Admin Tabel (Manual), and uploaded the new data entry, and replaced the entire table with the new data.
That's worked well, no problems here.
But when i went to the client table it showed me No Data.
Next is the edit function, and new entry function is gone from the admin table.
So now it dosent show the data on the client view from the AdminTable (CSV), and i can't edit the data from the admin table, but now i can edit, and delete from the client table (SQL)
Everything was working correct until i replaced all the data in admin table.
yes i resolved the problem with the edit function.
Just disabled the function, so its now showing the edit and delete function on top of the table. Would just be nice to have both function on adin table. Mouse over editing function, and editing function over the table.
Anyway. We can live with that, if its not possible to have both function on the admin table at the same time.
And second issue.
Yes resolved the problem by creating a new table, simply copy the query, and thats it. It works, and show the needed data.
But still dont understand why the ''old'' client table stop showing data after replace the entire admin table.
I mean, it would be great to solve the issue, as we gonna upload new data each month. Not replace, but simply update the table. Havent tried that yet..
But also when im finish, i will have to replace the entire table one time more to get all 4000 customers data into the table again.
Reason replaced the data now is because i have created test uses with fictive data to see if it works correctly.
1. Thank you for clarifying, i understand now what you mean.
You are correct, at the moment it is like this,
if you enable the Popover Editing, then the New/Edit/Delete row buttons from the top will disappear,
and just the popover will appear on row click .
-
It is currently like that, but you can make a suggestion for our developers and they will try to make a solution to allow users to select if they wish both options at same time.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
2. I am sorry, but i still don't understand what you described for this issue.
I can see on the previous screenshot, you have activated to "Limit to show rows only for current user ID"
But you have chosen both row ID and user ID as same column "wdt_ID".
The wdt_ID is the unique row ID of the Manual tables,
and for user ID you have to select another column - then this column is going to compare the rows with wp_users table from your WP database, and it checks if the current user ID is in any of the rows for selected user ID column,
it will only show those rows.
If you wish to see all rows as Admin in back-end even while limiting them for current user ID on front-end -
then check this option on the right "Show all rows in back-end":
But i don't understand the rest, when you described about copying the Query, and the details between the "old" client table and Admin table as well as new table with copied Query...
Could you please record your screen and show me all of this details,
perhaps add some screenshots and elaborate a bit more to clarify,
how are you adding the user ID values - did you add actual dummy users on your WordPress and you made a user ID column that will reference the wp_users table ID's?
Please clarify a bit more and we can help. Thank you
( Of course, if there is any sensitive data that you don't wish to share as Public, mark the reply as PRIVATE)
Hi Again.
So everything was working fine. I would make a finally test, so i created a new spreadsheet with different data connected to an user id.
What i did:
I go to Admin Tabel (Manual), and uploaded the new data entry, and replaced the entire table with the new data.
That's worked well, no problems here.
But when i went to the client table it showed me No Data.
Next is the edit function, and new entry function is gone from the admin table.
So now it dosent show the data on the client view from the AdminTable (CSV), and i can't edit the data from the admin table, but now i can edit, and delete from the client table (SQL)
Everything was working correct until i replaced all the data in admin table.
What goes wrong again??
Attached files: Screenshot from 2022-12-27 09-06-45.png
Screenshot from 2022-12-27 09-05-49.png
Screenshot from 2022-12-27 09-04-46.png
Screenshot from 2022-12-27 09-04-36.png
Screenshots of the client table
Attached files: Screenshot from 2022-12-27 09-08-58.png
Screenshot from 2022-12-27 09-09-16.png
Screenshot from 2022-12-27 09-08-14.png
Screenshot from 2022-12-27 09-08-35.png
Ofcourse - the reason why i could not see the edit buttons on the admin table was simply because i enabled ''
Popover edit block ''So now this working again..
When i look at the query it dosent display the same name as the admin table, only the userid..
But it was also like this before i uploadet new data to the table.
In the query is like
cvrnr
and
in the admin table is like cvr_nr.
In my last post where i couldnt pull data from the admin table, it was because i have written the query like
userid
cvr_number
Using _ for replace a space.
So when i removed the _, and simply written cvrnr like this, then i could pull data from the admin table.
Thats why i dont understand it
Attached files: Screenshot from 2022-12-27 11-09-28.png
Hi, kim
Thanks for reaching out to us
-
I did not fully understand, it seems that you resolved the first issue where you did not see the Editing Buttons,
now when you disabled Popover Editing, you can see the Editing buttons?
-
2. But I did not fully understand the second issue , you said :
'When i look at the query it dosent display the same name as the admin table, only the userid.. '
It seems there was some issue with the way how you wrote the SQL Query for the Client's table,
did you resolve it now, or is the issue ongoing?
If it is ongoing, can you elaborate and additionally show me some screenshots
or record a short Loom/ScreenCast video of your screen so that I can see what you mean in more details?
If there is any sensitive data, please mark the reply as PRIVATE, for safety.
Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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
yes i resolved the problem with the edit function.
Just disabled the function, so its now showing the edit and delete function on top of the table. Would just be nice to have both function on adin table. Mouse over editing function, and editing function over the table.
Anyway. We can live with that, if its not possible to have both function on the admin table at the same time.
And second issue.
Yes resolved the problem by creating a new table, simply copy the query, and thats it. It works, and show the needed data.
But still dont understand why the ''old'' client table stop showing data after replace the entire admin table.
I mean, it would be great to solve the issue, as we gonna upload new data each month. Not replace, but simply update the table. Havent tried that yet..
But also when im finish, i will have to replace the entire table one time more to get all 4000 customers data into the table again.
Reason replaced the data now is because i have created test uses with fictive data to see if it works correctly.
Hi, kim
1. Thank you for clarifying, i understand now what you mean.
You are correct, at the moment it is like this,
if you enable the Popover Editing, then the New/Edit/Delete row buttons from the top will disappear,
and just the popover will appear on row click .
-
It is currently like that, but you can make a suggestion for our developers and they will try to make a solution to allow users to select if they wish both options at same time.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
2. I am sorry, but i still don't understand what you described for this issue.
I can see on the previous screenshot, you have activated to "Limit to show rows only for current user ID"
But you have chosen both row ID and user ID as same column "wdt_ID".
The wdt_ID is the unique row ID of the Manual tables,
and for user ID you have to select another column - then this column is going to compare the rows with wp_users table from your WP database, and it checks if the current user ID is in any of the rows for selected user ID column,
it will only show those rows.
If you wish to see all rows as Admin in back-end even while limiting them for current user ID on front-end -
then check this option on the right "Show all rows in back-end":
But i don't understand the rest, when you described about copying the Query, and the details between the "old" client table and Admin table as well as new table with copied Query...
Could you please record your screen and show me all of this details,
perhaps add some screenshots and elaborate a bit more to clarify,
how are you adding the user ID values - did you add actual dummy users on your WordPress and you made a user ID column that will reference the wp_users table ID's?
Please clarify a bit more and we can help. Thank you
( Of course, if there is any sensitive data that you don't wish to share as Public, mark the reply as PRIVATE)
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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