Book a Demo

Author Topic: How do you prevent CSV Import from sorting results?  (Read 2771 times)

mse

  • EA User
  • **
  • Posts: 308
  • Karma: +1/-0
    • View Profile
How do you prevent CSV Import from sorting results?
« on: November 14, 2019, 08:56:07 pm »
I noticed that after importing a CSV file into EA, the resulting requirements elements are sorted in the package based on the "Name" field. I do not want it to sort. I want the import to have the same order as the original CSV. Is there a way to control this somehow?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How do you prevent CSV Import from sorting results?
« Reply #1 on: November 14, 2019, 09:14:57 pm »
Can you add the treepos field to the CSV import/export specification?

Geert

mse

  • EA User
  • **
  • Posts: 308
  • Karma: +1/-0
    • View Profile
Re: How do you prevent CSV Import from sorting results?
« Reply #2 on: November 15, 2019, 07:09:07 pm »
Do you mean CSV_KEY and CSV_PACKAGE_KEY? If so, I am trying that out now and it seems to deliver good results. It might take some VBA scripting to create these two columns with the fields, but that is tolerable it seems.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How do you prevent CSV Import from sorting results?
« Reply #3 on: November 15, 2019, 07:37:19 pm »
No, I just checked, and the tree position field is apparently not available in the CSV specification.

In the latest version of the excel importer (5.0) I added this as an available field.
You might be able to use this as an alternative.

I haven't officially released it yet, but you can download it from here: https://drive.google.com/open?id=10h6ijv1jqwWi6RtEXEHwUTFAsihzSa0E

Geert