Sections       PREVIOUS PAGE      NEXT PAGE

11 Copying, Deleting, Exporting, and Printing Registration List

You can extract registration data for use in other applications. The registration table view allows you to first prepare the display of the registrations before copying, exporting, or printing the data.

11.1 Copying and Pasting

You can copy the cells of the table view and paste it directly into another application like Notepad or Excel. You can copy the entire table, or a specific row, column, or cell.

11.1.1 Copying and Pasting the Entire Table

To copy the data in the table view and paste it into another software program:

    1. 1. Arrange the view of field columns as desired using methods described in Section 8. You can also leave the current view in the default view.
    2. 2. Right mouse click somewhere in the table view.
    3. 3. Select “Copy All” from the popup menu as shown in Figure 34.
    4. 4. Access the software program where you want to paste the data (for example, Excel).
    5. 5. Execute the Paste command to put the data into the target file. In Windows, this command can be executed by the shortcut CTRL-V.
    6. Figure 34. Copy Functions of Registration Table View

       

11.1.2 Copying and Pasting a Specific Row, Column, or Cell

To copy a specific row in the table view, right mouse click on a cell in the desired row and select “Copy Row” from the popup menu shown in Figure 34. To copy a specific column, right mouse click on a cell in the desired column and select “Copy Column” from the popup menu. To copy a specific cell, right mouse click on the desired cell and select “Copy Cell” from the popup menu.

11.2 Exporting to a File

11.2.1 Types of Export Files

You can export the registration into a tab-delimited text file. Once the data is in this format, you can import the data into software programs like Excel. There are two different ways to present the data in export file. The selected type will determine how the categories fields will be saved in the export file.

Figure 35. Select Export Type

 

11.2.2 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. 1. Arrange the view of field columns as desired using methods described in Section 8. You can also leave the current view in the default view.
    2. 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. 3. Select the export file type “Division codes” in the “Select Export Type” window of Figure 35.
    4. 4. Browse for the directory where the export file will be saved.
    5. 5. Enter a name for the file, and give it a file extension of “txt”.

11.2.3 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:

The are 8 exported fields related to the “ADULT” category are as follows:

To export the registrations from the table view using separate fields for each category field:

    1. 1. Arrange the view of field columns as desired using methods described in Section 8. You can also leave the current view in the default view.
    2. 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. 3. Select the export file type “Separate columns for each field” in the “Select Export Type” window of Figure 35.
    4. 4. Browse for the directory where the export file will be saved.
    5. 5. Enter a name for the file, and give it a file extension of “txt”.
    6. 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. 7. Click “Ok”.
    8. 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. 9. Click “Ok” to complete the export.

11.3 Printing

You can print the registration list directly from the table view. To do this:

    1. 1. Run the Administration Software. You can print the registration list from the local database or server database using the full version or the web version. You do not have to be logged into the server to print data from the local database.
    2. 2. Arrange the view of field columns as desired using methods described in Section 8. You can also leave the current view in the default view.
    3. 3. Right mouse click somewhere on the table view and select “Print” from the popup menu. Alternatively, if you are on the “Registrations” tab of the full version, you can click on the “Print” button that appears at the bottom of the table view.
    4. 4. Select the paper orientation of “Portrait” or “Landscape” from the print options. It may
    5. 5. Select the desired printer.
    6. 6. Click “Ok” to send the print job to the printer print.
Sections       PREVIOUS PAGE      NEXT PAGE