Tutorials
In order to better understand how to create and use a Text File Schema Definition file, here is a brief tutorial using a very simple example of names and places from a fictional company called Smythee Estuary Importers. The sample file used is given below.
This example describes how to create and edit a Text File Schema Definition file using a plain text editor. You could also use a spreadsheet editor, an advanced text editor or a dedicated CSV editor.
It is highly recommended that while you are learning how to create a Text File Schema Definition, you go through them in the order presented here. Also, working through them in this order this is a good "road map" of how to build your own Text File Schema Definition for your own Text File.
| Record | Description |
|---|---|
| Minimal | This tutorial will show you how to build a Text File Schema Definition that will contain the absolute minimum of information required to define and validate the Tutorial Text File successfully. |
| Suggested | This tutorial will show you how to build a Text File Schema Definition that, in addition to the Minimal Text Fille Schema Definition previously completed, will also contain the suggested information used to define and validate the Tutorial Text File successfully. |
| Lists and Values | This tutorial will show you how to build a Text File Schema Definition that, in addition to the two tutorials previously completed, will also contain the information used to define and validate the Tutorial Text File using Lists and Values. |
| Conditions | This tutorial will show you how to build a Text File Schema Definition that, in addition to the three tutorials previously completed, will also contain the information used to define and validate the Tutorial Text File using Conditions. |
| Rules | This tutorial will show you how to build a Text File Schema Definition that, in addition to the four tutorials previously completed, will also contain the information used to define and validate the Tutorial Text File using Rules. |
| Reduce | This tutorial will show you how to reduce a Text File Schema Definition to make the Schema File size smaller after having completed all the previous tutorials. |
Tutorial Text File
last_name,first_name,state,zip_code,price,date,notes
Craig,Kai,OK,73755,15499,12/26/2019,"friendly, prompt and good tipper"
Wilcox,Jack,,,12458,7/14/2017,very nice
O'Neil,Kasper,WY,82937,15499,3/7/2011,paid by certified check
Marks,Sopoline,CT,06778,4859,8/21/2014,"never paid, do not do any further business"
Kelly,Colorado,,,9899,6/3/2018,</pre>