Import CSV & Train on Watson

To train on Watson, perform the following steps.

  1. Navigate to the Cherwell Configuration Console and go to the CSV tab on the window.
Figure 1. Figure 137 - Cherwell Configuration Console (cont.)
  1. Here, you may upload your CSV mapping of Cherwell Service Catalog items which contains the mandatory columns such as Service, Category, Subcategory, and other optional columns such as Variations and Synonyms arranged in the same order as that in the sample CSV file. You can get a sample document on the same console by clicking the Download Sample CSV button. User can fill and upload the downloaded sample.
Figure 2. Figure 138 - Cherwell Configuration Console (cont.)
  1. The following points must be considered when uploading the CSV file:
  • The CSV file must have the header row with the following case-sensitive headings in the following order:
  • Service
  • Category
  • Sub-Category
  • Variations
  • Synonyms
  • This must be the same order as that in the sample CSV file. If this is not true, you will get an error while importing the CSV. Even if the 4th and 5th columns are optional, the corresponding headers must be present.
  • Subcategory must only contain a-z or A-Z or 0-9 or space or dash (-) or Underscore (_) or period(.) or parenthesis or slash (/).
  • Since comma is used as a column separator in the CSV file, it should not be part of the content of any column.

Multiple Synonyms/Variations should be separated by using the semi-colon and there must not be any semi-colon after the last Synonym/Variation.

  • Once uploaded successfully you would receive a confirmation.
  1. Navigate to the Mapping tab on the Cherwell Configuration Console. Here, you can find all the uploaded data.
Figure 3. Figure 139 - Cherwell Configuration Console (cont.)
  1. Once the complete data is fetched and shown on the Mapping tab, then you can click on the Train button. This would run the set of operations to automate the training depending on the uploaded data.
  2. Once the training is complete, you will get a successful message. Wait for 2-3 mins before you test it on the chat as Watson takes some time to train the Entities and Variations sent at once.
  • Clicking the Train button also creates the conversation flow for the use cases (get ticket status, show service request form/create ticket, show all my tickets, show all my configured devices, search knowledge articles, and reset password) in Watson. This happens only when the Train button is clicked for the first time or during the first import of any CSV file. For subsequent imports of the CSV file, the conversation flows in the corresponding Watson skill are left untouched.
  • If you have created a sandbox/demo tenant, then note that you can create only 10 unique Sub-Categories, otherwise you will get an error when you click the Train button.
  • The maximum size of any Sub-Category name that is allowed on BigFix AEX’s side is 100 characters. While counting the characters, please note that a space/right parenthesis/left parenthesis in the name counts for 3 characters and a slash counts for 4 characters. If this is not followed, you will get an error when you click the Train button.
  • The maximum size of any single Variation is 1024 characters. The Variation column can contain multiple variations separated by a semicolon. The 1024-character limit applies to the single variation only.
  • The maximum size of any Category name that is allowed on BigFix AEX’s side is 64 characters. If this is not followed, you will get an error when you click the Train button.