Database viewer enhancements?

[otrov]

I recently posted about custom column in AS, and in same direction some workaround could be CSV file: first column set to filename, and others user defined; then selecting some filename rows and copying to clipboard to take advantage of "Load selection (^#F6)" works beautifully IMO. However I just noticed that CSV viewer is limited in what I expected:
1. Can't sort columns (this is huge request I know)
2. ^LMB (Ctrl+click) to select multiple rows doesn't work (right now #LMB works for selecting multiple rows, but that is not enough)
3. minor bug: Full screen button doesn't work as expected (on my end it works as window restore button)

[edit]:
2. #LMB doesn't work, but left click+drag

+ I don't know if it's my graphic driver but when row width is larger then screen layout, then moving scroll bar garbages presented row data, I can post screenshot if needed

[Jan Patera]

+ I don't know if it's my graphic driver but when row width is larger then screen layout, then moving scroll bar garbages presented row data, I can post screenshot if needed

Yes, please, post a screenshot and the file in question. Thanks.

[otrov]

I somehow didn't received notification about topic reply, as I probably forgot to subscribe as I usually do, so I saw reply just now and here is screenshot:



It affects one particular long row or maybe two sometimes IIRC. I don't know if it's my graphic driver (onboard Intel 82945G Express) on Win 7 U 32b:

Intel Graphics Kernel Mode Driver / Intel Graphics Accelerator Drivers for Windows Vista(R)
system32\DRIVERS\igdkmd32.sys
igfx	8.14.10.1930	Kernel Driver	Running

but I haven't experienced similar in other programs. For example if I go left<->right while problematic row is visible, it gets more and more garbaged untill it turns to black filled rectangle. If the row looses sight, then going back to it, it seems like it refreshed, and than same thing happens again. Also see those three rows are selected, but selection background of problematic row isn't changed, etc

[otrov]

About requested file: I don't think it's file content related (it's TAB separated CSV file, BTW) as I copied some problematic rows in other file then opening it I can see that previously problematic rows aren't affected now. Here is another screenshot, with different kind of problem, but same as previous if I layer some dialog over it (like calc.exe in this example) that part of screen isn't refreshed:



Another issue could be also that in my previous screenshot, CSV file wasn't read whole. I then edited file, leaving last shown row (by Database viewer) and then rest of the file in new file (which is shown in my last screenshot) and it's read whole now.

[otrov]

Rows from 58-297 are truncated, and they show fine in other apps that can do CSV. Is there some limitation on file size (thou file is not big)?
I added attachment

Interestingly garbaged row is 57 after which couple of rows are truncated
I don't see anything special in row 57 in editor

[therube]

Options, CSV Options.

Set Text Qualifier to either Quotes or None.

Then your missing rows show up.

Actually thinking it should be set to None.

And that there in fact 8 (or is it 9) fields that should display.
Line# 57 has (") embedded within some of the fields.

Assuming that all fields are enclosed in ("), though the separator is TAB.
Some records, like #57, though not all, have (") embedded within the field.


You can use a program like CSVed for an alternate view.
If you go to edit #57, CSVed show: List index out of bounds (8).

Not sure that list.csv is valid, or at least valid in the manner that you're looking to have it?

[otrov]

The file indeed has double quotes in some fields that may confuse viewer, but then they have TAB separator as delimiter as you mentioned
However, I changed script which generated this files to filter double quotes in fields
Thanks

I know CSVed as only CSV editor which doesn't require gigantic frameworks just to read CSV file, but I think I had some issues in the past and removed it from my system. I'll keep it just in case as CSV is very handy format.
Also must say, AS viewers are bliss, I mean - try to open simple CSV file. Except text editor there is no way to quickly view CSV, it's either Excel (and all .NET machinery) or Calc (and all java stuff). That's why I asked for column sorting if possible, and Ctrl+click for multi-selection (which shouldn't be that hard I imagine)

Should I leave garbaged rows as graphic driver issue?

[Jan Patera]

Should I leave garbaged rows as graphic driver issue?

I can reproduce it. I will have a look.