Clovertech

Table Configurator

› Clovertech Forums › Read Only Archives › Cloverleaf › Product Enhancements › Table Configurator

  • Creator
    Topic
  • June 6, 2005 at 8:35 pm #47802
    James Cobane
    Participant

      Enhancement short description:

      In the Table configurator, it would be nice to be able to import a comma separated file as a table.

      Date:

      06/06/2005

      Operating System:

      All

      Version of OS:

      All

      Cloverleaf Version:

      5.3 and above

      Revision:

      Tool:

      Table Configurator

      Enhancement Long Description:

      It would be nice to be able to ‘import’ a comma separated (.csv) or other simple text file into the tool to create (or update) a table.  This would save potential typographic errors, and eliminate hand entry for larger tables.  We often receive requests to create lookup tables, and get provided Excel spreadsheets or comma-separated files that we could use to load the tables.  We have a tcl script that we created to do this, but it would be nice to have this feature in the toolset.

      Thanks,

      Jim Cobane

      PHNS, Inc.

    • Creator
      Topic
    Viewing 3 reply threads
    • Author
      Replies
      • January 4, 2006 at 10:12 pm #56751
        Arslan Khan
        Participant

          Hi All,

          Does any one know of any way to import text (or csv) files that we could use to load the tables.

          Thanks.

          Arslan

        • January 5, 2006 at 2:29 am #56752
          Dennis Pfeifer
          Participant

            csv is ok .. but .. I prefer tab delimited ..

            one can save it from Excel.

            I then take the file .. let’s call it tbl

            perl -pi -ne ‘s/n/n#n/g’ tbl

            perl -pi -ne ‘s/t/n/g’ tbl

            I then cut and paste a header from another table ..

            kind of manual .. but .. it’s pretty quick and easy ..

            One common problem is that people will insert spaces in Excel and not know it..

            Dennis

          • January 5, 2006 at 3:16 pm #56753
            Chris Brossette
            Participant

              We use an AIX script and a tcl to convert a file with the physician code and name to a Table, then purge the caches for the process.  This has worked well for us and I have changed the tcl to create other tables but it would be nice to be able to import the data when it is a one-shot process of creating a table…..

              If you want a copy of the script and tcl, just send me an e-mail…..

              Have a Great New Year….. 😀

            • February 21, 2012 at 7:44 am #56754
              Ben Michael
              Participant

                Or for CSV (without quotes) I found this worked:

                perl -pi -ne ‘s/n/n#n/g’ tbl

                perl -pi -ne ‘s/,/n/g’ tbl

                Table ended up being to big and went with SQLite as per:

                https://usspvlclovertch2.infor.com/viewtopic.php?p=25470#25470

            • Author
              Replies
            Viewing 3 reply threads
            • The forum ‘Product Enhancements’ is closed to new topics and replies.