Import Video File Information into Excel

[CodenameAter]

Hello All,

This is a bit of a weird question but I imagine someone has asked it before. Here goes:

I want to upload .avi files information into excel. I have a number of surveillance cameras and I need to log events & write comments. Each video files contains a lot of information including the file name, length, date, etc. All I want is a way to quickly upload an entire file folder of video files into excel so that it would read something like:

File Name	Length	Date	Comments
Event20150607...	00:05	06/07
Event20150607...	00:10	06/07

<tbody>
</tbody>

I am not worried about how the data looks as long as it uploads in some delimited formate. I can run macros to deal with the data after the fact. I also do not care if they can view the file as that is done is a separate program, I just need the info as to avoid manually writing it in.

Let me know. Thank you.

 

[mole999]

does you camera system provide any archiving info. there used to be a video file reader called gspot (be careful which links you follow)

 

[CodenameAter]

does you camera system provide any archiving info. there used to be a video file reader called gspot (be careful which links you follow)

I don't know, I'll have to investigate but I didn't even think of that, good call. It's really old software but it might have some sort of logging function.

I'll look for the gspot....software that is, such a corny joke :P Thanks for the suggestion

 

[mole999]

maybe info here Get video information with ffmpeg | commandlinefu.com

 

[CodenameAter]

maybe info here Get video information with ffmpeg | commandlinefu.com

Thanks for the link. I actually found out that my system does store this information in Access format. I have no idea where they store it and the manual doesn't say anything, pretty sure the system was invented before the internet so there isn't much out there but the manual does say it stores it, so let the treasure hunt begin

 

[mole999]

so it will be an access.mdb a bit like sql, you'll either have an rs232 output or usb link