We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #1725984
Multisite Compatibility
Closed

Comments

  •  1
    Richard Kaplan started the conversation
    September 26, 2018 at 2:26pm

    Hi

    Is WPDataTables compatible with WordPress Multisite?

    Would it be possible for me to use WPDatatables to access data from an external MySQL database shared among multisite users, but have the WPDatables tables unique to the individual sites?

  • [deleted] replied
    September 26, 2018 at 10:59pm

    Hi Richard,
    Thank you for your inquire.

    Yes it is multisite compatible. You can either network activate it or activate it on the subsite separately. It will create a separate tables for every subsite.Also you can use our built in tools to query results from other tables in the multisite. 

  •  1
    Richard Kaplan replied
    September 27, 2018 at 1:35pm

    Thank you - that is helpful

    To clarify just a bit more - my database is extremely large (about 150 gigabytes and 30 million records).

    Does the software duplicate the entire database for each subsite?  Can it track only the differences when records are changed by a given subsite?  Or could I / should I make the main database read-only but have separate tables unique to each subsite?

  • [deleted] replied
    September 27, 2018 at 8:56pm

    Hi Richard,


     If the database is that big my best suggestion would be to use it as main database and connect to it with separate database connection option. This way all the sub-site would have access to the same data and you all the changes will be made on the same data - Documentation

    For testing purpose we have sandbox website where you can see and test all plugin functionalities

    sandbox.wpdatatables.com

    username: demo

    password: demo


  •  1
    Richard Kaplan replied
    September 27, 2018 at 9:15pm

    Thanks


    To clarify - I need the ability for each subsite to be able to have its own private comments and private edits to the data.


    In that case, do I need to clone the database for each subsite?   If so, how do I distribute new records which are to be shared by all of the sites?