jokedst / CsvQuery

Plugin for Notepad++ that treats CSV files as (read only) SQL tables
152 stars 28 forks source link

CSVQuery not working on Notepad++ 8.4.8 #39

Closed paulsimongb closed 1 year ago

paulsimongb commented 1 year ago

Hi

CSVQuery 1.2.9 is not working on Notepad++ 8.4.8. When I select Toggle CSV Query Window, nothing happens. There is no error but the split screen parsing into columns no longer happens.

paulsimongb commented 1 year ago

These are the Plug Ins installed in case the problem is due to a conflict between them, however, for example CSV Query used to work Ok with CSV lint.

image

jokedst commented 1 year ago

Can not reproduce :( Works for me. I tried both 64 bit and 32 bit Notepad++, I installed CSV Lint and it worked fine with both running on the same file.

Could you try to turn on "debug mode" in the settings, then select "manual parse settings" in the CSV Query menu, then click "Try again". A debug popup should show some statistics. Does it? If CSV query crashes or something that debug window shouldn't show up.

freeriderx11 commented 1 year ago

Hello

I have this error on Notepad++ 8.4.8 when I clic Read File in CSVQuery : 2023-01-05_09h49_01

paulsimongb commented 1 year ago

Hi

I tried what you suggested.

The debug window does open and shows

image

I tried it with Manual Parse Settings as follows

image

and also with

image

Neither work.

The overall Debug Info for Notepad++ is

Notepad++ v8.4.8 (64-bit) Build time : Dec 24 2022 - 19:40:27 Path : C:\Program Files\Notepad++\notepad++.exe Command Line : Admin mode : OFF Local Conf mode : OFF Cloud Config : OFF OS Name : Windows 10 Pro (64-bit) OS Version : 21H2 OS Build : 19044.2364 Current ANSI codepage : 1252 Plugins : ComparePlugin (2.0.2) CSVLint (0.4.6.2) CsvQuery (1.2.9) mimeTools (2.9) nppConverter (4.5) NppExport (0.4) NPPJSONViewer (2.0.3) XMLTools (3.1.1.13)

Regards

Paul SImon

jokedst commented 1 year ago

That debug popup indicates CSVQuery "works", as in it parses and displays the results. Somewhere.

Could it be that you have detached the window and it's hiding outside the screen or something? I know that happened to me in the past :P Can't remember how I fixed it though.

@freeriderx11 that seems like an unrelated problem. That looks like some problem when writing the CSV to the data grid. Could you try another CSV file?

paulsimongb commented 1 year ago

Hi

I finally figured out what was going on. The window was docked in the lower pane and somehow, the lower pane had zero height so it was there but invisible. I just needed to drag the split point up.