Jeremy Posted April 23, 2021 Share Posted April 23, 2021 We exported some views for data analysis but it appears that something may have changed with the way it outputs the information: This was previously how it exported with the Categories laid out in full: now they have changed to a single word Has this changed with the latest update to the Service Manager where the column of Category has been added as a selection? Link to comment Share on other sites More sharing options...
James Ainsworth Posted April 26, 2021 Share Posted April 26, 2021 Hi Jeremy, I'm not aware of anything that would have changed with the export, but I will check. For some reason, I can't see the images that you posted. The single category that is displayed in the request list is designed to show the last item in the category tree, but additional information should be stored in the actual table. On a Service there is an option that lets you set the root of the category. This allows a branch within the category structure to be used for that service. There is also this setting below that will actually store just the branch for the service instead of the entire path. Is it possible that someone has recently set the root category for the service and also enabled this setting? Link to comment Share on other sites More sharing options...
Victor Posted April 27, 2021 Share Posted April 27, 2021 10 hours ago, James Ainsworth said: For some reason, I can't see the images that you posted. The images were copied from a Gmail message (see the links). Viewing this image would only work for the user that has access to that email, won't work for anyone else. Ideally in this scenario the image would be copied locally first (as an image file, not link file) then uploaded/added in the forum post. Link to comment Share on other sites More sharing options...
Jeremy Posted April 27, 2021 Author Share Posted April 27, 2021 sorry here is the image.... Link to comment Share on other sites More sharing options...
Jeremy Posted April 27, 2021 Author Share Posted April 27, 2021 in the settings we have this.... No one apart from me would change these and I have not done anything in relation to these for a very long time. Link to comment Share on other sites More sharing options...
Steve Giller Posted April 27, 2021 Share Posted April 27, 2021 @Jeremy It would be useful to see what data you are gathering and from where. From the before/now screenshots it's not just the category that's changed but also the heading (from Request Category to Category) so there's some information missing there. Also, James asked 12 hours ago, James Ainsworth said: Is it possible that someone has recently set the root category for the service and also enabled this setting? You've confirmed that the setting hasn't changed, but has the Root Category for the Service been set? Link to comment Share on other sites More sharing options...
Jeremy Posted April 27, 2021 Author Share Posted April 27, 2021 @Steve Giller this is exporting a view and yes the heading has also changed from 'Request Category' to just 'Category' in the exported view as well as the data within This seems to have happened since the update where it mentions - No root categories have been set for services. Link to comment Share on other sites More sharing options...
Steve Giller Posted April 27, 2021 Share Posted April 27, 2021 @Jeremy That information has helped, thank you. Previously, the "Category" column was not available on the request list, but due to popular demand it was made available on the export list. When we made it available in the request list (again, by popular demand) we changed it to display only the final tree element to prevent it breaking. This was also when we changed the display name to "Category" instead of "Request Category". We're looking into whether we can provide an option for the full tree to be exported. Link to comment Share on other sites More sharing options...
Jeremy Posted April 27, 2021 Author Share Posted April 27, 2021 @Steve Giller it appears that the full tree shows in Reporting module so I guess that it's stored somewhere..... Link to comment Share on other sites More sharing options...
Steve Giller Posted April 27, 2021 Share Posted April 27, 2021 @Jeremy If you Report on the Requests table rather than exporting the Request List View then the h_itsm_requests.h_category field will store either the final element or the full tree based on the settings posted by James above. Link to comment Share on other sites More sharing options...
Jeremy Posted April 28, 2021 Author Share Posted April 28, 2021 @Steve Giller originally this was exported from the request list as this is where most users are able to export data in the short term I have created a report for them but ideally we would like the ability to export the full tree from the request list. Link to comment Share on other sites More sharing options...
AndyG Posted April 28, 2021 Share Posted April 28, 2021 @Jeremy We have made a change to the process of exporting the request list. With this change, values in the "Category" column will contain the same information as before when using the old "Request Category" column. This will be included in the next release of the Service Manager app which is likely to be available in the week commencing 10th May 2021. 1 Link to comment Share on other sites More sharing options...
Jeremy Posted May 24, 2021 Author Share Posted May 24, 2021 We have noticed that this has been updated for the 'Category' selection but today it has been raised that the 'department; export has the long version e.g. UOP/ProfessionalServices/InformationServices/ rather than the old version of Information Services Can this also be updated? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now