Neil D. McAliece wrote:
I was more thinking FUD around MSSQL and MSDE rather than MD3 particularly. I'm
still undecided about MD3 until it's been around a bit. (At least the script
printing ad splash screens are gone)
I'm hoping to convert the practice we manage early in the new year. I'll test
it somewhere first of course.
There will be some reworking of reporting tools, but I'm not too pessimistic about
it. HCN will give you a read only password for the PS3/MDW3 db & I have
connected to it (but haven't done anything seriously with it). I also remember in
some of their news letters (seems like decades ago) they asked for people who had
addon apps for MD2 to contact them to make sure that the same things were possible
in MD3.
I can't imagine any Vendor not allowing the connecting of external reporting
tools to your own data. (I could be proved wrong though).
btw, I'm only just starting to play with Open Office Base (apart from the
casual look I had at the beta). It's looking good. Should be able to connect it
to just about anything from windows or linux via JDBC, ODBC or native support.
If I do anything for division reporting, I think I'll do it in OO so that any
practice can use it for themselves if they like. Better than doing it in
Access. There are quite a few practices that don't have Access licenses. I
guess I could use a commercial product that produces an executable , but OO is
looking good for being able to put together reporting fairly quickly and being
able to install it just about anywhere.
Linking to MD2 in OO works fine from Linux too. Native support for dbf files. Just
mount a windows share (I'll use a copy of the MD2 files rather than the dir the
practice acitvely uses) then connect to external db > choose dBase > browse to
location of the files. If the path is consistant, it should open at any practice and
work.
I can get a practice server to schedule a file copy of the needed MD2 files to a
separate directory once a week or so, & the practice can run OO reports when
ever they like.
Usefulness of data is another issue. The db I've picked on to try some reporting has
thousands of uncoded diagnosis entries. I'm not a clinical person, but some of them look
pretty odd. One diagnosis that comes to mind is "home troubles". If it related
to depression, I'm not sure that you would ever pick it up.
Is there a central repository that Divisions are contributing tools to? I want
to go through the exercise myself so that we can be flexible depending on
division programs or practice requests. I'm happy to pass on any stuff I do
(once it is past the tinkering stage).
Thanks for your views Neil. I'm particularly interested be OO base, and
i hope you're right re HCN's attitude to data extraction time will tell.
By the way, as a former Social Worker with 25 years experience, I'd say
that 'home troubles' probably refers to marital conflict or domestic
violence, or both.
The central repository would be a good suggestion for Adrian at ADGP to
organise, though Alberto's resource site might be another possibility.
Greg
--
Greg Twyford
Information Management & Technology Program Officer
Canterbury Division of General Practice
E-mail: [EMAIL PROTECTED]
Ph.: 02 9787 9033
Fax: 02 9787 9200
PRIVATE & CONFIDENTIAL
***********************************************************************
The information contained in this e-mail and their attached files,
including replies and forwarded copies, are confidential and intended
solely for the addressee(s) and may be legally privileged or prohibited
from disclosure and unauthorised use. If you are not the intended
recipient, any form of reproduction, dissemination, copying, disclosure,
modification, distribution and/or publication or any action taken or
omitted to be taken in reliance upon this message or its attachments is
prohibited.
All liability for viruses is excluded to the fullest extent permitted by
law.
***********************************************************************
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk