In this article
Note that Genius now has the ability to “Synchronize model to database designer tables” when setting up the Text Analytics task. If you use this option, you will not then need to go through the steps below (go to Running the Genius Task for more information).
From time to time you will need to make changes to your categorization model. If you only need to change the expressions then you will not have to update anything in Authoring. However if you need to change the structure of the model, for example adding or removing categories, sub-categories or attributes, then you will also have to update the Database Designer table.
To do this:
- Launch your new model structure in Model Builder.
- Go to the Category List in Model Builder and copy your updated list.
- Paste the list into an Excel spreadsheet and save it as a tab-delimited text file.
- Go into Database Designer, find your table by searching for the schema name, and open the table.
- Go to the Contents tab and click Upload from file located at the bottom of the table - .
- Click Choose file and select your file.
- In the Upload behavior area, select Overwrite.
- Check the Synchronize after upload box.
- Click Upload table content (in the lower-right corner of the overlay).
- When the process is completed, click Synchronize.
Figure 1 - The table in Database Designer
The Upload Table Content dialog opens - .
Figure 2 - The Upload Table Content dialog
Your new categorization table will be loaded. Once your text analytics task runs again, your new categories will be included in your report. If you wish to analyze historical data, you will need to run the task yourself.
Tip
If you have a lot of historical data, then you should consider adding a start date expression into the task expression field as this will limit the analysis to only the relevant data.
Note: The Text Analytics task will process a maximum of 50,000 verbatim per run. If you have more than 50,000 verbatim, then you will need to set up a recurring task to pick up the remaining verbatim for analysis.