Converting ICD10 between wiki and ccmdb.accdb

The wiki is the master record for ICD10 diagnoses. Occasionally it needs to be dumped into CCMDB.accdb.

from wiki to CCMDB.accdb

See S_ICD10_table#Query_to_populate_from_wiki for actual process, the following are just notes.

generate SMW output using

 | format=dsv
 | filename=ICD10_wiki_to_table.txt
 | sep=;

eg S ICD10 table#Query to populate from wiki

Import as delimited text using delimiter semicolon

If I want to export the URLS I need to use the template format.

{{fullurl:}} 

https://www.mediawiki.org/wiki/Help:Magic_words#URL_data This should not be necessary as long as the dx names always correspond to the page name on the wiki.

from CCMDB.accdb to wiki

Since the wiki is the master this should never be needed.

There is no clean way to do is since the wiki will have had edits and questions and such. Changes will have to be propagated manually.

One last ditch possibility might be to export all dxs, programmatically edit the export, and then re-import all.