Add list of urls to the Qutebrowser’s sqlite3 history
1
vote
1
answer
86
views
### General overview
I have a `history.csv CSV file of urls formated like this:
;;2024-03-30T12:00:00;2024-03-30T12:00:00
(The _2024-03-30T12:00:00_ is the same)
The goal is to get this urls in the history of Qutebrowser who is in sqlite3.
### What I did
#### Prerequest
First I closed Qutebrowser.
#### Opening the DB
I run:
sqlite3 ~/.local/share/qutebrowser/history.sqlite
#### Adding the new urls
In the sqlite3 shell I did:
.mode csv
.separator ';'
.import urls.txt History
The things seams good, except just some bad formated lines like:
history.csv:11671: unescaped " character
history.csv:11671: unescaped " character
history.csv:11772: expected 4 columns but found 6 - extras ignored
#### Verificaton
I verified the changes took place with:
SELECT * FROM History;
And yes, I saw the urls.
#### Closing
Finally I closed the console with:
.quit
### The problem
When I went back to Qutebrowser and try to open some urls to see if it works, so it doesn’t work. The urls seems not imported.
### The question
What to do to import urls into Qutebrowser’s history? By the way I described or any other way.
## Update
The links I added appear when I activate :history
command inside Qutebrowser. But did not appear in history completion. So it’s not a question of database.
Asked by fauve
(1529 rep)
Mar 31, 2024, 12:59 PM
Last activity: Mar 31, 2024, 11:06 PM
Last activity: Mar 31, 2024, 11:06 PM