Latest revision as of 04:24, 1 August 2007

Xml file location

_Project-ID-Xxxx/xml/data/Data-ID-001.xml.xml

How to import Records into Any table

From command line execute: "build-ID-001.[bat|sh] data"

XML format

<table tablename="AD_ImpFormat">
    <row name="Import Loader Format" >
      <column name="AD_Client_ID" lookupvalue="System" />
      <column name="AD_Org_ID" lookupvalue="*" />
      <column name="IsActive" class="Boolean" value="true"/>
      <column name="CreatedBy" lookupcustom="System" lookupcustom_table="AD_User" lookupcustom_col="Name"  />
      <column name="UpdatedBy" lookupcustom="System" lookupcustom_table="AD_User" lookupcustom_col="Name"  />

      <column name="AD_Table_ID" lookupcustom="I_ImpFormat" lookupcustom_col="TableName" />
      <column name="FormatType" lookup_ref_list="AD_ImpFormat FormatType" ref_name="Comma Separated" />
    </row>
    <row name="Import Loader Format Row" >
      <column name="AD_Client_ID" lookupvalue="System" />
      <column name="AD_Org_ID" lookupvalue="*" />
      <column name="IsActive" class="Boolean" value="true"/>
      <column name="CreatedBy" lookupcustom="System" lookupcustom_table="AD_User" lookupcustom_col="Name"  />
      <column name="UpdatedBy" lookupcustom="System" lookupcustom_table="AD_User" lookupcustom_col="Name"  />

      <column name="AD_Table_ID" lookupcustom="I_ImpFormat_Row" lookupcustom_col="TableName" />
      <column name="FormatType" lookup_ref_list="AD_ImpFormat FormatType" ref_name="Comma Separated" />
    </row>
  </table>

  <table tablename="AD_ImpFormat_Row"> <!-- Import Loader Format -->
    <row name="Loader Format Name" 
         key1name="AD_ImpFormat_ID" lookupkey1name="Import Loader Format" key1Where="" key1SearchBy=""
         key2name="" lookupkey2name="" key2Where="" key2SearchBy="" 
         key3name="" lookupkey3name="" key3Where="" key3SearchBy="" 
         key4name="" lookupkey4name="" key4Where="" key4SearchBy="" 
    >
      <column name="AD_Client_ID" lookupvalue="System" />
      <column name="AD_Org_ID" lookupvalue="*" />
      <column name="IsActive" class="Boolean" value="true"/>
      <!--column name="Created" class="Date" value="" /-->
      <column name="CreatedBy" lookupcustom="System" lookupcustom_table="AD_User" lookupcustom_col="Name" />
      <!--column name="Updated" class="Date" value="" /-->
      <column name="UpdatedBy" lookupcustom="System" lookupcustom_table="AD_User" lookupcustom_col="Name" />

      <column name="AD_ImpFormat_ID" lookupname="Import Loader Format" />
      <column name="SeqNo" value="10" class="Integer" />
      <column name="AD_Column_ID" lookupcustom="Name" lookupcustom_table="AD_Column" lookupcustom_col="ColumnName" tableNameMaster="AD_Table" masterColumn="TableName" masterValue="I_ImpFormat" />
      <column name="DataType" lookup_ref_list="AD_ImpFormat_Row Type" ref_name="String" />
      <column name="DataFormat" value="" class="String" />
      <column name="StartNo" value="1" class="Integer" />
      <column name="EndNo" value="" class="Integer" />
      <column name="DecimalPoint" value="." class="String" />
      <column name="DivideBy100" value="N" class="String" />
      <column name="ConstantValue" value="" class="String" />
      <column name="Callout" value="" class="String" />
      <column name="Script" value="" class="String" />
    </row>
  </table>