• Resolved Merlin Silk

    (@merlinsilk)


    Hi Peter,
    I just discovered your plugin to my great delight because it is doing exactly what I thought I would have to write myself – – and that would have been a big thing for me 🙂
    What I need is rather simple, I want to maintain a mailing list in WordPress and allow people in the office to browse/search the list and add new records to it.
    And I started to design the new table but I ran into basic questions on how I enter for example auto_increment for my primary field ID.
    I went through most of your tutorials and most of it I do understand – or will understand on the second or third time through, but what I would love a very basic step by step tutorial. From designing a simple table with an auto-increment ID field and maybe a unique field (like an email address), and then all the further steps how I show those on a WP page to allow authorized users to view and edit that table. With such a basic walk-through I think, it would be easier to understand the relationship of Data explorer, designer, project and publisher.
    Thank you so much for your amazing work.
    Merlin

    • This topic was modified 5 years, 10 months ago by Merlin Silk.
    • This topic was modified 5 years, 10 months ago by Merlin Silk.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Merlin,

    Thank you for your flattering words and valuable suggestion! 💡 I have planned to improve the documentation, but never thought about the integration issues with all those different tools and features. Good point!!! Can you tell me which table columns and functionality you like to have in your data app? Next week I will be on a holiday. Maybe I can create a video tutorials after my holiday specifically for your mailing list? 🙂

    Best regards,
    Peter

    Thread Starter Merlin Silk

    (@merlinsilk)

    Hi Peter,
    thanks for the prompt reply. I did get a bit more into the details and tried to figure out how to get my table set up and so far have come up with
    CREATE TABLE mastermailing
    (ID int NOT NULL AUTO_INCREMENT
    ,Last varchar(60) NOT NULL
    ,First varchar(60) NOT NULL
    ,Source varchar(16) NULL DEFAULT NULL
    ,Email varchar(100) NOT NULL
    ,Status enum(‘enabled’,’disabled’) NULL DEFAULT NULL
    ,Added date NULL DEFAULT NULL
    ,PRIMARY KEY (ID,Email)
    );

    CREATE UNIQUE INDEX email ON mastermailing (Email);

    … and want to continue from here. The plan is to have a new page – maybe private, so that office personnel has to be logged in to see it – with this table content showing for searching and editing/adding. I know you have a tutorial for that – I will just have to review that.
    But in general, a tutorial that takes a complete newbie like me by the hand and shows how to accomplish the whole setup – I think that would help not only me.
    Cheers,
    Merlin
    PS: beside that – any idea how I could get a default for the column ‘Added’ that only inserts the date when the record is created?

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Merlin,

    I released a new version of the plugin yesterday. Your request made me thinking about the documentation and help. Yes! I didn’t forget you!

    I decided to move the documentation to a public location and add some step by step instructions how to work with the plugin, hoping this will give users more insight information and a beter understanding how the different features of the plugin work together.

    I created two quick tours which can be found here: https://wpdataaccess.com/docs/documentation/getting-started/quick-tours/

    From my perspective these quick tours should be helpful, but I’m curious whether it is helpful for users like you. May I ask you to have a look at these quick tours and let me know if this is what you need?

    If not, I’m interested in how I can better serve users like you. I’m trying to learn from my plugin users. Your help is appreciated.

    Thanks in advance!

    Best regards,
    Peter

    Thread Starter Merlin Silk

    (@merlinsilk)

    Excellent!
    I finally got to work on that part of the web site again and have to say that the tutorial is just what I was hoping for.
    Thank you so much!
    Cheers,
    Merlin

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Great to hear the tutorial was helpful Merlin! 🙂 It was a pleasure!

    Best regards,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    I’m closing this topic. Just let me know if you need more help.
    And you already did… 🙂 Peter

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘A very basic tutorial’ is closed to new replies.