Sometimes when I run a search and open up a dozen or more pages, I want to use that search result in a USENET posting where I just want all the URLs.places.title like '%' order by datum" |
Normally I manually laboriously cut and paste into a text file.
Subject title 1
[URL]
Subject title 2
[URL]
Subject title 3
[URL]
...
I thought I had a bright idea of saving time by using the bookmarks.html file which I could save all the open tabs into and convert to text.
I don't normally use bookmarks so it will contain just the current tabs.
I right click any tab > Select All Tabs > Bookmark Tabs
That should save all the tabs into the bookmarks file.
Help > More Troubleshooting Information > Application Basics > Profile Folder > Open Folder = %APPDATA%\Mozilla\Firefox\Profiles\
I was surprised there is no longer a bookmarks.html file there.
Just the bookmarksbackups folder and the places.sqlite file.
Googling, the first hit was an online tool to convert the session file. https://www.jeffersonscher.com/ffu/scrounger.html
But that will contain the entire history to weed through.
And it requires closing all the open tabs (which could lose data if
something goes wrong and you can't get them all back when they are open).
I just want the bookmarks in a text file. Not the history.
Googling, the next few hits are complicated scripts running session add ons and python converters from the sqlite format to Excel.
Example.
sqlite3 -csv -header places.sqlite "select datetime(moz_historyvisits.visit_date/1000000, 'unixepoch', 'localtime') as datum, moz_places.url, moz_places.title from moz_places, moz_historyvisits where moz_places.id = moz_historyvisits.place_id and moz_
convertfrom-csv | select -last 3 | fl
That's too much for something that should be very simple.
Is there something simpler to convert places.sqlite > places.txt?
Sometimes when I run a search and open up a dozen or more pages, I want
to use that search result in a USENET posting where I just want all the
URLs.
Normally I manually laboriously cut and paste into a text file.
Subject title 1
[URL]
Subject title 2
[URL]
Subject title 3
[URL]
...
I thought I had a bright idea of saving time by using the bookmarks.html
file which I could save all the open tabs into and convert to text.
I don't normally use bookmarks so it will contain just the current tabs.
I right click any tab > Select All Tabs > Bookmark Tabs
That should save all the tabs into the bookmarks file.
Help > More Troubleshooting Information > Application Basics > Profile
Folder > Open Folder = %APPDATA%\Mozilla\Firefox\Profiles\
I was surprised there is no longer a bookmarks.html file there.
Just the bookmarksbackups folder and the places.sqlite file.
Googling, the first hit was an online tool to convert the session file. https://www.jeffersonscher.com/ffu/scrounger.html
But that will contain the entire history to weed through.
And it requires closing all the open tabs (which could lose data if
something goes wrong and you can't get them all back when they are open).
I just want the bookmarks in a text file. Not the history.
Googling, the next few hits are complicated scripts running session add
ons and python converters from the sqlite format to Excel.
Example.
sqlite3 -csv -header places.sqlite "select datetime(moz_historyvisits.visit_date/1000000, 'unixepoch', 'localtime')
as datum, moz_places.url, moz_places.title from moz_places,
moz_historyvisits where moz_places.id = moz_historyvisits.place_id and moz_places.title like '%' order by datum" |
convertfrom-csv | select -last 3 | fl
That's too much for something that should be very simple.
Is there something simpler to convert places.sqlite > places.txt?
I just want the bookmarks in a text file. Not the history.
On 08/03/23 15:47, Dean Hoffman wrote:
I just want the bookmarks in a text file. Not the history.
What I do is Bookmarks -> Manage Bookmarks -> Import and Backup ->
Export Bookmarks to HTML. OK, it isn't a straightforward text file,
because it displays the page titles, with a link to the URL, and if you
View Source you will see a lot more than the basic URL is there.
However, if you copy that data to a plain text file and run a quick edit
on it, deleting everything including and after {?utm_medium}, and then including and after {/"} (ignoring the braces, which I am using purely
as delimiters), this should get you pretty close to what you need.
Sometimes when I run a search and open up a dozen or more pages, I want to use that search result in a USENET postingbrowser.bookmarks.autoExportHTML in about:config set it to true.
where I just want all the URLs.
Normally I manually laboriously cut and paste into a text file.
Subject title 1
[URL]
Subject title 2
[URL]
Subject title 3
[URL]
...
I thought I had a bright idea of saving time by using the bookmarks.html file which I could save all the open tabs into
and convert to text.
I don't normally use bookmarks so it will contain just the current tabs.
I right click any tab > Select All Tabs > Bookmark Tabs
That should save all the tabs into the bookmarks file.
Help > More Troubleshooting Information > Application Basics > Profile Folder > Open Folder =
%APPDATA%\Mozilla\Firefox\Profiles\
I was surprised there is no longer a bookmarks.html file there.
Just the bookmarksbackups folder and the places.sqlite file.
Googling, the first hit was an online tool to convert the session file. https://www.jeffersonscher.com/ffu/scrounger.html
But that will contain the entire history to weed through.
And it requires closing all the open tabs (which could lose data if
something goes wrong and you can't get them all back when they are open).
I just want the bookmarks in a text file. Not the history.
Googling, the next few hits are complicated scripts running session add ons and python converters from the sqlite format
to Excel.
Example.
sqlite3 -csv -header places.sqlite "select datetime(moz_historyvisits.visit_date/1000000, 'unixepoch', 'localtime') as
datum, moz_places.url, moz_places.title from moz_places, moz_historyvisits where moz_places.id =
moz_historyvisits.place_id and moz_places.title like '%' order by datum" |
convertfrom-csv | select -last 3 | fl
That's too much for something that should be very simple.
Is there something simpler to convert places.sqlite > places.txt?
I thought I had a bright idea of saving time by using the bookmarks.html
file which I could save all the open tabs into and convert to text.
That's too much for something that should be very simple.
Is there something simpler to convert places.sqlite > places.txt?
Sometimes when I run a search and open up a dozen or more pages, I wantadd extension "Email Tabs" then use its option "Copy Links to Clipboard"
to use that search result in a USENET posting where I just want all the
URLs.
Normally I manually laboriously cut and paste into a text file.
Subject title 1
[URL]
Subject title 2
[URL]
Subject title 3
[URL]
...
I thought I had a bright idea of saving time by using the bookmarks.html
file which I could save all the open tabs into and convert to text.
I don't normally use bookmarks so it will contain just the current tabs.
I right click any tab > Select All Tabs > Bookmark Tabs
That should save all the tabs into the bookmarks file.
Help > More Troubleshooting Information > Application Basics > Profile
Folder > Open Folder = %APPDATA%\Mozilla\Firefox\Profiles\
I was surprised there is no longer a bookmarks.html file there.
Just the bookmarksbackups folder and the places.sqlite file.
Googling, the first hit was an online tool to convert the session file. https://www.jeffersonscher.com/ffu/scrounger.html
But that will contain the entire history to weed through.
And it requires closing all the open tabs (which could lose data if
something goes wrong and you can't get them all back when they are open).
I just want the bookmarks in a text file. Not the history.
Googling, the next few hits are complicated scripts running session add
ons and python converters from the sqlite format to Excel.
Example.
sqlite3 -csv -header places.sqlite "select datetime(moz_historyvisits.visit_date/1000000, 'unixepoch', 'localtime')
as datum, moz_places.url, moz_places.title from moz_places,
moz_historyvisits where moz_places.id = moz_historyvisits.place_id and moz_places.title like '%' order by datum" |
convertfrom-csv | select -last 3 | fl
That's too much for something that should be very simple.
Is there something simpler to convert places.sqlite > places.txt?
On 2023-03-08 15:31:04 +0000, Zaghadka said:
Import and Backup -> Export Bookmarks to HTML
Is there a subsequent HTML to TEXT conversion out there?
Import and Backup -> Export Bookmarks to HTML
Sometimes when I run a search and open up a dozen or more pages, I want to use that search result in a USENET posting where I just want all the URLs. Normally I manually laboriously cut and paste into a text file.
Googling, the next few hits are complicated scripts running session
add ons and python converters from the sqlite format to Excel.
Example.
sqlite3 -csv -header places.sqlite "select datetime(moz_historyvisits.visit_date/1000000, 'unixepoch', 'localtime') as datum, moz_places.url, moz_places.title from moz_places, moz_historyvisits where moz_places.id = moz_historyvisits.place_id and moz_places.title like '%' order by datum" |
convertfrom-csv | select -last 3 | fl
That's too much for something that should be very simple.
Is there something simpler to convert places.sqlite > places.txt?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 297 |
Nodes: | 16 (2 / 14) |
Uptime: | 11:38:34 |
Calls: | 6,666 |
Files: | 12,213 |
Messages: | 5,336,377 |