Administer > Database administration > Data persistence > Exporting records > Unload records from multiple files

Unload records from multiple files

Applies to User Roles:

System Administrator

To unload records from multiple files:

  1. Click Tailoring > Unload Script Utility.

  2. Fill in the following fields.

    Field Description
    Unload Script Type a name or label to identify your unload script. This name can include spaces.
    Unload? Select this option to create an external unload file from the records queried by this script.
    Purge? Select this option to delete the records queried by this script.
    Show Unload Records Select this option to display the Filename, Query, and Data Map fields. These fields enable you to specify the tables and queries to use when unloading records.
    Filename Specify the name of the table to unload records. This field is visible only if you select Show Unload Records.
    Query Type the SQL query to select records for unloading. You can use Service Manager operators and variables in this field. This field is visible only if you select Show Unload Records.
    Datamap Specify true or false to specify whether Service Manager should use the data map file to unload any associated records. You must have previously defined a data map for the listed file in order to use this feature. By default, Service Manager reads a blank entry in this field as false. This field is only visible if you have select Show Unload Records.
    Show Protected Formats Select this option to display the Protected Formats field. This field enables you to specify the forms to protect from purging.
    Protected Formats Type the names of the forms to protect when you purge records from this script.

  3. Click Add.

Related topics

Data maps
Exporting records
Export descriptor records
Unload files
Importing records
Purging and archiving records
Unload script utility
Master data records
Load/unload implications of case-sensitivity

Add an export descriptor record
Export a record list to a text file
Export a record list to an Excel file
Export a record list using an export description record
Export an individual record using an export descriptor record
Export selected records from a table using an export descriptor record
Schedule the exporting of records using an export descriptor record
Schedule the unloading of records
Unload a database dictionary only
Unload a record list
Unload an individual record
Unload selected records from a file
Update an export descriptor record

Unload error messages
Load error messages and notifications