XML to DBF Custom Route
Custom assembly:
D:\Engine\Sandfield.Messaging.CustomRoutes.DbfFile.XmlToDbf.dllCustom class:
Sandfield.Messaging.CustomRoutes.DbfFile.XmlToDbf.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