Re: [Gnumed-bugs] <bug>: Import

[Karsten Hilbert]

Hello ALI,

> InternalError: => Cannot set address [LB, AG, Beirt, 961].

..

> PL/pgSQL function "create_address" line 14 at SQL statement

..

> 2011-07-16 23:11:59  DEBUG     gm.logging 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmlog2::log_stack_trace()
>  #155): >>> execution frame [link_address] in 
> [C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.business.gmPerson]
>  at line 1035 <<<

...

> 2011-07-16 23:11:59  DEBUG     gm.logging 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmlog2::log_stack_trace()
>  #155): >>> execution frame [create_address] in 
> [C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.business.gmDemographicRecord]
>  at line 412 <<<

...

> 2011-07-16 23:11:59  DEBUG     gm.logging 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmlog2::log_stack_trace()
>  #170):                 vars = {'urb': u'Beirt', 'country': u'LB', 'number': 
> u'03546565', 'state': u'AG', 'street': u'Malla', 'postcode': u'961', 
> 'subunit': None}

Did you add any Lebanese demographics to the GNUmed
database? (Did you want to say "Beirut" rather than "Beirt"?

If you did not this:

>               select dem.create_address (
>                       %(number)s,
>                       %(street)s,
>                       %(postcode)s,
>                       %(urb)s,
>                       %(state)s,
>                       %(country)s,
>                       %(subunit)s
>               )

will not work because GNUmed does not come with Lebanese
data pre-defined.

Let us know if you have Lebanese data so we can add it.

> 2011-07-17 00:44:24  INFO      gm.meds 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.business.gmmedication::__init__()
>  #897): Gelbe Liste/MMI v8.2 interface (native Windows)
> 2011-07-17 00:44:24  DEBUG     gm.shell 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmshellapi::run_command_in_shell()
>  #99): shell command >>>C:\Programme\MMI PHARMINDEX\glwin.exe -KEEPBACKGROUND 
> -PRESCRIPTIONFILE C:\Documents and Settings\ALI\.gnumed\tmp -CLOSETOTRAY<<<
> 2011-07-17 00:44:24  DEBUG     gm.shell 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmshellapi::run_command_in_shell()
>  #100): blocking: True
> 2011-07-17 00:44:24  DEBUG     gm.shell 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmshellapi::run_command_in_shell()
>  #101): acceptable return codes: [0]
> 2011-07-17 00:44:24  INFO      gm.shell 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmshellapi::run_command_in_shell()
>  #131): running shell command >>>C:\Programme\MMI PHARMINDEX\glwin.exe 
> -KEEPBACKGROUND -PRESCRIPTIONFILE C:\Documents and Settings\ALI\.gnumed\tmp 
> -CLOSETOTRAY<<<
> 2011-07-17 00:44:25  DEBUG     gm.shell 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmshellapi::run_command_in_shell()
>  #134): os.system() returned: [1]
> 2011-07-17 00:44:25  ERROR     gm.shell 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.pycommon.gmshellapi::run_command_in_shell()
>  #139): platform does not support exit status differentiation
> 2011-07-17 00:44:25  ERROR     gm.meds 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.business.gmmedication::switch_to_frontend()
>  #980): problem switching to the MMI drug database

You need the German Gelbe Liste/MMI drug database installed
in order to use it.

> 2011-07-17 00:44:25  DEBUG     gm.gui 
> (c:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outpyz1.pyz\gnumed.wxpython.gmexceptionhandlingwidgets::handle_uncaught_exception_wx()
>  #152): unhandled exception caught:
> Traceback (most recent call last):
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.wxpython.gmListWidgets",
>  line 235, in _on_left_extra_button_pressed
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.wxpython.gmMedicationWidgets",
>  line 784, in add_from_db
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.business.gmMedication",
>  line 1022, in import_drugs
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.business.gmMedication",
>  line 957, in create_data_source_entry
>   File 
> "C:\workplace\gnumed-client.0.9.6\build\pyi.win32\setup\outPYZ1.pyz/Gnumed.business.gmMedication",
>  line 923, in get_data_source_version
> IOError: [Errno 2] No such file or directory: 'C:\\Programme\\MMI 
> PHARMINDEX\\datadate.txt'

This is now handled more gracefully. Thanks for reporting.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346