Exporting Requirements to CSV - include Not

[Prev]

Hi there,

Sorry if this is a duplicate query, I would like to export a set of requirements to CSV from EA but also include the "Notes" text.  I know how to export Requirements in general, but I can only seem to export the titles.

Many thanks in advance.
Prev

[Geert Bellekens]

Have you tried to create a search that returns only the fields you need, and then copy/paste that into excel?

Geert

[Stefan Bolleininger]

You can include the notes field into a csv specification

"Project"->"Model import/export"->"CSV Import/Export Specifications"

There you can create a new search and include what you want.

Be aware, a csv means comma seperated value every notes with a "," in it will seperate....

Geerts solutions is better for saving up the complete text with notes.

[OpenIT Solutions]

Two tips here -

on Windows you can goto Control Panel -> Regional and Language Options -> Customize and change "List separator' to be say a | (pipe) - this way when you copy and paste a search result from Sparx into a .csv file you will be able to view it correctly in say Excel - even if names and notes contain commas.

one that got me - by default "View Notes" notes option on the Model Search is set to "Hide Notes" - so your notes will not be shown even if you include them in your sql etc - you need to select "Notes Preview" or "Full Notes"

Regards,

Jon.