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

    Got a reply from SD ... "Looks like your last successful download was on 5/23. On 5/24 for some reason we received 194 connections between 10:54 and 11:05 triggering a denial of service attack ban. The logs show it was lifted on 5/25, but I still see the entry in iptables. I reset fail2ban and hopefully you're working again." Weird...
    Got a reply from SD ... "Looks like your last successful download was on 5/23. On 5/24 for some reason we received 194...
    I'm using MediaPortal 1.38.1 x64 and have an SD-DD lineup account. In the last week, I have not been able to update my EPG, and...
    Replies
    3
    Views
    614
    Thanks for the update on this. I should have searched before posting, always assume it is something I have done wrong.
    Thanks for the update on this. I should have searched before posting, always assume it is something I have done wrong.
    Hi All, I have a strange one. I recently added 2 new TV series to my setup and they are not being correctly identified in the...
    Replies
    2
    Views
    297
    Hi. I was probably being a bit fast and loose with my terminology. I meant "somewhere within the files that MP2 uses in its database". Anyway, I found a way to do this which was far from automated but relatively low effort. I found what looked like all the images (CD covers, DVD covers, backgrounds etc all lumped together in...
    Hi. I was probably being a bit fast and loose with my terminology. I meant "somewhere within the files that MP2 uses in its...
    I am in the process of setting up a legacy media player (Mede8er) which I happened to have laying around into my home cinema setup...
    Replies
    2
    Views
    544
    fixed the episode naming above ^. There was no error in the naming of the file itself. Every time I enter TV Series, it tries to re-scan the episodes. The series appears for just a few seconds and disappears again.
    fixed the episode naming above ^. There was no error in the naming of the file itself. Every time I enter TV Series, it tries to...
    I recorded all 6 episodes of "Walking With Dinosaurs (2025)" from PBS, edited the non essential stuff out and saved them as MKV. I...
    Replies
    1
    Views
    2K
    Fixed, I think. Certainly the vintage MP2 installer that I was using no longer installs the LAV filters. I can only assume that these were never part of the install package itself, but rather downloaded during the install, and that link no longer exists. Shame that the installer doesn't indicate this. Last time when I installed the...
    Fixed, I think. Certainly the vintage MP2 installer that I was using no longer installs the LAV filters. I can only assume that...
    Hi all, I've recently retired my MP2 setup for my main HTPC and gone back to separates, but I wanted to retain the ability to play...
    Replies
    4
    Views
    706
    Top Bottom