Export downloading data?

Get help with all aspects of SABnzbd
Forum rules
Help us help you:
  • Are you using the latest stable version of SABnzbd? Downloads page.
  • Tell us what system you run SABnzbd on.
  • Adhere to the forum rules.
  • Do you experience problems during downloading?
    Check your connection in Status and Interface settings window.
    Use Test Server in Config > Servers.
    We will probably ask you to do a test using only basic settings.
  • Do you experience problems during repair or unpacking?
    Enable +Debug logging in the Status and Interface settings window and share the relevant parts of the log here using [ code ] sections.
Post Reply
thereddog
Newbie
Newbie
Posts: 7
Joined: March 17th, 2013, 3:07 am

Export downloading data?

Post by thereddog »

I've just hit the 6.0TB downloaded milestone, I'd love to be able to export the data so that I can create graphs and play with the numbers in Excel. Is this possible?
Top
User avatar
shypike
Administrator
Administrator
Posts: 19774
Joined: January 18th, 2008, 12:49 pm

Re: Export downloading data?

Post by shypike »

All History data is stored in a simple SQLIte database, file history1.db in the admin folder.
There are quite a few utilities around that allow you to extract data from SQLite databases.
Top
anzerman
Newbie
Newbie
Posts: 5
Joined: March 26th, 2010, 7:14 pm

Re: Export downloading data?

Post by anzerman »

I have been having at look at the history.db file and had a question. Is there a date and time entry in the database? I cant seem to see it when I extract it using http://www.speqmath.com/tutorials/sqlite_export/ . Am I missing something? Or is the data just not there?
Top
User avatar
sander
Release Testers
Release Testers
Posts: 9062
Joined: January 22nd, 2008, 2:22 pm

Re: Export downloading data?

Post by sander »

anzerman wrote:I have been having at look at the history.db file and had a question. Is there a date and time entry in the database? I cant seem to see it when I extract it using http://www.speqmath.com/tutorials/sqlite_export/ . Am I missing something? Or is the data just not there?
The second field "completed" is the date/time in unix time stamp format. See http://www.unixtimestamp.com/
Top
anzerman
Newbie
Newbie
Posts: 5
Joined: March 26th, 2010, 7:14 pm

Re: Export downloading data?

Post by anzerman »

thanks for that :)
Top
Post Reply

Return to “General Help”