Script to make FRL from spreadsheet

Homepage Clovertech Forums Read Only Archives Cloverleaf Cloverleaf Script to make FRL from spreadsheet

  • Creator
    Topic
  • #50725
    Mark Thompson
    Participant

    Does anyone have a script they want to share for building an FRL from a spreadsheet?

    - Mark Thompson
    HealthPartners

Viewing 3 reply threads
  • Author
    Replies
    • #67261
      garry r fisher
      Participant

      Hi Mark,

      I’ve never done it but it should be possible. Have a look at tCOM for accessing the spreadsheet if you are using Tcl. If you know Java then there is a open source library called jExcel which also may be of use.

      I hope this provides you with some inspiration.

      Garry

    • #67262
      Charlie Bursell
      Participant

      I knew I had this somewhere, I just had to find it  😀

      This script assumes you have saved your speadsheet in two columns as a CSV file.  The first column should be the field name and the second column the field width.  This should be eay to do within Excel.

      It builds a simple FRL using the same name as the CSV file.  It assumes no subfields, includes, masks, etc.

      Feel free to modify to fit specific needs

    • #67263
      Bala Pisupati
      Participant

      Charlie,

      In the above situation, where will the Excel file be, if the Excel is on some folder say /quovadx/qdx5.5/integrator , how do I make it go through the proc that has been provided. the values are not in hl7 format, so i can’t pump it into a thread before converting to frl format. So how do I do this.

      Please forgive me if the questions seem too basic.

      Bala

    • #67264
      Charlie Bursell
      Participant

      I think if you run it, it gives a usage statement:

                Usage:     csv2frl

                   csv file = Path to CSV file

      If the CSV file is not in the current directory you must provide the full path

      The CSV file is simply exported from the Excel file wherever that resides.  If on another server you may have to move it to where you are building the FRL

      I don’t understand your question about HL7, etc.  This script is simply to build an FRL confguration file

Viewing 3 reply threads
  • The forum ‘Cloverleaf’ is closed to new topics and replies.

Forum Statistics

Registered Users
4,964
Forums
28
Topics
9,103
Replies
33,613
Topic Tags
248