[elegantwheeler]

Awesome !! really considerate of you

For anyone who has difficulty reading it because it's a 21GB file. Use this to convert it to a readable database, you can query it much faster.

if you want more than uid, email, user and name, then change table structure and just read the other keys from the entry and insert them. if u cant figure out ask someone

import json
import sqlite3
from tqdm import tqdm

conn = sqlite3.connect('trello.db')
cursor = conn.cursor()
cursor.execute('''
    CREATE TABLE IF NOT EXISTS trello_users (
        id TEXT PRIMARY KEY,
        fullName TEXT,
        username TEXT,
        email TEXT
    )
''')

conn.commit()
conn.close()


def parse(json_file):
    conn = sqlite3.connect('trello.db')
    cursor = conn.cursor()

    with open(json_file, 'r') as f:
        for line in f:
            try:
                entry = json.loads(line.strip())
                id = entry.get('id', '')
                fullName = entry.get('fullName', '')
                username = entry.get('username', '')
                email = entry.get('email', '')



                cursor.execute('''
                    INSERT OR IGNORE INTO trello_users (id, fullName, username, email)
                    VALUES (?, ?, ?, ?)
                ''', (id, fullName, username, email))

            except json.JSONDecodeError as e:
                print(f"Shit broke: {e}")
                continue

    conn.commit()
    conn.close()

if __name__ == '__main__':
    parse('trellfull.json')

[buu]

Unsecured APIs. So hot in 2024.

Great find and share!

[djataseeker]

the password is in the reveal, you put in:

https://emo.rip/


as the password to unlock

---

First difficulty is to see the password... mystery and no one says it... this is odd and strange at least. Can anyone inform here the password?
Also would be nice if a good Samaritan republished it in SQLite format, as CSV always a pain as this case shows...

For anyone who has difficulty reading it because it's a 21GB file. Use this to convert it to a readable database, you can query it much faster.

if you want more than uid, email, user and name, then change table structure and just read the other keys from the entry and insert them. if u cant figure out ask someone

import json
import sqlite3
from tqdm import tqdm

conn = sqlite3.connect('trello.db')
cursor = conn.cursor()
cursor.execute('''
    CREATE TABLE IF NOT EXISTS trello_users (
        id TEXT PRIMARY KEY,
        fullName TEXT,
        username TEXT,
        email TEXT
    )
''')

conn.commit()
conn.close()


def parse(json_file):
    conn = sqlite3.connect('trello.db')
    cursor = conn.cursor()

    with open(json_file, 'r') as f:
        for line in f:
            try:
                entry = json.loads(line.strip())
                id = entry.get('id', '')
                fullName = entry.get('fullName', '')
                username = entry.get('username', '')
                email = entry.get('email', '')



                cursor.execute('''
                    INSERT OR IGNORE INTO trello_users (id, fullName, username, email)
                    VALUES (?, ?, ?, ?)
                ''', (id, fullName, username, email))

            except json.JSONDecodeError as e:
                print(f"Shit broke: {e}")
                continue

    conn.commit()
    conn.close()

if __name__ == '__main__':
    parse('trellfull.json')

the password is:


https://emo.rip/


enter the above as-is to get in
https://emo.rip/

---

First difficulty is to see the password... mystery and no one says it... this is odd and strange at least. Can anyone inform here the password?
Also would be nice if a good Samaritan republished it in SQLite format, as CSV always a pain as this case shows...

For anyone who has difficulty reading it because it's a 21GB file. Use this to convert it to a readable database, you can query it much faster.

if you want more than uid, email, user and name, then change table structure and just read the other keys from the entry and insert them. if u cant figure out ask someone

import json
import sqlite3
from tqdm import tqdm

conn = sqlite3.connect('trello.db')
cursor = conn.cursor()
cursor.execute('''
    CREATE TABLE IF NOT EXISTS trello_users (
        id TEXT PRIMARY KEY,
        fullName TEXT,
        username TEXT,
        email TEXT
    )
''')

conn.commit()
conn.close()


def parse(json_file):
    conn = sqlite3.connect('trello.db')
    cursor = conn.cursor()

    with open(json_file, 'r') as f:
        for line in f:
            try:
                entry = json.loads(line.strip())
                id = entry.get('id', '')
                fullName = entry.get('fullName', '')
                username = entry.get('username', '')
                email = entry.get('email', '')



                cursor.execute('''
                    INSERT OR IGNORE INTO trello_users (id, fullName, username, email)
                    VALUES (?, ?, ?, ?)
                ''', (id, fullName, username, email))

            except json.JSONDecodeError as e:
                print(f"Shit broke: {e}")
                continue

    conn.commit()
    conn.close()

if __name__ == '__main__':
    parse('trellfull.json')

i had no problem downloading it and uploaded it to mongodb.  there was an error at the end that some records were too large

but i did get 15.2M records in

[b4rv4z]

Thank you bro !!!!

[jfxk]

mongodb, Good idea! I'll try, but wouldn't it be MUCH MUCH easier if people shared it in SQLite file? With any tool, ex: Portable HeidiSQL, can easily open and export to any other DB or to CSV... anyone to do the "job" of converting and sharing SQLite file as this is open to share?

easy load into mongodb:

{"id": "4d5eb3cad76aa11360000110", "aaId": "70121:582fd5ad-a739-49e8-89c4-99e76fc5f514", "activityBlocked": false, "avatarHash": "2810c1f514b3406eeb5abf5e26b3bdb3", "avatarUrl": "https://trello-members.s3.amazonaws.com/4d5eb3cad76aa11360000110/2810c1f514b3406eeb5abf5e26b3bdb3", "bio": "", "bioData": {"emoji": {}}, "confirmed": true, "fullName": "Bobby Grace", "idEnterprise": null, "idEnterprisesDeactivated": null, "idMemberReferrer": null, "idPremOrgsAdmin": null, "initials": "BG", "memberType": "normal", "nonPublic": {}, "nonPublicAvailable": true, "products": [], "url": "https://trello.com/bobbygrace", "username": "bobbygrace", "status": "disconnected", "aaBlockSyncUntil": null, "aaEmail": null, "aaEnrolledDate": null, "avatarSource": null, "credentialsRemovedCount": null, "domainClaimed": null, "email": "johnrobertgracejr@gmail.com", "gravatarHash": null, "idBoards": ["52952087bfa6ee005f0016c9", "54971ad5c1b6f54d71813a15", "5530334a9fd952764e448eab"], "idOrganizations": [], "idEnterprisesAdmin": [], "limits": {"boards": {"totalPerMember": {"status": "ok", "disableAt": 4500, "warnAt": 3600}}, "orgs": {"totalPerMember": {"status": "ok", "disableAt": 850, "warnAt": 680}}}, "loginTypes": null, "marketingOptIn": null, "messagesDismissed": null, "nodeId": "ari:cloud:trello::user/4d5eb3cad76aa11360000110", "oneTimeMessagesDismissed": null, "sessionType": null, "prefs": null, "trophies": [], "uploadedAvatarHash": null, "uploadedAvatarUrl": null, "premiumFeatures": ["additionalBoardBackgrounds", "additionalStickers", "customBoardBackgrounds", "customEmoji", "customStickers", "plugins"], "isAaMastered": true, "ixUpdate": "487"}
{"id": "4d5eb4c7d76aa113600001ab", "aaId": "70121:6a128b1b-1f29-4148-b31b-8173e052cee5", "activityBlocked": false, "avatarHash": "352d0a1768a45b0109edf7460a688cf2", "avatarUrl": "https://trello-members.s3.amazonaws.com/4d5eb4c7d76aa113600001ab/352d0a1768a45b0109edf7460a688cf2", "bio": "", "bioData": {"emoji": {}}, "confirmed": true, "fullName": "Kevin Gessner", "idEnterprise": null, "idEnterprisesDeactivated": null, "idMemberReferrer": null, "idPremOrgsAdmin": null, "initials": "KG", "memberType": "normal", "nonPublic": {}, "nonPublicAvailable": true, "products": [], "url": "https://trello.com/kevin", "username": "kevin", "status": "disconnected", "aaBlockSyncUntil": null, "aaEmail": null, "aaEnrolledDate": null, "avatarSource": null, "credentialsRemovedCount": null, "domainClaimed": null, "email": "kevingessner@gmail.com", "gravatarHash": null, "idBoards": [], "idOrganizations": [], "idEnterprisesAdmin": [], "limits": {"boards": {"totalPerMember": {"status": "ok", "disableAt": 4500, "warnAt": 3600}}, "orgs": {"totalPerMember": {"status": "ok", "disableAt": 850, "warnAt": 680}}}, "loginTypes": null, "marketingOptIn": null, "messagesDismissed": null, "nodeId": "ari:cloud:trello::user/4d5eb4c7d76aa113600001ab", "oneTimeMessagesDismissed": null, "sessionType": null, "prefs": null, "trophies": [], "uploadedAvatarHash": null, "uploadedAvatarUrl": null, "premiumFeatures": ["additionalBoardBackgrounds", "additionalStickers", "customBoardBackgrounds", "customEmoji", "customStickers", "plugins"], "isAaMastered": true, "ixUpdate": "3283"}

[rocket19939]

Oh, it seems interesting. Let me see.

This forum account is currently banned. Ban Length: Permanent (N/A Remaining)
Ban Reason: Leeching | http://c66go4clkqodr7tdjfu76jztjs7w7d3fajdeypxn73v4ju3dt7g5yyyd.onion/Forum-Ban-Appeals if you feel this is incorrect.

[Preyy]

Ty brother, this is juicy!

[17camels]

the password does not work as-in:

**https://emo.rip/**

anybody have similar issue?

[somosom]

thanks man! i will try it

[Taro]

Link is down, it redirects to a telegram channel. Can it be update by someone ?