Flat file exchange using dataports
Although dataports have been dropped in favor of the more useful XMLport, there are still plenty of customers that are on versions where XMLports are not available. This recipe will show you how to create a basic dataport for importing and exporting data.
How to do it...
Create a new dataport from Object Designer.
Add a data item for the Customer table.
With the Customer Data Item selected, click on View |Dataport Fields (Alt + V, D).
Add the following fields to the Field Designer window.
Enabled
SourceExpr
StartPos
Width
Yes
"No."
0
0
Yes
Name
0
0
Your dataport should look similar to the following screenshot:
With a new, blank line selected in the dataport click on View | Properties (Shift + F4).
Set the following properties for the dataport:
Property
Value
FieldStartDelimeter<None>
FieldEndDelimeter<None>
FieldSeparator<TAB>
Save and close the dataport.
How it works...
In many programming languages you have to manually...
