1. User Guide
  2. Data File Specification
  3. Creating the Data File

Creating the Data File

After the Data File Specification is defined, follow the mentioned guidelines to prepare the Data Files:

  • Columns to be included in the Data File must be as per the Data File Specification.
  • Name of the Data File must be same as the Data File Specification with a prefix of “input_yyyymmdd” where yyyymmdd is the Date (As of Date) for which the Data File is prepared. For example:
    • Data File Specification Name is “Asset.dat”
    • The As of Date is 06-July-2022
    • Data File Name must be “input_20220706_asset.dat”
  • Permitted Delimiters are comma (,) and pipeline (|).
  • Data Validations:
    • Number fields: only numbers and dot (.) are allowed.
    • Description fields: comma (,) pipeline (|), single quotes (‘’), and double quotes (“ “) are not supported.
    • Any nullable fields which are mapped in the Data File Specification definitions must not skipped in the Data File.
    • The column order in the Data File should be in sync with the order defined in the Data File Specification definition.
    • Field Enclosures: Only double quotes (“”) are considered as Field Enclosures.
See the following sample files for your reference:
  • input_20151009_asset.dat
  • input_20150330_ASSETTXN.dat
  • input_20220110_STGML.dat
For more information about the data required by the OFS CCA CS Services, see the Download Specifications available at the following documents: .