Versions Compared

Old Version 6

changes.mady.by.user Unknown User (raybarlow)

Saved on

compared with

New Version Current

changes.mady.by.user Ashish Vijaywargiya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Data Files

...

Introduction

There is a data import tool in OFBiz called the DataFile tool. It uses XML files that describe flat file formats (including character delimited, fixed width, etc) and parses the flat files based on those definitions. So, by design it is somewhat like the Entity Engine. It uses a generic object to represent a row in the flat file. It includes features like a line type code for each line and can support hierarchical flat files (ie where parent/child relationships are implied by sub-records).

...

  • the record.name attribute must contain the name of the entity in which the records will be imported (for example: <record name="Product" limit="many">)
  • the field.name attribute must contain the name of the entity field in which the records will be imported (for example: <field name="productId" type="String"/>)

...

Code Block
<?xml version="1.0" encoding="UTF-8" ?>

<data-files xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="http://wwwofbiz.ofbizapache.org/dtds/datafiles.xsd">
    <data-file name="posreport" separator-style="fixed-length" type-code="text">
        <record name="tillentry" limit="many">
            <field name="tillCode" type="String" length="16" position="0"/>
            <field name="name" type="String" length="32" position="17"/>
            <field name="prodCode" type="String" length="12" position="63"/>
            <field name="quantity" type="String" length="8" position="76"/>
            <field name="totalPrice" type="String" length="8" position="85"/>
        </record>
    </data-file>
</data-files>

...

Code Block
<?xml version="1.0" encoding="UTF-8" ?>

<data-files xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="http://wwwofbiz.ofbizapache.org/dtds/datafiles.xsd">
    <data-file name="stockdata" separator-style="fixed-record" type-code="text" record-length="768">
        <record name="stockdataitem" limit="many">
            <field name="barcode" type="NullTerminatedString" length="12" position="0"/>
            <field name="prodCode" type="NullTerminatedString" length="12" position="68"/>
            <field name="price" type="LEInteger" length="4" position="80"/>
            <field name="name" type="NullTerminatedString" length="30" position="16"/>
        </record>
    </data-file>
</data-files>

...

Code Block
<?xml version="1.0" encoding="UTF-8"?>
<data-files xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="http://wwwofbiz.ofbizapache.org/dtds/datafiles.xsd">
    <data-file name="bacs-iscd" separator-style="delimited" type-code="text" delimiter="&#009;">........

...