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.

Export in xlsx format from Module view without link address.

0 votes

Comments

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.

 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" 


Accepted answer

Permanent link

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

 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.

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,019

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

Question was seen: 993 times

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

Confirmation Cancel Confirm