Frame IO to Flame

[johnt]

Hi @john-geehreng

I’m running v1.3
I checked the terminal and saw these errors which say it can’t see headers with timecode - when I open the csv in libre calc, I can see timecode headers

No timecode found. The CSV needs a header that reads ‘Timecode In’.
No timecode found. The CSV needs a header that reads ‘Timecode In’.
VM load pref failed loading /var/tmp/tmp269 with error 6
Sucessfully created marker at 00:00:29:13
VM load pref failed loading /var/tmp/tmp269 with error 6
Sucessfully created marker at 00:00:38:19
A Marker already exists at the location.
Couldn’t create marker because of error: A Marker already exists at the location.
Sucessfully created marker at 00:00:56:18
No timecode found. The CSV needs a header that reads ‘Timecode In’.
No timecode found. The CSV needs a header that reads ‘Timecode In’.
No timecode found. The CSV needs a header that reads ‘Timecode In’.
No timecode found. The CSV needs a header that reads ‘Timecode In’.
No timecode found. The CSV needs a header that reads ‘Timecode In’.
No timecode found. The CSV needs a header that reads ‘Timecode In’.
Sucessfully created marker at 00:01:03:24
No timecode found. The CSV needs a header that reads ‘Timecode In’.
No timecode found. The CSV needs a header that reads ‘Timecode In’.

[cicero]

I use this script a lot now and whenever there’s a problem, it’s because of the formatting of the .csv.

I’ve opened your .csv in OpenOffice Calc and although there are TCs they aren’t in the first column.
You need to

• delete top row of column headings
• have column 1 just contain TCs
• have column 2 just contain comments
• delete all other extraneous data

Sorry if you know all this already.

[johnt]

I didn’t know this @cicero - so I did what you suggested but it imported nothing this time. This is the csv I made.

FE_2min_SFX_LittleDeath_7_New_Ending_7thMarch_edit_2.zip (1.3 KB)

edit - I’ve tried all sorts of edits and using googl sheets and open office and importing the csv direct - it’s just not working for me. puzzled

[john-geehreng]

@johnt try this:
FE_2min_SFX_LittleDeath_7_New_Ending_7thMarch_rev16.csv.zip (3.7 KB)

Deleting the top row will break the script in v1.3. I’ve changed a few things in your .csv.

• There were a couple of line breaks in the Comment column that didn’t need to be there and caused it to fail.
• There were duplicate entries. I left them in csv, but changed the timecode by a frame.
• Apparently, the script doesn’t like commas. I’ll have to see if I can figure out why one of these days. I removed them from rows 12 and 17.

After that, it worked:

[johnt]

Excellent - works fine - thanks for the pointers

[cicero]

Sorry, I’m probably using an older version of the script. I always have to remove the top row of headings which doesn’t have TC in it, otherwise it breaks

Anyway you beat me to it @john-geehreng! It was the duplicate entries which were still catching me out.

Hope it works for you @johnt

[john-geehreng]

You guys might like the latest FrameIO scripts.

[PlaceYourBetts]

The last time I used this script it didn’t like multiple comments on the same time code. We often get rounds of feedback from the director and then maybe the creatives join in and either agree or offer an alternative comment but all at the same place on the edit.

[dustin]

@john-geehreng

…2. I’ve tested it in 2022.3, 2023.1, and 2023.2. I’ve also listed my tweaks in the Updates section of the script for those interested.If you want timeline markers, right click a sequence on the desktop or media panel, and look for Add Timeline Markers->Select CSV. If you want segment markers, select the segments in a timeline, right click, and look for Add Segment Markers->Select CSV. (5.7 KB)

Hello John, I am trying to use this script but i get the error in the console that says The location is outside of the Marker’s segment even though that is the start timecode of the clip. Any ideas?

[john-geehreng]

Hi Dustin. Is there any way you share the csv? Which option are you using “Add Timeline” or “Add Segment Markers?”

[dustin]

thanks for the reply, I am using the “add segment markers”. Here is the CSV I am trying to use.

4Max frame_io_test.csv.zip (741 Bytes)

[john-geehreng]

Sure thing. That doesn’t look like a csv from FrameIO. It should have a bunch more columns. Here’s an example:
frameio_example_csv.zip (1.2 KB)

In Flame, where do you find “add segment markers?” It should be under a FrameIO menu.

[dustin]

Okay I see, I was just trying to utilize this to bring in markers with a CSV. I don’t have a FrameIO menu, it just says add segment markers>select CSV

[cicero]

Trying to get v1.3 of @john-geehreng’s script to work and encountering some problems.

I’ve made a test.csv which has required columns, plus one called Vendor.

1 - My project, seq and segments on the seq are all 25fps. Seq and V1.1 segments are all on 10hr TC (V1.1 is a single imported slab of media cut up by EDL, so src/rec TCs are actually the same).
It seems to be parsing the TC wrong, so if

a) I right-click seq in Media Panel and “Add Timeline Markers > Select CSV” it drops two timeline markers but at wrong TC:
10:00:00:00 on csv becomes 19:59:59:24 on timeline
10:00:01:00 on csv becomes 20:00:00:24 on timeline

b) I select all segments on V1.1, right-click and “Add Segment Markers > Select CSV” it errors:
Couldn't create marker because of error: The location is outside of the Marker's segment.
This is presumably because it can’t find a 19 or 20hr TC within the 10hr media.

2 - I’m using John’s script unedited, except for adding two lines after comment stuff to move the data from the csv’s Vendor column into marker names:

            try:
                m = flame_obj.create_marker(marker_time.frame)
                m.duration = marker_dict["Duration"]
                comment = remove_quotes(marker_dict["Comment"])
                m.comment = comment
                vendor = remove_quotes(marker_dict["Vendor"])
                m.name = vendor
                print("Sucessfully created marker at", m.location)

In case 1a above where I do get some markers (but at the wrong TC), the marker names are not being poulated with the Vendor info and the shell gives
Couldn't create marker because of error: 'Vendor'
Maybe m.name isn’t recognised?

Any thoughts?
Many thanks!

test.csv.zip (243 Bytes)

[john-geehreng]

Give these a shot. I edited the csv to have an empty “dummy” column at the end and I updated the script a little bit. It’s working for me, but the duration should probably be zero unless you want a longer duration.

custom_vendor.zip (3.6 KB)

[cicero]

Thanks so much John - that works perfectly!
For future ref:
1 - Was the TC issue a 25fps thing?
2 - Dummy column - does it always need more columns than the specified ones to write/read the dictionary correctly?

[john-geehreng]

Cool.
1 - No, it wasn’t a 25fps thing. There was a “.frame” in the script that should not have been there. You can see it in the code above: m = flame_obj.create_marker(marker_time.frame)
2 - The last item in a column returns with a “\n” at the end, so it was failing to find “Vendors” because “Vendors\n” was returned.

[cicero]

Good to know. Thanks.

Also when I transfer a real-job csv with 100 or so notes, and apply as segment markers (not timeline markers), it seems to drop two markers at each TC. Not a problem as I can just multi-select and delete, leaving one of each marker. But a bit weird.

Anyway thanks again for taking the time!