[BUG - Data] Dump n load order dump by order of input and show which id maps to which scenario

[louispt1]

Bug Description

When you dump scenarios by id, the scenarios are ordered on the bases of their id in the dump and therefore import. It would be useful to order the dump in the order given by the user, and to map the dumped ids to the newly created scenario ids on import.

---

Data Source

Internal scenario dump and load process

---

Type of Data Issue

What type of data issue is this?
Select all that apply:

• Data Quality
• Data Integrity
• Data Processing
• Data Loading
• Data Validation
• Data Transformation
• Data Export
• Other

---

Steps to Reproduce

Add or modify steps as needed.

1. Dump ids 1,3,2
2. Import your dump
3. Scenarios will be created with new ids, 5,6,7. 5 will likely map to 1, 6, will map to 2 and 7 will map to 3 - this is not the order the ids were input

---

Impact

Describe how this affects downstream processes or outputs.

This makes it harder to understand which scenario is which after you've imported them, which can make testing more cumbersome than it necessarily has to be.

Proposed solution:

• Order scenarios based on the users' input
• Map the newly created scenario ids to their original ids on import

[github-actions]

This issue has had no activity for 60 days and will be closed in 7 days. Removing the "Stale" label or posting a comment will prevent it from being closed automatically. You can also add the "Pinned" label to ensure it isn't marked as stale in the future.