Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Polarsys » Capella workbench » csv exports(comma in the values)
csv exports [message #1821177] Thu, 06 February 2020 16:03 Go to next message
Thierry Poupon is currently offline Thierry PouponFriend
Messages: 18
Registered: January 2020
Junior Member
I'm using a model which includes 283 OC in which 167 own a scenario. All these are implying 50 OEs. I'm currently transitionning OAS to OES and trying to track progression, in particular of declaring in the model the implications.
So I export the full OC list in a csv file, with all columns except description and review where some carriage return may occur.
The point is some of the columns show several traces. Then, the values are listed separated by commas.
So the two levels are mixed (several values in column, and columns). and my file has 66 commas in title row, and any values for other rows between 29 and 103! More, the list is using 3 columns in excel. (I immediatly resave to xlsx format to avoid truncature to 256 characters length).
Is it possible to change one of the separators in Capella?
Thank for any response or advise.
Thierry
PS: I can't share my model for confidentiality reasons.
Re: csv exports [message #1821289 is a reply to message #1821177] Mon, 10 February 2020 12:52 Go to previous messageGo to next message
Philippe Dul is currently offline Philippe DulFriend
Messages: 25
Registered: November 2013
Junior Member
Hi,

There is a preference in Capella 1.4.0 to change the separator for csv export:

https://github.com/eclipse/capella/wiki/Release-Notes-1.4.0#added-preferences-to-select-csv-delimiter-used-in-export

Windows / Preferences / Capella / Export / CSV

Best regards,
Philippe
Re: csv exports [message #1821380 is a reply to message #1821289] Wed, 12 February 2020 08:16 Go to previous message
Thierry Poupon is currently offline Thierry PouponFriend
Messages: 18
Registered: January 2020
Junior Member
Thanks
Since, I have found that the issue was not the separator, as Capella separates columns by brackets in addition to comma. When several values are in one column, they are only separated by comma. The issue is coming from several colomns. For some reasons the export process generates a wide matrix. By export process I include csv generation, and then save as xlsx. I expected a single column file, but I have a variable width matrix. So, importing the matrix into my main workbook, I need to run the query, add a column to concatenate all, and then run a second query to separate the columns again.
Is there anyway to understand the character that causes this column split? (It does not occurs between the same fields for all rows)... I understand Excel support is needed too.
Thanks
I try again to migrate to 1.4.0 (from 1.3.0)...
Previous Topic:"Edit -> Copy" command is disabled
Next Topic:Data Bus Interface Definition and Instantiation
Goto Forum:
  


Current Time: Thu Mar 28 13:39:53 GMT 2024

Powered by FUDForum. Page generated in 0.02355 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top