Old 03-27-2022, 08:24 PM   #1
mrmong
Human being with feelings
 
Join Date: Oct 2021
Posts: 34
Default Importing Marker CSV and Diffing with Current Markers

Hello!

I'm looking for a way to be able to import or diff an external Marker CSV file which will only update the region marker texts if there are differences between whats in the reaper session AND the external marker csv

Would anyone know how to do this?

The long workaround i have for this is to use excel and do some index matches but i'd like to roll this out to my team to be able to quickly update the marker texts so that when they are QC-ing the dialog files they can be accurate to the database


Context of this use case would be that:
A recording session with markers acting as subtitle script gets updated offline externally in another database csv file and user can just simply run this script to quickly get an updated marker subtitles if there any difference
mrmong is offline   Reply With Quote
Old 03-27-2022, 11:25 PM   #2
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

This can only be solved by custom reascript coding.
X-Raym is offline   Reply With Quote
Old 03-28-2022, 01:55 AM   #3
mrmong
Human being with feelings
 
Join Date: Oct 2021
Posts: 34
Default

Quote:
Originally Posted by X-Raym View Post
This can only be solved by custom reascript coding.
i'm still quite a beginner scripter as I've built a few simple scripts to help with my team's workflow.

Could i get some hints on where i can start with for this use case? much appreciated!
mrmong is offline   Reply With Quote
Old 03-28-2022, 03:43 AM   #4
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

this is nit basic script cause there is file parsing


but you can start with extsing scripts via reapack. find one which does region processing and one which does file parsing and inspect the code.

my import region from csv script might help
X-Raym is offline   Reply With Quote
Old 03-30-2022, 09:08 AM   #5
mrmong
Human being with feelings
 
Join Date: Oct 2021
Posts: 34
Default

Quote:
Originally Posted by X-Raym View Post
this is nit basic script cause there is file parsing


but you can start with extsing scripts via reapack. find one which does region processing and one which does file parsing and inspect the code.

my import region from csv script might help
Thanks for the hints! i've managed to get it working!
The import region from CSV script was a good point of reference.

What i did was to use the column indexes variables to get the info from each column such as the region name and the subtitle name in the database csv

Check that against the regions in the project

If the region name in database and the session's region matched, check the markers table.

If the markers in the project don't match the column index's subtitles, update it to match the database's!


Thanks again for your help!!
mrmong is offline   Reply With Quote
Old 03-30-2022, 12:06 PM   #6
X-Raym
Human being with feelings
 
X-Raym's Avatar
 
Join Date: Apr 2013
Location: France
Posts: 9,875
Default

Thx for the feedback and glad it helped !
X-Raym is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 08:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.