1. Home
  2. Docs
  3. Index
  4. Data Publisher
  5. Setup and use the Data Publisher

Setup and use the Data Publisher

Setup the Data Publisher

  • Make sure the jQuery DataTables and jQuery DataTables Responsive libraries are loaded ( Settings > WP Data Access > Data Publisher)
  • Grant access to tables you want to show on your web pages (Settings > WP Data Access > Front-End)
  • You can give non admin users access to the Data Publisher as well ( Settings > WP Data Access > Data Publisher)
  • Use shortcode ‘wpdataaccess’ to add your publication to a web page (How to use shortcode ‘wpdataaccess’)

Create a publication

  • Navigate to: WP Data Access > Data Publisher
  • Select a database table (make sure you have granted access)
  • Select columns to be displayed or * to see all (use the select button to select available columns)
  • Select desired output (flat or responsive)
  • Select desired options for responsive output
  • Save publication
  • Test publication

Publish a publication

  • Copy your shortcode (click Show shortcode button)
  • Paste your shortcode into your post or page
  • Publish and test your post or page

Important

Menu item WP Data Access > Manage Plugin was moved to Settings > WP Data Access

 

Was this article helpful to you? Yes 1 No

20 Replies to “Setup and use the Data Publisher”

  1. I believe the WP Data Access plugin will enable me to achieve my requirements, but I have come up against a couple of issues. The data that I wish to display contains records of vehicle details, but some information is repeated so that I have included that in child tables. For example, the vehicle records include more than 100 vehicles, but there are only 4 different types of engine. Thus I have an “engine” field in the vehicles table, which equates to the “id” field in the engines table.

    In a Data Project, I can define the relationships, but I’m afraid the documentation doesn’t explain clearly to me how I can display the engine details in the vehicle row. The project appears in my WP dashboard, and I can see the data from the vehicles table. I have not yet found the documentation on how to publish the data from the project on a page which will be displayed in the browser.

    I have also looked at the Data Publisher. Here I can display the vehicle data table on a page, and click on the button to open a popup (or tooltip) that displays the full data record for one individual vehicle. This is precisely what I want – and something that I have not so far found in any other WP plugin. So thank you for that – it saves me some coding in PHP if I were to write my own code. But, the problem here is that I cannot see how to incorporate the child data – the engine data in my example.

    The data is all historical, and I have exported and imported the data from the previous version of the website, so the data tables are all setup and populated in WP. There will be no new data, so I don’t need to provide for data entry – so no need for user admin, etc. I just want to display the complete vehicle record with the associated data – the engine, as mentioned above – plus a couple of other features.

    Can you advise me? Thanks in advance for your help.

  2. Hi Nigel,

    If you don’t need to edit your table data, you don’t need the Data Projects tool. The main purpose of the Data Projects tool is data management. If you only need to query your data you are better of with the Data Publisher.

    To use the Data Publisher however, you need to set one additional step. While the Data Projects tool supports parent-child relations, the Data Publisher only supports straight tables. So I see your problem. The solution to solve this problem however is very simple. You just need to write a query that joins your tables correctly and then create a view for that query. Within the Data Publisher you can use a view just as you would use a table.

    I hope this helps. Let me know if I have not been clear enough or you need help otherwise.

    Best regards,
    Peter

  3. Hello Peter,

    Thanks for your prompt and helpful response.

    I created the view in phpMyAdmin, and this works exactly as I require with the Data Publisher in your plugin. The records in my view have an ID field which I use to define the initial ordering of the records. As far as I can see, I need to include and display this ID field to ensure this sorting works as intended?

    One other minor question: can I change the title on the popup/tooltip with the details, so that it displays something more specific than “Row details”?

    Thanks again for your help.

    Best regards,

    Nigel

  4. Using version 3.0 of the plugin.
    I’m trying to publish data from an imported custom table to the front of the website.
    I can view the table and modify the table column settings in steps 1 and 2 of the publication process.
    However I can’t select the table in the data publisher – part of step 3.
    There is no “Manage Plugin” link in the WP Admin dashboard left column and no way I can find (so far) to set front-end/back-end settings.

    Something inadvertently left out of version 3 or changed and not reflected in the tutorials?

  5. Hi Tracy,

    Sorry, I’m a bit behind with the documentation. The plugin settings menu was moved from the WP Data Access menu to the Settings menu.

    I added a note to the video and the page. Thank you for reminding me!

    Best regards,
    Peter

  6. Hi Peter,

    Thanks for this plugin, which might come very close to what I intend to do with Datatables within my WP setup.
    However, I’m struggling a bit with the more advanced configuration of table options.
    In particular, I have a table with data that I want to render differently for each column.
    Let’s say I have a table “books” with a column “book_url”, which links to an external shop site – How would I render the stored URL as a HTML link with ?

  7. Hi Fabian,

    That’s the more complex stuff! 🙂

    From what I understand from your requirement, the best solution might be to add a dynamic hyperlink to your table and add it to your publication. You can find the documentation here:
    https://wpdataaccess.com/2020/03/22/dynamic-hyperlinks/

    Use the HTML column to add your own attribute to the link. Hope this helps…

    Best regards,
    Peter

  8. Hi Peter,

    I would like to know, if there’s a possibility to allow front-end editing of published tables?
    or can I create some kind of form, where someone would add a new entry for a table and then this row is added to my tables i created with your plugin?
    Do you have a suggestion, how to implement this? Do I need another plugin?

    Thank you very much for your efficient support!
    Best regards,
    Chiara

  9. Any tips for getting my remote database table (rdb) to appear in the Data Publisher page? As of right now, it just says “No Data”. I am the administrator on the wordpress site and have selected the ‘administrator’ role in the Data Publisher Tool Access settings. The table is connected correctly and appears in the Data Explorer.

    Feel free to delete my previous comment, prematurely hit the enter key! 🙂

    1. Have you granted access to your remote table? Please follow these steps:
      – Go to Settings menu
      – Submenu WP Data Access
      – Tab Front-End
      – Select your remote database from the list
      – Click on the remote tables to which you want to grant access
      – Save your settings
      Let me know if this solve your problem…

  10. Hi,
    in Data Publisher -> “Table Name”

    How can I use more than one existed “Table” that allowed me to customize the published data columns ?

    if not possible ..

    Can I design my own table columns that imported from other tables already existed?

    Thank you!

    1. Hi Sultan,

      Looks like you want to join tables? You can create a view and use your view instead of a table. This works in the Data Publisher as well as Data Projects (in Data Projects you cannot make the view updatable).

      Let me know if I misunderstood your question,
      Peter

  11. Hi Peter –
    I am looking for a solution for my backend SQL database that allows for an expanded search feature eg name, surname, start_date, end_date. Based on the search criteria that the user enters, the results from the SQL database are then returned.
    Does your excellent WP Data Access plugin allow for changing the search feature? I can see on your videos there is only ever one search field.
    Many thanks in advance

    1. Welcome TMS! 🙂

      The plugin supports only one search column and standard searching. An alternative search extension is written by Charles Godwin. You can download it from here: https://github.com/CharlesGodwin/wpda-cwg-extensions

      Alternatively, you can buy the full text search pro extension which supports full text search for InnoDB and MyISAM tables, and searching specific columns. The extension can also generate listboxes for specific columns containing available column values only. The extension will be available in June 2020.

      Best regards,
      Peter

Leave a Reply to Fabian Cancel reply

Your email address will not be published. Required fields are marked *