1. Roger
  2. Valentina Studio
  3. Saturday, March 13 2021, 04:37 PM
  4.  Subscribe via email
Hello

I try to make an export in Studio. Every time I have my exportet csv (or xls file) the order from the columns is an other. How can I make an export with every time the same column order? - Not rows!

Greetings Roger
Comment
There are no comments made yet.
Roger Accepted Answer
Ohh, perfect! Many thanks Sergey :D
Have a nice day Roger
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Sergey Pashkov Accepted Answer
As a temporary workaround you can disable saving the schema cache:
Preferences->General->Save and restore schema cache (screenshot attached)

After reopening the database the list of fields will be sorted by ID.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Roger Accepted Answer
Many thanks Sergey.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Sergey Pashkov Accepted Answer
I’m working on it right now.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
Roger Accepted Answer
... what think you - can I hope for an idea how to fix the export sort order from the columns or is it bether to make my export with program code?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
Roger Accepted Answer
sure, yes ?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 6
Sergey Pashkov Accepted Answer
And the database is Valentina?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 7
Roger Accepted Answer
In this case I made 4 exports to .csv files. Every row you see in the Excel file is the header row from one of my exports, the titles.

It is the same in export to cdv as a dump to excel.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 8
Sergey Pashkov Accepted Answer
But you export table, not query result, right?
What database is used?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 9
Roger Accepted Answer
Thanks Sergey

So far you have right, the eported order is the same as I see in fields to export - but every time I say "all fields export" in this list is a new sort order....

I send you a Excel file with the haeders from 4 exports and hardcopies from Studio.

I think the order change after a new start from my computer (Windows). And I have notbing changed in Studio.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 10
Sergey Pashkov Accepted Answer
Hello Roger,

So you select some table and in the context menu click Export to CSV, right?
In the dialog, you add all fields, and the columns in CSV should be exported in the exact same order.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 11
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories