Extract/Create Mini DV Metadata and etc...?

[JohnnyMalaria]

The CSV file will direct the Enosoft DV Processor (via an Excel VBA program) how to change the metadata in the DV AVI file. The modified DV AVI file will then be sent to tape.

RE the CSV file, does each line represent a single frame and does 1 mean a scene change? Also, you input is an MPG file - is this what you are creating from PPro? If so, it needs to be a DV AVI.

[Undead Sega]

ahhh i see, so i would be modifying the DV files before i take them back onto tape?

and yes, the scene detection was done straight from the Mpeg files that is split in according to their aspect ratio, each of the video clips has their own scene detection CSV file. After knowing what to do, i will convert (and post-process) each of the files into DV-AVIs.

[Undead Sega]

any answer by any chance?

[JohnnyMalaria]

Sorry, I thought you were just clarifying.

Yes, the files would be modified prior to going back to tape.

For each MPEG file that you use to create the CSV file, you need to create an frame-for-frame equivalent in the DV version.

When I get a chance, I'll put together a detailed flowchart showing the exact steps (as I understand them).

[JohnnyMalaria]

Is there one line per frame in the CSV file? If so, the example you provided contains about 25 minutes. The maximum Excel could import at a time is about 43 minutes. Will you exceed that in a single video file? This determines how to handle the CSV file.

[Undead Sega]

Hi, sorry for the late reply, but those CSV files i made were split amongst there aspect ratio, and it is in this case, that one of the video files spreads to 1 hour max, and another probably around over 40 mins.

would this be a problem? right now, i will be converting those MPG video files to an identical DV AVI files

[JohnnyMalaria]

No, it isn't a problem. It just requires a slightly different approach.

[Undead Sega]

So the approach of me creating the DV files, and using ur software to make a Metadata within them and then placing into a DV tape is not the case for this method then?

[JohnnyMalaria]

It is the same method. It's just a small difference in how to get at the information in the CSV file. But it's no big deal.

[Undead Sega]

so what will i need to do then, i am in the short process of getting your software

[JohnnyMalaria]

Creating the CSV file and the DV version of the MPEG file is the right thing to be doing.

The main thing you need to do for now is to wait for me. I have to get a prototype Excel macro working to try out the concept (realistically a couple of weeks since I have some commerical projects to complete).

[Undead Sega]

oh okay then.

so basically what ur saying is, a CSV file containing information for a video file over 40 mins wont work?

[JohnnyMalaria]

It will work (I needed to know so that I can choose which way to process the file - the end effect is the same).

[Undead Sega]

ohh, so what is the problem that i could be misunderstanding then?

[JohnnyMalaria]

I think I confused you.

With the example CSV you sent, I simply opened it in Excel and thought of reading the information from the spreadsheet (because Excel will be used to co-ordinate changing the metadata while the DV file is sent to tape). But because the CSV file may exceed Excel's limit of 65,000 lines (about 40 minutes), I will have to open the file in a slightly different way - the results will be the same.

[Undead Sega]

ohhh okay thern, well good news, i have successfully made identical DV AVIs of the original MPGs, and i still have the CSV files as well made from them, now all i ask is, what do i do next?

[JohnnyMalaria]

When I've got a working prototype I'm PM you so you can try it.

[Undead Sega]

oh okay then, so what can i do for now? wouldnt the previous method work?

[Undead Sega]

anyone?

[JohnnyMalaria]

Convert the MPEGs to DV as you already plan to and generate the CSV files. No need to change anything.

It will probably be a couple of weeks before I can get something to you. I'll PM you when I have something for you to test.

[Undead Sega]

oh okay, well i think i already mentioned that i have already generated the CSV files and created an idental DV-AVIs from the original (split MPG) videos.

im just wondering, what can i do now? would the previous method work at all?

[JohnnyMalaria]

There is no previous method - I simply needed to know how long the videos might be.

Because you have created the DV-AVIs and the CSV files, you have done all you can do until I can send you an Excel macro which will most likely be in a couple of weeks (it doesn't exist yet).

[Undead Sega]

well what i meant by previous method was that, like how it is originally done.

either way, may i ask, why do i have to wait for this Excel Macro? what is this for?

[JohnnyMalaria]

Because I am writing something for you for free that uses Excel to control the DV processor software to make the changes to the metadata according to the CSV file. There was no original version.

[Undead Sega]

i see...so what i was asking from the begining of this thread wouldnt have been possible in the first place?

[JohnnyMalaria]

You asked it if were possible - which it is. You didn't ask if something existed off-the-shelf today that would do it. This is why we have had a long discussion about the CSV files, how you create the AVI files etc so that I could create the Excel macro to do it for you.

[Undead Sega]

ahhh okay then, so this Excel macro u are making, would this be part of your software? like an update perhaps?

[JohnnyMalaria]

Yes. It will be something that works with Excel and our DV processor. As long as you already have those, you'll be all set.

[Undead Sega]

hey JohnnyMalaria! how are you? and how is everything going?

[JohnnyMalaria]

I'm fine. Things are going okay - I'll PM you when I have something for you to test.