Move Microsoft EDGE collections to raindrop / csv

README.md

Move Microsoft edge collections to services like Raindrop (that can accept csv)

Get the sqlite db file

1. You can find the db file in the following places

• Windows: %LocalAppData%\Microsoft\Edge\User Data\Default\Collections
• MacOS: ~/Library/Application Support/Microsoft Edge/Default/Collections
• Linux: TBD

2. Copy the files (esp. collectionsSQLite) to a seperate Folder.

Execute the script

1. Install python 3.10 and then setup pandas via pip pip install pandas
2. save collections_to_csv.py to the same folder with the db files from the previous step.
3. Exec the script python collections_to_csv.py

Then you can simply import the file normally to raindrop.

collections_to_csv.py

import json
import sqlite3
import pandas as pd

con = sqlite3.connect("./collectionsSQLite")
cur = con.cursor()

df = pd.read_sql_query(
  """
    SELECT i.title as title, c.title as folder, i.source as data, i.date_created as created
    FROM collections as c, items as i, collections_items_relationship as r
    WHERE r.item_id == i.id and r.parent_id == c.id
  """,
  con
)

def blob_to_json(col):
  my_json = col.decode('utf8')
  d = json.loads(my_json)
  return d["url"]

df["description"] = ""
df["tags"] = ""
df["created"] = df["created"].astype(int)
df["url"] = df["data"].apply(blob_to_json)

df.to_csv(
  "out.csv",
  index=False,
  columns=["url", "folder", "title", "description", "tags", "created"]
)

This is not clear ..............some steps must be missing.........

Ah think I could have worded that differently.

1. Create a file called collections_to_csv.py in the same folder as you found the db files (You can find the relevant folder from the step Get the sqlite db file
2. Install python You can find instructions here
3. Python comes with a package manager, pip on a command line run pip install pandas
4. Use the command line to execute collections_to_csv.py on the same folder by executing python collections_to_csv.py

I can help you better if you can tell me what platform/OS you are on.

Do note its been a solid minute since I wrote this, Microsoft may have updated their schema.

Hi, I am using Win 8.1 at this time.

…

__________________________________ Sent from eM Client | www.emclient.com <https://www.emclient.com/get>

------ Original Message ------ From "Blaine" ***@***.***> To "Blakeinstein" ***@***.***> Cc "Comment" ***@***.***> Date 6/24/2024 9:31:12 AM Subject Re: Blakeinstein/README.md

@Blakeinstein commented on this gist. -------------------------------------------------------------------------------- Do note its been a solid minute since I wrote this, Microsoft may have updated their schema. — Reply to this email directly, view it on GitHub <https://gist.github.com/Blakeinstein/0cdf4a17ad3dc2e440e8dd389f5f7aba#gistcomment-5099815> or unsubscribe <https://github.com/notifications/unsubscribe-auth/BJKLI6FA5RTADV6VFXJWQ4LZJBCVBBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVEYTEMBSGMZDSNJVU52HE2LHM5SXFJTDOJSWC5DF>. You are receiving this email because you commented on the thread. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

@Davecon11 Win 8.1? Holy cow man how do you not get viruses and crap. You know they don't do security patches for that anymore right? Upgrade like now if you value your data.

Thank you so much for sharing this!