Multisites with a central DB

This thread is resolved. Here is a description of the problem and solution.

Problem:

Is it possible to have toolset pulling data from an external location/DB?

Solution:

As a workaround, you can consider HTML iframe tag, for example:

https://toolset.com/forums/topic/multisites-with-a-central-db/#post-1284747

Relevant Documentation:

https://www.w3schools.com/tags/tag_iframe.asp

This support ticket is created 5 years, 7 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Tagged: Views, Views plugin

This topic contains 2 replies, has 2 voices.

Last updated by philippeS-4 5 years, 7 months ago.

Assisted by: Luo Yang.

Author

Posts

July 5, 2019 at 9:03 am #1284711

philippeS-4

Hi Luo,

I hope you are well, my company organises different conference every year and I have to redo our website which was done by another company. Basically we have 8 different websites , one for each conferences which have the same look and feel.

I have been testing/working on our sponsor and programme page which you have helped me in the last few weeks.

hidden link
hidden link

The issue I am facing is how do I manage my sponsor/speaker and so on data from a single location and not on every site? Is it possible to have toolset pulling data from an external location/DB? Would WP multisite be the answer in this situation and would toolset from a conference site be able to retrieve the data from a "management site" where I would enter all my sponsors and only assign the one I need for a specific conference.

The other way I am thinking is to build an external DB let say in FileMaker or else, and then generate a CSV file with the sponsor content for a conference. Here again not ideal if we consider that the we almost have daily changes on the sponsor list and multiply this by 8.

Unless toolset is not the right approach and I need to start thinking about mysql, which I have no experience and certainly going to require a steep learning curve.

I realise this out of Toolset support scope somehow and I would like your view on how this could be done using Toolset.

Thanks for you continuous effort.
Phil

July 5, 2019 at 9:39 am #1284747

Luo Yang

Dear Phil,

There isn't such kind of built-in feature within Toolset plugins:
have toolset pulling data from an external location/DB

As a workaround, you can consider HTML iframe tag, for example:
1) In the original data website, create a page, display only the sponsor/speaker, without header, footer or sidebars.
2) In other website, use HTML iframe tag to display above page, see document:
hidden link

July 5, 2019 at 9:52 am #1284755

philippeS-4

My issue is resolved now. Thank you!