Converting ICD10 between wiki and ccmdb.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Ttenbergen moved page Converting ICD10 between wiki and ccmdb.mdb to Converting ICD10 between wiki and ccmdb.accdb without leaving a redirect: Text replacement - "ccmdb.mdb" to "ccmdb.accdb")
m (Text replacement - " ccmdb.accdb" to " CCMDB.accdb")
 
Line 1: Line 1:
The wiki is the master record for ICD10 diagnoses. Occasionally it needs to be dumped into [[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 ==
== from wiki to [[CCMDB.accdb]] ==
'''See [[S_ICD10_table#Query_to_populate_from_wiki]] for actual process, the following are just notes. '''
'''See [[S_ICD10_table#Query_to_populate_from_wiki]] for actual process, the following are just notes. '''


Line 18: Line 18:
This should not be necessary as long as the dx names always correspond to the page name on the wiki.
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 ==
== from [[CCMDB.accdb]] to wiki ==
Since the wiki is the master this should never be needed.  
Since the wiki is the master this should never be needed.  



Latest revision as of 21:28, 2020 July 24

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.