1. Roger
  2. Valentina Studio
  3. Samstag, März 13 2021, 04:37 PM
  4.  Abonnieren via E-Mail
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
Kommentar
There are no comments made yet.
Roger Akzeptierte Antwort
Ohh, perfect! Many thanks Sergey :D
Have a nice day Roger
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Anhänge
Kommentar
There are no comments made yet.
Roger Akzeptierte Antwort
Many thanks Sergey.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
I’m working on it right now.
Kommentar
There are no comments made yet.
Roger Akzeptierte Antwort
... 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?
Kommentar
There are no comments made yet.
Roger Akzeptierte Antwort
sure, yes ?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
And the database is Valentina?
Kommentar
There are no comments made yet.
Roger Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
But you export table, not query result, right?
What database is used?
Kommentar
There are no comments made yet.
Roger Akzeptierte Antwort
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.
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  • Seite :
  • 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