1. Roger
  2. Valentina Studio
  3. Суббота, Март 13 2021, 04:37 PM
  4.  Подписаться через 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
Комментарий
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.