Open forever-and-a-day opened 2 years ago
If somebody wants to copy your notes from emmVRC to VRCX here's an example how to do it with cygwin + jq + sqlite3:
cd ~/AppData/Roaming/VRCX
cp VRCX.sqlite3{,.bak}
taskkill //F //IM VRCX.exe
D=/d/VRC/DeletedMods/UserData/emmVRC/UserNotes
for f in $D/usr_*; do
u=${f##*/}
u=${u%%.*}
echo "INSERT OR REPLACE INTO memos(user_id, edited_at, memo) VALUES ('$u', '2022-07-30T00:00:00.000Z', '`cat $D/$u.json|jq -r .NoteText|sed "s:':'':g" `');"
done > commands.sql
sqlite3 VRCX.sqlite3 < commands.sql
Is your feature request related to a problem? Please describe.
With the news about EAC, it would be nice to have a standalone program that can take emmVRC's user notes and import them into VRCX to make them usable in the future (should VRC not reverse their decision).
Describe the solution you'd like
A standalone .exe to move notes over, even when emmVRC is no longer usable in-game. There is a solution for FriendNotes (https://github.com/markviews/FriendNotes-to-VRCX), but many people started using emmVRC's user notes before FriendNotes existed, with no real option to migrate notes to another mod.
Describe alternatives you've considered
I don't think there are alternatives, other than vrchat not blocking modding or introducing friend notes in the vanilla game.
Additional context
No response