External Source updating directly the MySQL DB

Hi,

Thanks for contacting us here about this extension.

If I create a new table with this component, can I after connect the DB to be updated automatically from an external source?
Will the component create a table in the DB that I can update directly form this external source?

The data is coming from our CRM and we will do the job that update the MySQL tables obviously, I only need to confirm if this is possible.

Sorry, which plugin do you mean here? But this feature is not possible on both WordPress and Joomla platform.
Our plugin can sync with Google Sheets currently.

Hope it helps!
Cheers,

in the demo about Excel and Google Sheets Import/Export/Synchronization you paste a URL for the Google sync, this is my question:
The URL can be a private URL (I.P.) where I post my excel data? this can be the solution to me since the local job can export the data in a excel format to a location in our local server, then I get that URL and paste it in the field and ready to rock right?

Using only excel, no Google.

Thank you for your help.

Hi,
Thanks for getting back to me with more information.

in the demo about Excel and Google Sheets Import/Export/Synchronization you paste a URL for the Google sync, this is my question:
The URL can be a private URL (I.P.) where I post my excel data? this can be the solution to me since the local job can export the data in a excel format to a location in our local server, then I get that URL and paste it in the field and ready to rock right?

Using only excel, no Google.

Sorry, do you mean Droptables or WP Table Manager? I suppose, it's WP Table manager plugin.

The url from Google sheets is public link. After fetching data from Google sheets, you can export the table.
If you do not want everyone see your Google sheet url, you can set the visibility for posts/pages.

You can see the export option here:
https://www.joomunited.com/wordpress-documentation/wp-table-manager/260-wp-table-manager-common-use#toc-5-excel-and-spreadsheet-import-export

Thanks a lot!
Cheers,

Hello, no, I want to use DropTables for Joomla.
Does the sync work with any URL or has to be Google sheets mandatory?

Hi,

Thanks for your reponse.

Does the sync work with any URL or has to be Google sheets mandatory?

No, our Droptables can work with the Google Sheets url only.

Hope it helps!
Cheers,