Example: Converting Wiki Text to Plain Text when Importing Tables
Assume that you want to import some tabular data from Word and that data looks like this. You want to import the Summary column to a Work Item's summary and the Description as adescription. Notice that the Summary column contains some bold formatted text.
When you import this as table from Word document, you notice that the summary field of the result data looks like this:
This is happening because the Word import convert the Word content to wiki and keeps the bold style, and then converts it to bold text.
To fix this, you will need to do some conversion during the import. So start the import again, and on the 2nd page of the wizard you have the option to apply some conversion on the import field.
1. Start the import again.
2. On the conversions page of the wizard, click Configure advanced conversions.
3. Choose Script conversion for the Summary field where you want plain-text instead of wiki.
4. Choose Groovy as the script language.
5. Paste the script below to the script editor.
return com.intland.codebeamer.text.WikiToPlainTextConverter.extractTextFromWiki(input, request).getLeft();
This script converts the wiki text that will go into the summary field as plain text.
When you continue with the import, you will see that the summary is correctly imported.