gosuki Pocket import (CSV issue)

[mariusrugan]

hi,

Thanks a lot for your work!

it seems the CSV structure that you had from Pocket is completely different from what i have.

My export schema is (both in August 2025 and October 2025):

title,url,time_added,tags,status
https://handbrake.fr/,https://handbrake.fr/,1554542073,,unread

gosuki/cmd/pocket.go

Line 68 in 5bdfb77

func importFromPocketCSV(ctx context.Context, c *cli.Command) error {

assumes

		url := row[1]
		title := row[2]
		// timeAdded := row[3]
		tags := row[4]
		desc := row[5]

also even on a sample file

url,title,time_added,tags,desc
https://handbrake.fr/,,,,

import is not working

~/go/bin/gosuki import pocket /Users/mariusrugan/Backups/pocket/20250822_pocket/debug.csv --debug=trace

imported 0 bookmarks

INFO ff: error: expanding base directory: lstat /Users/mariusrugan/Library/Application Support/Firefox: no such file or directory
importing from /Users/mariusrugan/Backups/pocket/20250822_pocket/debug.csv
DEBU db: initializing cacheDB
DEBU db: <memcache> opened at <file:memcache?mode=memory&cache=shared&_journal=MEMORY> with driver <sqlite3_gosuki>
DEBU db: checking schema version
DEBU db: <memcache> initialized
DEBU db: <memcache_l2> opened at <file:memcache_l2?mode=memory&cache=shared&_journal=MEMORY> with driver <sqlite3_gosuki>
DEBU db: checking schema version
DEBU db: <memcache_l2> initialized
INFO db: preloading <~/.local/share/gosuki/gosuki.db> to cache
DEBU db: initializing cacheDB
DEBU db: starting cache sync scheduler
DEBU db: <gosuki_db> opened at <file:/Users/mariusrugan/.local/share/gosuki/gosuki.db?_journal_mode=WAL&_mutex=no&cache=shared> with driver <sqlite3_gosuki>
DEBU db: checking schema version
DEBU db: schema version=3
DEBU db: syncing </Users/mariusrugan/.local/share/gosuki/gosuki.db> to <memcache>
DEBU db: syncing </Users/mariusrugan/.local/share/gosuki/gosuki.db> to <memcache_l2>
imported 0 bookmarks
DEBU db: closing DB <gosuki_db>

MacOS gosuki version v1.2.1 installed via go install

go install -tags systray github.com/blob42/gosuki/cmd/gosuki@latest

I'll probably dig into it and fix it & and PR back, it's just for you and anyone else a FYI.

Thanks a lot in advance for your time!

[blob42]

@mariusrugan thanks for the detailed information.

I will update the parsing logic in the next commits

Since I did not have a pocket account myself, I relied on third party project that parsed the exported data from Pocket after they closed the service. I am not sure if the CSV format they used before the closure was the same as the one post closure.

Do you know if it is the same CSV format ?

EDIT: I used the pocket format defined in this project. The Repo contains to export formats and I used the wrong one.

[blob42]

can you try to import from the fix-pocket-import branch ?

[mariusrugan]

@blob42 thanks for the quick replies,

i also solved it see here:
master...mariusrugan:gosuki:master

some extra improvements:

• i'd like to use the Modified from timeAdded coming from the export, transformed into uint64
• the tags are not comma separated but "|"

		bookmark := &gosuki.Bookmark{
			URL:      url,
			Title:    title,
			Tags:     strings.Split(tags, "|"),
			Module:   PocketImporterID,
			Modified: i, 
		}

Where would you like the PR ?
to your staging branch ? or to the fix-branch ?

(i'll rework it don't worry on my side)

[mariusrugan]

The formatting in
https://github.com/WorkOfStan/web-pages-to-pdf/blob/35851093e7db2ebd3ba81c8927a877112fe082c4/getpocket_sample.csv?plain=1#L9

is correct, is what i have

title,url,time_added,tags,status
Opération Bobcat 1942-1946 - Tahiti Heritage,https://www.tahitiheritage.pf/operation-bobcat-1942-1946/,1689230329,history|military|polynesie|usa,unread

[blob42]

Where would you like the PR ? to your staging branch ? or to the fix-branch ?

Prefect, you can go ahead with the PR on the fix branch.

[blob42]

Should be solved in #16 thanks @mariusrugan