| Author |
Message |
| Registered: March 14, 2007 | Reputation:  |  Posts: 6,744 |
| | Posted: | | | | 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
 |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 3,321 |
| | Posted: | | | | 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 |
|
| Registered: May 22, 2007 | Reputation:  | | Posts: 1,033 |
| | Posted: | | | | 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 |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | 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 |
|
| Registered: March 13, 2007 | | Reputation: |  Posts: 3,436 |
| | Posted: | | | | 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) |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,744 |
| | Posted: | | | | 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 |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 2,005 |
| |
| Registered: April 13, 2007 | | Posts: 26 |
| | Posted: | | | | Has anyone seen this error while trying to export with this plug in?
"Object reference not set to an instance mof an object" |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | 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. |
|
| Registered: June 29, 2007 | | Posts: 30 |
| | Posted: | | | | 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 |
|
| Registered: May 22, 2008 | | Posts: 11 |
| | Posted: | | | | 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. |
|
| Registered: June 29, 2007 | | Posts: 30 |
| | Posted: | | | | 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. |
|
| Registered: June 29, 2007 | | Posts: 30 |
| | Posted: | | | | 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. |
|
| Registered: April 13, 2007 | | Posts: 26 |
| | Posted: | | | | 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" |
|
| Registered: March 21, 2007 |  Posts: 1 |
| | Posted: | | | | 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 |
|
| Registered: June 29, 2007 | | Posts: 30 |
| | Posted: | | | | 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 |
|