Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

Αναζήτηση στην υποστήριξη

Προσοχή στις απάτες! Δεν θα σας ζητήσουμε ποτέ να καλέσετε ή να στείλετε μήνυμα σε κάποιον αριθμό τηλεφώνου ή να μοιραστείτε προσωπικά δεδομένα. Αναφέρετε τυχόν ύποπτη δραστηριότητα μέσω της επιλογής «Αναφορά κατάχρησης».

Μάθετε περισσότερα

Save download history to text file

  • 2 απαντήσεις
  • 1 έχει αυτό το πρόβλημα
  • 7 προβολές
  • Τελευταία απάντηση από cor-el

more options

I would like to learn how to save my download history to a text file, using 64-bit Linux (Linux Mint).

Thanks in advance.

I would like to learn how to save my download history to a text file, using 64-bit Linux (Linux Mint). Thanks in advance.

Όλες οι απαντήσεις (2)

more options

Maybe there is an add-on to do it, but I didn't found one.

I know this way (tested on Windows, assuming it is the same for Linux):

  1. Install DB Browser
  2. Start DB Browser and open places.sqlite file (in Firefox profile folder)
  3. Select moz_annos table
  4. Click on File > Export > Table(s) as CSV file…
  5. Click on OK, enter a file name ans select location

A CSV file is a text file, you can open it with any text editor, or better, with LibreOffice Calc. Each download corresponds to 3 lines: 1) download location 2) file name 3) time and size.

more options

You can also do such queries with the SQLite Manager extension in Firefox.

I use this:

SELECT content AS Filename, datetime(dateAdded/1000000,'unixepoch','localtime') AS dateAdded, url AS Location, moz_anno_attributes.name AS Annotation
FROM moz_places, moz_annos, moz_anno_attributes
WHERE (moz_places.id = moz_annos.place_id) AND (moz_annos.anno_attribute_id = moz_anno_attributes.id) AND ((moz_anno_attributes.name LIKE 'downloads/destinationFileURI') OR (moz_anno_attributes.name LIKE 'downloads/destinationFileName'))
ORDER BY dateAdded DESC