Exporting the database? (1 Viewer)

eventone

Portal Member
February 16, 2007
48
1
Home Country
Portugal Portugal
Hi, is it possible to export the database to excel or access so I can get a listing of episodes?
 

Inker

Retired Team Member
  • Premium Supporter
  • December 6, 2004
    2,055
    318
    Well, you can use the SQLite Database browser in your documents folder and export as csv. Then you can import that into excel or access. But youll need to manually export the tables you want. Youll probably be most interested in the tables online_episodes and online_series. You can join them by seriesID.

    Hope this helps.
     

    Users who are viewing this thread

    Similar threads

    I'm getting old... no... I am old... "Once upon a time..." there was a tool to Export MovingPictures-Database to a Document (pdf). Does anybody remeber how it was called, where I can find it... Here are screenshot from the exported Files -->
    I'm getting old... no... I am old... "Once upon a time..." there was a tool to Export MovingPictures-Database to a Document (pdf)...
    I'm getting old... no... I am old... "Once upon a time..." there was a tool to Export MovingPictures-Database to a Document (pdf)...
    Replies
    0
    Views
    532
    Of course, I think it's not difficult, add fields to the database, and then change everything in the user interface for the rating, and not break anything. I don't have time for this yet, maybe it will appear after the 25th, but that's not certain.
    Of course, I think it's not difficult, add fields to the database, and then change everything in the user interface for the rating...
    Would it be possible to add a star rating (1-5) for pictures in the database, preferably even within browsing files? This way, you...
    Replies
    8
    Views
    582
    Ok, so perhaps a solution, but not the "right" solution. On the client, within media portal configuration, under TV settings, advanced options, I switched to UNC paths instead of the default RSS, and it's working very well. Sure I had to figure out the paths, but no big deal. Maybe helpful for someone in the future. Thanks for the...
    Ok, so perhaps a solution, but not the "right" solution. On the client, within media portal configuration, under TV settings...
    Hi folks. I have an issue with a new install/integration into my mediaportal system. I have a “mediaportal server” which has the TV...
    Replies
    5
    Views
    1K
    As easy as that ;). Restarted HTPC and 'out of memory' errors have disappeared, thank you!
    As easy as that ;). Restarted HTPC and 'out of memory' errors have disappeared, thank you!
    Just installed the MediaPortal 1.37 Pre-Release. Client takes a long time to start up because it is looking for the...
    Replies
    4
    Views
    847
    MP1 MP2 Wiki inaccessible DE
    Is it possible to download for offline reference?
    Is it possible to download for offline reference?
    I tried to access the Wiki yesterday and again today, but the page does not load. After some timeout, I get 502 Bad Gateway. Is...
    Replies
    7
    Views
    357
    Top Bottom