I think Personal Video Database is the best of its kind that I've tried, the feature to have a list of actors is especially appreciated and I like the fact that it is very customizable.
My question is regarding CSV import, I don't seem to be able to import a movie through a CSV file no matter what I do. I've searched the threads and it looks like the usual workaround is to use XLS instead, but I wonder if I am misunderstanding something, particularly since it doesn't prompt for field structure on each import, which implies to me that there is some best configuration for the CSV plugin that I shouldn't have to keep changing. I may have some questions about XLS import as well, but I'll start with this because it may answer some of my XLS questions as well.
In preferences for the CSV import I have two fields pushed over to the right Title and Actors (if this were a real example, the intention would be to pull the remaining fields from IMDB -- love the Ctrl-Alt-I shortcut). And I have a file that looks like this in Notepad:
"This is a test","No actor"
So to me, after importing, I should have a movie called This is a Test (which I don't).
I even tried exporting to CSV and I even failed to import that file. I noticed the export created semicolon separated values in the file, so I also tried using semicolons in the delimiter for import. Also the exported file has three characters that appear at the beginning of the file ?»? in Notepad and Excel, which I am not sure what to make of. I am running Windows 7 x64.
So is there a best way to set up CSV plugin preferences to make it work or should I just stick with XLS files?