search

spine-tools / Spine-Toolbox

Spine Toolbox is an open source Python package to manage data, scenarios and workflows for modelling and simulation. You can have your local workflow, but work as a team through version control and SQL databases.
https://www.tools-for-energy-system-modelling.org/
GNU Lesser General Public License v3.0
70 stars 17 forks source link

Excel import export parameter sorting #507

Closed spine-o-bot closed 1 year ago

spine-o-bot commented 3 years ago

In GitLab by @DillonJ on Apr 1, 2020, 17:46

When exporting a database having used the new purge functionality, I get inconsistent ordering of the parameter columns across different dbs... this is inconvenient for copy/paste and such.

Perhaps whether there is data or not somehow impacts on the ordering.

spine-o-bot commented 3 years ago

In GitLab by @pvper on Apr 2, 2020, 09:30

I guess we could always sort by name for parameters when exporting, would that solve this problem?

spine-o-bot commented 3 years ago

In GitLab by @DillonJ on Apr 2, 2020, 11:00

Hi @pvper Per - yes, I think this would solve it nicely

spine-o-bot commented 3 years ago

In GitLab by @soininen on Sep 21, 2020, 12:26

assigned to @soininen and unassigned @pvper

spine-o-bot commented 3 years ago

In GitLab by @manuelma on Sep 21, 2020, 15:01

There is #783 that might be related.

soininen commented 3 years ago

@manuelma Are you working on that Excel export? Can you get this fixed on the same go (if the bug is still there)?

jkiviluo commented 1 year ago

Is this still around?

soininen commented 1 year ago

Looks like we sort the columns by name now. I think we can close this one.