Rechercher dans l’assistance

Évitez les escroqueries à l’assistance. Nous ne vous demanderons jamais d’appeler ou d’envoyer un SMS à un numéro de téléphone ou de partager des informations personnelles. Veuillez signaler toute activité suspecte en utilisant l’option « Signaler un abus ».

En savoir plus

Save download history to text file

  • 2 réponses
  • 1 a ce problème
  • 2 vues
  • Dernière réponse par 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.

Toutes les réponses (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