Good to know you got what you needed, mediadogg!

ProfilerQuery 3.19.4

Spent some "precious time"    to fix so that saving flag set also works after duplicate check.

Quoting GSyren:

Quote:
ProfilerQuery 3.19.4

Spent some "precious time"    to fix so that saving flag set also works after duplicate check.

Works a treat.

Quoting GSyren:

Quote:
Quoting mediadogg:

Quote:
Yes. Isn't that just what I described?

Ok, I just thought it would always come up automatically on text import, because that's the way it behaved back when I used Excel, and that's the way LibreOffice always behaves (at least for me). That's not quite the same as doing a text-to-columns after the import, even though the result is the same.

For the third time: in USA, the CSV delimiter defaults to "," not ";".

When I edit your CSV file to replace the ";" with "," my Excel automatically parses the fields, just as your LibreOffice does. But you can't reliably edit CSV for delimiters if the CSV might contain quoted text that includes the delimiter. That's why I didn't suggest the edit step in my instructions.

If you gave users the option of selecting the delimiter for their locality, the problem would go away. 

Oh, and BTW Excel, by default, interprets a UPC as a number and might even convert it to scientific notation, if you don't reformat the UPC column to text. To force that conversion, the CSV export should enclose the UPC in double quotes, and insert a single quote in front of the UPC, e.g. "'043396275171.3". But that embedded quote screws up the flag set, when you save that column to text.

Quoting mediadogg:

Quote:
For the third time: in USA, the CSV delimiter defaults to "," not ";".

That may well be, but I think we're talking cross purposes here, because I don't see how that matters.

When I open the csv file in LibreOffice, the very first thing I see is that dialog. Basically it asks How would you like to import this file. So I check the box for delimiter that says Semicolon. In the example grid within the dialog I click the first column and I select  Column Type: Text. I then select the other columns and I select Column Type: Hide. I click OK, and Bob's you uncle - the program imports the first column only and sets it to Text.

This dialog always shows when I open a csv file,, so there is no need to go through the text-to-columns steps after the import. This happens no matter what the delimiter within the file happens to be. I was convinced that the same thing applied to Excel.

You are right, though, that text fields show be quoted. Not sure why I didn't do that in the first place. Probably because I didn't think of it because I never had any issues with text fields. I never came across a title with semicolon, and I never even thought of including overview or notes in the output. I should have thought about it, because I knew that text fields could - and should - be quoted. I intend to remedy that.

Quoting GSyren:

Quote:
ProfilerQuery 3.19.5
- Fixed quoting of strings in csv export (which includes Open in Spreadsheet).
- Added comma as configurable separator in csv export.
- Finally got around to fixing the misspelling of "spreadsheet" in the File menu. 

Wow, quick work. Thanks. Now my Excel will open up with the work already done. In my case, I don't get the dialog unless I request a text to column parsing. Maybe there is an option I don't know about. Anyways, your quick work makes it all moot now!!!    (that's a moot woot).

Hello Gunnar,

I ran into following problem with v3.19.6 (copied from error-dialog)

Quote:
ProfilerQuery 3.19.6


NullReferenceException: Object reference not set to an instance of an object.
  at ProfilerQuery.MainWindow.RunENDED() in C:\Users\User\Documents\Visual Studio 2017\Projects\ProfilerQuery\ProfilerQuery\MainWindow.xaml.vb:line 233

Maybe this tells you right away, where I should look for solution? I use Win10, DVDP 4.0.0 build 1762. I don't have "Visual Studio 2017" and I don't think I ever did.

I had exported from database (blu-rays only) to Collection_blu.xml (only content needed in "Presentation"- see pic below) and opened this file in ProfilerQuery:

Main selection (as you can see 1794 blu-rays loaded):


Presentation:


... clicking on "RUN!", I get the above error message and only the following 5 entries are found:


Any help is greatly appreciated if you know what might be wrong. Thanks!

ProfilerQuery 3.19.7 fixes the pipe character problem.