<?xml version="1.0" encoding="UTF-8"?>
<transformation>
  <info>
    <name>Product - Suppliers</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>admin</modified_user>
  <modified_date>2007&#47;04&#47;09 17:01:13.040</modified_date>
    </info>
  <notepads>
    </notepads>
  <order>
  <hop> <from>Select values</from><to>Transform fields</to><enabled>Y</enabled> </hop>  <hop> <from>XBase input</from><to>Select values</to><enabled>Y</enabled> </hop>  <hop> <from>Transform fields</from><to>Filter rows</to><enabled>Y</enabled> </hop>  <hop> <from>Filter rows</from><to>Product Suppliers</to><enabled>Y</enabled> </hop>  <hop> <from>Filter rows</from><to>Dummy (do nothing)</to><enabled>Y</enabled> </hop>  </order>

  <step>
    <name>Product Suppliers</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>ID</idColumn><mapping><source>ID</source><target>&lt;entityRelationship.productSupplier>source</target><excludeNull>true</excludeNull><value>&lt;product.*>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>SUPPLIERID</source><target>&lt;entityRelationship.productSupplier>target</target><excludeNull>true</excludeNull><value>&lt;party.supplierorganisation>$value</value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>NAME</source><target>&lt;entityRelationship.productSupplier>reorderName</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>CODE</source><target>&lt;entityRelationship.productSupplier>reorderCode</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>LISTPRICE</source><target>&lt;entityRelationship.productSupplier>listPrice</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><mapping><source>PACKSIZE</source><target>&lt;entityRelationship.productSupplier>packSize</target><excludeNull>true</excludeNull><value></value><removeDefaultObjects>false</removeDefaultObjects></mapping><generateLookups>true</generateLookups><skipProcessed>true</skipProcessed><batchSize>1000</batchSize></mappings>     <cluster_schema/>
    <GUI>
      <xloc>630</xloc>
      <yloc>140</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Select values</name>
    <type>SelectValues</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
    <fields>      <field>        <name>INVENTNO</name>
        <rename>ID</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>PACKSIZE</name>
        <rename/>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>COSTPRICE</name>
        <rename>LISTPRICE</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>LSTSUPPLY</name>
        <rename>SUPPLIERID</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>ORDERCODE</name>
        <rename>CODE</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      <field>        <name>INVENTNAME</name>
        <rename>NAME</rename>
        <length>-2</length>
        <precision>-2</precision>
        </field>      </fields>     <cluster_schema/>
    <GUI>
      <xloc>180</xloc>
      <yloc>140</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>Transform fields</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
ID.setString(&quot;DRUG&quot; + ID.getString())

</jsScript_script>
        </jsScript>     </jsScripts>    <fields>      </fields>     <cluster_schema/>
    <GUI>
      <xloc>320</xloc>
      <yloc>139</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <step>
    <name>XBase input</name>
    <type>XBaseInput</type>
    <description/>
    <distribute>Y</distribute>
    <copies>1</copies>
         <partitioning>
           <method>none</method>
           <field_name/>
           <schema_name/>
           </partitioning>
    <file_dbf>F:\VETAID\INVENTY.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>65</xloc>
      <yloc>140</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>Product Suppliers</send_true_to>
<send_false_to>Dummy (do nothing)</send_false_to>
    <compare>
<condition>
 <negated>N</negated>
 <conditions>
  <condition>
   <negated>N</negated>
   <leftvalue>SUPPLIERID</leftvalue>
   <function>IS NOT NULL</function>
   <rightvalue/>
   </condition>
  <condition>
   <negated>N</negated>
   <operator>AND</operator>
   <leftvalue>SUPPLIERID</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>470</xloc>
      <yloc>141</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

  <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>469</xloc>
      <yloc>229</yloc>
      <draw>Y</draw>
      </GUI>
    </step>

</transformation>