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

Procedure

To define a file request type for uploading products 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_​PRODUCT_​BO business object or custom product business object in the Service Name field.
  13. Attach an algorithm created using the C1-PRODUCTPR algorithm type to the Pre-Processing Algorithm field corresponding to the product business object.
    Note: For more information on C1-PRODUCTPR, please refer C1-PRODUCTPR.
  14. Select the Add or Replace option from the Operation list depending on whether you want to create new products or edit the existing products using the file request type.
  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 PRODUCTCODE C1_​PRODUCT_​BO/productCode
    2 DESCRIPTION C1_​PRODUCT_​BO/description
  18. Click Save.
    The file request type is defined for uploading products in the CSV format.