Skip to main content
  Thursday, September 17 2020
  1 Replies
  1.7K Visits
  Subscribe
Hi there,

We would need a way to connect an excel file (and only specific selected cells) and automatically synchronize them with a table that would be available online, on our Wordpress website.
I understand this would be possible with WP Table Manager, but there are still few questions that need to be answered before proceeding with the demo.

Is it possible to automatically update the values in the selected cells from a specific excel file, without having to save and upload that .xls file?
Since we have the Bloomberg and ICE XL plugins in Excel (auto update the values in some specific cells according to the trading market), we would need to be sure the values that automatically update by themselves could also be automatically synchronized with that online table in wordpress, 24/7? The excel file is on a local server, always ON and available.

Also, is there a way that in the near future, you will :

1. Implement the function to create an alert when a cell reaches a specific value, and send an email to selected email contacts or even to ourselves?
2. Reduce the synchronization timing, and have it like every 1 minute? We need to update infos as accurate as possible, and 5min is a bit slow.

Thanks a lot in advance for the answers,

Chris
A
3 years ago
Hi,

Thanks for contacting us here about this extension.

Is it possible to automatically update the values in the selected cells from a specific excel file, without having to save and upload that .xls file?


Yes, you can sync your excel files on your WP server to our plugin. The sync time is set at plugin settings.

You can go here for more information:
https://www.joomunited.com/wordpress-documentation/wp-table-manager/263-wp-table-manager-excel-google-sheets-sync#toc-2-sync-a-table-with-an-excel-file-data-2

1. Implement the function to create an alert when a cell reaches a specific value, and send an email to selected email contacts or even to ourselves?
2. Reduce the synchronization timing, and have it like every 1 minute? We need to update infos as accurate as possible, and 5min is a bit slow.


1. This feature is not possible in our plugin; however, we can create hooks for your customization.

2. You can adjust the sync time to 1 min on your database or we can help you with that.
In this case, it could cause errors on your site because of the short sync time.
Please be careful and think further between your desire and reality!

Hope it helps!
Kind regards,
  • Page :
  • 1
There are no replies made for this post yet.