MediaArea / BWFMetaEdit

WAV/BWF metadata editor
https://MediaArea.net/BWFMetaEdit
Other
51 stars 19 forks source link

Trouble displaying duration info when exporting CSV file #310

Open knfleck opened 2 weeks ago

knfleck commented 2 weeks ago

Hello!

Maybe it's me. But when I export "Technical Metadata (one global CSV file) the duration field is formatted 00.00.0 / mm.ss.0, which works well until I have files that are over an hour long. Is there a way to export that information as hh:mm:ss.0? Like, having space for hour information.

I'm hoping to copy/paste the duration information from BWFME-generated spreadsheet into an Excel spreadsheet for a client deliverable. And there are some files that are over an hour in duration.

Thank you!!!

g-maxime commented 2 weeks ago

On which platform?

With latest version, I have the hours:


FileName,....,Duration,....
bigfile.wav,....,01:01:01.000,....
shortfile.wav,....00:00:36.000,....```

Can you share a CSV file? 
knfleck commented 2 weeks ago

Hi Maxime,

Thanks for your help! I downloaded the latest version of BWFMWE. But your comment also made me think that maybe the auto-formatting in Excel was the culprit. Turns out, it was. D’oh! I played with the cell formatting and I can now see the hours.

Simple fix on my end! Thanks again for your help 😊

Cheers, Karl

From: Maxime Gervais @.> Sent: Thursday, November 7, 2024 1:44 AM To: MediaArea/BWFMetaEdit @.> Cc: Karl Fleck @.>; Author @.> Subject: Re: [MediaArea/BWFMetaEdit] Trouble displaying duration info when exporting CSV file (Issue #310)

On which platform?

With latest version, I have the hours:

FileName,....,Duration,....

bigfile.wav,....,01:01:01.000,....

shortfile.wav,....00:00:36.000,....```

Can you share a CSV file?

— Reply to this email directly, view it on GitHubhttps://github.com/MediaArea/BWFMetaEdit/issues/310#issuecomment-2461444444, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVVFAXCSHGZ3TLUL4H5ESCTZ7MDZVAVCNFSM6AAAAABRJA5QVWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRRGQ2DINBUGQ. You are receiving this because you authored the thread.Message ID: @.***>