Index

  1. Home
  2. Docs
  3. Index
  4. Data Publisher

Data Publisher

Articles

Was this article helpful to you? Yes No 1

20 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…

  1. 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.

    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

  2. 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

  3. 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

      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

        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

          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

            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

              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

                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

                  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

                    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

    1. 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

Leave a Reply to Peter Schulz Cancel reply

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

one × four =