• Resolved jimhunterabdn

    (@jimhunterabdn)


    Hi Peter

    Firstly – great plugin – much appreciated. I’m somewhat new to this so please forgive if the answer to my question is obvious. [I’m using latest versions of wordpress and your plugin]

    I want my (naive) users to be able to edit my existing table (meetings) on the font end – hence I’m trying to use the wpdadiehard shortcode. However I also want to use some of the formatting facities available viz. column headers which are not the same as the field name, selection of which columns to display, and SQL type WHERE clause (meeting_date > NOW()).

    I’ve set up page definitions using Data Publisher and Data Projects and played around with different shortcodes with the results as follows:

    [wpdataaccess table=”meetings”]
    Raw table data – column headers derived from field name, all columns, no filtering

    [wpdataaccess table_name=”meetings”]
    ERROR: Missing argument [need at least pub_id, pub_name or table argument]

    [wpdataaccess pub_id=”1″]
    Chosen column headers, selected columns and active ‘WHERE’ filter

    [wpdataaccess project_id=”1″ page_id=”1″]
    ERROR: Missing argument [need at least pub_id, pub_name or table argument]

    [wpdadiehard table=”meetings”]
    ERROR: Missing argument(s) [(project_id and page_id) or table_name]

    [wpdadiehard table_name=”meetings”]
    Raw table data – column headers derived from field name, all columns, no filtering

    [wpdadiehard pub_id=”1″]
    ERROR: Missing argument(s) [(project_id and page_id) or table_name]

    [wpdadiehard project_id=”1″ page_id=”1″]
    Column headers derived from field name, all columns, active ‘WHERE’ filter

    I think this is as described in your documentation, but I don’t see how I can get what I want which is:

    [wpdadiehard …]
    Chosen column headers, selected columns and active ‘WHERE’ filter

    Am I missing something? Thanks for any help…

    Jim

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

    (@peterschulznl)

    Hi Jim,

    Welcome, and thank you for your compliment! 🙂

    To get the most out of the plugin:
    – use the Data Publisher for publications
    – use Data Projects for data administration

    These tools allow you to specify how you want to show your publication or project page. The easiest way to get the shortcode for a publication or project page, is from the dashboard menu. Shortcodes for publication are available from the Data Publisher menu. Just click on the shortcode link and copy/paste the shortcode in your web page. It works the same way for Data Projects.

    You should get shortcodes like these:
    [wpdataaccess pub_id="1"] for publications
    [wpdadiehard project_id="1" page_id="1"] for project pages

    There are some older shortcode formats, but I would advise not to use them anymore. They are mainly for backward compatibilty. When I just started with the plugin users needed to manually create publications. This still works but has many limitations compared to using the Data Publisher.

    Does this help?

    Best regards,
    Peter

    Thread Starter jimhunterabdn

    (@jimhunterabdn)

    Thanks Peter for your prompt reply.

    I was hoping that some of the facilities that are available when defining pages using Data Publisher (e.g. specifying Column Names and Column Labels), would be available when defining pages using Data Projects. But I guess they are somewhat different beasts!

    Best wishes

    Jim

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Sorry Kim, looks like I misunderstood your question!

    You can configure Data Projects in much more details than publications. Please check out the table options feature, which can be found under tab Manage Table Options on your Data Projects page.

    There are a number of video tutorials you that might be helpful. Here is a link to a tutorial which I think can serve as a good starting point:
    https://wpdataaccess.com/docs/documentation/data-projects/manage-table-options/

    Hope this helps. Please let me know if you need further assistance.

    Good luck,
    Peter

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Published table formatimg using wpdadiehard’ is closed to new replies.