Copy link to clipboard
Copied
How can I automate multiple in and out points from a spreadsheet to automate multiple edits on one long clip in a sequence?
It's not a particularly common need, as most workflows which have timecodes as text, also have the actual time values...
The missing piece is code to translate between textual representation of times, and actual time values.
This seems promising!
https://stackoverflow.com/questions/31385418/convert-timecode-to-seconds
Once you have seconds, you should be able to use PPro's ExtendScript APIs (including the handy Time object).
Copy link to clipboard
Copied
Might need to write a script for that.
Copy link to clipboard
Copied
Thanks for your reply. I can't believe there's not a simple solution for this. Seems like it'd be a common need....
How would I go about making a script? It will lieterally save me several hours of tedious work. Here's my in and out points:
0:10:36 | 0:10:51 |
0:10:51 | 0:11:07 |
0:11:07 | 0:11:10 |
0:11:10 | 0:11:22 |
0:11:24 | 0:11:25 |
0:11:25 | 0:11:39 |
0:11:40 | 0:11:58 |
0:12:06 | 0:12:25 |
0:12:29 | 0:13:08 |
0:13:31 | 0:13:42 |
0:14:37 | 0:14:49 |
0:14:54 | 0:15:23 |
0:15:55 | 0:16:21 |
0:16:35 | 0:16:46 |
0:16:55 | 0:17:38 |
0:18:02 | 0:18:51 |
0:20:32 | 0:20:52 |
0:21:06 | 0:21:36 |
0:21:55 | 0:22:04 |
0:22:33 | 0:22:44 |
0:22:53 | 0:23:12 |
0:23:53 | 0:24:21 |
0:24:27 | 0:24:55 |
0:24:59 | 0:25:04 |
0:25:04 | 0:25:22 |
0:25:28 | 0:25:43 |
0:25:51 | 0:26:33 |
0:26:56 | 0:27:05 |
0:27:17 | 0:27:25 |
0:27:39 | 0:28:26 |
0:28:46 | 0:29:21 |
0:29:40 | 0:30:02 |
0:30:03 | 0:30:16 |
0:30:37 | 0:31:30 |
0:31:36 | 0:31:49 |
0:32:00 | 0:33:22 |
0:33:34 | 0:33:51 |
0:33:54 | 0:34:21 |
0:36:53 | 0:37:15 |
0:34:36 | 0:35:22 |
0:40:48 | 0:41:18 |
0:38:18 | 0:38:50 |
0:35:40 | 0:36:04 |
0:41:20 | 0:41:25 |
0:43:17 | 0:43:30 |
0:43:41 | 0:43:50 |
0:44:13 | 0:44:29 |
0:45:02 | 0:45:27 |
0:45:42 | 0:45:48 |
0:41:33 | 0:42:32 |
0:47:40 | 0:47:47 |
0:47:56 | 0:48:17 |
0:49:19 | 0:49:56 |
0:49:58 | 0:50:42 |
0:50:43 | 0:50:48 |
0:51:23 | 0:51:03 |
0:52:14 | 0:52:45 |
0:53:04 | 0:53:26 |
0:53:30 | 0:53:50 |
0:56:45 | 0:56:53 |
0:59:13 | 0:59:19 |
0:59:21 | 0:59:28 |
0:59:39 | 1:00:19 |
1:00:29 | 1:00:41 |
1:00:41 | 1:01:12 |
1:03:01 | 1:04:03 |
1:05:01 | 1:05:26 |
1:04:37 | 1:04:46 |
1:05:58 | 1:06:09 |
1:11:05 | 1:11:08 |
Copy link to clipboard
Copied
Copy link to clipboard
Copied
It's not a particularly common need, as most workflows which have timecodes as text, also have the actual time values...
The missing piece is code to translate between textual representation of times, and actual time values.
This seems promising!
https://stackoverflow.com/questions/31385418/convert-timecode-to-seconds
Once you have seconds, you should be able to use PPro's ExtendScript APIs (including the handy Time object).
Copy link to clipboard
Copied
Bruce, thanks for your reply. I appreciate it but unfortunately, I'm not a code guy and that all sort of looks like gobbledygook to me.
Copy link to clipboard
Copied
fyi... Here is another reply I received:
"I would suggest that you convert the spreadsheet to edl, and then import the edl file. Obviously your spreadsheet needs to be formatted so the converter can read it accurately. There are plenty of converters around, a quick Google search brought this one in at the top: httpsxxxxx