Siebel Fundamentals > Sharing Information >

Exporting Data

The export feature is valuable when you query for specific data and need to export that data to a separate file. The exported data in the file can be read in Microsoft Excel or imported into other applications.

If the data you are exporting includes dates or numbers, they will be formatted according to your machine's Regional Settings properties. Your Regional Settings are configured using the Microsoft Windows Control Panel. In some cases, the formatting may depend on the Regional Settings set up by your company on the server. Check with your Siebel administrator.

Exporting is performed from a list, allowing you to export a single record or a list of records.

NOTE:  If a record you export includes a multi-value group field, only the primary value for that field is exported.

To export data to an external file

1. Navigate to the screen from where you want to export data and run a query to display the desired records.
2. In the main list of data, use the Columns Displayed function to add and remove columns in the list.

   For more information, see Organizing Columns in a List.

3. Click the menu button, and then click Export.

   The Export dialog box appears.
4. Use the Rows To Export and Columns To Export option buttons to define which rows and columns you want to export.

   NOTE:  The order of exported columns is determined in Siebel Tools by the order of the Sequence property values of the columns as they are set in the List Column object.

   For more information about properties of the List Column object, see Object Types Reference.

5. Use the Output Format option buttons to define the format of the output document.

   To correctly export Siebel data to a Microsoft Excel document, use the Tab Delimited Text File option.

   Choosing the Text File With Delimiter option will add quotes around each field value. This is to help differentiate between each column value.

6. Click Next.

   The File Download dialog box appears.

7. Select Save This File to Disk and click OK.

   The Save As dialog box appears.

8. Navigate to the location where you want to save the file and type a filename.
9. Click Save.

   CAUTION:  Depending on the amount of data you are exporting, this process can take several minutes. Performance may be affected if you are exporting more than 50,000 records.