Hi Roberts,
I have been able to get the prescription working. I had to populate the
stock, stockproperties and stockcategories in webERP. The code was using "A"
as categories and I had to create a drug category.
Thanks.
On Sat, Oct 16, 2010 at 5:46 AM, <
care2002-developers-requ...@lists.sourceforge.net> wrote:
> Send Care2002-developers mailing list submissions to
> care2002-developers@lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/care2002-developers
> or, via email, send a message with subject or body 'help' to
> care2002-developers-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
> care2002-developers-ow...@lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Care2002-developers digest..."
>
>
> Today's Topics:
>
> 1. Re: Interesting: freediams, perform prescriptions and check
> for pharmaceutical drug interactions (Ap.Muthu)
> 2. Re: Interesting: freediams, perform prescriptions and check
> for pharmaceutical drug interactions (Ap.Muthu)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 16 Oct 2010 09:44:29 +0530
> From: "Ap.Muthu" <apmu...@usa.net>
> Subject: Re: [Care2002-developers] Interesting: freediams, perform
> prescriptions and check for pharmaceutical drug interactions
> To: "Care2x - Dev List" <care2002-developers@lists.sourceforge.net>
> Message-ID: <2ae66e5ee1614b17b12ab94aa59eb...@barebone>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On analysing the FreeDIAMS database, we find duplications in the DRUGS
> table:
>
> SELECT UID, COUNT(*) AS Records FROM DRUGS GROUP BY UID HAVING Records > 1;
> UID Records
> 21045002 2
> 21998001 2
> 78665001 2
>
> We also find that the COMPOSITION table has many UIDs duplicated, but
> unique if a compound key along with MOLECULE_CODE is used (other than for
> the above codes in duplicate in the DRUGS table).
>
> SELECT UID, MOLECULE_CODE, COUNT(*) AS Records FROM COMPOSITION GROUP BY
> UID, MOLECULE_CODE HAVING Records > 1;
> UID MOL_CODE Records
> 21045002 852 2
> 21998001 852 2
> 78665001 852 2
>
> The current USFDA page is at:
> http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm
> and the latest Database is at:
> dr...@fda Download File (ZIP - 1557KB) Last updated: 10/13/2010
>
> - Ap.Muthu
>
> Attached is the MySQL Schema and Data Dump taken from the FreeDIAMS SQLite
> drugs-en_US.db
> HTH
>
> Regards,
> Ap.Muthu
>
>
>
> Hi Dr Antas,
>
>
> Karibu sana !! (warm wellcome in swahili)
>
>
> I looked the site and it is really needed. It is really difficult to
> program when needs high level of knowledge in drug interactions and thought
> it would be available only in commercial software.
> Our drug provider and hospitals have requested software that could
> report if prescribed drugs or combinations could cause problems.
>
>
> I looked the software tools they use:
> "FreeMedForms and derivatives use :
> * C++ language
> * Qt4.5 libs
> * SQLite / MySQL
> * XML / HTML / ECMA Script
> * Bash for some scripts
> All the code documentation in writtent inside. the code. using the
> doxygen language. "
>
>
> I think our developers should look how to integrate this software with
> Care2x. In our east African version we have prescription module using drug
> list. But freediams can also be used to prescribe drugs.
>
>
> Mauri
>
>
> On 7 Oct 2010 at 16:08, an...@e-healthexpert.org wrote:
>
>
> > freediams: perform prescriptions and check for pharmaceutical drug
> > interactions: http://www.freemedforms.com/en/freediams_doc
> >
> > JA
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
> Date: Sat, 16 Oct 2010 10:15:57 +0530
> From: "Ap.Muthu" <apmu...@usa.net>
> Subject: Re: [Care2002-developers] Interesting: freediams, perform
> prescriptions and check for pharmaceutical drug interactions
> To: "Care2x - Dev List" <care2002-developers@lists.sourceforge.net>
> Message-ID: <e7c721c3c6324272ad8693bfbea2e...@barebone>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Attached is the revised (record duplications removed) MySQL schema and data
> for the FreeDIAMS SQLite database: drugs-en_US.db
>
> - Ap.Muthu
>
> On analysing the FreeDIAMS database, we find duplications in the DRUGS
> table:
>
> SELECT UID, COUNT(*) AS Records FROM DRUGS GROUP BY UID HAVING Records >
> 1;
> UID Records
> 21045002 2
> 21998001 2
> 78665001 2
>
> We also find that the COMPOSITION table has many UIDs duplicated, but
> unique if a compound key along with MOLECULE_CODE is used (other than for
> the above codes in duplicate in the DRUGS table).
>
> SELECT UID, MOLECULE_CODE, COUNT(*) AS Records FROM COMPOSITION GROUP BY
> UID, MOLECULE_CODE HAVING Records > 1;
> UID MOL_CODE Records
> 21045002 852 2
> 21998001 852 2
> 78665001 852 2
>
> The current USFDA page is at:
> http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm
> and the latest Database is at:
> dr...@fda Download File (ZIP - 1557KB) Last updated: 10/13/2010
>
> - Ap.Muthu
>
> Attached is the MySQL Schema and Data Dump taken from the FreeDIAMS
> SQLite drugs-en_US.db
> HTH
>
> Regards,
> Ap.Muthu
>
>
>
> Hi Dr Antas,
>
>
> Karibu sana !! (warm wellcome in swahili)
>
>
> I looked the site and it is really needed. It is really difficult to
> program when needs high level of knowledge in drug interactions and thought
> it would be available only in commercial software.
> Our drug provider and hospitals have requested software that could
> report if prescribed drugs or combinations could cause problems.
>
>
> I looked the software tools they use:
> "FreeMedForms and derivatives use :
> * C++ language
> * Qt4.5 libs
> * SQLite / MySQL
> * XML / HTML / ECMA Script
> * Bash for some scripts
> All the code documentation in writtent inside. the code. using the
> doxygen language. "
>
>
> I think our developers should look how to integrate this software with
> Care2x. In our east African version we have prescription module using drug
> list. But freediams can also be used to prescribe drugs.
>
>
> Mauri
>
>
> On 7 Oct 2010 at 16:08, an...@e-healthexpert.org wrote:
>
>
> > freediams: perform prescriptions and check for pharmaceutical drug
> > interactions: http://www.freemedforms.com/en/freediams_doc
> >
> > JA
> -------------- next part --------------
> An HTML attachment was scrubbed...
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: FreeDIAMS-MySQL.zip
> Type: application/x-zip-compressed
> Size: 546517 bytes
> Desc: not available
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
> Download new Adobe(R) Flash(R) Builder(TM) 4
> The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
> Flex(R) Builder(TM)) enable the development of rich applications that run
> across multiple browsers and platforms. Download your free trials today!
> http://p.sf.net/sfu/adobe-dev2dev
>
> ------------------------------
>
> _______________________________________________
> Care2002-developers mailing list
> Care2002-developers@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/care2002-developers
>
>
> End of Care2002-developers Digest, Vol 52, Issue 29
> ***************************************************
>
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
