Page Comparison

...

Description

The purpose of this document is to provide a description of the configuration of Xml Cdr files, so that they can be read correctly by the Service Providers.

...

Important Note: It is mandatory to setup both parameter tree entries RECORD_RETRIEVE_SQL, RECORD_RETRIEVE_SQL_WITH_ID_GREATERTHAN_CLAUSE, because the File processor XML filler classes are configured to load only a maximum 10000 records in one select. For example: If there are 20000 more records , then the XML Filler has to reload the records, with ( ID > the max id from previous select).Soin the database, and we want to add them to the XML file, the reload_method  column of the relevant xml_tag_def entry must be set to 'reloadRecords'. If it is set, after printing the first set of 10000 records, the GenericXMLFiller tries to load next batch of records, having the ID greater than the ID of the last retrieved record in the previous step. 

 For example: If there are 20000 records, then the GenericXMLFiller uses the SQL queries configured in the above parameter tree entries like this:

• The query from RECORD_RETRIEVE_SQL parameter is used to load the first batch of records (10000) .
• If there are more records to be added to the same XML file and the reload_method on one of the XML_TAG_DEF entries is set to 'reloadRecords', The SQL from RECORD_RETRIEVE_SQL_WITH_ID_GREATERTHAN_CLAUSE parameter is used to load the next batches , with 10000 max rows selected in each subsequent batch, until all pending records have been added to the file.

3.3.2 - XmlFillerBillingRecords and XmlFillerIdl

Detailed description of XmlFillerBillingRecords and XmlFillerIdl can be found here: Xml Cdr Exporter

3.4 - ValueFormatter

The value formatter has been introduced in order to be able to configure the formatting of objects. Here we can specify a formatter class and a pattern that will be used to generate a string.

...