Database Publishing

  • Resolved Jeremy

    (@jeremybeckett)


    4 years, 1 month ago

    Hi Peter,

    Thank you for creating such an amazing plugin and for being so supportive of its users.

    I wondered if you could help me resolve some customisation issues I am having with version 3.1.5 regarding making some minor adjustments to a table (published through Data Publisher) and the way that the data is delivered.

    Before I dive in I’ll add that I have checked these support forums and the documentation for answers.

    1) Is it possible to edit the table created by the Data Publisher? I wanted to make some adjustents to the text style, column widths and alter where/how some of the data appears. For example instead of the data appearing in a single row across a number of columns:

    column 1 column 2 column 3
    data 1 data 2 data 3

    I wanted to have data appear in multiple rows in a column:

    column 1 column 2
    data 1 data 3
    data 2

    2) is there a way of changing the default number of entries that a published table starts with from 10 to a different value? I have tried altering the default pagination value in Settings -> Front-end to a different number but that doesn’t make a difference.

    3) instead of modal or collapsed expanded data “view” is it possible to have the expanded data be published on a WordPress page after selecting it from the published table? I have read through the hyperlinks artile and I don’t understand how to pass the data on to the WordPress page.

    Sorry if this is a lot to ask help for! I’m by no means a web dev or coder and am struggling with the finer points of you plugin.

    Many thanks for your help.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 1 month ago

    Hi Jeremy,

    Thank you for your compliment! 🙂 Let’s go through your questions…

    1) For the kind of table change you are looking for, I would recommend to see if it can be done with css.

    The Data Publisher uses jQuery DataTables to build publications. You cannot change the table structure. You can only change the layout of your publication (positioning of search field, navigation, etc). To change the publication layout you can use the dom options. Here are some links to the documentation:
    https://datatables.net/reference/option (all available options)
    https://datatables.net/reference/option/dom (dom option specifically)
    https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/ (how to use in WP Data Access)

    2) This works with jQuery DataTables options as well. Here is the documentation:
    https://datatables.net/reference/option/pageLength

    You’ll also need to read through this documentation to use the pageLength option in WP Data Access:
    https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/

    This will change the settings to 5:
    { "pageLength": 5 }

    3) Yes this is possible! But this cannot be done with a standard hyperlink. You need to use a dynamic hyperlink to add the values of your key columns to your hyperlink. This documented here:
    https://wpdataaccess.com/docs/documentation/data-explorer/table-settings/ (section Dynamic hyperlinks)

    Let me know if this helps… 😉

    Best regards,
    Peter

    Thread Starter Jeremy

    (@jeremybeckett)

    4 years, 1 month ago

    Thank you so much for getting back to me Peter.

    I’ll put the investigation on customising the JQuery Data Table on my to do list. The tweak to the table option you gave me worked perfectly.

    As for the third question, I understand – in principle – what the dynamic hyperlink does and have read your instructions so I feel fairly confident about setting up the links. Do you have any examples or advice you could point me to so that I can setup the template for the page that receives the data from the dynamic link?

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 1 month ago

    Hi Jeremy,

    >>> Do you have any examples or advice you could point me to so that I can setup the template for the page that receives the data from the dynamic link?

    Good question! The last month I have been working on a second plugin that does support this kind of functionality, but it is not yet ready. Looks like you need to get back to good old php programming… 🙂 Sorry!

    Let me know if it works… Or if you need help…

    Best regards,
    Peter

    Thread Starter Jeremy

    (@jeremybeckett)

    4 years, 1 month ago

    HiPeter – all kinds of help would be appreciated! Can I message you directly so we can chat? I’m interested in your new plugin.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    4 years, 1 month ago

    Hi Jemery,

    Yes, you can! 🙂 You can use the contactform on the plugin website to send me a message in private, or connect on linkedin. My linkedin page is in the footer of the plugin website.

    Waiting for your call… 😉
    Peter

    Thread Starter Jeremy

    (@jeremybeckett)

    4 years, 1 month ago

    Thanks Peter – I’ve just messaged you through LinkedIn.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Database Publishing’ is closed to new replies.