<!-- Oracle Remote Diagnostic Agent / Data Collection Results 4.29 -->
<!-- Module:S313IREQ Version:1.23 Report:log_textpds_conf OS:linux -->
---+ Display of textpds.conf File
---## Information Taken from /u01/install/APPS/fs1/FMW_Home/as_1/reports/conf/textpds.conf
<verbatim:stat>
 -rw------- 1 applmgr oinstall 5723  Jun 11 12:56 2015  Oct 11 09:19 2006  textpds.conf
</verbatim>
<verbatim>
<?xml version="1.0" encoding="UTF-8"?>
<!-- 1st February 2002-->
 <!--
 
 This is the configuration file for the TextQuery of Oracle Reports. In this
 file, information about the different File Formats for which you want the 
 textpds to work is mentioned.

 Only those File Format entries that are present in this configuration file
 will be supported by the Text Query of Oracle Reports. In the Reports builder 
 in the TextPDS Dialog, you will find the list of File Format names you have 
 specified here and you can select one of them from the drop down list for a 
 specific Text query in your Report.

 The entries in this file would be loaded when you create a new Text query.
 For any changes in this configuration file to be effective, the Reports
 Builder needs to be re-started.

 The Text query will not work if any changes are made to this DTD section.
 In case you want to modify them, the corresponding changes needs to be
 done in Text Plugin Datasource java code

 In the XML section, you will typically specify the File Format information.
 It is recommended to edit this file and comment the unused File Formats
 rather than deleting everything and writing from scratch on your own.

 The File Format information is typically, the File Format Name, Comment
 character, Column Delimiter and  File Format type. Each File Format will
 have columns. The individual  Column information is to be given in
 ColumnInfo tag. The Column information are the Column Name, Column Type,
 Cell Wrappers, pattern.

 File Format Attributes:

 name      : File Format Name. This name will appear in the Data Definition
             drop down list. The first File Format appearing in this xml file
             will be the default File Format for Text PDS.

 comment   : Comment character. This will be used in the DataSource. The
             lines beginning with the comment character will be ignored.

 delimiter : Column Delimiter. The Data Source file will have data in rows.
             Each row will have fields or tokens corresponding to the Columns 
             specified in the configuration file. Each field or token will be 
             separated by a Column delimiter(See cellWrapper). If the value of 
             delimiter is "default" then it will mean that delimiter will be 
             one of the characters from the "default delimiter set". The 
             "default delimiter set", is "\t\n\r\f": the space character, 
             the tab character, the newline character, the carriage-return 
             character, and the form-feed character. Delimiter characters 
             themselves will NOT be treated as tokens. Hence the value of the 
             field cannot assume any value from default character delimiter 
             character set.

 type      : File Format Type. Can be fixed or variable. In case of variable" 
             file format, the columns width is variable. In case of "fixed" 
             file format, the column width is fixed and is specified using 
             the attributes "startpos" and "width" for each column. The Column 
             Delimiter is ignored in case of "fixed" file format type.

 nullValue : Null value character.

Column Attributes:

name         : Column Heading

type         : Column Data Type. Currently, 3 data types are supported -
               String, Number, Date.

cellWrapper  : This attributes is optional. If specified, this character will
               override the File Format delimiter for the column for which it
               is specified.
pattern      : This attributes is optional.Currently used only for date fields. 
               Specifies the pattern in which date field is to be expected.

-->

<!--XML section.Please edit this section to give your file format information-->
<textPDS  
    xmlns="http://xmlns.oracle.com/reports/pdstext"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://xmlns.oracle.com/reports/pdstext file:$$Instance.oracle_home$$/reports/dtd/textpds.xsd" 
    >

  <!--Data definition for Apache Log file format-->
  <fileFormat  name = "Apache Log File" comment = "#" delimiter = "default"
               type ="variable" nullValue = "-">
    <columnInfo>
      <column    name = "Remote Host"      type = "string" />
      <column    name = "Remote Log Name"  type = "string"/>
      <column    name = "Remote User"      type = "string"/>
      <column    name = "time"             type = "date"    cellWrapper = "\[]"
                 pattern = "dd/MMM/yyyy:hh:mm:ss zzz"/>
      <column    name = "Request"          type = "string"  cellWrapper = "&quot;"/>
      <column    name = "status"           type = "number"/>
      <column    name = "bytes"            type = "number"/>
    </columnInfo>
  </fileFormat>
  
 <!--Data definition for Comma Delimited file format-->
 <fileFormat  name = "Example Variable Width Comma Delimited" comment = "#" 
              delimiter = "," type = "variable"> 
     <columnInfo> 
      <column    name = "var_cd_col1"     type = "string" /> 
      <column    name = "var_cd_col2"     type = "string"/> 
      <column    name = "var_cd_col3"     type = "string"/> 
     </columnInfo> 
  </fileFormat> 

  <!--Data definition for Fixed Width format-->
  <fileFormat  name = "Example Fixed Width Space Delimited" comment = "#" 
               delimiter = ""  type = "fixed"> 
     <columnInfo> 
      <column    name = "fw_sd_col1"     type = "string" startpos = "1"  width = "13"/>
      <column    name = "fw_sd_col2"     type = "number" startpos = "14" width = "10"/>
      <column    name = "fw_sd_col3"     type = "date"   startpos = "25" width = "10"/>
    </columnInfo> 
 </fileFormat> 
</textPDS>
</verbatim>
[[#Top][Back to top]]
