Feature to export/import postal routes

[audig]

In our context, we have numerous routes defined in Postal.

While exploring options to export and import the list of routes to another instance, we came to the conclusion that recreating all Postal data through the UI is mostly feasible due to our limited customization, except for the routes. With thousands of routes, which were created by our software over time, manual recreation would be time-consuming.

We identified a solution by exporting the routes table and importing it into the new MySQL instance. However, this process requires considerable effort to update the dump with new server IDs, endpoint IDs, and domain IDs.

To streamline this, it would be great if postal had a feature allowing an export as CSV. This way, users can easily update the CSV file and import it into another instance, eliminating the need for manual ID adjustments.

This feature could be developed either as a form in the UI or as an API call. It would significantly enhance the efficiency of managing routes across instances.