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

Unable to export DNG Module to xls or xlsx format

 Hello,


I am having a strange issue where I am unable to export my DNG module to .xls or .xlsx format but able to export in .CSV format.

I have more than 200 artifacts in a module and I am doing the following steps:

1.) Open a module.
2.) Right click on the speciifc view -> Select "Export View"-> xlsx or xls

I get empty EXCEL as a result.

Can anyone please help me out.

Best regards,
Shriraam Balasubramanian

0 votes

Comments

What version+iFix are you using? If you're not running the latest iFix for your version then update to the latest iFix and try again - if it still fails please create a support case.

 Hello Ian,


Thanks for your response.
We're using 6.0.6.1 iFix017

Best regards,
Shriraaam 

 Hello Ian,


Do I need to create a support case?

Yes it certainly sounds like you should.



One answer

Permanent link
I have had clients with this problem and we found it was artefacts in the module that contained unprintable characters or data.

The CSV export often showed these up as strange characters or blanks where there shouldn't be any, but the Excel export would silently fail

0 votes

Comments

What is the solution? What do you mean by unprintable characters?

We dont have any in this case as we have plain text and diagrams in this module.

Regards,
Shriraam

Well that's the problem with unprintable characters - you can't see them in the DNG text.

If you look through your CSV export you will sometimes see them as question marks where you don't expect them. The solution is to find them and edit the requirement to remove them

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
× 6,121

Question asked: Jun 17 '21, 6:19 a.m.

Question was seen: 2,020 times

Last updated: Jun 18 '21, 9:17 p.m.

Related questions
Confirmation Cancel Confirm