User avatar
🌆 @m@shrimp.melontini.me
1y
wait how do i export shrimpnet norts
2
0
0
0
User avatar
Two Hollywood Phonies @autumn@cafe.autumn.town
1y
@m you cannot .
1
0
0
0
User avatar
Two Hollywood Phonies @autumn@cafe.autumn.town
1y
@m only via the db
1
0
0
0
User avatar
🌆 @m@shrimp.melontini.me
1y
@autumn you can via /api/iceshrimp/users/{id}/notes API
2
0
0
0
User avatar
🌆 @m@shrimp.melontini.me
1y
@autumn oh wait no, there's a limit per reqs aj_cri
1
0
1
0
User avatar
Two Hollywood Phonies @autumn@cafe.autumn.town
1y
@m hold on kopper gave me the command i need for getting stuff out the db (still havent used it )
2
0
0
0
User avatar
Two Hollywood Phonies @autumn@cafe.autumn.town
1y
@m psql -U postgres -d misskey -t -A -c "select replace(text, E'\\n', ' ') from note where \"userId\" = '9lf1cyhacboh0005' and (visibility = 'public' or visibility = 'home') and not \"localOnly\" and cw is null and text is not null;" > export.txt

that's gonna export public and home visibility notes and nothing with cws on it, also change the userid too
1
0
2
0
User avatar
🌆 @m@shrimp.melontini.me
1y
@autumn yeah, this works, thank you
0
0
1
0