Book a Demo

Author Topic: Do I have to use GUID for csv roundtrips?  (Read 2320 times)

mse

  • EA User
  • **
  • Posts: 308
  • Karma: +1/-0
    • View Profile
Do I have to use GUID for csv roundtrips?
« on: April 23, 2024, 09:53:33 pm »
I have been experimenting with the CSV import of requirements and I cannot find a way to use my own unique IDs. Every import just copies the requirements again and I get lots of duplicates. If I add GUIDs to the csv then it updates the requirements. I do not want to use the GUIDs because the system I am using has nothing similiar to that unless I add an attribute to it.

Is there an alternate ID I can use to update requirements in a package or do I have to script this one out? For example, suppose I have a requirement in my EA model with the following attributes


Name: Perform Startup
Description: TBD
TOOL-ID: ACME12-12345
Status: Draft

In the CSV file, it is like this:

Name, Description, TagValue_TOOL-ID,Status
Perform Startup, TBD, ACME12-12345,Draft

When I make changes in the ACME tool I would like to import again into EA and have that exact requirement updated.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Do I have to use GUID for csv roundtrips?
« Reply #1 on: April 23, 2024, 10:33:27 pm »
When using regular CSV import/export you can only use the GUID.

There are a few possible options:

1. you export the EA GUID back to your third party tool, and make sure it gets added in an export
2. you write a script to merge a CSV export from EA (with GUID's) with a CSV export from your other tool (without GUIDs) and then use regular CSV import
3. you write a script to merge the CSV export from your other tool directly in EA.

If 1 is not possible, I would probably opt for number 3

Geert