Export to Excel - "Service Tags" are not exported properly
Status: Solved
Description
- In the Service module - add tags to some of the requests which are open/unassigned.
- Go to Find > Find Requests.
- Find several requests - when the results are received- add a column of "Tags". Make sure that in the result you will have requests which have a tag and some which don't.
- Export the results into excel.
Observed that: when the results are exported into excel, the output is incorrect:
- the requests which do not hold a tag, receive "[A:]" or "-2147483648".
- the requests which hold a tag, receive an ID of the tag instead of a label.
Expected that: when the export is performed and the "Tags" column is included - the export would show an actual label of the tag instead of IDs or characters.
info
Please log in to comment.
Details
| Issue id | 37814 |
| Registered | 12 Jan 2023 |
| Last modified | 22 Apr 2025 |
| Severity | Medium |
| Area | Sales |
| Status | Solved |
| Target release | CRM Online 10.5.4 |
| Released date | 6 Apr 2025 |
| Type | Bug |
Comments
[2023.11.15: onb]
Details claims the area is only Sales.
I can confirm that this also affects Service.
When exporting service tickets to excel the tags are not reported properly.
- Tickets with dual tags are only reported with one tag.
- Tickets with no tags are reported with ⦏A:⦎ tag
- Some tickets are reported with a minus value.
[2024.02.15: Denni]
This is rather relevant for the clients to get sorted and fixed.
[2025.02.19: susan]
I have noticet that only one tag is included in the export. Even when service ticket has multiple tags only the first one is in the export.
Unfortunately this means that the export completely usesless for us.