to better understand the db structure of x2x, try to take a look at the developers wiki : http://apps.sourceforge.net/mediawiki/care2002/index.php?title=Developer %27s_Manual
gj. On Mon, 2009-06-01 at 17:01 -0500, Marcelino Mateos Palacios wrote: > I agree about the "problem" This is what I am trying to solve and will be the > main scope of the project. > > I was thinking to use AGI for this. xml-rpc seems to be faster and simpler... > (Now we must see how asterisk can handle it) > Or may be use a mix of both… > > I'm now trying to understand the database structure of care2x and the way > Freepbx works, since it uses php and mysql in a relatively reliable and > stable way. > > About the scheduling module, first, I must see the way asterisk will interact > with c2x. Once I understand it, the integration according to the requirements > will be simpler. > > Thanks for the recommendation. It is usefull to me. > > greetings > > > ----- === xxxxx XXXXX xxxxx === ----- > Marcelino Mateos Palacios. > ----- === xxxxx XXXXX xxxxx === ----- > > > > From: gjergj.sheld...@gmail.com > > To: care2002-developers@lists.sourceforge.net > > Date: Mon, 1 Jun 2009 23:09:49 +0200 > > Subject: Re: [Care2002-developers] Care2x and VoIP Asterisk > > > > Hi Marcelino, > > > > if you can avoid the voice recognition part and limit it to the minimum, > > as you mention use the dial keys then it's perfect! :) > > > > so the "only" problems left are interfacing asterisk to c2x and the > > scheduling. > > > > as for the asterisk <-> c2x communication an interesting option could be > > to use xml-rpc calls. this since the libraries i've seen for asterisk to > > communicate with php ( phpagi, asterisk php and asterisk php api ) have > > to major drawbacks > > - not properly ready for production ex here : > > http://eder.us/projects/asterisk_php/ > > - and second, there's nothing that assures you that the developing of > > those libraries will continue, risking to stall the future updates of > > c2x for those systems. > > > > regarding the scheduler, we have to discuss a bit on the features that > > are needed. > > > > regards > > gjergj > > > > > > On Mon, 2009-06-01 at 12:31 -0500, Marcelino Mateos Palacios wrote: > >> Hello GJ… > >> > >> In order to be able to use the telephonic appointment system, the user > >> must already have an id (in this case we will use the file Id or even a > >> Patient Id which is assigned by the system. > >> > >> > >> > >> Usually, the user comes to the hospital when something hurts… In this > >> first visit is when the receptionist will take the patient data and > >> will introduce it into the system. > >> > >> > >> > >> After this, the user will be able to use the system (with the user Id > >> given by the receptionist) to access the appointments system (via phone > >> or web) > >> > >> > >> > >> I’d like to use the phone because many of our patients (users) come > >> from places where there is no internet and there are only a couple of > >> telephonic lines are shared with all the people (towns with 100 or 200 > >> people). > >> > >> > >> > >> The ASR will be used to acquire some data that are difficult to > >> introduce with the phone, for example, the name or in cases where a > >> pulse dial phone is used or where the people disables the keypad to > >> prevent users to make unauthorized calls (is the technology present in > >> our small Mexican towns), and the system will confirm that it > >> understands what the user was trying to say. > >> > >> > >> > >> The rest of the process will be using the phone keypad (pres 1 to do > >> something and 2 to make another) > >> > >> > >> > >> Of course there will always be an option to reach and operator which > >> will make the process if the user can’t (if you want to speak with our > >> operator, say yes, or wait on the line). This was no conceived to make > >> the receptionist work obsolete, it was made to reduce the work load and > >> allow her to focus on other activities, for example, to drink more > >> coffee or have more time to chat etc etc. > >> > >> > >> > >> This is my justification. > >> > >> > >> > >> Thanks for the comments and I will include this (with your permission) > >> as part of my work justification with another common questions made by > >> other people. > >> > >> > >> > >> > >> ----- === xxxxx XXXXX xxxxx === ----- > >> Marcelino Mateos Palacios. > >> ----- === xxxxx XXXXX xxxxx === ----- > >> > >> > >> > >> > >> > >> ---------------------------------------- > >>> From: gjergj.sheld...@gmail.com > >>> To: care2002-developers@lists.sourceforge.net > >>> Date: Sun, 31 May 2009 19:05:21 +0200 > >>> Subject: Re: [Care2002-developers] Care2x and VoIP Asterisk > >>> > >>> Hello Marcelino, > >>> > >>> the way c2x works - the majority of theis kind of sw works - is that the > >>> user has to be registered and admitted in an ambulatory / department > >>> before he/she can access the services of a hospital, be it lab, > >>> pharmacy, etc. > >>> > >>> the first - and most difficult step - is going to be the scheduling of > >>> the appointment for patient that are not registered in the system; there > >>> are some fields that would need to be filled in for a registration to be > >>> accepted by c2x. it's true that one can modify them and make it > >>> acceptable without filling those forms..but is it correct ? > >>> > >>> another - quick - thing, do you think it's a good idea to use voice > >>> recognition in a medical environment ? > >>> > >>> regarding the scheduler and the lab analysis is not that difficult. > >>> > >>> gj. > >>> > >>> > >>> On Sun, 2009-05-31 at 11:52 -0500, Marcelino Mateos Palacios wrote: > >>>> Hello Enrique, Hi Gjergj > >>>> Thanks for the answers. > >>>> > >>>> The project is giving his first steps... > >>>> > >>>> I have some experience with asterisk and another IP PBX’s. I have 3 in > >>>> production. The biggest has almost 70 extensions. > >>>> > >>>> The process for install and configure asterisk in a lab environment is > >>>> the first step (although I already have some experience with this.) > >>>> > >>>> The Next… is to know the way care2x modify the tables and relations in > >>>> the database (I will be querying Gjergj for this :-) ) > >>>> > >>>> I have no much experience with databases and php, (I have been working > >>>> in the communications world) but the project will basically focuses on > >>>> write the registers needed by care2x. > >>>> > >>>> We will use asterisk AGI language to make the interface from the PBX to > >>>> the database. Is the same process and techniques used for asterisk to > >>>> manage information from FreePBX and all the modules (there are a nice > >>>> tutorial about how to do this with the call logs, known as CDR.) and I > >>>> pretend use it to complete the project. > >>>> > >>>> The last step will be to install and configure the "text to speech" and > >>>> "automatic speech recognition" engines to interact with the user. I > >>>> pretend to use a package known as Festival. > >>>> > >>>> Although I’d like to use an “API” call “Loquendo VoxNauta”, (this has > >>>> great voices) I have read that is too expensive. > >>>> > >>>> And the last step, is to put all together… > >>>> > >>>> There will be some “intermediate steps” like intercommunicate two VoIP > >>>> PBX (specifically, cisco call manager) and configure another stuff we > >>>> have in the Lab and I’d like to use. > >>>> > >>>> Officially, I will start the work this Monday June 1st and I will make > >>>> one weekly report until mid November when I will present the work and > >>>> defend the investigation to obtain my Master grade. > >>>> > >>>> Wish me luck. > >>>> > >>>> I’m from Oaxaca México and student from the Anahuac University, here in > >>>> Oaxaca. > >>>> ----- === xxxxx XXXXX xxxxx === ----- > >>>> Marcelino Mateos Palacios. > >>>> ----- === xxxxx XXXXX xxxxx === ----- > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> ________________________________ > >>>>> Date: Sun, 31 May 2009 09:15:05 -0500 > >>>>> From: enri...@laentrada.com.mx > >>>>> To: care2002-developers@lists.sourceforge.net > >>>>> Subject: Re: [Care2002-developers] Care2x and VoIP Asterisk > >>>>> > >>>>> Hi Marcelino, > >>>>> > >>>>> I'm from Mexico too. Id like to know more of your project. I already > >>>>> installed an asterix PBX on laboratory's environment and, after ear a > >>>>> spech from the POP, I want to modify my PBX in order to make some kind > >>>>> of authomatic tasks. This is one interesting task to do. I'm in DF. > >>>>> Where are you from? > >>>>> > >>>>> > >>>>> Thank you > >>>>> > >>>>> Enrique. > >>>>> > >>>>> 2009/5/30 Gjergj Sheldija> > >>>>> > >>>>> Hi Marcelino, > >>>>> > >>>>> > >>>>> > >>>>> i'm working exactly on this - the scheduling module - you can contact me > >>>>> > >>>>> directly on my mail to share what i've achieved until now and how it may > >>>>> > >>>>> help you. > >>>>> > >>>>> > >>>>> > >>>>> regards > >>>>> > >>>>> > >>>>> > >>>>> gj. > >>>>> > >>>>> > >>>>> > >>>>> On Sat, 2009-05-30 at 17:38 -0500, Marcelino Mateos Palacios wrote: > >>>>> > >>>>>> “This project will use the open source, IP PBX “ASTERISK” as the > >>>>> > >>>>>> system core. > >>>>> > >>>>>> It will be used the database of another open source GNU system known > >>>>> > >>>>>> as “Care2x” (a Hospital Information System or HIS), specifically, the > >>>>> > >>>>>> outpatient module. > >>>>> > >>>>>> The final objective will be to schedule an appointment using the > >>>>> > >>>>>> telephone and the possibility to call the user to remind him the date > >>>>> > >>>>>> and time. > >>>>> > >>>>>> In a further stage, this will extend to laboratory studies and > >>>>> > >>>>>> radiology. > >>>>> > >>>>>> All the general (and specific) tasks will be documented (photographs, > >>>>> > >>>>>> diagrams, screenshots, and the most significant commands) > >>>>> > >>>>>> There will be no a step by step guide, since the problems and > >>>>> > >>>>>> circumstances on each deployment, can vary in very significant ways, > >>>>> > >>>>>> giving as result, the misdirection to the reader or obsolescence of > >>>>> > >>>>>> this work, (as many tutorials in the internet)” > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> ------------------------------------------------------------------------------ > >>>>> > >>>>> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > >>>>> > >>>>> is a gathering of tech-side developers & brand creativity > >>>>> professionals. Meet > >>>>> > >>>>> the minds behind Google Creative Lab, Visual Complexity, Processing, & > >>>>> > >>>>> iPhoneDevCamp as they present alongside digital heavyweights like > >>>>> Barbarian > >>>>> > >>>>> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com > >>>>> > >>>>> _______________________________________________ > >>>>> > >>>>> Care2002-developers mailing list > >>>>> > >>>>> Care2002-developers@lists.sourceforge.net > >>>>> > >>>>> https://lists.sourceforge.net/lists/listinfo/care2002-developers > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> -- > >>>>> Con un atento saludo de: > >>>>> Lic. Enrique F. Valderrama Ocampo > >>>>> Gerente de Proyectos > >>>>> La Entrada de Internet, > >>>>> Olivos No. 36-B, Col Cuauhtémoc, M. Contreras > >>>>> > >>>>> México, 10020, D. F. > >>>>> Tel. (+52 55) 5033 4343 > >>>>> Fax. (+52 55) 5425 4694 > >>>> > >>>> _________________________________________________________________ > >>>> Conoce Hotmail y protege tu correo > >>>> www.windowslive-hotmail.com/protectyourself/es/default.htm > >>>> ------------------------------------------------------------------------------ > >>>> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > >>>> is a gathering of tech-side developers & brand creativity professionals. > >>>> Meet > >>>> the minds behind Google Creative Lab, Visual Complexity, Processing, & > >>>> iPhoneDevCamp as they present alongside digital heavyweights like > >>>> Barbarian > >>>> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com > >>>> _______________________________________________ > >>>> Care2002-developers mailing list > >>>> Care2002-developers@lists.sourceforge.net > >>>> https://lists.sourceforge.net/lists/listinfo/care2002-developers > >>> > >>> > >>> ------------------------------------------------------------------------------ > >>> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > >>> is a gathering of tech-side developers & brand creativity professionals. > >>> Meet > >>> the minds behind Google Creative Lab, Visual Complexity, Processing, & > >>> iPhoneDevCamp as they present alongside digital heavyweights like > >>> Barbarian > >>> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com > >>> _______________________________________________ > >>> Care2002-developers mailing list > >>> Care2002-developers@lists.sourceforge.net > >>> https://lists.sourceforge.net/lists/listinfo/care2002-developers > >> > >> _________________________________________________________________ > >> Windows Live te ayuda a mantenerte en contacto con todos tus amigos en un > >> solo sitio. > >> http://www.microsoft.com/mexico/windows/windowslive/products/social-network-connector.aspx > >> ------------------------------------------------------------------------------ > >> Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT > >> is a gathering of tech-side developers & brand creativity professionals. > >> Meet > >> the minds behind Google Creative Lab, Visual Complexity, Processing, & > >> iPhoneDevCamp as they present alongside digital heavyweights like > >> Barbarian > >> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com > >> _______________________________________________ > >> Care2002-developers mailing list > >> Care2002-developers@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > > ------------------------------------------------------------------------------ > > OpenSolaris 2009.06 is a cutting edge operating system for enterprises > > looking to deploy the next generation of Solaris that includes the latest > > innovations from Sun and the OpenSource community. Download a copy and > > enjoy capabilities such as Networking, Storage and Virtualization. > > Go to: http://p.sf.net/sfu/opensolaris-get > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > _________________________________________________________________ > Conoce Hotmail y protege tu correo > www.windowslive-hotmail.com/protectyourself/es/default.htm > ------------------------------------------------------------------------------ > OpenSolaris 2009.06 is a cutting edge operating system for enterprises > looking to deploy the next generation of Solaris that includes the latest > innovations from Sun and the OpenSource community. Download a copy and > enjoy capabilities such as Networking, Storage and Virtualization. > Go to: http://p.sf.net/sfu/opensolaris-get > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers ------------------------------------------------------------------------------ OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers