搜索 | 用户支持

防范以用户支持为名的诈骗。我们绝对不会要求您拨打电话或发送短信,及提供任何个人信息。请使用“举报滥用”选项报告涉及违规的行为。

详细了解

Save download history to text file

  • 2 个回答
  • 1 人有此问题
  • 2 次查看
  • 最后回复者为 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