1. Roger
  2. Valentina Studio
  3. 土, 3月 13 2021, 04:37 PM
  4.  メールで購読
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
コメント
There are no comments made yet.
Roger 承諾済みの回答
Ohh, perfect! Many thanks Sergey :D
Have a nice day Roger
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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.
添付ファイル
コメント
There are no comments made yet.
Roger 承諾済みの回答
Many thanks Sergey.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
I’m working on it right now.
コメント
There are no comments made yet.
Roger 承諾済みの回答
... 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?
コメント
There are no comments made yet.
Roger 承諾済みの回答
sure, yes ?
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
And the database is Valentina?
コメント
There are no comments made yet.
Roger 承諾済みの回答
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.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
But you export table, not query result, right?
What database is used?
コメント
There are no comments made yet.
Roger 承諾済みの回答
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.
添付ファイル
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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.
コメント
There are no comments made yet.
  • ページ :
  • 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