Defining a File Request Type for Uploading SQIs in the CSV Format

Procedure

To define a file request type for uploading SQIs in the CSV format:

  1. Click the Admin link in the Application toolbar.
    A list appears.
  2. From the Admin menu, select F and then click File Request Type.
    A sub-menu appears.
  3. Click the Add option from the File Request Type sub-menu.
    The File Request Type screen appears.
  4. Enter the file request type and description in the respective fields.
  5. Select the Data Transformation Required option.
    The File Format field is enabled.
  6. Select the Comma Separated Values option from the File Format list.
  7. Enter csv in the File Extension field.
  8. Attach an algorithm created using the C1-FRHVA algorithm type to the File Validation Algorithm field.
  9. Attach an algorithm created using the C1-FRTA algorithm type to the Data Transformation Algorithm field.
  10. In the Services section, enter the required sequence number.
  11. Select the Business Service option from the Service Type list.
  12. Enter the C1-SQIUPLOAD business service or custom SQI business service in the Service Name field.
  13. Select the Add option from the Operation list.
    Note: At present, you cannot edit the existing SQIs using the Price Item, Parameter, and SQI Upload feature. You can only edit the existing SQIs from the user interface.
  14. If you have included a header in the CSV file, add the appropriate details in the Header Transformation section.
  15. Similarly, if you have included a footer in the CSV file, add the appropriate details in the Footer Transformation section.
  16. In the Field Transformation section, specify the following details:
    Field Name Field Description Mandatory (Yes or No)
    Sequence Used to indicate the data field in the CSV record which you want to upload in the system. Yes
    Field Name Used to indicate the field for which the data is uploaded in the system. Yes
    Map Field XPath Used to specify the XPath of the field where you want to store the data field from the CSV record. Yes

    For example,

    Sequence Field Name Map Field XPath
    1 DECIMALPOSITIONS C1-SQIUPLOAD/decimalPositions
    2 DESCRIPTION C1-SQIUPLOAD/description
  17. Click Save.
    The file request type is defined for uploading SQIs in the CSV format.