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 |
|
|||||||||
Export information in a form |
|
3 | Choose Export. |
Horizon displays the Export to File window:
4 | Complete these fields: |
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