hey, Is ıt possible to import excel data sources on the frontend? I use the ferure that allowed to each user managed his own table, but I need to allow him also to import excel table (to each user) on the frontend. how can I do it?
If you mean that users can import own excel files and build wpdatatables from front-end, unfortunately at the moment that is not possible with built in features of plugin.
Sorry but can you please explain me in little more details what you exactly need or send me some screenshot/screencast and I will gave you my suggestion.
ok, I have a site with users that managed by woocommerce. every user can create and edit his table by your wpdatatables feature, so the table and data in it will be unique for him. so i asked if is ıt possible to import excel data from the frontend, and you claimed you did not have such a possibility in the system but you said I could add it manually. So let's assume that a user uploads an Excel table to my site (uploads folder of Wordpress), how do I add the table to the user page that only this specific user can see and edit the information in it?
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
When users upload their excel files you have to manulally create wpdatatables with third option in table wizard(because those tables will be editable and you can uise option Users can see and edit own data). You have to add column userid with user id(if it does not already exist in file) like you can see in our documentation about Creating Editable Tables in WordPress where users can see and edit only their own data. Then insert shortcode on users page and only they will see data in table that can be edit. If you have a lot of users then this solution will not be the best.
There is a one more solution(more workaround) if that excel files from all users have same structure(number and names of columns are the same) you can make table id in database (via phpmyadmin) and then convert those excel files to CSV format and import those that in that table in database.(you have to add manually userid in userid column(if it does not already exist in file))
Like this when you import all files from all users in one table in database, you can make one table with query
SELECT * FROM that_table_name_with_users_data
and then use option Users can see and edit own data or with placeholder %CURRENT_USER_ID% like this
SELECT * FROM that_table_name_with_users_data WHERE userid_column = %CURRENT_USER_ID%
and like this you will have all data from users in one table and users on front will see only own data.
hey, Is ıt possible to import excel data sources on the frontend?
I use the ferure that allowed to each user managed his own table, but I need to allow him also to import excel table (to each user) on the frontend.
how can I do it?
Hi shai_malul,
Thank you for your purchase.
If you mean that users can import own excel files and build wpdatatables from front-end, unfortunately at the moment that is not possible with built in features of plugin.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
so what can I do?
the user can upload an excel file and I from the back end can fetch the excel to he wpdatatables?
some alternative pop your head?
Hi shai_malul,
When users upload excel file on your website(uploads folder of wordpress) you have to manually make table from that file in backend with our plugin.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
ok, it could work.
so can I create a specific table for a specific user?
Hi shai_malul,
Sorry but can you please explain me in little more details what you exactly need or send me some screenshot/screencast and I will gave you my suggestion.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
ok, I have a site with users that managed by woocommerce.
every user can create and edit his table by your wpdatatables feature, so the table and data in it will be unique for him.
so i asked if is ıt possible to import excel data from the frontend, and
you claimed you did not have such a possibility in the system but you said I could add it manually.
So let's assume that a user uploads an Excel table to my site (uploads folder of Wordpress), how do I add the table to the user page that only this specific user can see and edit the information in it?
Hi shai_malul,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
When users upload their excel files you have to manulally create wpdatatables with third option in table wizard(because those tables will be editable and you can uise option Users can see and edit own data). You have to add column userid with user id(if it does not already exist in file) like you can see in our documentation about Creating Editable Tables in WordPress where users can see and edit only their own data. Then insert shortcode on users page and only they will see data in table that can be edit. If you have a lot of users then this solution will not be the best.
There is a one more solution(more workaround) if that excel files from all users have same structure(number and names of columns are the same) you can make table id in database (via phpmyadmin) and then convert those excel files to CSV format and import those that in that table in database.(you have to add manually userid in userid column(if it does not already exist in file))
Like this when you import all files from all users in one table in database, you can make one table with query
SELECT * FROM that_table_name_with_users_data
and then use option Users can see and edit own data or with placeholder %CURRENT_USER_ID% like this
SELECT * FROM that_table_name_with_users_data
WHERE userid_column = %CURRENT_USER_ID%
and like this you will have all data from users in one table and users on front will see only own data.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables