I’m trying to import markers from Dropbox Replay (which is similar to Frame.io) and they have options to export it as .csv or condensed .csv. On importing the file into Nuendo, it seems to separate the attributes decently well. I’m using only two columns, ‘Description’ and ‘Timecode In’.
Yep. I had to create (well, find and adapt) a formula that I paste into fields in a doc editor to get timecode transferred correctly.
In your case it would be pretty easy to do except for those first single-digit values (minutes I presume). You could probably easily add a leading “01” (like I do) and then you would have to add a zero if it’s a single digit, and then delete / replace the end with “00” frames.
I bet this could be done somehow. I’m too dumb to figure it out.
Ah, yes, didn’t realize the timecode format was messed up. Yep, for this project it seems like a quick fix. Maybe I’ll get in touch with Dropbox support and check if they can change on their end for the sake of compatibility.
I agree with Kenobi… those numbers do not look like Timecode.
HH:MM:SS:FR is the correct format for any Timecode.
Are you able to see the Dropbox Replay directly, or adjust them there, or format the CSV file on export from Dropbox??
For now, I’ll have to edit it manually outside of Dropbox Replay. Avid has direct integration for Protools to import markers. Hopefully they support Nuendo in the future.
EDIT: Seems like you can change between timecode, seconds and frames in Dropbox Replay, but, I still need to add the HH in front of the timecode unfortunately.
Well, it’s better than nothing, but can still be a lot of extra work. Hopefully dropbox listens to it’s users and adds the hours slot in their timecode.
You can do that in a regular CSV reading software like LibreOffice or MS ‘calc’ by adding the value to each cell. In time formats from some clients that’s what I have to do. I add both the leading hours and the end frames. Then it works.
Thanks for the recommendation. I tried doing this on Apple’s Numbers to add a prefix to all cells together, but couldn’t figure it out. Had to do it cell by cell. But at least the marker import worked.
Do you do this cell by cell or can you add a prefix to all cells at one go?
There is probably a better way to do this, I’m not that good at these types of programs, but I got this from searching online.
So I import the CSV into LibreOffice. Then I choose this option by right-clicking on the column header (“B”):
After I have that new column I copy over all the time data in that first column to the second column. I suppose if you don’t care about that second column you could skip that step.
Then I select the first cell and paste this =“01:”&A4:A9&“:00”:
As you can see that adds the leading 1hr and end zero frames. Once that’s done I copy the cell itself and then select all cells below in that column and just paste on top of all of them:
Then just save-as and import into Nuendo. Don’t ask me if there’s an easier way, there probably is, this is what I found and it works. I actually think there may be some utility floating around out there that does this but I haven’t found it. I’m also guessing it’s possible to write a macro or script or whatever to get it done. Perhaps I’ll look into it again when I get time.
Haha, I can relate. I hate doing these kind of tasks, but it speeds up workflow in Nuendo. Let me also look around to see if there’s an easier way to do this. Thanks for sharing your workflow.
