|
|
|
|
|
1
|
2
|
3
|
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
|
25
|
26
|
27
|
28
|
29
|
30
|
31
|
|
|
#27036 - 07/12/07 05:56 PM
Re: Free Database Software
[Re: bongski55]
|
Geoff Hannis
Hero
Registered: 12/02/04
Posts: 3026
Loc: the path less trodden
|
Pleased to hear that you were able to get the program up and running without any problems, Bong. If you're serious about wanting to use it, just zip your spreadsheets to me, and I'll import them into the XTM format. No worries.
I know you're at the Sultan Qaboos University Hospital, Mate (lucky guy), but how come you've got that many assets? What are you doing, counting the flowmeters as well? 
|
|
Top
|
|
|
|
|
#27054 - 09/12/07 12:15 PM
Re: Free Database Software
[Re: Louis Lyniswern III]
|
Geoff Hannis
Hero
Registered: 12/02/04
Posts: 3026
Loc: the path less trodden
|
Interesting stuff, Louis. Web-based is the way forward, for sure. But there may be problems, as Ed SWM has already pointed out.
Meanwhile, it seems to me that many techs labouring away out there in the world still make use of stand-alone systems. Networks, broad-band connections and all the rest are not yet universal, shall we say (let alone IT departments)!
As I've banged on about quite a few times before, I like the idea of a collaborative effort, sharing not only ideas, but data as well. So far this has not progressed much beyond the "pipe-dream" phase, I'll have to admit (due to a general lack of interest amongst the Brethren, it would seem). I would love to be proved wrong on that one. Perhaps the winter months will see a sudden rush of enthusiasm for "sharing the wealth" (ie,of knowledge).
On the question of hosting, I would have thought that "both" is the answer there. No doubt our Mr.Huw can advise (...why not do it in collaboration with the ebme site)?
On the question of charging fees ... well, all I can say there is "good luck"!
Looking forward to seeing your stuff, Mate.
Edited by Geoff Hannis (09/12/07 12:30 PM)
Edit Reason: Some editing was required!
|
|
Top
|
|
|
|
|
#27056 - 09/12/07 01:22 PM
Re: Free Database Software
[Re: Louis Lyniswern III]
|
Geoff Hannis
Hero
Registered: 12/02/04
Posts: 3026
Loc: the path less trodden
|
Like Louis, Geoffrey has also looked at a multitude of equipment database structures, but would have to disagree with Louis by saying that the striking thing about them is their similarity! And modern database (spreadsheet etc.) software permits swapping between formats with relative ease.
My own stance is that the whole biomed CMMS scenario falls into two camps:- highly-priced "commercial" packages, and lowly (lowly as in "humble", but also as in "zero cost") efforts of the type I usually refer to as "home grown" (which group does Steve Lake's EMS solution fall into? I don't know)!
Contributors to this forum have been known to express strong views in support of both models, which is fair enough.
Your point about a centralized shared database is well-taken. But (in my role of Devil's Advocate), who's to say that your database (or mine, ECRI's ... or anybody else's) is any better than anyone else's? In my many years in this game, I have often seen techs quite happy with what they had available to them locally, especially if it was what they themselves had developed (ie, to suit their needs). There's nothing wrong with "pride of ownership", in my opinion (in fact I would like to see far more of it - especially amongst those who we like to call "user staff" - nurses and the like).
"One size fits all" tends not to be the answer, in my experience. What is needed is a logical basic structure, an interface that is readily and totally configurable to suit local needs (dare I say idiosyncrasies?), and extremely flexible reporting routines (this is probably where SQL scores).
Where we on this forum can make a real difference is in collaboration. That's where I plant my flag!
Kaz had the right idea, I reckon:-
I propose that we thresh out an agreed specification for the New System, then code it ourselves, step by step, whilst welcoming contributions from the entire community along the way.
Edited by Geoff Hannis (09/12/07 02:01 PM)
Edit Reason: Needed editing as usual!
|
|
Top
|
|
|
|
#27057 - 09/12/07 04:06 PM
Re: Free Database Software
[Re: Geoff Hannis]
|
bongski55
Visionary
Registered: 15/08/04
Posts: 37
Loc: Oman
|
Pleased to hear that you were able to get the program up and running without any problems, Bong. If you're serious about wanting to use it, just zip your spreadsheets to me, and I'll import them into the XTM format. No worries. I know you're at the Sultan Qaboos University Hospital, Mate (lucky guy), but how come you've got that many assets? What are you doing, counting the flowmeters as well?
 no not the flowmeters but ALL office equipment,audio and video equipment and photocopiers! the first BME admin made a mistake of "taking it all" and now we are stuck with this non biomed equipment!nobody in his right mind would accept them if we try to pass it to others now.
I'll try to email you data minus the non medical equipment later.
thanks!
_________________________
|
|
Top
|
|
|
|
|
#27058 - 09/12/07 04:23 PM
Re: Free Database Software
[Re: bongski55]
|
Geoff Hannis
Hero
Registered: 12/02/04
Posts: 3026
Loc: the path less trodden
|
I believe I met your "first BME admin" back in 1987, Bong. The guy seemed pretty clued up to me!
To my mind, there's nothing wrong with "taking it all". Especially when operating in a commercial environment (which you're not, I presume). If the customer (user) is daft enough to pay to have biomeds take care of their office equipment, that's all well and good!
Many years ago when I was travelling around a well-known Desert Kingdom touting for business at small private hospitals and clinics, the people there always wanted a quote to come and service all their equipment. Yes, including the emergency battery-backed lighting units, refrigerators, fans and all the rest (including, even, the medical, dental and laboratory equipment). Not "money for old rope", though, as those old guys drove a hard bargain, let me tell you. Lot's of sweet tea had to be drunk too, of course. I worked out some good spreadsheet formulae (on good old DOS Lotus 1-2-3, of course) at that time, and used to amaze potential customers by being able to return the following day complete with an inventory (on floppy disk) - usually the first proper inventory list they had ever seen - together with a fully-costed series of maintenance options. In the (few) cases that I got the "go-ahead", they always went for the "fixed price" option, by the way. Those clinics were, after all, businesses. I wish I was still there doing that stuff!
Meanwhile, you can include all those other items in your data if you want (TaskMaster takes care of it all). Equipment still needs PM (in my opinion), regardless of whether it's an ECG monitor, CT scanner, or an electric kettle! As long as you're charging by the hour that is! Ha, ha.
By the way, my method is to group all flowmeters of each type (air, oxygen) as a single "asset" for each Ward etc. It keeps the numbers down that way!
Edited by Geoff Hannis (09/12/07 05:16 PM)
Edit Reason: Added a bit more.
|
|
Top
|
|
|
|
|
#27092 - 12/12/07 01:47 AM
Re: Free Database Software
[Re: gringo]
|
GaniG
Newbie
Registered: 15/11/07
Posts: 6
Loc: Philippines
|
Hi Geoff,
Medical equipment management is just beginning to be realized here in our country. Your database program is what I have been wanting, can you give me a copy too?
Thanks
|
|
Top
|
|
|
|
|
47 registered
(Jonathan Wells, obiwan, Adonis, Baldrick, Gav, Paul McEleney, Andrew FK, Eddie, kaiser, John Carpenter, Apollo11, legofrenzy, John Stewart, Linda Woods, IT, Dicky, Harry Gurney, Miniman, Eagle, SUZUKI, Rob1234, biomedbill, Huw, D.O.A, TheWoo, Topper, 1 invisible)
and 381 anonymous users online.
|
|
|
