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... 3 4 5 6 7 ...14  Previous   Next
New Plugin: CSVExport
Author Message
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,736
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
btw: would it be possible to use the semicolon as field seperator instead of the comma? Everytime I open a file from the CVS export in excel everything is put in the first field.
Karsten
DVD Collectors Online

DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Is that just a German thing?  Because CSV stands for Comma Separated Values.  I've never heard of anything defaulting to semicolons.  But perhaps that's just a US standard?

Regardless, it sounds like a fairly easy change.  I'll try to get to it at some point in the near future.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
 Last edited: by Mark Harrison
DVD Profiler Desktop and Mobile RegistrantAgrare
Registered: May 22, 2007
Reputation: High Rating
United States Posts: 1,033
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
Is that just a German thing?  Because CSV stands for Comma Separated Values.  I've never heard of anything defaulting to semicolons.  But perhaps that's just a US standard?

Regardless, it sounds like a fairly easy change.  I'll try to get to it at some point in the near future.


I'd make it a setting if you could (which should also be easy to do) Possibly also include a colon as a possible seperator or just user definable (though that could result in some false seperations). Also, if your adding options, you may want to consider also being able to set the text qualifier ( " or ' and i think their may be another one that is commonly used)

mind you I haven't used this plug in (haven't had a use for it yet) so it may already be available. Just throwing out some related suggestions you may want to consider/evaluate.

@ DJ, it would be failry easy using a text editor such as textpad or even writing a simple program to convert the comma's in the output from Mark's plug to semicolons

-Agrare
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,394
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
Is that just a German thing?  Because CSV stands for Comma Separated Values.
I was also intrigued by this, as I have written a bunch of data conversion programs in the past, and I never had any trouble using the comma, and I know that my programs were used outside the US. But I did I find the following quote in the instructions for a particular program out there on the WWW, so I guess things have changed since I made those progarms years ago:

"You can choose between English CSV (columns are separated by comma, decimal separator is the point) and German CSV (columns are separated by semicolon, decimal separator is the comma). The default option and presetting for the direct download is the language of the presentation. Please note that the CSV file may display incorrectly if you have not chosen the CSV language suitable for your country setting."

From here - seems like a reputable source.

(Edit: I wonder if you could switch the Excel country setting temporarily to US English, do the import, then switch it back - that should work, right?)
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Reputation: High Rating
Taiwan, Province of China Posts: 3,432
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
OpenOffice allows you to select the type of separator when opening the file


Well, admittedly, comma is slightly more trouble than semicolon, as it is more likely to appear within th data... The safest separator is, as used by the Awards files etc., the pipe (|).
Achim [諾亞信; Ya-Shin//Nuo], a German in Taiwan.
Registered: May 29, 2000 (at InterVocative)
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,736
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Agrare:
Quote:

@ DJ, it would be failry easy using a text editor such as textpad or even writing a simple program to convert the comma's in the output from Mark's plug to semicolons

Yup, currently I am doing this

Quoting mediadogg:
Quote:
"You can choose between English CSV (columns are separated by comma, decimal separator is the point) and German CSV (columns are separated by semicolon, decimal separator is the comma). The default option and presetting for the direct download is the language of the presentation. Please note that the CSV file may display incorrectly if you have not chosen the CSV language suitable for your country setting."


That sounds likely because in Germany you do indeed use the "," as decimal seperator

1.234,56 € = one-thausand-two-hundred-thirty-four Euros and fifty-six Cents.
Karsten
DVD Collectors Online

 Last edited: by DJ Doena
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,004
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Excel uses the semicolon as separator when opening CSV files on German OS. You could do Import Textfile and then you can choose the separator yourself.

As I proposed in the past for this plugin:
Either it could be an option to change the separator (easy solution). Or you query the system for the separator to use.
http://msdn.microsoft.com/en-us/library/bb507201(VS.85).aspx

I think "LOCALE_SLIST" is the constant in question used in the CSV files.
"LOCALE_SDECIMAL" on the other hand is used to get the decimal separator.


DVD Profiler Unlimited Registrantabierce512
Registered: April 13, 2007
Posts: 26
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Has anyone seen this error while trying to export with this plug in?

"Object reference not set to an instance mof an object"
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting abierce512:
Quote:
Has anyone seen this error while trying to export with this plug in?

"Object reference not set to an instance mof an object"


Try re-installing the plug-in.  I know when I've uninstalled other plug-ins, it can break the remaining ones.  I think some shared file gets removed.  Re-installing the export plug-in seems to fix everything again.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantScaryBear
Registered: June 29, 2007
Posts: 30
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
Quoting ScaryBear:
Quote:
Has there been any discussion on whether it would be possible to include Tags in the export?  I use tags for setting TV, Box Set, Misc, etc, which would be handy for creating these pages.  Right now, I put things like 'TV' or 'Box Set' somewhere in the Edition field and have the database pick it up from there, but having it use tags would be very handy.


I've avoided tags because it seemed like it could get messy.  And no one ever wanted them before.  I have profiles that have multiple tags assigned.  What do you do with those?  And do you list the full path of the tag like HD/Blu-Ray or just list Blu-ray?

The easiest way to do it would be to just list the deepest tag and stuff multiple tags into a single field separated by commas.  Would that work?

So if I had something like Planet Earth tagged as Documentaries/Nature and TV/Other for example, I'm thinking the easiest way to go would be a single field that would list Nature, Other.  But that's not very descriptive.  So maybe it would be better to list the full tag and separate them like "Documentaries/Nature, TV/Other".

Thoughts?


Wow, I was expecting a straight to the point "No", "Not gonna happen", "Don't ask again" lol

That would be awesome if you could build that in as you described in just one field.  I was thinking it would have to be many fields, but your way would be perfect.

I would be very happy with just the deepest tag to keep the field from getting too big.  You could also limit the length of each tag to say 10 characters or the total length of the field at 255 char, or both, just to make sure the field can be used without any problems (if you're concerned about field length, otherwise don't bother, it would work fine for me either way).  Either comma or semi-colon separated would both work fine, just as long as the field was in quotes (which I'm sure it would be since the rest of the fields in your csv export are in quotes, but just thought I'd mention it).

So if I have a movie tagged as follows ...

HD/Blu-ray
Non-Movie/TV
Other/Gift
Other/Seasonal/Xmas

... the Tag field in the csv file would be "Blu-ray,TV,Gift,Xmas"?  I'm pretty sure that's what you are saying, and that would be perfect for me.

Thanks
 Last edited: by ScaryBear
DVD Profiler Unlimited RegistrantZogger
Still playing....
Registered: May 22, 2008
Posts: 11
Posted:
PM this userDirect link to this postReply with quote
Thanks for creating this. It allowed me to get my collection on my iPhone without having to enter it manually. By the way for the person wanting to use semicolons, try using Notepad or any text editor, you can do a find and replace for the comma to semicolon change.
DVD Profiler Unlimited RegistrantScaryBear
Registered: June 29, 2007
Posts: 30
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Zogger:
Quote:
Thanks for creating this. It allowed me to get my collection on my iPhone without having to enter it manually. By the way for the person wanting to use semicolons, try using Notepad or any text editor, you can do a find and replace for the comma to semicolon change.


Just curious how you got your collection on your iPhone.  What iPhone app are you using?  The only app I've seen so far that could import a csv is DVD Dashboard which only shows the title and one genre ... not that there's anything wrong with that, it's just a bit limited for what I'd like to see.
DVD Profiler Unlimited RegistrantScaryBear
Registered: June 29, 2007
Posts: 30
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I see there is a new iPhone app for importing CSV files with all the details called CSV Touch.  Haven't tried it yet though, though I will in the next few days.
DVD Profiler Unlimited Registrantabierce512
Registered: April 13, 2007
Posts: 26
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
I have unistalled and re-installed several times and I still can not export with this utilty, I would love to be able to use it but I always get this error

"Object reference not set to an instance of an object"
DVD Profiler Unlimited RegistrantTinyTim
Registered: March 21, 2007
Netherlands Posts: 1
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Great plugin!

Just got a minor issue with the purchase price. Ran into it when Insurance asked for approx. value of my collection.

I'm buying Discs in the US, UK and EU, so different currencies.

example
US Purchase
info in DVDP:
purchase price 21.95, Currency $
info in export:
purchase price €21.95 (format currency = number), SRP $21.95  (format general = text)

UK Purchase
info in DVDP:
purchase price 13.15, currency £
info in export:
purchase price £13.15 (format general = text), same goes for SRP

No problems for € (is default in DVDP and Vista/Excell)

Perhaps it's an idea to be able to export the currency field (as in the personalize DVD Option) and export the Purchase price as a value.

Thnx

Tim
DVD Profiler Unlimited RegistrantScaryBear
Registered: June 29, 2007
Posts: 30
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I finally got around to trying out CSV Touch for the iPhone and it works really well.  Had no problems with 1800 records and 15 fields. Files are downloaded into the iPhone from any website or FTP (I used MobileMe), and once downloaded it's easy to sync when changes are made ... just upload a new file to the original website or FTP with the same file name, and click on the sync button in CSV Touch.  Fields can be moved around and deleted as well.

If using MobileMe, you will need to use the idisk.mac.com/username-Public/filename.csv format, not the one shown in MobileMe of public.me.com/username/filename.csv.  Apparently MobileMe changes the format of the file when downloaded via public.me.com.

You can find more info here: http://www.ozymandias.se/Ozymandias/Home.html
    Invelos Forums->DVD Profiler: Plugins Page: 1... 3 4 5 6 7 ...14  Previous   Next