Skip to content
This repository has been archived by the owner on Oct 15, 2022. It is now read-only.

[FEATURE REQUEST]: External program to import emmVRC user notes into VRCX #1707

Open
forever-and-a-day opened this issue Jul 26, 2022 · 1 comment
Labels
feature New feature or request

Comments

@forever-and-a-day
Copy link

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

@forever-and-a-day forever-and-a-day added the feature New feature or request label Jul 26, 2022
@realityvrc
Copy link

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
feature New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants