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

mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
== from wiki to ccmdb.mdb ==
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   
generate SMW output using   
<pre>
<pre>
Line 10: Line 14:
Import as delimited text using delimiter semicolon
Import as delimited text using delimiter semicolon


== from ccmdb.mdb to wiki ==
If I want to export the URLS I need to use the template format. <pre>{{fullurl:}} </pre>
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.


Uses
One last ditch possibility might be to export all dxs, programmatically edit the export, and then re-import all.
* input table ''s_ICD10_for_wiki_import''
* VBA code ''which''
* query ''which''
* to generate output table 1s




[[Category: IT Instructions]]
[[Category:IT Instructions]]
[[Category: ICD10]]
[[Category:ICD10]]