Exporting Data

The export feature is valuable when you query for specific data and want 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 computer's Regional Settings properties. Your Regional Settings are configured using the Microsoft Windows Control Panel. In some cases, the formatting depends 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 Siebel 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.

   
   

   Note: For numeric fields, the number of digits to the right of the decimal point that are exported to the document is a function of the regional settings of your operating system. Modifying the operating system settings will allow for more digits, up to a maximum value of nine digits to the right of the decimal point.

   
   

   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.

   
   

   Note: Depending on the amount of data you are exporting, this process can take several minutes. A message with the current status of the export is displayed and periodically updated at the top of the Export dialog box. Performance might be affected if you are exporting more than 50,000 records

   
   

   Once all of the export data has been retrieved, 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.

10. Click Close to close the Export dialog box.