Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Plugins Page: 1... 10 11 12 13 14 ...19  Previous   Next
Tool: ProfilerQuery
Author Message
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,508
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Good to know you got what you needed, mediadogg!
My freeware tools for DVD Profiler users.
Gunnar
 Last edited: by GSyren
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,508
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting mediadogg:
Quote:
open result to spreadsheet had all the fields jammed together in the first column

I'm a bit confused about this. Here is how it looks in LibreOffice (sorry about this being in Swedish, but I think you get the idea):


It's been several years since I worked with Excel, but I could have sworn that Excel did the same thing. Doesn't it?
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,508
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
ProfilerQuery 3.19.4

Spent some "precious time"    to fix so that saving flag set also works after duplicate check.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting GSyren:
Quote:
Quoting mediadogg:
Quote:
open result to spreadsheet had all the fields jammed together in the first column

I'm a bit confused about this. Here is how it looks in LibreOffice (sorry about this being in Swedish, but I think you get the idea):
...
It's been several years since I worked with Excel, but I could have sworn that Excel did the same thing. Doesn't it?

Yes. Isn't that just what I described? At least I thought it was. It just didn't come up automatically, because in the USA, the default delimiter for CSV is comma "," not semicolon. So you have to do it manually, but after the first couple of commands, you land at the exact same screen you show.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
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.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,508
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with 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.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
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.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting GSyren:
Quote:

... Comma is really not a good alternative since some titles contain a comma.

What stops a title (or notes, or overview) from including a semicolon?

In general, text fields should be enclosed in quotes when output to CSV and embedded quotes should be escaped. This gives the CSV parser a fighting chance, and allows an almost arbitrary inclusion of any text.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,508
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,508
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with 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. 
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,396
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
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).
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,508
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
ProfilerQuery 3.19.6

Fixes a memory leak when the collection is reloaded.
Again includes KeyCatcher.exe, which was accidentally dropped somewhere along the line.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantDraxen
I see shiny discs...
Registered: March 13, 2007
Finland Posts: 681
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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!
Mika
I hate people who love me, and they hate me. (Bender Bending Rodriguez)
 Last edited: by Draxen
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,508
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
With the help of Draxen I have found the problem. ProfilerQuery cannot handle profiles that have a pipe character (| sometimes called vertical mark) in the title. So if anyone has a problem with a title (probably a boxset) that is something like "Title A | Title B", changing the pipe character to a slash will eliminate the problem.

A fix for this will be included in the next update of ProfilerQuery.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 4,508
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
ProfilerQuery 3.19.7 fixes the pipe character problem.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantDraxen
I see shiny discs...
Registered: March 13, 2007
Finland Posts: 681
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting GSyren:
Quote:
ProfilerQuery 3.19.7 fixes the pipe character problem.


Thank You! 
Mika
I hate people who love me, and they hate me. (Bender Bending Rodriguez)
    Invelos Forums->DVD Profiler: Plugins Page: 1... 10 11 12 13 14 ...19  Previous   Next