Incorporating Database Schema Changes

  • Resolved donkiely

    (@donkiely)


    2 years, 8 months ago

    After creating a few data forms and project templates, I’ve discovered that I need to make a few changes to the database schema, specifically to add a few virtual generated columns. (There isn’t a way to do this in WPDA, right? I’ve not seen a way, but I’m not totally up on the plugin yet.)

    After I add those generated columns in the MySQL database, what do I need to do to incorporate the changes into the WPDA objects? I’ve seen references to exporting and importing templates and projects (such as here), but that seems to be for redirecting to use a different database that has the same structure. Or will that re-import the schema with the changes? I’m guessing not.

    Any suggestions?

    I have to say, the more I learn about WPDA the more I love it. Very impressive piece of work!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    2 years, 8 months ago

    Hi @donkiely,

    Thanks for the post! Are you currently connecting to a remote database or is this a database created locally alongside your WordPress database?

    If you’re connecting remotely, any new tables created in your remote database should also appear in your Data Explorer.

    You can also message us at Contact | WP Data Access if you wish to add more information privately.

    Let us know if you have more questions! 😊

    Thread Starter donkiely

    (@donkiely)

    2 years, 8 months ago

    Thanks, Kim! To clarify, yes, this is a remote database. But I’m not concerned about Data Explorer. I’m asking about the objects I create from the database: projects and templates. When I add the virtual generated columns, what will I have to do to incorporate them into my existing objects? Again, not the Data Explorer.

    Plugin Contributor Kim L

    (@kimmyx)

    2 years, 8 months ago

    Hi @donkiely,

    Thanks for the response! I asked Peter about your question, please see his response below:

    When the data structure of a table changes, the users just needs to open the project template, go to tab reconcile and perform a reconciliation. This is documented here:
    https://wpdataaccess.com/docs/data-apps-templates/reconcile/

    When the user enabled keep options, all current settings will be saved. Only column that are deleted will be removed.

    Hope this helps! Let us know if you have more questions. 😊

    Thread Starter donkiely

    (@donkiely)

    2 years, 7 months ago

    Thanks, Kim! Yes, that clarifies it perfectly. I just got done adding the virtual generated columns and reconciling the affected project templates. And it worked beautifully, without affecting any other settings.

    It’s about time that I head over and give WP Data Access a 5-star review, which I’ll do now. It and you all are awesome!

    • This reply was modified 2 years, 7 months ago by donkiely.
    Plugin Contributor Kim L

    (@kimmyx)

    2 years, 7 months ago

    Hi @donkiely,

    Glad that worked! Thanks so much for leaving a review! 🤗

    Have a great day!

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

The topic ‘Incorporating Database Schema Changes’ is closed to new replies.