Index>

20150506-oddb2xml-galenicFor

Summary

• oddb2xml: Use parslet to split column_C of packages into preparation_name and galenic_form
• oddb.org: Use only non-digit part of drug names for sorting

Commits

• https://github.com/ngiger/oddb2xml/commit/fe2f4243cb373934718188f46a377a097fe8845b Added some translation for doc
• https://github.com/ngiger/oddb2xml/commit/20f747e89a961fc49c8457449f705212943a3507 Most galenic_forms are now correct
• https://github.com/ngiger/oddb.org/commit/d8e21e8948e94abd454feee2c1cc51d81194fe52 Results are sorted ignoring all digits

Index

• oddb2xml: Use parslet to split column_C of packages into preparation_name and galenic_form
• oddb.org: Use only non-digit part of drug names for sorting

Keep in Mind for work to do

• Fix dojo error http://www.sitepen.com/blog/2012/10/31/debugging-dojo-common-error-messages/#forgot-dom-ready
• I removed on May-27 tests for ix_registrationss, fix_sequences, fix_compositions, fix_packages from test/test_plugin/swissmedic.rb,as he could not find any references for them in the src code. Did I erroneously remove stuff when cleaning up the swissmedic import earlier?
• The whole test for older/newer Packages must be adapted to xlsx. One must compare the rows (e.g. by creating csv files) and do the same stuff in xlsx!
• creat gem: task: input=file with ean-codes, standard output show ean-codes + atc-code. Source is Swissmedic Packungen.xlsx or XML.
• Import via data/medreg_companies.yaml
• Fix problem with radioactivatum 99m-technetio when parsing Wirkstoffe
• Fix galenic_forms when parsing swissmedic.xlsx
• Cleanup generic_type. Replace it everywhere by sl_generic_type and adapt code accordingly.

oddb.org: Use only non-digit part of drug names for sorting

We want to change the sort order of

Keppra 100mg/ML Flaschen
Keppra 1000 mg Tabletten
Keppra 250 mg Tabletten
Keppra 500 mg Tabletten

to

Keppra 250 mg Tabletten
Keppra 500 mg Tabletten
Keppra 1000 mg Tabletten
Keppra 100mg/ML Flaschen

Done with commit Results are sorted ignoring all digits

oddb2xml: Use parslet to split column_C of packages into preparation_name and galenic_form

Reworking the parslet parser for galenic_form to handle exceptions better.

Updated documentation with translation of latin words, see Added some translation for doc

Reduced number of lines unable to parse to 17. Looking at the generated gal_forms I still have some errors. Adding these to the spec-tests, eg. are

Arkocaps Passiflore/Passionsblume, 300 mg, capsules
Tuberkulin PPD RT 23 SSI, 10TE/0.1 ml, Injektionslösung
Alk7 Frühblühermischung, Depotsuspension zur s.c. Injektion "1 Flasche A + B"

These examples work. All lines can be parsed, but (among others) I must correct the following lines

Nitroderm TTS 10 
Methrexx 7.5 mg / 0.75 ml,Injektionslösung in Fertigspritzen
Phytopharma foie et bile capsules/Leber-Galle Kapseln
Sulfure de Rhénium (186Re)-RE-186-MM-1 Cis bio International
Amoxicillin Sandoz 100mg/4ml,Granulat zur Herst.einer Suspension

Pushed commit Most galenic_forms are now correct. oddb2xml --calc still does NOT use the new parslet for the preparation-name and galenic_form. This will come next week.