Clovertech

Tables – automated way of updating them?

› Clovertech Forums › Cloverleaf › Tables – automated way of updating them?

  • Creator
    Topic
  • November 15, 2021 at 11:27 pm #119318
    Jason
    Participant

      not sure if this has been asked before but at our site, we have constant requests to update Tables. We then need to go in and manually update them using the Lookup Table Configurator tool.

      is there possibly a way to update these automatically/programmatically?

    • Creator
      Topic
    Viewing 6 reply threads
    • Author
      Replies
      • November 16, 2021 at 7:17 am #119319
        Charlie Bursell
        Participant

          How many tables? At a User Conference many moons ago I had a presentation on building and using dynamic tables. Maybe it would still apply?

        • November 16, 2021 at 11:14 am #119326
          Jason
          Participant

            Just 1 or 2… dynamic tables.. I’m interested, how do they work??

            thanks!

          • November 16, 2021 at 12:20 pm #119327
            Peter Cosman
            Participant

              Also very interested to know if there is an official supported way of doing this.

            • November 16, 2021 at 9:17 pm #119333
              Charlie Bursell
              Participant

                AFIK there is no official method for this. It would be a good enhancement to support dynamic tables.

                Enclosed is the proc I used to demonstrate the possibility. T is based on the assumption there is a spreadsheet which can be modified and used as a basis for the updates.

                It was presented back in 2010 and a lot has changed since then but I think the premise is still valid.

                Maybe you could use this as a starting point to build your own.

                Attachments:
                You must be logged in to view attached files.
              • November 16, 2021 at 9:19 pm #119335
                Paul Stein
                Participant

                  Programmatically could possibly be done via Swagger/CLAPI.

                  I do see an operations listed for addOneRow, deleteOneRow, and updateOneRow.

                  I too am interested in Charlie’s dynamic tables and look forward to reviewing his tcl proc.

                  • This reply was modified 3 years, 1 month ago by Paul Stein.
                • November 22, 2021 at 10:26 pm #119362
                  Jason
                  Participant

                    thanks Charlie! I’m going to look through this script as well

                  • December 1, 2021 at 6:18 pm #119383
                    Jason
                    Participant

                      Charlie,

                      Just looked through the script, great work, but where are you actually writing into the Tables? maybe I missed it, I guess that’s the crux of the issue.

                      Thanks

                  • Author
                    Replies
                  Viewing 6 reply threads
                  • You must be logged in to reply to this topic.