what seems to be working is to change import gmPG2 to import gmPG in pycommon/gmCfg.py as you mentioned psycopg doesn't work on windows in the wiki does it now ? On Mon Sep 25 21:04 , Sebastian Hilbert sent:
>On Monday 25 September 2006 14:57, Syan Tan wrote: >> ----- Original Message ----- >> From: Syan Tan [EMAIL PROTECTED]> >> To: Karsten Hilbert [EMAIL PROTECTED]> >> Sent: Mon Sep 25 20:56 >> Subject: Fwd: Re: [Gnumed-devel] revisited tweak for v_emr_journal >> >> >> I substituted "v_pat_items vpi" with "v_pat_episodes vpi" , >> and with clin.clin_narrative join v_pat_items , I used clin.v_pat_narr3 >> or clin.v_narrative_soap ; >> >> my installation was also slow because blobs.med_doc was missing id_patient >> index. and creating this index fixed a slow documents browser tab. >> >> Some usability wishes :- embedded mime applications within gnumed, >> addresses displayed on patient searches, patient search displays >> surname/firstname in alphabetical order; >> ? dates of encounters following episode titles in emr browser. >> >> BTW, I have tried to bootstrap gnumed on a windows machine at work, >> and am having a hard time getting python from the bootstrap directory >> to see where the link to client directory, >> Gnumed package, is. >> >> Any suggestions ? >I do this all the time without probs. In the wiki i recently added: > >You need to add python and postgresql (bin directorytory) to your path. >Do this via System preferences environment variables > >then bootstrap via the menu shortcut. > >If it fails open the shortcuts properties and copy the path created by the >install. > >than open a shell (start-->run app--> cmd) >and paste the string. > >It should bootstrap or show the error > >I have had a few people that simply needed to add python and postgresql to >their path. > >> >> Getting pyPgSQL package on a windows installation of windows to work also >> was a problem, I think I had to copy all the DLL files from postgresql into >> the pyPgSQL site-packages directory. >Use pypgsql 2.3 instead of the latest version. Soon we will move away from >pypgsql anyway. psycopq doesn't work well right now. Karsten and I need to >fix this on Windows >> >> This python path finding problem is almost as diabolical as java paths , >> would put most end users off , I think. >It's not hard. I already detect this in my installer. I just need to modify >the path in my next release. No magic whatsoever. i had many people install >it latetly. I always boils down to adding the above to your path >> >> On Mon Sep 25 13:10 , Karsten Hilbert [EMAIL PROTECTED]> sent: >> >On Mon, Sep 25, 2006 at 09:06:01AM +1000, syan tan wrote: >> >> there is actually no need to make gnumed asynchronous ; >> > >> >Good to know ! >> > >> >> what is required if optimization is wanted is to tweak the views so that >> >> sequential scanning on tables with tens of thousands of rows is not >> >> done. >> > >> >Yes. >> > >> >> Then emr journal ( as well as emr browser) will work in >> >> even the largest history in my test data. ( 6 years, almost weekly). >> > >> >That's pretty amazing. >> > >> >> One of the common join conditions is on clin_root_item.pk_item = >> >> T.pk_item where T is a table or view , but examination shows that the >> >> views only want tables from v_pat_episodes, which has been optimized in >> >> the previous post . >> >> >> >> manually, this came up with v_emr_journal, v_hx_family, >> >> v_lab_requests, and I think that was all. >> > >> >Assuming I added the IS NULL index on v_pat_episodes is >> >there anything else I need to do to the views you mention >> >here ? Or is it just the list that needs to be re-created >> >when dropping v_pat_episodes ? >> > >> >Karsten >> >-- >> >GPG key ID E4071346 @ wwwkeys.pgp.net >> >E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 >> > >> > >> >_______________________________________________ >> >Gnumed-devel mailing list >> >[email protected] >> >http://lists.gnu.org/mailman/listinfo/gnumed-devel >> >> _______________________________________________ >> Gnumed-devel mailing list >> [email protected] >> http://lists.gnu.org/mailman/listinfo/gnumed-devel > >-- >Sebastian Hilbert >Leipzig / Germany >[www.gnumed.de] -> PGP welcome, HTML ->/dev/null >Faire Angebote beim Internetshoppen gibt es in meinem Onlineshop >fairdeal.profiseller.de > > >_______________________________________________ >Gnumed-devel mailing list >[email protected] >http://lists.gnu.org/mailman/listinfo/gnumed-devel _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
