Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RDNG : Export in xlsx format from Module view without link address.

Questions
Tags
Users
Badges
Vani B
(154●3●13●75) Aug 01 '22, 2:40 a.m.

Export in xlsx format from Module view without link address.

0 votes

Comments
Ian Barnard
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Aug 01 '22, 4:25 a.m.
Please edit more specifics because I don't see an actual question in your 'question'.- also note that readers aren't omnisicent of your situation and may need to know the version+ifix you're using and if there's an issue with spreadsheet export then include the details of what you did, what result you get, and what result you expected.

Vani B
Aug 01 '22, 4:47 a.m.
 CLM Version 6061 IFX024 For Example if we have artifacts in module which has "satisfied  By"  link data, when try to export the module view to CSV/EXcel. In the export excel sheet Satisfied By column data is like 1082183.1135740: uuuuuuuuuuuuuuuuuuuuu {LINK id=1082183.1135740 uri=https://test.com/rm/resources/MB_19389929bc9e4d5b9923dd4257ca1610} instead it should be "082183.1135740: uuuuuuuuuuuuuuuuuuuuu" 

2 answers
3,097 views
0 votes

Accepted answer

Permanent link
Kimberly Boshers
(103●8) Aug 01 '22, 10:40 a.m.

I run a find and replace to the worksheet output using wildcard.  Find what: {*}

Don't enter anything for Replace with:
Replace All

Vani B selected this answer as the correct answer

0 votes

One other answer

Permanent link
Ian Barnard
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (3.0k●7●15) edited
Aug 01 '22, 6:19 a.m.

 So I'm treating your question as "When I export a DOORS Next view to spreadsheet the link columns contain text like 1082183.1135740: uuuuuuuuuuuuuuuuuuuuu {LINK id=1082183.1135740 uri=https://test.com/rm/resources/MB_19389929bc9e4d5b9923dd4257ca1610}

I need the spreadsheet to contain like "082183.1135740: uuuuuuuuuuuuuuuuuuuuu" - how can I get this formayt?"

You can't - the link columns always contain the full link definition because otherwise roundtrip wouldn't be possible. I guess you'll have to post-process the spreadsheet content if you don't need the link information.

You could create an Idea to request different/enhanced functionality from spreadsheet export, explaining the business value of this change - see Welcome to the IBM Ideas Portal

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,144

Question asked: Aug 01 '22, 2:40 a.m.

Question was seen: 3,097 times

Last updated: Aug 01 '22, 10:40 a.m.

Confirmation Cancel Confirm