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

Procedure

To define a file request type for uploading parameters 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 Object option from the Service Type list.
  12. Enter the C1_​PRICE_​PARM business object or custom parameter business object in the Service Name field.
  13. Attach an algorithm created using the C1-PRICEUPL algorithm type to the Pre-Processing Algorithm field corresponding to the parameter business object.
    Note: For more information about the C1-PRICEUPL algorithm, refer to C1-PRICEUPL.
  14. Select the Add option from the Operation list.
    Note: At present, you cannot edit the existing parameters using the Price Item, Parameter, and SQI Upload feature. You can only edit the existing parameters from the user interface.
  15. If you have included a header in the CSV file, add the appropriate details in the Header Transformation section.
  16. Similarly, if you have included a footer in the CSV file, add the appropriate details in the Footer Transformation section.
  17. 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 PRICEPARMCODE C1_​PRICE_​PARM/priceParmCode
    2 DESCRIPTION C1_​PRICE_​PARM/description
  18. Click Save.
    The file request type is defined for uploading parameters in the CSV format.