[chai-t] Re: Getting a list of clinics from DH

  • From: "Mac Manus, Christopher" <C.Macmanus@xxxxxxxxxxxxx>
  • To: <chai-t@xxxxxxxxxxxxx>
  • Date: Tue, 24 Jul 2012 07:00:15 +1000

Thanks William.  Very timely and useful.




From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On 
Behalf Of Rose William
Sent: Monday, 23 July 2012 4:51 PM
To: chai-t@xxxxxxxxxxxxx
Subject: [chai-t] Getting a list of clinics from DH


Hi all,


I remember attending the various ABF forums and hearing about a "way to 
download the list of registered clinics". It turns out the latter is ... *drum 
roll* a formatted report! Huzzah!


If, like me, you were hoping to download a big list to cross-check with your 
clinic master, and really wanted a CSV containing Clinic ID, Tier 2 class, etc, 
you may be interested in the attached XSLT that converts the report to usable 


I say usable CSV because the Export to CSV available via HealthCollect returns 
a CSV that Excel won't open without using another program to convert it to 
ANSI, and even then it has lots of padding and spaces in places it should, 
presumably due to the formatting of the original report. Plus the column 
headings are useful things like "textbox32".



To use the XSLT attached, you will need to:

*       Make a new directory somewhere, e.g. C:\CHAI-T
*       Download msxsl.exe from 
http://www.microsoft.com/en-us/download/details.aspx?id=21714 and save it in 
your new directory.
*       Save the attachment non-admitted-clinics-to-csv.xsl in your new 
*       Log in to HealthCollect, browse to Reports -> AIMS -> Non-Admitted 
Clinics and choose the Non-admitted Clinic Summary report
*       Run the report for whatever parameters you like, then export the 
report, choosing XML file with report data as the format. Save it as 
Non-admitted Clinic Summary.xml
*       Go to Start -> Run and run cmd.exe
*       Type cd C:\CHAI-T (or whatever you are using) and press Enter.
*       Type msxsl "Non-admitted Clinic Summary.xml" 
"non-admitted-clinics-to-csv.xsl" -o "Non-admitted Clinic Summary.csv" and 
press Enter
*       You should now be able to open the Non-admitted Clinic Summary.csv in 
Excel and see meaningful column headings

You can also use the XSLT with SSIS's XML Task if you want to make a package 
out of it.


Kind regards,


William Rose

Business Intelligence Manager

Information Management


+61 3 9656 5231   |   Level 8, St Andrews Place, East Melbourne VIC 3002


This email (including any attachments or links) may contain confidential and/or 
legally privileged information and is intended only to be read or used by the 
addressee. If you are not the intended addressee, any use, distribution, 
disclosure or copying of this email is strictly prohibited. Confidentiality and 
legal privilege attached to this email (including any attachments) are not 
waived or lost by reason of its mistaken delivery to you. If you have received 
this email in error, please delete it and notify us immediately by telephone or 
email. Peter MacCallum Cancer Centre provides no guarantee that this 
transmission is free of virus or that it has not been intercepted or altered 
and will not be liable for any delay in its receipt. 

This email was Anti Virus checked by KeyTrust UnityASV

Other related posts: