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  Previous   Next
Tool: ProfilerQuery
Author Message
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 2,785
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 software
Gunnar
 Last edited: by GSyren
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 2,785
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 software
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 2,785
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 software
Gunnar
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,923
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.
 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: 4,923
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.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 2,785
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 software
Gunnar
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,923
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.
 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: 4,923
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.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 2,785
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 software
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 2,785
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 software
Gunnar
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,923
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.
    Invelos Forums->DVD Profiler: Plugins Page: 1... 10 11 12  Previous   Next