Exporting the Contents of a Grid or Form

You can export the contents of a grid or form, or even the contents of the entire source table for the grid or form. (For example, you can export the contents of the grid to another database or to a backup source.) You can choose whether the information will be exported into a comma-separated value file, a text file, or as a SQL insert script.

To export the contents of a grid or form

1 Start a process that uses grids or forms.

Horizon displays the grid for the process you chose.

2 Do one of these options:

To do this

Do this

Export information in a grid

1 To highlight more than one row or column at a time, press CTRL and click on each row or column.
2 If you want to choose certain rows or columns of the grid to export, click on each row or column to highlight it.
3 Click the Grid options menu button (  ).

Export information in a form

1 Find the form you want.
2 Right-click on the form.
3 Choose Export.

Horizon displays the Export to File window:

4 Complete these fields:

Field

Action

Export file name

Enter or browse to the path where you want to export the file.

Export codepage

Choose the codepage of the database to which you want to export. (For more information on the codepage, see your database’s SQL documentation.)

Row Selection

Do one of these options:

To export all the rows in the table, choose All Table Rows.

This option exports all information for all of the rows in a table, regardless of what Horizon displays in the grid.

To export all of the rows displayed in the grid, choose All Grid Rows.

This option exports every row that Horizon currently displays in the grid.

If you highlighted certain rows in the grid, choose Selected Grid Rows.

This option exports only the rows that you highlighted in the grid.

Note: If you use this option, you can also export selected columns by also highlighting the columns you want to export and clicking Selected Grid Columns.

To use an SQL statement to choose specific rows to export, choose Select Table Rows ‘where’, then enter the conditions by which you want to limit the list.

You can use Boolean operators to enter two or more criteria. If you do not enter a “where” statement, Horizon exports the entire table.

Column Selection

Do one of these options:

To export all the columns in the table, choose All Table Columns.

This option exports all information for all of the columns in a table, regardless of what Horizon displays in the grid.

To export all the currently visible columns in the grid, choose All Grid Columns.

This option exports every column that Horizon currently displays in the grid. You may need to unhide certain columns in the grid that may be hidden.

If you highlighted certain columns in the grid, choose Selected Grid Columns.

This option exports only the columns that you highlighted in the grid.

Note: If you use this option, you can also export selected rows by also highlighting the rows you want to export and clicking Selected Grid Rows.

If you want to choose from a list of columns to export, choose Select Columns, then choose the columns you want to export and click OK.

Export File Type

Do one of these options:

If you want to export the information into a comma-separated value file (.csv), choose Comma-Delimited (.csv).

This option exports the complete information, regardless of length.

If you want to export the information into a text file (.txt) with fixed-length fields, choose Length-Delimited.

This option exports the information up to a certain length; therefore, some of the information may be cut off in the exported file.

If you want to use an SQL script to export the information to another database, choose SQL Script (.sql), then continue with step 5.

Include Column Header

If you chose a Comma-Delimited (.csv) or Length-Delimited (.txt) export file type and if you want to include column headers with the exported information, mark this box.

5 If you chose SQL Script (.sql) at the Export File Type field and want to enter specific export criteria, complete these fields; otherwise, continue with the next step.

Note: Even if you chose SQL Script (.sql) as the Export File Type, you do not need to complete these fields. If you do not complete these fields, Horizon uses the default settings for these fields.

6 Click Export.

Horizon exports the information to the file you specified.

 


© 1998-2017 Sirsi Corporation