Removing unwanted recording from Mimic-Recording-Studio: Difference between revisions

From Voice Technology Wiki
Jump to navigation Jump to search
m (Categories)
m (Fixed Syntax highlighting problem.)
 
Line 1: Line 1:
==Problem==
You made an unwanted/bad recording in [[:Category:Mycroft|Mycrofts]] [[Mimic-Recording-Studio]] (''MRS'') and instead of skipping or re-recording the phrase you accepted that recording. Now you want to remove it before continuing your recording session?
You have made an unwanted/bad recording in [[:Category:Mycroft|Mycrofts]] [[Mimic-Recording-Studio]] (''MRS'') and instead of skipping or re-recording the phrase you accepted that recording. Now you want to remove it before continuing your recording session?


==Steps to solve problem==
==Steps to solve problem==


#Stop Mimic-Recording-Studio
# Stop Mimic-Recording-Studio
#Find the recorded file in your MRS directory (''eg: <MRS-BaseDir>/backend/audio_files/<GUID of recording session>/<GUID of recording>.wav'')
# Find the recorded file in your MRS directory (''eg: <MRS-BaseDir>/backend/audio_files/<GUID of recording session>/<GUID of recording>.wav'')
#"Remember" the GUID of the "bad" recording
# "Remember" the GUID of the "bad" recording
#Delete the file from audio_files directory
# Delete the file from audio_files directory
#''Remove recording from <GUID>-metadata.txt file (this step is optional)''
# ''Remove recording from <GUID>-metadata.txt file (this step is optional)''
#Open SQLite DB with a Tool like DBeaver (''<MRS-BaseDir>/backend/db/mimicstudio.db)''
# Open SQLite DB with a Tool like DBeaver (''<MRS-BaseDir>/backend/db/mimicstudio.db)''
#Run following SQL query:
# Run following SQL query:
 
<syntaxhighlight lang="sql">
<syntaxhighlight lang="sql">
DELETE FROM audiomodel WHERE audio_id = '<GUID of recording>';
DELETE FROM audiomodel WHERE audio_id = '<GUID of recording>';
Line 16: Line 16:
</syntaxhighlight>
</syntaxhighlight>


#Close SQLite DB connection
# Close SQLite DB connection
#Restart Mimic-Recording-Studio
# Restart Mimic-Recording-Studio


[[Category:Lessons learned]]
[[Category:Lessons learned]]
[[Category:Mycroft]]
[[Category:Mycroft]]

Latest revision as of 21:12, 29 November 2021

You made an unwanted/bad recording in Mycrofts Mimic-Recording-Studio (MRS) and instead of skipping or re-recording the phrase you accepted that recording. Now you want to remove it before continuing your recording session?

Steps to solve problem[edit | edit source]

  1. Stop Mimic-Recording-Studio
  2. Find the recorded file in your MRS directory (eg: <MRS-BaseDir>/backend/audio_files/<GUID of recording session>/<GUID of recording>.wav)
  3. "Remember" the GUID of the "bad" recording
  4. Delete the file from audio_files directory
  5. Remove recording from <GUID>-metadata.txt file (this step is optional)
  6. Open SQLite DB with a Tool like DBeaver (<MRS-BaseDir>/backend/db/mimicstudio.db)
  7. Run following SQL query:
DELETE FROM audiomodel WHERE audio_id = '<GUID of recording>';
UPDATE usermodel SET prompt_num = prompt_num - 1 WHERE uuid = '<GUID of Recording Session>';
  1. Close SQLite DB connection
  2. Restart Mimic-Recording-Studio