Clovertech

Table updates outside the GUI

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Table updates outside the GUI

  • Creator
    Topic
  • February 15, 2011 at 7:59 pm #52273
    Rob Lindsey
    Participant

      CL 5.8 on AIX 6.1

      I am working on a system that has a lot of table updates done manually and I would like to convert those over to an automated script.  The issue that I am running into is that the version of the tables is now version 4.0 and I have code that works with the version 3.0 table formats.

      The main difference is the Prolog statements the default and revdefault lines and the encoding lines.

      The tools that I have used in the past TioSave, TioLoad, TioUpdateData, and TioGetValueLists.  Everything works fine except for the TioSave which defaults to version 3.0.  All of the Encoding lines are missing from the updated table.

      Does anyone know of a different PROC that I can use to get version 4.0 info into the table?

      Thanks in Advance.

      Rob Lindsey

    • Creator
      Topic
    Viewing 1 reply thread
    • Author
      Replies
      • February 15, 2011 at 8:18 pm #73643
        Jim Kosloskey
        Participant

          Rob,

          We wrote our own table builder proc that does not rely on the unsupported internal functions. That way we can easily make a change.

          For Tables the file format is not very complex.

          However, beginning with 5.8 there is the ability to encrypt the table and so we may need to re-engineer for that.

          Our proc uses a delimited file (usually CSV) that is exported from either a spreadsheet or a DB as input. The entire Table is rebuilt each time.

          email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

        • February 15, 2011 at 8:22 pm #73644
          Rob Lindsey
          Participant

            Yes I agreee that the Table format is simple.  

            I was just trying to use the built in functions (which actually does do locking).

            I am trying to do the same thing with CSV files but I am giving the ability to Add, Change, or Delete entries instead of rebuilding the entire table.  I had one written years ago but again it was for the older version and does not handle the encoding stuff.

        • Author
          Replies
        Viewing 1 reply thread
        • The forum ‘Cloverleaf’ is closed to new topics and replies.