SRTransport Tutorial for OSX
Extracting Data through EOF
Abstract: Extracting data from a table to a file is a common operation. Doing this with your EO model is convenient because it is used constantly in your development tasks, and because it provides for simple, drag-and-drop extracts and imports.
This tutorial takes about 5 minutes to perform.
#1 - Drag your EO Model into SRTransport, Choose an Entity
If you're using EOModeler, you can just drag an entity directly into SRTransport.
SRTransport reads the model, and shows the columns.
#2 - Choose a File and a Format
Select Choose Destination from the Transport menu, and then File from the list of transport types.
Choose a file name and a folder.
Finally, set the format of the file to Default, as shown in this picture.
Close this window and return to the Transport window.
#3 - Set The Expressions
Choose Match-By-Name from the Transport menu to map input columns to output columns.
Edit the Value Expressions as you wish.
#4 - Transport Your Data
Click the transport button  .
In the Transporter Room, click the  button.
You have successfully created a data file from your entity.
Conclusion
This is a simple example of using SRTransport to extract data from a database. Of course, you can also load data from files into entities, or transport data from one entity to another.
Here are some others ways in which you might explore SRTransport's more advanced features.
Change the format of the file, deleting, renaming or adding columns.
Add a qualifier so that a subset of rows are exported.
Write expressions that modify the data as its transported. You can combine fields, split fields, perform math and string operations, etc.
Save this transport configuration in a .transport file.
Run your .transport configuration from the command line.
Build another transport in the oposite direction, in order to load your entity with data. Be sure to delete your existing data, otherwise primary key errors will occur.
Write validation rules so invalid records are rejected and written to a reject file.
Use SRBrowse with SRTransport to supercharge your data processing and analysis tasks.
| 
