Data Publisher

  2. Home
  4. Docs
  6. Data Publisher

Data Publisher

Articles

Was this article helpful to you? Yes No 1

25 Replies to “Data Publisher”

    1. Please just leave that field blank. The plugin will generate an ID when you save your publication the first time. Hope this helps…

      Reply

  2. Hi,

    I created a Publication and Published it in a page. The type of one of the columns that is shown is “Attachment”. When I am logged as Administrator is show the icon of the file attached, that’s ok. The problem is, when I am logged as Subscriber nothing is shown in this column. You could tell me if this is a bug or if I have to make some configuration?

    Thanks a lot.

    Reply

    1. Hi Ávila,

      Sorry for my late reply! I’m on holiday… 🙂

      Did you add the attachment to your publication? It is not added automatically:
      – Go to the Data Publisher
      – Edit your publication
      – Click the select button (after column “Column Names (* = all)”)
      – Add the attachment and save

      Does this help?

      Best regards,
      Peter

      Reply

  3. Peter

    I would like to be able to select the records (for printing, clipboard, csv, or excel) from multiples pages

    at the moment I can only select from one page all other selections are forgotten

    Simon

    Reply

  4. Dear Peter,

    I have created a database with a product catalogue incl. product images and prices. I have also published the catalogue and it works well.

    Now, what I would need is a form, where user can entry e.g. a number of products and based on this, products should be shown and incl. the total caculated price should per product (numer of items coming from the form x single price coming out the database)

    Is that possible within the plugin or what else would be needed?

    Many thanks for your help and best regards
    Bojan

    Reply

      1. Dear Peter,

        sorry for bothering you again. Everything re the table works perfect now. In order to avoid computed fields i´m calculating different prices within the table (for number of 1 – 100 products, that´s fine )

        E.g. if user enters 50 in a form field, the respective line incl. calculated field should be shown.

        So, where I´m really struggling right now is to setup the form field.

        1. Do I understand it right, that i cannot include the form and the table shortcode on the same page as the page needs to reload after submitting the form field? If yes, i will setup the form on one page, opening the other incl. the table – no problem

        2. could you please help me with the form field, lets´s take the entered 50, search in the table for respective line with 50 (on specific row) and show certain rows out of the same line

        Many thanks again
        Bojan

        Reply

        1. Hi Bojan,

          This page might be helpful to create a search form:
          https://wpdataaccess.com/docs/documentation/data-publisher/adding-filters/
          See section: URL Parameters.

          You can create a search form that redirects the user to your publication using URL parameters in the specified format. Here is a real live example:
          https://www.rutherfordglobal.com/pars-search/
          Select #CCN = 3959752984492 and click SEARCH

          If you are looking for a more generic search solution this page might interest you as well:
          https://wpdataaccess.com/search-builder-demo/

          Good luck,
          Peter

          Reply

          1. Many Thanks, Peter.

            I´m having a table with a column name gesamtkosten. One of the entries is 15325.

            I have included a form with WPForms Builder and entered in the confirmation mail the following url:

            https://myurl.de/ ?wpda_search_column_gesamtkosten=%%
            And it always shows all values after submission, instead of showing entered value in the form.

            If I Put: https://myurl.de/ ?wpda_search_column_gesamtkosten=15325. It shows only 15325.

            Do you have an idea what is missing?

            Many thanks
            Bojan

            Reply

            1. Hi Bojan,

              It looks like you want to use wildcards, is that correct? Wildcards only work with text columns. If I understand your situation correctly, your columns gesamtkosten and logo are numeric? You can try to create a view and convert your numeric values to text, but your query results will be unpredictable. Can you share a public url? You can use the contactform if you prefer to send it in private.

              Thanks,
              Peter

              Reply

              1. Hi Peter,

                many thanks. I sorted it out by doing my homework by reading a lots of documentation 😉

                So, what I need is a form with 2 custom fields (numeric).

                It works (when using form with one field and entering e.g. 12):
                wpda_search_column_einzelpreis=12

                This also works (when using form with 2 fields and entering 12 and 2), showing one line where both column values are matched:
                wpda_search_column_einzelpreis=12&wpda_search_column_anzahl=2

                But what I would like is to show both lines i.e. I would like to show a value from one column in one line AND an another value from another column in the second line.

                Is that possible using url?

                Many thanks
                Bojan

                Reply

                1. Hi Bojan,

                  Good you got it working! 🙂 If I understand your question correctly you need to add an or condition? Or conditions with url parameters is currently only supported within one column using arrays. You cannot add an or condition for two different columns. Sorry! It is on my to do list…

                  Best regards,
                  Peter

                  Reply

                  1. Thanks Peter ;-),

                    exactly, in order to show 2 values/lines from 2 form fields, i would need an OR condition.

                    Is there any other best practise to read information from database based on form and list them on a page?

                    Many thanks again
                    Bojan

                    Reply

                    1. Hi Bojan,

                      Your question got me thinking… I added a new URL parameter ‘wpda_search_column_operator’ to support the OR condition. It will be available with the next update which I hope to release this week.

                      Thanks for the discussion! 🙂

                      Best regards,
                      Peter

    2. Hi Peter,

      I managed to create a table, a form and even a view with calculated fields – and it works fine.

      The Problem i´m having is, that I´m trying to show at the bottom of the table a total sum of a column. I can put it in the view but it shows naturally the total amout of all rows.

      Due to the fact, that I´m working with a form which is fitering the table, I would like to show only sum of filtered columns, any idea how to sort this out?

      Many thanks
      Bojan

      Reply

  6. Hi,

    Firstly this is a really excellent plug in. I only spent about one hour playing with the free version before deciding to upgrade, so great job!!

    Question 1 : Is it possible to set the default pagnation value for a publication (wpdataaccess shortcode) on the front end like it can be set for the wpdadiehard shortcode ?

    Question 2 : Is there any possible way to automatically add row numbers when displaying a publication grid on the font end ?

    Many thanks
    Mark

    Reply

    1. Hi Mark,

      Glad you like the plugin! 🙂

      Answer 1: You can use the advanced settings to change default pagination. The following page contains an example:
      https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/
      See section: Change the list of shown entries (lengthMenu = items shown in list, pageLength = default);

      Answer 2: There are two ways to do this:
      (1) Create a view based on your query and add a row number to your view. Then use the view for your publication instead of the table.
      (2) Add a custom renderer. There are multiple ways to do this. Within WP Data Access I would advice to use the built-in function fnRowCallback. There is a fnRowCallback example on the page I previously mentioned. Here is direct link to that section:
      https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/#javascript-functions-more-complex

      Hope this helps,
      Peter

      Reply

      1. Thank you Peter for your response. I will check out both links and report back if I have any issues.

        Regards
        Mark

        Reply

  7. Hi, I am creating a publication with data publishers, but when it comes to showing the data to the front-end, it always shows all the table data at once. Thus, the pagination and the entries sorting number did not work.

    Am I missing something so that the data publishers did not work properly?
    Thank you.

    Reply

    1. Hi Tama,

      Please open your publication in the Data Publisher, open the Advanced Settings section and enable these checkboxes:
      > Allow Searching?
      > Allow Ordering?
      > Allow Paging?
      > Server Side Processing?

      Hope this helps,
      Peter

      Reply

Leave a Reply

Your email address will not be published.