INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: One for Marko: Fill properties from filename  (Read 2732 times)

Mr ChriZ

  • Citizen of the Universe
  • *****
  • Posts: 4375
  • :-D
One for Marko: Fill properties from filename
« on: June 29, 2006, 01:51:43 pm »

Helping a mate get to grips with MC.
He's got a load of video files which we want to fill properties from filename for.
Trouble is the file names are like this
Smallville - xyy - name.avi

Where x refers to Series , and y Episode number.
Is there away of splitting the x from the yy.
The x is alway going to be a single digit.
and the y two digits.

They will be going into the fields
[Series] and [Episode]
?
Cheers
Chris

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: One for Marko: Fill properties from filename
« Reply #1 on: June 29, 2006, 02:12:14 pm »

There should be... Using something like mid() from programming languages.  I think asking Marko was pretty smart!   ;)

I've fought that battle many times.... Unfortunately no-one uses anything approaching a numbering standard.  I've settled on

01e12 (for season one, episode twelve) for those that I record and store...
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re: One for Marko: Fill properties from filename
« Reply #2 on: June 29, 2006, 02:53:53 pm »

Since there are not so many seasons (9 at max) I would just use something like this.


Fill Properties From Filename:

[Album] [Episode] - [Name]

The episode fields would be after that like - xyy

After that select the season one files (or do you prefer series), give the season its number and use the Find and Replace tool for fixing the Episode field.

Find What: - 1
Replace:       (empty)


Then repeat the same with other seasons:

Find What: - 2
Replace:       (empty)

etc...
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

Mr ChriZ

  • Citizen of the Universe
  • *****
  • Posts: 4375
  • :-D
Re: One for Marko: Fill properties from filename
« Reply #3 on: June 29, 2006, 03:08:55 pm »

Cheers Alex, shame there isn't the option to use Regex
really but i'm sure we'll manage!  :)

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: One for Marko: Fill properties from filename
« Reply #4 on: June 29, 2006, 03:29:41 pm »

Since there are not so many seasons (9 at max) I would just use something like this.

Yes... But there could be 9 seasons each of 14 different shows...

 ;D

(Just being a devil's advocate.)
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9139
Re: One for Marko: Fill properties from filename
« Reply #5 on: June 30, 2006, 02:10:26 am »

I would have replied with much the same suggestion as Alex.

also...

Another option, less work for you, more work for the library, would be to import the xyy data to a library field that would never be displayed, so call it something obscure such as xyy, using the template [Album] - [xyy] - [Name], then create expression based calculated fields for [episode] and [series]

the calculated data templates would be:

for series: mid([xyy]0,1)
for episode: mid([xyy],1,-1)

these fields would be searchable, sortable, and available in library browser views too.

-marko.

Mr ChriZ

  • Citizen of the Universe
  • *****
  • Posts: 4375
  • :-D
Re: One for Marko: Fill properties from filename
« Reply #6 on: June 30, 2006, 03:56:17 pm »

Cheers Marko!
Unfortunatly My friend got trigger happy with the rename files from properties tool
, and then topped it off by removing the files from MC, and we've just spent the past hour getting back to where
he was at yesterday....

Maybe MC should have an undo history list!

Mr ChriZ

  • Citizen of the Universe
  • *****
  • Posts: 4375
  • :-D
Re: One for Marko: Fill properties from filename
« Reply #7 on: July 02, 2006, 07:14:41 am »

I made a C# Script to resolve this in the end.
It inserts an X at a certain point in each filename.

http://yabb.jriver.com/interact/index.php?topic=33020.msg235390#msg235390

benn600

  • Citizen of the Universe
  • *****
  • Posts: 3849
  • Living: Santa Monica CA Hometown: Cedar Rapids IA
Re: One for Marko: Fill properties from filename
« Reply #8 on: July 02, 2006, 09:07:17 am »

Somewhat related questions here:

I would like to spend time adding tags to all of my pictures and videos so MC has much more info.  For example, I want to add to the people and place tags so my pictures are easily searchable and I can find things instantly.  The problem I am wondering about is if I add tags to my library database, are these tags stored in the individual files somehow?  I'm not sure if JPG's (or AVI's, MPG's, MOV's) have tagging capabilities or not (that's what I'm wondering).  The problem is that I don't want to tag them and then my other 3 libraries would have to go through the same process.  We aren't all going to tag 14,000 pictures.  If the tags are stored in the files, a quick re-scan and import would quickly gather the updated information.

How do you guys handle this?

Also, I wouldn't mind the tags being stored in the files anyway because it is information that should be there--just like the title info for a song SHOULD be there.  It makes no sense to not have it.  This way, MC is not required to keep the tags true.
Logged

Mr ChriZ

  • Citizen of the Universe
  • *****
  • Posts: 4375
  • :-D
Re: One for Marko: Fill properties from filename
« Reply #9 on: July 02, 2006, 09:45:28 am »

Sadly as far as I know AVI's, MPGs, MOV's can't hold tags at all.
So it's just down to MC doing it's bit.  It's a pain
when you send someone files though and they don't get the tags!

JPG's I'm not so sure about.

Alex/Marko and others know more about this.
I'm waiting for some supreme format to take over from them all!
Alex mentioned something called Matroska at some point in the past which sounded good,
but I don't think MC supports it at present?

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: One for Marko: Fill properties from filename
« Reply #10 on: July 02, 2006, 05:24:05 pm »

Sadly as far as I know AVI's, MPGs, MOV's can't hold tags at all.
So it's just down to MC doing it's bit.  It's a pain
when you send someone files though and they don't get the tags!

JPG's I'm not so sure about.

Alex/Marko and others know more about this.
I'm waiting for some supreme format to take over from them all!
Alex mentioned something called Matroska at some point in the past which sounded good,
but I don't think MC supports it at present?

MOVs can, but I don't think MC supports it (and it might be proprietary Apple stuff and the tags they can contain are pretty limited).

AVI and MPG container formats can't hold any tags of value.  They're old formats really.

MKV (Matroska video), MP4 (which was based on Quicktime MOVs), and OGM (Ogg Media File) container formats are much newer generation formats, and support far more advanced tagging capabilities.  MC can certainly catalog and play back all of those formats, assuming your system has all the needed filters and splitters installed.  I don't know what level of "in-file" tagging support MC has currently for these formats.

My guess would be none, but I don't know.

Either MKV or MP4 is really probably the future.  I personally like MKV files, just because all the relevant specs are patent free and public domain.  I'd really like to see a nice, easy to use tool similar to AutoGK that could create x264 MKV files.  If that happened, all my recodes would probably move to that format right away.  Thus far, creating them still is a balancing act.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9139
Re: One for Marko: Fill properties from filename
« Reply #11 on: July 03, 2006, 02:24:30 am »

.wmv's can hold tags...

Quote
Audio Codec: Windows Media Audio 9
Format: 160 kbps, 44 kHz, stereo (A/V) 1-pass CBR
Protected: No
Seekable: Yes
Trusted: No

WMA Tag dump:
    Signature_Name:
    Title: Addicted To Love
    Author: Robert Palmer
    Copyright: Universal Music
    Description: no branding
    Rating: 01HG013200
    WMFSDKVersion: 9.00.00.2980
    WMFSDKNeeded: 0.0.0.0000
    WM/ToolName: Media Center
    WM/ToolVersion: 11.1.54

    WM/Genre: music video
    WM/Year: 2003
    WM/AlbumTitle: 06/06/2003
    Duration: 2347400000
    Bitrate: 963855
    Seekable: Yes
    Stridable: Yes
    Broadcast: No
    Is_Protected: No
    Is_Trusted: No
    HasAudio: Yes
    HasImage: No
    HasScript: Yes
    HasVideo: Yes
    CurrentBitrate: 950040
    OptimalBitrate: 950040
    HasAttachedImages: No
    Can_Skip_Backward: No
    Can_Skip_Forward: No
    FileSize: 27939118
    HasArbitraryDataStream: No
    HasFileTransferStream: No
    WM/ContainerFormat: 1
    IsVBR: No
    Agility FPS: 4627730092099895300

jpg files hold them for sure. bear in mind that MC  only writes proprietry image tags to jpg files, which means that only MC can read them (the tags, not the files, of course :) )
Pages: [1]   Go Up