Copying entries in history: WYSINWYG
There is (IMHO) some missing functionality / unwanted feature or call it what you like (bug?).
History -> Manage History
select e.g. Last 7 days, right click on Name and select at least two attributes (you can choose from: Tags, Location,Most Recent Visit, Added and Last Modified)
Select the first entry of the list, all displayed fields are selected/highlighted.
Copy (either with the menu or with Ctrl-C) and paste it in your favourite text editor.
Why is only the URL copied? Other fields were also highlighted. Why are they not included?
This is WYSINWYG (what you see is not what you get).
It is possible to export bookmarks as an html file, so why is this not possible with history?
OK, it is possible to query the sqlite3 database directly to get some history info but it's a bit cumbersome.
To do so,
copy the sqlite (places.sqlite) database to some safe place then open the database (with 'sqlite3 places.sqlite') get the history info you are interested in with a sqlite query, e.g. select title,visit_count,site_name,url,description,last_visit_date from moz_places where url like '%support%';
But there is no simple (AFAIK) way to convert 'last_visit_date' (an integer) to something human readable.
So either include the whole selection when something is copied (WYSIWYG) or provide export history as an html file.
ps:
why is there on option 'other' in the list of 'topics' ?
pps:
I already posted this comment but it got lost somehow
Všetky odpovede (2)
There are several flavors present on the clipboard. If you copy/paste a history or bookmarks entry in a normal text editor then you only get the URL (text/unicode). If you use an HTML capable editor then you get the title and the URL (A HREF) (text/html).
<A HREF="https://support.mozilla.org/en-US/questions/1481813">Copying entries in history: WYSINWYG | Firefox Support Forum | Mozilla Support</A>
Internally text/x-moz-place is used, this uses JSON what allows to transfer all metadata, this doesn't work with folders as in that case you only get the folder ID and not the folder content.
{"title":"Copying entries in history: WYSINWYG | Firefox Support Forum | Mozilla Support","id":-1,"itemGuid":"","instanceId":"xxxxxxxxxxxx","type":"text/x-moz-place","uri":"https://support.mozilla.org/en-US/questions/1481813"}
sclaes said
History -> Manage History select e.g. Last 7 days, right click on Name and select at least two attributes (you can choose from: Tags, Location,Most Recent Visit, Added and Last Modified) Select the first entry of the list, all displayed fields are selected/highlighted. Copy (either with the menu or with Ctrl-C) and paste it in your favourite text editor. Why is only the URL copied? Other fields were also highlighted. Why are they not included?
The Library window uses old XUL layout code which doesn't behave like standard HTML. Someday this will be rewritten, but it appears not to have been a priority. Possibly there is an add-on that could list out and/or export history in a format you prefer?
OK, it is possible to query the sqlite3 database directly to get some history info but it's a bit cumbersome. ... But there is no simple (AFAIK) way to convert 'last_visit_date' (an integer) to something human readable.
Most date-time values are in UNIX Epoch time. You can convert them out using a calculation like this as a column in your query:
datetime(last_visit_date/1000000, 'unixepoch') AS LatestVisit