Saved CSV Import Maps XML Definition Example
The following is a SuiteCloud Development Framework (SDF) XML definition example of a savedcsvimport
SDF custom object that maps fields in a CSV file to fields on the Sales Order record type:
<savedcsvimport scriptid="custimport_salesorder">
<recordtype>SALESORDER</recordtype>
<importname>Sales Order Import</importname>
<datahandling>ADDUPDATE</datahandling>
<columndelimiter>PIPE</columndelimiter>
<transactionform>[scriptid=custform_csv_import]</transactionform>
<description>Sales Order Import</description>
<decimaldelimiter>COMMA</decimaldelimiter>
<filemappings>
<filemapping>
<file>SALESORDER</file>
<primarykey>ID</primarykey>
</filemapping>
<filemapping>
<file>SALESORDER:ITEMS</file>
<foreignkey>Transaction ID</foreignkey>
</filemapping>
</filemappings>
<recordmappings>
<recordmapping>
<record>SALESORDER</record>
<fieldmappings>
<fieldmapping>
<field>STDEMAIL</field>
<value>jmiller@example.com</value>
</fieldmapping>
<fieldmapping>
<field>STDMEMO</field>
<value/>
</fieldmapping>
<fieldmapping>
<field>STDPHONE</field>
<columnreference>
<file>SALESORDER</file>
<column>Phone Number</column>
</columnreference>
</fieldmapping>
<fieldmapping>
<field>STDCUSTOMER</field>
<columnreference>
<file>SALESORDER</file>
<column>Customer EID</column>
<type>EXTERNAL_ID</type>
</columnreference>
</fieldmapping>
</fieldmappings>
</recordmapping>
<recordmapping>
<record>SALESORDER:ITEMS</record>
<fieldmappings>
<fieldmapping>
<field>STDAMOUNT</field>
<columnreference>
<file>SALESORDER:ITEMS</file>
<column>Items Amount</column>
</columnreference>
</fieldmapping>
</fieldmappings>
</recordmapping>
</recordmappings>
</savedcsvimport>