X
Nhấn vào đây để đến phiên bản di động của trang web.

Diễn đàn trợ giúp

Save download history to text file

Được đăng

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.

Chi tiết hệ thống bổ sung

Phần bổ trợ đã cài đặt

  • The IcedTea-Web Plugin executes Java applets.
  • The Videos 3.10.1 plugin handles video and audio streams.
  • DivX Web Player version 1.4.0.233

Ứng dụng

  • Chuỗi đại diện người dùng: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:33.0) Gecko/20100101 Firefox/33.0

Thông tin chi tiết

Banban 57 giải pháp 334 câu trả lời
Được đăng

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.

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): # Install [http://sqlitebrowser.org/ DB Browser] # Start DB Browser and open places.sqlite file (in Firefox profile folder) # Select '''moz_annos''' table # Click on File > Export > Table(s) as CSV file… # 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.
cor-el
  • Top 10 Contributor
  • Moderator
17528 giải pháp 158483 câu trả lời
Được đăng

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
You can also do such queries with the SQLite Manager extension in Firefox. *https://addons.mozilla.org/firefox/addon/sqlite-manager/ I use this: <pre><nowiki>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</nowiki></pre>