Lose sorting when exporting to .csv

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
I sort on a header (text field) prior to exporting, then "save as a spreadsheet".  The .csv file has the correct sorting up to row 2020 on one table (exported 31083 records), and up to row 2200 on another table (exported 23263 records).  After row 2020 and 2200 respectively, the sorting disappears and data is in no particular order.  Any ideas?
Photo of ChameleonPLM Admin

ChameleonPLM Admin

  • 100 Points 100 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
How many records are being displayed on the first page of the report before the "save as a spreadsheet" button is clicked"? Maybe clicking on the header only sorts the currently displayed records. Perhaps the workaround would be to only export a saved query using its defined sorting order rather than an interactively defined sorting order through clicking on the header.



Photo of ChameleonPLM Admin

ChameleonPLM Admin

  • 100 Points 100 badge 2x thumb
Hi Dan - thanks for your help.   On the 23263 record table the displayed records on the first page = 200, but records displayed throughout the entire 117 displayed pages is sorting correctly.  Only the export sorting is breaking at row 2200.  This is exactly the end of page 11 in the display.  I just tried your idea and did a defined sort (under customize this report), then exported, and the exported .csv sorting is breaking at exactly the same place as when I sorted via clicking the header - row 2200 of the 23263 records.  
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
I would have to see the app and data to confirm the problem and debug. I would take it up with QuickBase support.