• Resolved dizwell

    (@dizwell)


    Hello Peter,

    While you are off enjoying a well-earned break, I thought I might add a couple of your things to the to-do list or the to-be-considered list?!

    1) A tiny typo: Data Publisher -> Edit any of the publications. 9 fields down: Type. The drop-down list says ‘Modal, Collaped or Expanded’. The second one is a typo: it’s “collapsed”, not “collaped”. If you pile all the options in to do a manually-created shortcode, for example, you definitely type “collapsed”.

    2) Suggestion: I may be using the Data Publisher wrong, but if I have an underlying table and want to create different pages that display different parts of that table depending on the WHERE clause that I can add in on Data Publisher’s 12th option, it would be really helpful to be able to copy an existing publication and then just edit the copy’s WHERE clause. At the moment, I’m having to create a new one in one window, have the original in a separate window, and type or copy across each of the options, one-by-one. (My use-case is all of Mozart’s compositions: I want to list all his symphonies on one page, all his concertos on another. The only difference is WHERE dzno like ’01___’ in one case and where it’s like ’03___’ in another, but unless I missed it, I wasn’t able to use the original publication to create the second).

    3) Suggestion: When you are editing data in a table, you pick a row, click ‘Edit’, make your edit and then click “save changes to the database”. Fine -except that the ‘Edit table’ screen then still continues to display the same record you just edited. You have to click the left-arrow at the top of the page to get back to the list of rows, which reset themselves back to the top of the list, so you have to scroll around a bit to find the next record you’re interested in, before you can pick it, select edit and so on. It would be really helpful to have navigation buttons on the data editing page itself. So after you edit a record and click ‘Save to the database’, you could click ‘Next record’ and the data page would load with data belonging to the next record. If that’s not the record you wanted to change, just click ‘Next record’ again or ‘Previous record’ and so on. In other words, stay in data editing mode, but be able to step forward and backward through records without needing to go back to the row-by-row listing of table data. For a series of quite similar edits to a dozen rows at a time, this would be much faster than save – back arrow – scroll to find the next record – edit – save etc, I think.

    None of which is to detract from your plugin in any way: I think it’s brilliant to have database functionality exposed like this at all! Thank you for it and all the work you’ve put into it.

    Anyway: hope you aren’t too swamped in the new year!

    All the best,
    HJR

Viewing 7 replies - 1 through 7 (of 7 total)
  • I agree about the typo in item 1 I noticed it too.
    Item 2
    I haven’t tested it but I presume this will work.You could put your where clause in the shortcode and then only have have one pub. Refer to https://wpdataaccess.com/docs/documentation/shortcodes/shortcode-wpdataaccess/ and the sql_where parameter.

    Item 3 no comment.

    • This reply was modified 4 years, 3 months ago by charlesgodwin.
    Thread Starter dizwell

    (@dizwell)

    Yup, you can pile everything that you can put inside a publication into a shortcode. But if you want to specify columns, column names, responsiveness and all the rest of it, that’s not a shortcode any more but a very, very longcode with lots of chances for typing it wrong! It’s simply a lot easier to create a publication and just refer to the entire collection of publication criteria as ‘id=5’. Thus, the fact that you can do it in the shortcode doesn’t negate the usefulness of being able to copy one publication which then acts as a template for lots of others.

    In the interim, I worked around it by exporting the ‘template’ publication as a SQL statement, then importing it repeatedly, just editing the SQL file to supply new IDs and publication names each time. It worked, and I’m happy with it as a workaround… but a dedicated ‘copy’ or ‘duplicate’ function that auto-increments the ID number (and adds ‘copy 1’, ‘copy 2’ etc to the publication name) would still be simpler to work with, in my opinion.

    Agreed. I was answering the “I want it right now” vs “I want it right”.

    A duplicate function would be handy.

    Thread Starter dizwell

    (@dizwell)

    Ah, I see. 🙂

    Since I remember paying precisely zero for this excellent plug-in, I don’t think I’d ever dare do a ‘I want it right now’ post!

    Which incidentally reminds me to ask: is there a donation option or a ‘buy the Pro version’ option I missed? I think the plugin warrants it.

    No offence intended, it is a question I ask users. “Do you want it right, or do you want it right now?”

    I agree that it should accept donations, it is a good product. I don’t see any way to donate at https://wpdataaccess.com/

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Howard, Charles,

    Great to read all these great suggestions for improvement! 🙂 It’s a good start into the New Year! 😉

    Q1) You’re right! I’ll fix this.

    Q2) Good idea! I’ll add a copy link like the one in the manage table options area.

    Q3) Great idea!! I love it!! I can see how this improves the user interface. To implement this feature the Data Explorer and data entry forms have to be integrated somehow. That’s a tough one! 😉 I need to (re)think about the architecture of the plugin, but I will certainly pick this up.

    Regarding the discussion about the shortcode… Initially there was only the shortcode. The Data Publisher was added later. In the beginning I added all parameters to the shortcode that were available in the Data Publisher as well. Meanwhile the Data Publisher is getting more complex every month and allows more parameters than the shortcode. The old shortcode parameters are still available but I recommend to use the Data Publisher.

    Thank you for reminding me that I need to add a link to accept donations! 🙂

    Best regards,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Howard, Charles,

    Version 3 is out. I fixed the typo and added a copy publication link.

    I have not implemented the table editing suggestion yet, but it helped to make plans for an even better user interface. Now I just need to find the time to implement it… 🤔

    I added a donation link to the plugin! 😊

    Best regards,
    Peter

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘A couple of suggestions/bug-ettes’ is closed to new replies.