<?xml version="1.0" encoding="UTF-8"?>
<transformation>
  <info>
    <name>Practice - Users</name>
    <directory>&#47;</directory>
    <log>
      <read/>
      <write/>
      <input/>
      <output/>
      <update/>
      <connection/>
      <table/>
      <use_batchid>Y</use_batchid>
      <use_logfield>N</use_logfield>
      </log>
    <maxdate>
      <connection/>
      <table/>
      <field/>
      <offset>0.0</offset>
      <maxdiff>0.0</maxdiff>
      </maxdate>
    <size_rowset>1000</size_rowset>
    <sleep_time_empty>1</sleep_time_empty>
    <sleep_time_full>1</sleep_time_full>
    <unique_connections>N</unique_connections>
    <feedback_shown>Y</feedback_shown>
    <feedback_size>5000</feedback_size>
    <using_thread_priorities>Y</using_thread_priorities>
    <shared_objects_file/>
    <dependencies>
      </dependencies>
    <partitionschemas>
      </partitionschemas>
    <slaveservers>
      </slaveservers>
    <clusterschemas>
      </clusterschemas>
  <modified_user>-</modified_user>
  <modified_date>2007&#47;04&#47;20 14:09:23.197</modified_date>
    </info>
  <notepads>
    </notepads>
  <order>
  <hop> <from>User Input</from><to>Select User Fields</to><enabled>Y</enabled> </hop>  <hop> <from>Transform Users</from><to>OpenVPMS User Output</to><enabled>Y</enabled> </hop>  <hop> <from>Select User Fields</from><to>Filter rows</to><enabled>Y</enabled> </hop>  <hop> <from>Filter rows</from><to>Transform Users</to><enabled>Y</enabled> </hop>  <hop> <from>Filter rows</from><to>Dummy (do nothing)</to><enabled>Y</enabled> </hop>  </order>

  <step>
    <name>Dummy (do nothing)</name>
    <type>Dummy</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
     <cluster_schema/>
    <GUI>
      <xloc>354</xloc>
      <yloc>218</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Filter rows</name>
    <type>FilterRows</type>
    <description/>
    <distribute>N</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
<send_true_to>Transform Users</send_true_to>
<send_false_to>Dummy (do nothing)</send_false_to>
    <compare>
<condition>
 <negated>N</negated>
 <conditions>
  <condition>
   <negated>N</negated>
   <leftvalue>USERID</leftvalue>
   <function>IS NOT NULL</function>
   <rightvalue/>
   </condition>
  <condition>
   <negated>N</negated>
   <operator>AND</operator>
   <leftvalue>USERID</leftvalue>
   <function>&lt;&gt;</function>
   <rightvalue/>
   <value><name>constant</name><type>String</type><text/><length>-1</length><precision>-1</precision><isnull>N</isnull></value>   </condition>
  </conditions>
 </condition>
    </compare>
     <cluster_schema/>
    <GUI>
      <xloc>354</xloc>
      <yloc>140</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>OpenVPMS User Output</name>
    <type>OpenVPMSLoaderPlugin</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
<mappings><connection>OpenVPMS</connection><idColumn>USERID</idColumn><mapping><source>USERID</source><target>&lt;security.user>username</target><excludeNull>false</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>USERID</source><target>&lt;security.user>password</target><excludeNull>false</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>USERNAME</source><target>&lt;security.user>name</target><excludeNull>false</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>ACTIVE</source><target>&lt;security.user>active</target><excludeNull>false</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>VET</source><target>&lt;security.user>classifications[0]</target><excludeNull>true</excludeNull><value>&lt;lookup.userType>code=$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><generateLookups>false</generateLookups><skipProcessed>true</skipProcessed><batchSize>1000</batchSize></mappings>     <cluster_schema/>
    <GUI>
      <xloc>596</xloc>
      <yloc>137</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Select User Fields</name>
    <type>SelectValues</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
    <fields>      <field>        <name>USERID</name>
        <rename/>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>USERNAME</name>
        <rename/>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>CONSVET</name>
        <rename/>
        <length>-2</length>
        <precision>-2</precision>
        </field>      </fields>     <cluster_schema/>
    <GUI>
      <xloc>247</xloc>
      <yloc>137</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Transform Users</name>
    <type>ScriptValueMod</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
    <script/>
    <jsScripts>      <jsScript>        <jsScript_type>0</jsScript_type>
        <jsScript_name>Script 1</jsScript_name>
        <jsScript_script>&#47;&#47;Script here

var ACTIVE = true
var VET = null
if (CONSVET.getBool() == true) {
	VET = &quot;CLINICIAN&quot;
}</jsScript_script>
        </jsScript>     </jsScripts>    <fields>      <field>        <name>ACTIVE</name>
        <rename>ACTIVE</rename>
        <type>Boolean</type>
        <length>-1</length>
        <precision>-1</precision>
        </field>      <field>        <name>VET</name>
        <rename>VET</rename>
        <type>String</type>
        <length>-1</length>
        <precision>-1</precision>
        </field>      </fields>     <cluster_schema/>
    <GUI>
      <xloc>485</xloc>
      <yloc>137</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>User Input</name>
    <type>XBaseInput</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
    <file_dbf>${VETAID_DATA}&#47;USER.DBF</file_dbf>
    <limit>0</limit>
    <add_rownr>N</add_rownr>
    <field_rownr/>
    <include>N</include>
    <include_field/>
    <accept_filenames>N</accept_filenames>
    <accept_field/>
    <accept_stepname/>
     <cluster_schema/>
    <GUI>
      <xloc>118</xloc>
      <yloc>137</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

</transformation>