Personal Video Database

 This is a non important request and might be put at the bottom of Nostra's TODO list but just in case there is an easy way to implement it...

 What I'd like to be able to do is to export my database stats. The way they are presented is quite restricted and you cannot really manipulate them on screen.
 If we were able to export them as Tab-delimited files then we could open them in Excel for instance and generate our own representations.
 Actually the main point of this is that these stats are quite good to spot mistakes and holes in the data, like missing years, wrong genres and so on...

Have you configured the Excel import plugin properly?

It sounds obvious now that you say it... I' ll check that out and get back to you if problems.

Thanks

 I am working at exporting and re-importing my database in an attempt to fix the firebird problem we have already covered with Nostra, Buah and Rick.
 I have created a test database of two movies and I am only testing a simple export import of these out/in pvd.
 Exporting into an xml file goes with no problem but when I want to import it into pvd the databse just crashes on me.
 I have no idea why so I am attaching the bug report here if it helps. I am also attaching the .xls file (I have changed the extension to txt so that I could attach it)
 
 I have not yet updated to version 19 of PVD because this mean I would have to again manipulate firebird embedded files and all that mess I have to do with every new version of PVD.

 May I add that this is properly scarying me, as I need to do this on a 700Mb database file with many many movies...
 I would love to have Nostra help me fix the file instead...

[attachment deleted by admin]

 Yes I mean I cannot connect to it.
 Or at least this is what I think.
 I basically open pvd.exe and as usual pvd connects to the last file it connected to, my pvd database. That's what it does everytime I open it.
  What fixed this was the re-pasting of firebrd emedded files into pvd directory.
 Is that clear enough or sounds too strange?

 Hi all,

 You might remember my previous problems with firebird files embedded (see my other posts).
 
 After reading Rick's comments I decided to test pvdimport with j river media center again. It is now working quite well even though I need to perfect the process, fields, etc.
 The problem is that once I have open MC and ran Pvdimport, I cannot open my pvd database anymore, I get the runtime library error again.
 This is with the latest firebird services installed and running again, by the way.

 The solution is again to copy firebird's embedded files in pvd's directory...

 I thought this behavior might help you (especially Nostra) understand what is going on with my pvd library file.
 I would love a fix.
 
 While waiting for a fix, I am trying out Buah's suggestion of exporting/importing my database but it proves rather complex.
 Please see my other post on the subject.

 Deazo.

 Thanks,

 wouldn't this mean that my posters would be "locked" outside of the database file?
 Or can I then re-integrate them into a database file (the way I prefer them to be)?

 I did not get the error message you are describing actually (Specified file is not a PVD XML file), unless you are looking at the bug report, which I did not read in details.

 Buah I did try in the order you suggested and that did not change the problem.
 Neither the backup nor my database are opening with the current pvd17 version without adding the firebird 2.1 files.

 Nostra, thanks for having a look, I really do hope you will give me a way to sort that out and not have to use firebird 2.1 files.
 Just so you know, I can send you a reduced size database (10mb) (that behaves the same than my 600mb one) with which you can play if needed...

 

 OK I have redone everything and still get the error when restoring the backup.
 The only difference is that instead of "found 8" it says "found 9"...

 Do you know why?

 Just for info, I am using PVD17 now.
 

  To all,

 Patch: Replacing firebird files by 2.1 files does not solve the problem as I am getting an SQL error when trying to open my database. It used to work with the previous pvd version.

 Buah: I have installed firebird and re-installed pvd 16. The database opens fine, and I created a backup. Then I uninstalled firebird and PVD, re-installed PVD and tried to restore the previously created backup. I received an error message "expected backup version 1,2,3,4,5,6 or 7. Found 8."   Whatever that means....?

 The conclusion here is that my database is at the moment unusable without firebird services running. Yes Rick I know the services are not particularly demanding but I am using pvd on two computers and really don't want to be running unnecessary services, especially on the one supposed to play high quality videos.
 Also after trying a few time pvdimport and MC with no success I reported my attention to XBMC, which is not perfect but looks good for my wife and guests  so I want to keep it for now.

 Maybe Nostra would know what I need to manipulate in my database file in order to have it open without firebird, or with the 2.1 firebird files in pvd directory?
 FYI, pvd16 opens my old database files (test files and so on) with no problem so really there must be something in the file.
 I have posted a reduced database file in one of my post for you to test out. Let me know if you need it again.

If that is not possible, does anyone know how to import a pvd database into pvd? XML is fine but what about posters and so on?
I would not mind doing that. (I would use the old pvd14 to generate the export files and pvd16 to import them, is that possible?)

In the meantime I shall run firebird on both my PC's because I need to update many movies and enjoy the new features Nostra has designed for us all.

 Hope you can help.