Converting ICD10 between wiki and ccmdb.accdb: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== from wiki to | 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 | ||
If I want to export the URLS I need to use the template format. {{fullurl:}} | 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 | 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 | == 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. | |||
[[Category: IT Instructions]] | [[Category:IT Instructions]] | ||
[[Category: ICD10]] | [[Category:ICD10]] | ||
Latest revision as of 10:32, 30 July 2025
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.