a) we chose german as interface-language, but nothing happend in this direction … what is else to do, to get the german language interface? There some people in our team, that are not multilingiual.
b) We created a table this way:
Create a table by importing data from data source.
this works well … BUT … several columns should not show up on frontpage. We did this with the settings for this behalf.
In exel-style view we also see this columns but we are not able to etit them for internal purpose anymore. Only the official visible columns are editable. We are also not able to get them back to show up tem as official columns (for editing) … is that a Bug or is tehre any unknown trick to get this columns editable.
I'm sorry to disappoint you, but unfortunately we do not yet have German translation for wpDataTables. I'm sending you the language folder, but someone translated only 7%. We're waiting for one of our customers to send us the complete translation. We don't have any translators in our company, so we can only rely on our customers to send us the translations.
To include this translation in wpDataTables, you need to unzip the folder in ../wp-content/plugins/wpdatatables/languages/. The .po and .mo files should be in de_DE folder, and when you change the language to German, you will also need to translate WordPress in order for it to work.
As for importing the table from a data source - could you, please, send me the file used for table creation, so I can test it locally? If it contains sensitive data, please make sure to enable "Private" reply, so it is visible only to us.
did you get the file? I think a have to work on the translation. I try to complete that within the next two weeks for own purpose, but you can get it when it is complete.
Now, first thing I noticed when I imported your file is that there are 22 empty columns that are being imported as well. So, when you go to import the file, and get to the column selection screen just delete all columns with empty headers (after "Kommentar zum Versender" column).
My Excel date format is not the same as in wpDataTables, so I had to change all "date" columns to "string" in the column selection screen, for it to display correctly. I don't know how dates behave on your end, but you may not need to go through this.
Now, the plugin's logic works as you were able to see - hidden columns cannot be edited in any way. Not from Standard, nor from Excel-like editor.
Since you imported the table, there's a workaround for this. When the table is generated, it is saved in the database. You can see what its database name is by enabling Editing above the table:
You can use that name to create an SQL Query based table which would pull only those 4 columns from the original table, and then you can use that table to show on front-end. Query would look like this:
SELECT plz,
ort,
zusdat,
status
FROM wp_wpdatatable_17
So, now you would have the original table, imported from an Excel file where you can see all columns. And the second table can be used for public.
Unfortunately, I didn't see you answer until today. I didn't get a mail about the new addition.
I know all the points you described, including the empty columns I deleted during the import.
Then let's tackle the real problem:
I need a database where I can edit both the visible and the hidden data. If this is not the case, we have to collect the data very laboriously in the team and maintain it in a complicated way. The intention was to realize exactly that with this tool, so that we would not get redundant data. But unfortunately we need visible and invisible elements in our table, which have to be processed to fulfill the purpose.
Question: How can this be realized with your tool? If this is not possible, what ideas do you have to make it possible? Do you have any tools that allow an uncomplicated editing of the SQL database?
I'm not happy with the current solution yet and can imagine that some customers will feel the same way. What is the real problem that the invisible data cannot be changed? Isn't that just a setting thing within wpDataTables?
Unfortunately I'm still travelling in the meantime, but I'll get back to it soon.
I'm sorry, I red inattentively. Yes, that could be a way, with the seperate query of the table. I'll try it over the weekend and get back to you to report if it works for us.
a) we chose german as interface-language, but nothing happend in this direction … what is else to do, to get the german language interface? There some people in our team, that are not multilingiual.
Create a table by importing data from data source.b) We created a table this way:
this works well … BUT … several columns should not show up on frontpage. We did this with the settings for this behalf.
In exel-style view we also see this columns but we are not able to etit them for internal purpose anymore. Only the official visible columns are editable. We are also not able to get them back to show up tem as official columns (for editing) … is that a Bug or is tehre any unknown trick to get this columns editable.
Hello Wilfried.
Thank you for your purchase.
I'm sorry to disappoint you, but unfortunately we do not yet have German translation for wpDataTables. I'm sending you the language folder, but someone translated only 7%. We're waiting for one of our customers to send us the complete translation. We don't have any translators in our company, so we can only rely on our customers to send us the translations.
To include this translation in wpDataTables, you need to unzip the folder in ../wp-content/plugins/wpdatatables/languages/. The .po and .mo files should be in de_DE folder, and when you change the language to German, you will also need to translate WordPress in order for it to work.
As for importing the table from a data source - could you, please, send me the file used for table creation, so I can test it locally? If it contains sensitive data, please make sure to enable "Private" reply, so it is visible only to us.
Kind Regards,
Aleksandar Vuković
[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
Hello again Wilfried.
Unfortunately, we don't have an official translation project, so editing the .po files and sending them back to us is the only way at the moment.
You can send me the file to: [email protected]
Kind Regards,
Aleksandar Vuković
[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
Hello Aleksandar,
did you get the file?
I think a have to work on the translation.
I try to complete that within the next two weeks for own purpose, but you can get it when it is complete.
Wilfried
Hello Wilfried.
Thanks, I got the file.
Now, first thing I noticed when I imported your file is that there are 22 empty columns that are being imported as well. So, when you go to import the file, and get to the column selection screen just delete all columns with empty headers (after "Kommentar zum Versender" column).
My Excel date format is not the same as in wpDataTables, so I had to change all "date" columns to "string" in the column selection screen, for it to display correctly. I don't know how dates behave on your end, but you may not need to go through this.
Now, the plugin's logic works as you were able to see - hidden columns cannot be edited in any way. Not from Standard, nor from Excel-like editor.
Since you imported the table, there's a workaround for this. When the table is generated, it is saved in the database. You can see what its database name is by enabling Editing above the table:
You can use that name to create an SQL Query based table which would pull only those 4 columns from the original table, and then you can use that table to show on front-end. Query would look like this:
SELECT plz, ort, zusdat, status FROM wp_wpdatatable_17So, now you would have the original table, imported from an Excel file where you can see all columns. And the second table can be used for public.
Kind Regards,
Aleksandar Vuković
[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
Hello Aleksandar,
Unfortunately, I didn't see you answer until today.
I didn't get a mail about the new addition.
I know all the points you described, including the empty columns I deleted during the import.
Then let's tackle the real problem:
I need a database where I can edit both the visible and the hidden data.
If this is not the case, we have to collect the data very laboriously in the team and maintain it in a complicated way. The intention was to realize exactly that with this tool, so that we would not get redundant data. But unfortunately we need visible and invisible elements in our table, which have to be processed to fulfill the purpose.
Question: How can this be realized with your tool?
If this is not possible, what ideas do you have to make it possible?
Do you have any tools that allow an uncomplicated editing of the SQL database?
I'm not happy with the current solution yet and can imagine that some customers will feel the same way. What is the real problem that the invisible data cannot be changed? Isn't that just a setting thing within wpDataTables?
Unfortunately I'm still travelling in the meantime, but I'll get back to it soon.
Best regards
Wilfried
Hello, Aleksandar,
I'm sorry, I red inattentively.
Yes, that could be a way, with the seperate query of the table.
I'll try it over the weekend and get back to you to report if it works for us.
Best regards
Wilfried
No worries, Wilfried.
Please give it a shot, and let me know how it goes.
Kind Regards,
Aleksandar Vuković
[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