Ovo će web mjesto raditi na ograničen način, dok obavljamo održavanje stranice. Ako neki članak ne riješi tvoj problem i ako želiš postaviti pitanje, naša zajednica za podršku spremna je pomoći na Twitteru @FirefoxSupport i na Redditu /r/firefox.

Pretraži podršku

Izbjegni prevare podrške. Nikad te nećemo tražiti da nas nazoveš, da nam pošalješ telefonski broj ili da podijeliš osobne podatke. Prijavi sumnjive radnje pomoću opcije „Prijavi zlouporabu”.

Saznaj više

Save download history to text file

  • 2 odgovora
  • 1 ima ovaj problem
  • 2 prikaza
  • Posljednji odgovor od 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.

Svi odgovori (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