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

    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
    I made some updates to the Wiki page describing the <import> and <include> tags, including adding a couple of new xml examples. For the first example, I highlighted the example text and eventually found the location in the menus where I could select the CODE macro to have the example text formatted as a code example. So far, so good...
    I made some updates to the Wiki page describing the <import> and <include> tags, including adding a couple of new xml examples. For...
    I made some updates to the Wiki page describing the <import> and <include> tags, including adding a couple of new xml examples. For...
    Replies
    0
    Views
    536
    Actually, you just reminded me of how I have handled this in the past: I merged the contents of an old export.xml with a new one to make a complete file containing the old values I needed and the new values I didn't want to change. Why should it matter if the export file is missing some values? I would expect the import process to...
    Actually, you just reminded me of how I have handled this in the past: I merged the contents of an old export.xml with a new one to...
    My "fresh install" is missing some settings (in particular genre maps) that I would like to import from a previous export. There...
    Replies
    2
    Views
    713
    I have added a scheduled task to MariaDB to delete all entries with the same start and end date
    I have added a scheduled task to MariaDB to delete all entries with the same start and end date
    Hello, I'm encountering an issue after importing EPG data into the TV-Server/Database. The Problem: After importing an XMLTV...
    Replies
    7
    Views
    2K
    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
    1K
    Top Bottom