It's all about the answers!

Ask a question

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


Vani B (135531) | asked Aug 01, 2:40 a.m.

Export in xlsx format from Module view without link address.


Comments
Ian Barnard commented Aug 01, 3:31 a.m. | edited Aug 01, 4:25 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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 commented Aug 01, 4:37 a.m. | edited Aug 01, 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" 

Accepted answer


permanent link
Kim Boshers (784) | answered Aug 01, 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

One other answer



permanent link
Ian Barnard (1.4k613) | answered Aug 01, 6:19 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
edited Aug 01, 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

Your answer


Register or to post your answer.