Sample Header Ad - 728x90

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