14.1 Export using Division Codes
The first type exports the fields exactly as it is on the table view. Any category fields that are displayed in the table view are displayed the same way in the export file, which is using division codes.
To export the registrations from the table view exactly as you see it in the table view:
-
1. Arrange the view of field columns as desired using methods. Use the “Change View” function of the right mouse click menu to add missing fields. You can also leave the current view in the default view.
-
2. Click on the “Export” button at the bottom of the table view. Alternatively, right mouse click on the table view and select “Export” from the popup menu.
-
3. Select the export file type “Division codes” in the “Select Export Type” window of Figure 40.
-
4. Browse for the directory where the export file will be saved.
-
5. Enter a name for the file, and give it a file extension of “txt”.
14.2 Export using Separate Category Fields
The second type exports the standard registration fields allows you to export the each category field as its own field. The exported value of each field would be the full item name instead of division code.
For example, the category “ADULT” may have the following properties:
-
1 select field for the rank called “Belt”
-
3 select fields for the weight divisions called “18YRS”, “30YRS”, “40YRS”
-
2 checkbox fields called “Move up in weight” and “Move down in age”.
-
1 input field called “FREE entry name”
-
1 radio field called “T-shirt size”
The are 8 exported fields related to the “ADULT” category are as follows:
-
“ADULT:Belt”: Sample field values can be “White” and “Blue”
-
“ADULT:18YRS”: Sample field values can be “Light”, “Medium”, and “Heavy”
-
“ADULT:30YRS”: Sample field values can be “Light” and Heavy”
-
“ADULT:40YRS”: Sample field values can be “Light” and Heavy”
-
“ADULT:Move up in weight”: The value for this export fields is either blank or “Y”
-
“ADULT:Move down in age”: The value for this export fields is either blank or “Y”
-
“ADULT:FREE entry name”: Sample field values can be “John Smith” or “Jenny”
-
“ADULT:T-shirt size”: Sample field values can be “Medium” or “Large”
To export the registrations from the table view using separate fields for each category field:
-
1. Arrange the view of field columns as desired using methods. Use the “Change View” function from the right mouse click menu to add missing fields. You can also leave the current view in the default view.
-
2. Click on the “Export” button at the bottom of the table view. Alternatively, right mouse click on the table view and select “Export” from the popup menu.
-
3. Select the export file type “Separate columns for each field” in the “Select Export Type” window of Figure 40.
-
4. Browse for the directory where the export file will be saved.
-
5. Enter a name for the file, and give it a file extension of “txt”.
-
6. Select the standard registrations fields that will appear in the selection window. Ensure that all the desired fields appear on the right, and that fields you don’t want in the export file should be moved to the left. The list of available registrations will be limited to the fields that are in the current table view. If a field that you want in the export file is not on this selection of available fields, then cancel out of the export and use the “Change View” function to add the field to the current table view.
-
7. Click “Ok”.
-
8. Select the category fields that you want to included in the export file. Each category field is represented by a line in the selection window, with the related category in the prefix.
-
9. Click “Ok” to complete the export.
