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>
Related Topics
