Connections
      Back to home
      1. Help Center
      2. Intuitive Dashboards Core Software
      3. Connections

      Using delimited textfiles

      Delimited textfiles are commonly written and read by Windows and Unix systems – they consist of data arranged into columns separated by a character such as comma (,), pipe (|) or tab.

      A delimited textfile of suitable format for Intuitive Dashboards might look like this:
        
      1,DR MARKUS & PARTNERS (C81649),Derbyshire County PCT,East Midlands, SHA,1,3,0,0,0,0,0,0,0,1,3,0,0,451,236,0.52CRLF
      2,THE DENSHAM SURGERY,North Tees PCT,North East, SHA,19,15,0,0,1,5,3,7,5,1,5,5,2,624,333,0.53CRLF
      3,QUEENS PARK MEDICAL CENTRE,North Tees PCT,North East, SHA,46,93,0,1,0,11,19,22,13,17,31,18,7,669,343,0.51CRLF
      4,THE GUPTA/ GALLAGHER PRACTICE,Hartlepool PCT,North East, SHA,5,5,0,1,1,2,0,2,1,1,2,0,0,693,261,0.38CRLF
      5,WOODLANDS ROAD SURGERY,Middlesbrough PCT,North East, SHA,10,12,0,0,20,0,3,3,3,1,6,6,0,653,321,0.49CRLF
        
      Bear in mind that files written by Windows and Unix systems frequently have different end of line terminator characters shown here as CRLF. For example files written from an Oracle database on Linux may need to have characters changed using a utility such as sed. In this case refer to the following article: http://en.wikipedia.org/wiki/Newline
        
      Each delimited text file must be named yourfilename.txt and be accompanied by a format file called yourfilename.format.xml.
      For example the format for the above file looks like this:
        
      <TABLE FileFormat="Delimited" Delimiter="," >
      <FIELD Name="Record_Number" DataType="Int64" />
      <FIELD Name="Practice_Name" DataType="String" />
      <FIELD Name="PCT_Name" DataType="String" />
      <FIELD Name="SHA_Name" DataType="String" />
      <FIELD Name="Male" DataType="Int64" />
      <FIELD Name="Female" DataType="Int64" />
      <FIELD Name="Age_under_18" DataType="Int64" />
      <FIELD Name="Age_18_to_19" DataType="Int64" />
      <FIELD Name="Age_20_to_24" DataType="Int64" />
      <FIELD Name="Age_25_to_34" DataType="Int64" />
      <FIELD Name="Age_35_to_44" DataType="Int64" />
      <FIELD Name="Age_45_to_54" DataType="Int64" />
      <FIELD Name="Age_55_to_59" DataType="Int64" />
      <FIELD Name="Age_60_to_64" DataType="Int64" />
      <FIELD Name="Age_65_to_74" DataType="Int64" />
      <FIELD Name="Age_75_to_84" DataType="Int64" />
      <FIELD Name="Age_85_over" DataType="Int64" />
      <FIELD Name="distributed" DataType="Int64" />
      <FIELD Name="received" DataType="Int64" />
      <FIELD Name="resprate" DataType="Decimal" />
      </TABLE>