XML import

Stratford XML import.

Note that this is a working program however, we may change the format in the future if a standard is accepted. We cannot promise this, however, we probably will simply create a different format instead of breaking this one. It will depend on how many people use this program.

1. In your a/r folder: (ex: C:\Stratford\ssiwin\304911) put a control file named loadxml_xxxxx.ini - where xxxxx is something related to you such as loadxml_DrSmith.ini

Here is a sample of the contents:

[Data Conversion]

menuselection=Load O2Tester XML information

xmlFileLocation = C:\Stratford\ssiwin\304911\import\

PatientDemographics = DrSmith_Import.xml

hasXML=Yes

XMLraw=Yes

2. Somewhere on your computer put an XML file with information to be imported. In the example INI file above it has specified an XML file named DrSmith_Import.xml

Here is the full location of the file:

C:\Stratford\ssiwin\304911\import\DrSmith_Import.xml

Here is a sample of what might be in that file:

<?xml version="1.0" encoding="UTF-8"?>

<!--

You can put some comments anywhere outside the XMLDocument

and the program will ignore them.

If you use an XML syntax checker you will get an error unless you

enclose comments in the brackets as shown here.

I use Notepad++ with the XML plugin to test the syntax.

Note: you should not have a duplicate table inside an XMLSection

-->

<XMLDocument>

  <XMLSection>

     <m6nmpt>

        <ccode>10001</ccode>

        <cnmptcode>10001</cnmptcode>

        <clname>Jones</clname>

        <cfname>Sally</cfname>

        <cadd1>1234 Main Street</cadd1>

        <cadd2>Unit 2603</cadd2>

        <ccity>Las Vegas</ccity>

        <cstate>NV</cstate>

        <czip>89109</czip>

        <ccontry>USA</ccontry>

        <csex>F</csex>

        <ddob>01/01/1980</ddob>

        <cmarital>4</cmarital>

        <cssn>123121234</cssn>

     </m6nmpt>

      <m6veac>

        <ccode>04</ccode>     

     </m6veac>

     <m6ptp1>

     </m6ptp1>

     <m6nmco>

        <ccode>MCARE</ccode>

     </m6nmco>

     <m6ptin>

        <iptinorder>1</iptinorder>

        <crelatn>18</crelatn>

        <csignati>1</csignati>

        <csignatp>1</csignatp>

        <cassign>1</cassign>

        <cformtype>564</cformtype>

        <cinid>123121234A</cinid>

     </m6ptin>

     <m6nmco>

        <ccode>AETNA</ccode>

     </m6nmco>

     <m6ptin>

        <iptinorder>2</iptinorder>

        <crelatn>18</crelatn>

        <csignati>1</csignati>

        <csignatp>1</csignatp>

        <cassign>1</cassign>

        <cformtype>515</cformtype>

        <cinid>ABC1234567</cinid>

     </m6ptin>

  </XMLSection>

</XMLDocument>

If you are not familiar with the XML format, this may seem complex. I guess it is complex and you will probably need some help to get going. Our support agreement does not include help with things like this as it can be very involved. However, if you are a 'technical' person and you can look at this and it makes sense, we can probably help you get going. Please do not ask us to teach you to program as we do not have the resources to do that. Note that this XML import utility will allow you to import any information into any field in any data table without exception (Of course the data must be legal for that field - you can't import 'abc' into a date field). We have hundreds of data tables and thousands of fields so it is possible that you may want to import something that we have not yet programmed and/or we are not importing it correctly. In a case like that, we can't promise anything without knowing more, but our policy is to quickly change our software as necessary. This is not a blanket guarantee as this import utility is an optional program. If you do not have a current software support agreement, we will not be able to help you.

To get a list of the fields in each of the files, refer to a previous topic about the Database Structure (Export).