7 Comments

1. 

   Sunny on 2021-12-27 at 11:58 pm

   Hi,
   I want to use this demo in a real student admin system but need to modify (add) new columns for different tables (E.g. wpda_sas_student) I tried to use “designer” to add a new column and it was saved successfully in “Designer” page but when I go to the “Template” page and check wpda_sas_student, it is not updated. Also, I don’t see any change in “Student Administration” Page. Can you show me how to add new columns on different tables in the template?

   Thanks,
   Sunny

   Reply
   • 

     Peter Schulz on 2021-12-28 at 6:02 pm

     Good question Sunny!

     When you change a table in the designer, it just changes the design. Not the physical table. To modify the physical table you need to explicitly click the “ALTER TABLE” button. When you see the colors disappear in the Data Designer, your column was successfully updated. You can use the Data Explorer to check.

     After changing the physical table, you need to update your templates to reflect the changes in your Data Project:
     – Open the Project Templates page
     – Edit the template that uses the modified table
     – Click tab Reconcile
     – Enable “Keep options?” (IMPORTANT!!! Needed to keep the settings of all unchanged columns, like labels, defaults, etc)
     – Click “Reconcile Table”

     If your new column is used in multiple templates, you need to repeat this for each template.

     Great you’re using the demo project! 🙂 Let me know if you need help.

     Good luck,
     Peter

     Reply
     • 

       Sunny on 2021-12-29 at 5:40 am

       Hi Peter,
       Thanks very much for your help! It works after following your steps.
       I am sure I will have lot of questions to make it customized for my organization use. Should I continue to leave my questions here or is there a better to contact you?

       Thanks,
       Sunny

       Reply
       • 

         Peter Schulz on 2021-12-29 at 10:24 am

         Hi Sunny,

         Good you fixed it! 🙂 You can use the website, the forum or the contact form. The choice is yours. If you need to exchange sensitive info, it is better to use the contact form. In other cases using the website or forum might help other users as well.

         Thanks for asking,
         Peter

         Reply
         • 

           Sunny on 2022-01-06 at 3:05 am

           Hi Peter,
           Thanks. I sent you another question using Contact Form. Did you receive it?

           Thanks,
           Sunny

           Reply
2. 

   lobo on 2022-02-04 at 2:37 pm

   hello, I like buy this plugin, but before, please i need test the system
   Can you send me link to download the school system creating script.
   Thanks

   Reply
   • 

     Peter Schulz on 2022-02-05 at 10:40 am

     Hi Lobo,

     You can download the Student Information System from here:
     https://wpdataaccess.com/wp-content/uploads/2020/06/sas.zip

     There is a 14 day premium trial version available directly from your dashboard.

     Hope this helps,
     Peter

     Reply