Rename Files from XML - Apple scripting

IN PROGRESS
Bids
2
Avg Bid (AUD)
$875
Project Budget (AUD)
$750 - $1500

Project Description:
I am the senior video editor and default IT bloke for our small TV production company. I have built a media monitoring system which records a sizeable range of daily TV shows, so that our team of researchers can then view the recordings on our server (from their Mac laptops).

They can then export out clips out of interesting sections, and save those to our server, which the editors then grab and use in our Final Cut segments.

The system consists of half a dozen MacMinis that have Elgato EyeTV tuner USB sticks.

They record the shows (as MPEG2) into files . They are then set to automatically convert an "iPad" size H264 (using Elgato's Turbo H264 hardware encoder sticks - really helps), and then back up to a our Synology NAS servers.

Users copy these H264 clips to their desktops to watch (the MPEGs are usually too unwieldy). They then clip to and save back selected clips to the server, and our editors copy off those clips.

I have designed a network that seems to best fit the needs of our team, but there are some scripting solutions that I want to implement, but are beyond my self taught skills and over taxed brain.

1- The EyeTV program saves its recordings into a Package, that contains an MPEG2, and also an H264 (when the conversion is done). The name of the EyeTV Package is something like "Breakfast[20].eyetv", and the creation date does tell us the date of the recording, but it is annoying that it doesn't have the record date and channel in the file name. And even worse, the MPEG and exported H264 that are inside the Package have a random string for a name.
Given that our practice is to open the Packages and copy out the H264 to view later, I really want them to have sensible names.

What I want is to have a apple script and/or app that can copy the program name and date out of the EPG information (which is stored in an XML inside the Package) and make the Package and H264 have a sensible file name.

2. Once step is done, I want the recording Package to back up (but excluding the MPEG2 which are often massive and less useful than the H264) to our 8TB NAS. Every two hours approx.

[The system's main bottleneck is the early afternoon, when the recorders have finished recording and encoding the morning show, and are trying to back them up just as the most users are copying off and watching clips]

3. Every night (at about midnight) the recordings (including MPEG2) back up to our 20TB NAS.

So that is a summary of my desired workflow. I have broken it down into steps below, and I have indicated which ones I have been able to get working myself.




Media Monitoring System - WORKFLOW

Step 1: EyeTV Mac Mini records TV show as per EPG schedule. [WORKING - via EyeTV app]

Step 2: EyeTV converts MPEG2 to H264. [WORKING - via EyeTV App]

Step 3: wait until conversion has finished.

Step 4: Rename .eyetv package and internal H264 to this format "YYMMDD-Channel-ShowName.m4v"
[abbrev. channel name list: ch7, ch9 ch10, abc1, abc2, abc3, abc24, SBS, SkyN, FoxN, BBCN, CCTV, CNN]
{this info lives inside an XML file in the eyetv package}

Step 5: Backup renamed EyeTV Packages (including renamed H264, but not the MPEG2) that are not older than a week - to 8TB NAS every 2 hours.
Also exclude file "Live TV Buffer.eyetv" from backup
[currently using Carbon Copy Cloner - successfully excludes MPEG2 files, can't get it to only backup the last week]

Step 6: Backup EyeTV Packages (whole thing, except file "Live TV Buffer.eyetv") to NAS-Littlemore every night
[currently being done successfully by an automator script triggered by iCal]

Step 7: occasional manual deletion of large (>5GB) MPEG2 files from 20TB NAS and recording MacMinis
[currently use Pathfinder to do bulk search and delete of MPEG2 files inside the Packages - happy to keep this step manual]

Do you think you can help me?
Cheers
James

Skills required:
Cocoa, Mac OS, XML
Additional Files: Media+Monitoring+Network+Diagram.png
Hire jshape
Project posted by:
jshape Australia
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 750
in 10 days
$ 1000
in 5 days