Semantria For Excel / Release notes

6.0.102 (2018-05-24)

Fixes

Fixed an issue that caused the New Analysis Wizard to display a blank Analysis panel.

Fixed an issue in the SSV uploader's Custom Fields panel when selecting content that has a blank first row.

Resolved an issue that occured when uploading more than one Content column to SSV.

Resolved issues in the SSV upload process.

Minor text improvements to clarify SSV upload process.

Fixed an issue where configurations were not appearing in the New Analysis wizard.

6.0.74 (2018-04-19)

Fixes

Fixed an issue that caused the "Generate reports" button to not appear when disabling one-click report generation.

6.0.72 (2018-04-12)

Fixes

Fixed an issue that caused the last worksheet in the Excel workbook to become the active worksheet upon opening, regardless of what sheet was saved as last the open worksheet.

6.0.70 (2018-03-30)

New features and changes

Integration with Semantria Storage and Visualization: Semantria for Excel has been integrated with the new Semantria Storage and Visualization (SSV) product, allowing users to easily upload their Excel content for analysis online. Integration with SSV gives access to online content storage and sharing amongst a team, online analysis of larger datasets than can be processed within Semantria for Excel, and dashboards for interactive visualization of the results of content analysis. For more information on Semantria Storage and Visualization, contact sales@lexalytics.com.

New detail report - Machine Learning Model: A new detailed report has been added to Semantria for Excel for results from Lexalytics machine learning models. Customers that have engaged with Lexalytics on AI Assembler professional services projects will use this new detailed report to analyze content with their custom models. For more information about AI Assembler, contact sales@lexalytics.com.

Notes

NOTE: Semantria Storage and Visualization offers more advanced reporting capabilities, in particular for charting and visualization of the results of content analysis. In integrating with SSV, the survey reports functionality within Semantria for Excel has been replaced with online results visualization in SSV.

As we add new features to our reports, content that was analyzed in earlier versions of Semantria for Excel may not contain all results needed for these new features. This may require you to reprocess your content in order to generate new reports with these enhancements.

5.3.152 (2018-02-09)

Fixes

Fixed an issue that caused the Tuning tab to be disabled under certain conditions immediately upon login.

Fixed an issue that allowed "mixed" sentiment polarity label to appear in reports when it was not selected in Output Settings.

Fixed an issue in Query Detail report that could create a duplication of a single result when mentions are turned off on a configuration.

5.3.140 (2017-09-29)

New features and changes

Report sets: Do you often generate the same group of reports for certain analyses? Report sets allow you to label a set of reports commonly used, and generate them for a selected analysis at once. This can be done on results for existing analyses, or can be selected when performing a new analysis. Changes to the New Analysis Wizard allow you to specify your content, the configuration to use for analysis, the report set to use for report generation, and let Semantria for Excel do the rest.

New tuning report - Query Comparison: This report is designed to compare the query results between two different analyses. Primarily, this helps in reviewing the change resulting from query tuning.

New tuning report - Sentiment Phrases for Queries: This report provides the sentiment phrases that apply to query-level sentiment, which helps with sentiment tuning.

Redesigned user interface: The Lexalytics ribbon has a fresh new look, and various dialogs have been redesigned to be clearer and more focused. The sidepanel that shows analysis jobs and configuration has been redesigned.

Optimized report generation: "One-click report generation" allows you to switch from the checkmark selection of reports to immediate generation of reports for an analysis.

Other enhancements and fixes

Support has been added for offline usage, allowing reports to be generated and managed based on results that have already been processed.

Hyperlinks to original document record and additional metadata have been added to the Uncategorized Documents report.

You can now add text notes in the process of starting a new analysis to record a description of the purpose of the analysis.

Resolved an issue in selecting a single row for analysis from Excel workbook.

Addressed issues in the New Analysis Wizard that could cause the Options panel to be blank.

Fix to the configuration selection in the New Analysis Wizard which was not restricting to the selected language.

Notes

As we add new features to our reports, content that was analyzed in earlier versions of Semantria for Excel may not contain all results needed for these new features. This may require you to reprocess your content in order to generate new reports with these enhancements.

5.2.478 (2017-06-01)

Fixes

Fixed a build issue in the previous 32-bit distribution.

5.2.468 (2017-05-25)

Fixes

Fixed an issue affecting some customers unable to advance past Data Source selection in the New Analysis wizard.

Fixed an issue in configuration usage when selecting to analyze "Another Excel workbook" in New Analysis wizard.

Fixed an issue in Summary reports when used in non-English versions of Microsoft Excel.

5.2.435 (2017-04-13)

Fixes

IMPORTANT: Fixed consistency issues in detail report output.

Fixed an issue in the creation of configurations in accounts with POS tagging feature unavailable.

Enhancements

Ensure that the language of the default configuration is selected in the last step of the New Analysis Wizard.

Ensure that the Document Detail report is selected at the completion of generating all detail reports.

Notes

As we add new features to our reports, content that was analyzed in earlier versions of Semantria for Excel may not contain all results needed for these new features. This may require you to reprocess your content in order to generate new reports with these enhancements.

More enhancements are coming to Semantria for Excel 5.2! We've turned the update notification service back on to inform you of these improvements as they are released. If you have not yet migrated from Semantria for Excel 4.9 or 4.10, please contact us at support@lexalytics.com for guidance.

5.2.408 (2017-03-31)

Fixes

Fixed an error causing the query column to be blank in the Query detail report.

Fixed an error in the Standard Volume report when user-defined neutral range was set to 0.

Fixed an error that caused the Standard Volume word cloud to get out-of-sync from the Standard Volume chart.

Adjusted the behavior of the filter panel on the Standard Volume and NPS charts to only update visualizations when the Refresh button is pressed.

Notes

As we add new features to our reports, content that was analyzed in earlier versions of Semantria for Excel may not contain all results needed for these new features. This may require you to reprocess your content in order to generate new reports with these enhancements.

More enhancements are coming to Semantria for Excel 5.2! We've turned the update notification service back on to inform you of these improvements as they are released. If you have not yet migrated from Semantria for Excel 4.9 or 4.10, please contact us at support@lexalytics.com for guidance.

5.2.403 (2017-03-29)

New features and changes

Tuning Reports: Many of our customers use Semantria for Excel to adjust their sentiment phrases and categorization queries. A new "Tuning Reports" section has been added to the Report Library, containing reports that show documents which were not categorized, and possible sentiment phrases.

User experience overhaul: Continuing the user experience overhaul that was begun in the initial release of Semantria for Excel 5.2, we've revamped the process of signing in for new users.

Enhancements to reports: In addition to the Tuning Reports, a Query Co-occurrence report has been re-introduced based on customer feedback.

Other enhancements and fixes

An option has been added to selectively include document level information in all other Detail reports.

We've adjusted the sheet order of generated report sheets to match the order seen in the Report Library section of the ribbon.

Notes

As we add new features to our reports, content that was analyzed in earlier versions of Semantria for Excel may not contain all results needed for these new features. This may require you to reprocess your content in order to generate new reports with these enhancements.

More enhancements are coming to Semantria for Excel 5.2! We've turned the update notification service back on to inform you of these improvements as they are released. If you have not yet migrated from Semantria for Excel 4.9 or 4.10, please contact us at support@lexalytics.com for guidance.

5.2.358 (2017-03-06)

Fixes

An error in the New Analysis wizard for trial accounts has been fixed.

5.2.356 (2017-02-21)

New features and changes

New Socialgist functionality: One of the key features of Semantria for Excel 5 has been the ability to gather content from external sources for analysis. In Semantria for Excel 5.1, we introduced a connector to Socialgist Product Reviews. Now you have the option of filtering the product reviews to analyze by selecting from the sites that Socialgist gathered the content.

User experience overhaul: Beginning a new analysis is a fundamental action within Semantria for Excel, so we've completely overhauled the New Analysis Wizard with the user in mind. This step-by-step process is now clearer and more user-friendly, simply press the "Start" button and we'll guide you through it.

Enhancements to reports: We've added a separate Entity Themes report and added Phrases to the items you can display in Survey reports.

Other enhancements and fixes

The filter panel displayed on Survey Reports is now selectively shown or hidden to give more screen real estate to the visualizations.

Adjusted the alignment of data in our Detail reports and Summary reports.

Fixed an issue in the Detail reports where column headers could get mismatched.

Source text was missing from the Intention Detail report.

Notes

As we add new features to our reports, content that was analyzed in earlier versions of Semantria for Excel may not contain all results needed for these new features. This may require you to reprocess your content in order to generate new reports with these enhancements.

More enhancements are coming to Semantria for Excel 5.2! We'll be turning the update notification service back on to inform you of these improvements as they are released. If you have not yet migrated from Semantria for Excel 4.9 or 4.10, please contact us at support@lexalytics.com for guidance.

5.1.283 (2017-01-26)

Enhancements

The "Words" report seen in previous versions of Semantria for Excel 4.x has been reintroduced.

Fixes

An information message that was displayed when users clicked to view reports, without any reports selected, had been omitted.

Resolved an issue encountered when the first column of Excel spreadsheet is blank.

Resolved an issue in processing Excel files with small number of rows and short text.

5.1.266 (2017-01-17)

Fixes

Hotfix to resolve an issue in creating configurations within Semantria for Excel when discovery features are disabled.

5.1.265 (2017-01-16)

New features and changes

New SocialGist connector: In addition to the external sources such as SPSS files and SurveyMonkey that were introduced in Semantria for Excel 5.0, now you can connect to SocialGist Product Reviews. Gather and analyze customer reviews for your products and connect Net Promoter Scores with your categories or mentioned themes to focus quickly on areas that need attention with your detractors or promoters.

Flexible definition of Promoters and Detractors: Does your survey contain a Net Promoter scale from 1 to 10? or 1 to 7? or perhaps you're gathering customer reviews from SocialGist and using the ratings column which has a range of 0 to 100? It's all good, just tell us the lowest score that indicates a Promoter and the highest score that indicates a Detractor, and we'll do the rest!

Known issues

A column of numeric values selected for use as a ratings column must have more than 3 unique values.

5.0.185 (2016-12-07)

Fixes

Resolved an issue in handling very large document balances in the Account Status information display.

5.0.182 (2016-11-29)

Fixes

Resolved an issue in the installer related to the VSTO prerequisite.

5.0.174 (2016-11-15)

Fixes

Resolved an issue in the Uncategorized Results report

Closing a workbook that contains a saved Survey Report and then reopen it without closing and Excel requires reports to be regenerated. Reopening Excel and then reopening the previously saved workbook works as expected.

Summary report counts incorrect. These counts for elements such as entities and themes are including mentions and other sub-element items (such as entity themes) in the count, instead of just document count for the main element.

Incorrect legend in Volume by Sentiment chart

New analysis wizard dialog boxes are not appearing in the center of the window

Issues with filters on Standard Volume report

Close button in Semantria for Excel side panel was removing all reports except the Uncategorized report

Horizontal axis numbering on the Standard Volume report has a duplication when displaying by count

Known issues

Order of items on the Standard Volume report is always the pre-filtered order by volume

If column selected for metadata has no actual values, an error will occur during report generation. Please ensure that columns selected for metadata contain values.

5.0.160 (2016-11-02)

New features and changes

Connect structured and unstructured data: Semantria for Excel 4.x introduced the ability to pass along metadata (structured information) with the text being analyzed. Semantria for Excel 5 builds on this to utilize your structured data in visualizing and understanding your results instead of just passing it through.

Import data from Survey Monkey and SPSS: Bring in data from external sources to analyze in the familiar Excel environment. Semantria for Excel 5.0 gives you the option to analyze from online sources like SurveyMonkey as well as other local file formats like SPSS and Triple-S.

Interactive analytics charts: Sort and filter by various attributes from your structured data or surfaced by analysis of your unstructured content. Drill in for deep observations in your data.

Survey-specific net promoter columns: New visualizations to support our handling of survey data from SurveyMonkey and other new data sources. Connect promoters and detractors to insights from your unstructured data.

Support for multiple text fields per record: Multiple text fields can be specified during analysis, and the report generation process allows for specific text fields to be included in the report.

Known issues

If column selected for metadata has no actual values, an error will occur during report generation. Please ensure that columns selected for metadata contain values.

Closing a workbook that contains a saved Survey Report and then reopen it without closing and Excel requires reports to be regenerated. Reopening Excel and then reopening the previously saved workbook works as expected.

Order of items on the Standard Volume report is always the pre-filtered order by volume.

Horizontal axis numbering on the Standard Volume report has a duplication when displaying by count.

4.10.188 (2016-11-01)

Enhancements

Added a dropdown selection on the Detailed Report button to allow for selective report generation

Bug fixes

Microsoft Excel has a limit of 65530 hyperlinks in a single worksheet. When processing large datasets, this limit was halting the output of reports. We've introduced a check on the number of results, and do not hyperlink results if this limit will be exceeded.

4.10.182 (2016-10-17)

Bug fixes

Performance fixes to report generation

4.10.181 (2016-10-04)

Bug fixes

Fixed a bug in the generation of reports involving taxonomy results

Fixed a bug in mention highlighting

4.10.179 (2016-09-29)

New features and changes

Simplified user interface: We've completely streamlined the Semantria for Excel ribbon to remove the button overload. Results output is now based on your configuration settings, removing cases in which you select an output feature which is actually not enabled in your configuration.

Expanded reporting: Previous versions of Semantria for Excel put all results from Detailed Analysis onto a single sheet. This format is very challenging to import into other BI tools such as Tableau, and also generates a great deal of redundant information in the results sheet. The Detailed report in Semantria for Excel 4.10 will create individual worksheets for each type of result (entities, themes, topics, etc.), with hyperlinks back to the original content.

Keywords in context: If Mentions are enabled for your account,the Detailed report will provide snippets of the content with sentiment phrases, entities, themes, and topic occurrences highlighted for quick reference.

Yes, I agree to receive email communications from Lexalytics, including educational resources and newsletters. I understand that I may unsubscribe or limit the emails I receive at any time. (privacy policy)