Script to make FRL from spreadsheet

[Mark Thompson]

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

- Mark Thompson
HealthPartners

Topic

[garry r fisher]

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

[Charlie Bursell]

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

[Bala Pisupati]

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

[Charlie Bursell]

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

[Author]

Replies