Difference between revisions of "ADCK Any Table"
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
m |
m (→XML format) |
||
Line 28: | Line 28: | ||
<column name="AD_Table_ID" lookupcustom="I_ImpFormat_Row" lookupcustom_col="TableName" /> | <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" /> | <column name="FormatType" lookup_ref_list="AD_ImpFormat FormatType" ref_name="Comma Separated" /> | ||
+ | </row> | ||
+ | </table> | ||
+ | </pre> | ||
+ | |||
+ | <pre> | ||
+ | <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="" key1Where="" key1SearchBy="" | ||
+ | key3name="" lookupkey3name="" key1Where="" key1SearchBy="" | ||
+ | key4name="" lookupkey4name="" key1Where="" key1SearchBy="" | ||
+ | > | ||
+ | <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> | </row> | ||
</table> | </table> | ||
</pre> | </pre> |
Revision as of 04:23, 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="" key1Where="" key1SearchBy="" key3name="" lookupkey3name="" key1Where="" key1SearchBy="" key4name="" lookupkey4name="" key1Where="" key1SearchBy="" > <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>