You need to get the original BPAV folders. Using Clip Browser, they can easily collect your footage (assuming they archived what you shot) and combine/split into DVD sized chunks for burning. Simply getting around the issue by purchasing the codec may or may not solve all your issues, and it’s best to do things “by the book” in my opinion.
Earlier this year, despite how often this comes up, I still tried to take a “shortcut” for a friend and export MXF files for his PC-based Avid. He had issues with the footage, never having worked with XDCAM EX footage before, and I ended up doing just what we advise everyone else to do: give the editor the raw BPAV folders and let them sort it out. I knew better, figured I could deliver what he needed, and should have taken my own advice.
This brings up a common line of discussion, as it is associated with “school.” (thus I’m assuming you’re a student.) I’ve read plenty of accounts online of people complaining that graduates coming out of “school” have all kinds of grand Spielberg-ian ideas…but ZERO workflow skills. There’s only one way for that to happen to students who are still being allowed to graduate: instructors are not doing an adequate job of addressing, teaching, and enforcing good workflow habits. You got bit by it on a school project…imagine if there were thousands of dollars and an angry client in the mix! It’s a good lesson.
Hopefully you can get the original footage and work with it as you see fit. There’s always the aforementioned Calibrated Software codec as well. Hopefully you also got a good lesson. If you can graduate school with good workflow skills and the patience to work through the boring technical part of working with specific equipment and formats, you’re going to be ahead of 90% of the other graduates.
(PS: by putting “school” in quotes, I’m not mocking…I just want to point out that it’s a pretty broad term these days. Some are good, some are not so good. Neither can replace valuable real-world experience.)