XML to DBF Custom Route


An example of the expected XML file:

<DBFFile>

    <Header>

        <Version>FoxBaseDBase3NoMemo</Version>

    </Header>

    <Fields>

        <Field>

            <Name>AAA</Name>

            <Type>Integer</Type>

            <Length>5</Length>

        </Field>

        <Field>

            <Name>BBB</Name>

            <Type>Date</Type>

            <Length>50</Length>

        </Field>

        <Field>

            <Name>CCC</Name>

            <Type>Currency</Type>

            <Length>10</Length>

        </Field>

    </Fields>

    <Rows>

        <Row>

            <Data Name='BBB'>2024-01-02</Data>

            <Data Name='AAA'>100</Data>

        </Row>

    </Rows>

</DBFFile>


The complete list of available Version values:

    FoxBase

    FoxBaseDBase3NoMemo

    VisualFoxPro

    VisualFoxProWithAutoIncrement

    dBase4SQLTableNoMemo

    dBase4SQLSystemNoMemo

    FoxBaseDBase3WithMemo

    dBase4WithMemo

    dBase4SQLTableWithMemo

    FoxPro2WithMemo

    FoxBASE 


The complete list of all Field Types: (The Memo type is for the DBF versions ending with "WithMemo")

    Character

    Currency

    Numeric

    Float

    Date

    DateTime

    Double

    Integer

    Logical

    Memo