I have an Excel Table stored in Microsoft Teams and would like to access that table in wpDataTables. I can export the table to WordPress and access the table from Media. However, the spreadsheet is updated by others, so I would like to access the table directly. I can share the spreadsheet and have a live link showing the whole table. When I try to use the same share address in wpDataTables, I get an error saying that it is a wrong format. I would like to have several views of the data and the formatting of wpDataTables.
The first issue is to be able to access the spreadsheet in Teams.
This is an update on my previous request.
As mentioned, I can update the Excel file by importing it to the Media; however, this is a step that I am trying to avoid.
I am sorry to disappoint you, but with the current plugin capabilities,
in order for wpDataTables to access this file, the path to this file needs to end with the file extension,
so it needs to be publically accessible, and for the URL to end with ... .xls or .xlsx or .ods;
basically, any Excel extension needs to be at the end of the URL path, then our plugin can access and recognise the file format.
I think there is no way currently to access it if it is directly stored on Teams - but you can try, if you can find any way to get the URL path to the file to end with the Excel extension, it might work.
I am surprised that TMS does not provide access to Excel tables stored in Teams, given their proclaimed consideration that Excel is very important to them. I can access Excel on Teams by using the shared address - it would seem that TMS would be able to make this work as well.
My alternative seems to be to upload the Excel file to the Media folder in WordPress. This means that the spreadsheet would have to be reloaded every time there was a change to the data in the table. This would mean that the wpDataTable would have to be recreated every time the base table data was changed. In a paid environment, this would be fine; in a volunteer position, such as mine, it is a considerable workload.
I do like wpDataTables, but am finding that it is like may other WordPress plugins - it does not provide a whole solution.
Perhaps there are others who would like to see this type of integration - would certainly be a positive option.
I'll make sure to forward it to our developers, but at this time, it has to work as mentioned in my previous response.
Please feel free to add this to our feature suggestions page as they go directly to our developers.
On a side note - If you edit the Excel sheet, the wpDataTable generated from it would also load that new data, as long as the path to the file and it's structure doesn't change.
Thanks for getting back to me. Your comment about modifying an Excel table and having the change propagate to wpDataTables is exactly what I am trying to achieve.
I have sent a message to the feature suggestion page.
As a test, I created an Excel file and saved it to my computer (actually on OneDrive but linked to my computer). I was able to get a URL that ended with .XLSX and provided it to wpDataTables. When I saved, I got a message saying "File from provided URL is empty". It appears that wpDataTables is not working. Please give me some ideas.
It would be useful for you send me a description of a set of files that works - tell me the file names and domains involved.
As a backup plan, I copied the Excel file to the Media folder in WordPress and was able to create the proper wpDataTable. However, when I wanted to update the data: I could not update via the original table; I could not copy the Excel file to WordPress because a duplicate file is rejected.
There must be something that I am doing wrong - it should not be this difficult!
1. Thank you for the suggestion, we will do our best to work on it in the future.
2. Can you send me a URL to that file that says "File from provided URL is empty", then we can try to make a table from it on our Test site to reproduce the error?
Is this file accessible online, publically - it is not password protected or something like that?
3. When you say that the file is actually on OneDrive but linked to your computer, could you elaborate on that?
If the actual file is on Microsoft One Drive, unfortunately, our plugin can not currently work with a file source from there.
But if you can send us this URL that ends in the file extension, i am curious to do some testing if that's OK with you?
It might help with future plugin improvements so that we can see the behaviour for this use-case.
If the link or the file are confidential, please set the reply as PRIVATE, for security purposes, so that only we can see it.
4. I am sorry, but i don't understand what you mean by description/ set of files that work, file names and domains involved.
Basically, the file needs to be accessible,
if the access to the path does not need any log in/password, then our plugin should be able to access it - and the path should end in the file extension, that should be all.
Also, the file needs to have at least one row of data - it can not be empty, otherwise our plugin can't generate a table.
And also, there can be some formatting issues, it is best to keep all data in the source Excel as "Plain text/unformatted".
But, as mentioned, i am not 100% sure, i think it is not possible to have a file stored on Microsoft One Drive and to use it linked like that, as far as i am aware, we will double-check that.
-
5. 'I copied the Excel file to the Media folder in WordPress and was able to create the proper wpDataTable. However, when I wanted to update the data: I could not update via the original table;
I could not copy the Excel file to WordPress because a duplicate file is rejected.'
-
Yes. This is a limitation coming from the WordPress Media Library functionality,
basically you would usually have to rename the files so that it lets you overwrite them;
it is not an issue coming from our plugin, but i can help you.
Thanks for the feedback - I will reconstruct the environment and send you some details ... it may take a while, as I have several activities underway. The website is a volunteer task, so I can devote only part time to it.
I have an Excel Table stored in Microsoft Teams and would like to access that table in wpDataTables. I can export the table to WordPress and access the table from Media. However, the spreadsheet is updated by others, so I would like to access the table directly. I can share the spreadsheet and have a live link showing the whole table. When I try to use the same share address in wpDataTables, I get an error saying that it is a wrong format. I would like to have several views of the data and the formatting of wpDataTables.
The first issue is to be able to access the spreadsheet in Teams.
This is an update on my previous request.
As mentioned, I can update the Excel file by importing it to the Media; however, this is a step that I am trying to avoid.
Currently using 5.1
Hi, Jack
Sorry for the delay.
I am sorry to disappoint you, but with the current plugin capabilities,
in order for wpDataTables to access this file, the path to this file needs to end with the file extension,
so it needs to be publically accessible, and for the URL to end with ... .xls or .xlsx or .ods;
basically, any Excel extension needs to be at the end of the URL path, then our plugin can access and recognise the file format.
I think there is no way currently to access it if it is directly stored on Teams - but you can try, if you can find any way to get the URL path to the file to end with the Excel extension, it might work.
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
Good evening
I am surprised that TMS does not provide access to Excel tables stored in Teams, given their proclaimed consideration that Excel is very important to them. I can access Excel on Teams by using the shared address - it would seem that TMS would be able to make this work as well.
My alternative seems to be to upload the Excel file to the Media folder in WordPress. This means that the spreadsheet would have to be reloaded every time there was a change to the data in the table. This would mean that the wpDataTable would have to be recreated every time the base table data was changed. In a paid environment, this would be fine; in a volunteer position, such as mine, it is a considerable workload.
I do like wpDataTables, but am finding that it is like may other WordPress plugins - it does not provide a whole solution.
Perhaps there are others who would like to see this type of integration - would certainly be a positive option.
Please let me know if you see any other options.
Jack
Thank you for your feedback, Jack.
I'll make sure to forward it to our developers, but at this time, it has to work as mentioned in my previous response.
Please feel free to add this to our feature suggestions page as they go directly to our developers.
On a side note - If you edit the Excel sheet, the wpDataTable generated from it would also load that new data, as long as the path to the file and it's structure doesn't change.
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
Miloš
Thanks for getting back to me. Your comment about modifying an Excel table and having the change propagate to wpDataTables is exactly what I am trying to achieve.
I have sent a message to the feature suggestion page.
As a test, I created an Excel file and saved it to my computer (actually on OneDrive but linked to my computer). I was able to get a URL that ended with .XLSX and provided it to wpDataTables. When I saved, I got a message saying "File from provided URL is empty". It appears that wpDataTables is not working. Please give me some ideas.
It would be useful for you send me a description of a set of files that works - tell me the file names and domains involved.
As a backup plan, I copied the Excel file to the Media folder in WordPress and was able to create the proper wpDataTable. However, when I wanted to update the data: I could not update via the original table; I could not copy the Excel file to WordPress because a duplicate file is rejected.
There must be something that I am doing wrong - it should not be this difficult!
Thanks for your help.
Jack
Hi, Jack.
Sorry for the delay.
We had a break over the weekend as well.
-
1. Thank you for the suggestion, we will do our best to work on it in the future.
2. Can you send me a URL to that file that says "File from provided URL is empty", then we can try to make a table from it on our Test site to reproduce the error?
Is this file accessible online, publically - it is not password protected or something like that?
3. When you say that the file is actually on OneDrive but linked to your computer, could you elaborate on that?
If the actual file is on Microsoft One Drive, unfortunately, our plugin can not currently work with a file source from there.
But if you can send us this URL that ends in the file extension, i am curious to do some testing if that's OK with you?
It might help with future plugin improvements so that we can see the behaviour for this use-case.
If the link or the file are confidential, please set the reply as PRIVATE, for security purposes, so that only we can see it.
4. I am sorry, but i don't understand what you mean by description/ set of files that work, file names and domains involved.
Basically, the file needs to be accessible,
if the access to the path does not need any log in/password, then our plugin should be able to access it - and the path should end in the file extension, that should be all.
Also, the file needs to have at least one row of data - it can not be empty, otherwise our plugin can't generate a table.
And also, there can be some formatting issues, it is best to keep all data in the source Excel as "Plain text/unformatted".
But, as mentioned, i am not 100% sure, i think it is not possible to have a file stored on Microsoft One Drive and to use it linked like that, as far as i am aware, we will double-check that.
-
5. 'I copied the Excel file to the Media folder in WordPress and was able to create the proper wpDataTable. However, when I wanted to update the data: I could not update via the original table;
I could not copy the Excel file to WordPress because a duplicate file is rejected.'
-
Yes. This is a limitation coming from the WordPress Media Library functionality,
basically you would usually have to rename the files so that it lets you overwrite them;
it is not an issue coming from our plugin, but i can help you.
Here is a useful article that shows How to Easily Replace Image and Media Files in WordPress.
Let me know if that helps.
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
Thanks for the feedback - I will reconstruct the environment and send you some details ... it may take a while, as I have several activities underway. The website is a volunteer task, so I can devote only part time to it.
Jack
Hi, Jack.
No problem at all, we will be on stand-by, you can take your time, and you can reply when you get all the details ready.
Even it the ticket auto-closes after 7 days, you can still write on it, and your reply will come up to my attention,
we will make sure to follow it.
Thank you.
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