ADCK Any Table
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
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>