-
Suggestion
-
Resolution: Unresolved
-
None
-
1
-
2
-
Problem definition
By default, when importing objects and concatenating values from multiple datalocators, the default concatenator is space. However, it is not possible to ignore the concatenator and not use any value (e.g. so that "ABC" and "1234" together become "ABC1234").
Suggested resolution
Add option to disable concatenator completely, so the values are concatenated without any character in between.
Workaround
- Create the desired value right on the source side, example:
- If using database as a source, create a new column that contains concatenated values from other desired column values (without space), then use that new column as a datalocator.
- If using CSV as a source, open the file in Excel (or other spreadsheet editor) and use CONCATENATE function to generate a desired value in a new column, then use that generated column as a datalocator.
- Use Insight Automation rule, that would execute a Groovy script which would find if there is a space in the object attribute and remove it.
- Community blog that provides an example Groovy script: Groovy script to remove default concatenator after importing Insight objects
- Community blog that provides an example Groovy script: Groovy script to remove default concatenator after importing Insight objects
- links to
[JSDSERVER-8622] Add option to remove the concatenator completely when importing objects
| Support reference count | New: 2 |
| Labels | Original: pse-request | New: pse-request ril |
| Remote Link | New: This issue links to "Internal ticket (Web Link)" [ 977852 ] |
| Labels | New: pse-request |
| UIS | Original: 2 | New: 1 |
| UIS | New: 2 |
| Description |
Original:
h3. Problem definition
By default, when importing objects and concatenating values from multiple datalocators, the default concatenator is space. However, it is not possible to ignore the concatenator and not use any value (e.g. so that "ABC" and "1234" together become "ABC1234"). h3. Suggested resolution Add option to disable concatenator completely, so the values are concatenated without any character in between. h3. Workaround * Create the desired value right on the source side, example: ** If using database as a source, create a new column that contains concatenated values from other desired column values (without space), then use that new column as a datalocator. ** If using CSV as a source, open the file in Excel (or other spreadsheet editor) and use CONCATENATE function to generate a desired value in a new column, then use that generated column as a datalocator. * Use Insight Automation rule, that would execute a groovy script which would find if there is a space in the object attribute and remove it. |
New:
h3. Problem definition
By default, when importing objects and concatenating values from multiple datalocators, the default concatenator is space. However, it is not possible to ignore the concatenator and not use any value (e.g. so that "ABC" and "1234" together become "ABC1234"). h3. Suggested resolution Add option to disable concatenator completely, so the values are concatenated without any character in between. h3. Workaround * Create the desired value right on the source side, example: ** If using database as a source, create a new column that contains concatenated values from other desired column values (without space), then use that new column as a datalocator. ** If using CSV as a source, open the file in Excel (or other spreadsheet editor) and use CONCATENATE function to generate a desired value in a new column, then use that generated column as a datalocator. * Use Insight Automation rule, that would execute a Groovy script which would find if there is a space in the object attribute and remove it. ** Community blog that provides an example Groovy script: [Groovy script to remove default concatenator after importing Insight objects |https://community.atlassian.com/t5/Jira-Service-Management-articles/Groovy-script-to-remove-default-concatenator-after-importing/ba-p/1782832] |
| Security | Original: Atlassian Staff [ 10750 ] |
| Description |
Original:
h3. Problem definition
By default, when importing objects and concatenating values from multiple datalocators, the default concatenator is space. However, it is not possible to ignore the concatenator and not use any value (e.g. so that "ABC" and "1234" together become "ABC1234"). h3. Suggested resolution Add option to disable concatenator completely, so the values are concatenated without any character in between. h3. Workaround Create the desired value right on the source side, example: * If using database as a source, create a new column that contains concatenated values from other desired column values (without space), then use that new column as a datalocator. * If using CSV as a source, open the file in Excel (or other spreadsheet editor) and use CONCATENATE function to generate a desired value in a new column, then use that generated column as a datalocator. |
New:
h3. Problem definition
By default, when importing objects and concatenating values from multiple datalocators, the default concatenator is space. However, it is not possible to ignore the concatenator and not use any value (e.g. so that "ABC" and "1234" together become "ABC1234"). h3. Suggested resolution Add option to disable concatenator completely, so the values are concatenated without any character in between. h3. Workaround * Create the desired value right on the source side, example: ** If using database as a source, create a new column that contains concatenated values from other desired column values (without space), then use that new column as a datalocator. ** If using CSV as a source, open the file in Excel (or other spreadsheet editor) and use CONCATENATE function to generate a desired value in a new column, then use that generated column as a datalocator. * Use Insight Automation rule, that would execute a groovy script which would find if there is a space in the object attribute and remove it. |
| Description |
Original:
h3. Problem definition
By default, when importing objects and concatenating values from multiple datalocators, the default concatenator is space. However, it is not possible to ignore the concatenator and not use any value (e.g. so that "ABC" and "1234" together become "ABC1234"). h3. Suggested resolution Add option to disable concatenator completely, so the values are concatenated without any character in between. |
New:
h3. Problem definition
By default, when importing objects and concatenating values from multiple datalocators, the default concatenator is space. However, it is not possible to ignore the concatenator and not use any value (e.g. so that "ABC" and "1234" together become "ABC1234"). h3. Suggested resolution Add option to disable concatenator completely, so the values are concatenated without any character in between. h3. Workaround Create the desired value right on the source side, example: * If using database as a source, create a new column that contains concatenated values from other desired column values (without space), then use that new column as a datalocator. * If using CSV as a source, open the file in Excel (or other spreadsheet editor) and use CONCATENATE function to generate a desired value in a new column, then use that generated column as a datalocator. |