CSV Import

[Dorian Workman]

Has anyone had success importing a CSV file into EA?  I'm trying to import a list of requirements from Excel, without success.  These were my steps:

1. Format excel file into 3 columns, with columns headings of Name, Type, Notes.
2. Save as .csv file
3. In EA, right-click on the Requirements package and select CSV Import/Export
4. Create a new specification, with elements of Name, Type, Notes
5. Select my .csv file, hit Run

It fails, with error of Bad object type when creating record of type "  

Can anyone help please?

Thanks.

[mrf]

I've found the best thing to do when learning CSV import is to

1. Create a mock set of elements in EA
2. Create a CSV specification with the fields you require
3. Export the mock package to CSV using the specification created in step 2 and inspect it to see what sort of values EA is expecting.
4. Modify your original CSV file to conform with the output generated in step 3.

PS: Try stripping your CSV of quotes (") and see if that makes a difference.

[Dorian Workman]

Your advice to export first worked!  I was setting the 'Type' value incorrectly in my .csv file.  I was setting it to 'Functional', it needed to be set to 'Requirement' (i.e. the element type, duh!).

Thanks!