Project Detail

Description

Clips and bits are a DVD on demand solutions provider. We create a single DVD based on stored Video TS files or create a new DVD based on a list selected by a customer online. The new or existing Video TS files are pushed to our publishing environment.

I want to automate a process based on Apple with new servers and Raid Array. Prefer Applescript but advice on any other method would be appreciated.
I want Filemaker Pro to first do a complete capture of our online databases of our online store/s.
I need filemaker to automatically sync with the online database on a hourly basis and grab new orders from our online stores.

There are a number of components that make up the creation of a dvd.
The Video TS file
The DVD wrap/insert on outside cover. Jpeg
The image file that is printed on the surface of the DVD disc.. .btw files as created by Rimage System
Mailing Label
Dispatch note

I need to produce a Dispatch note on a lase printer on network with order ref on it
I need to produce a mailing label on a Brother label printer on network. with order ref on it
For a pre created DVD, I need the system to grab a the Video TS file, Disc image .btw file and associated wrap image and place on a "cache drive" on a seperate drive under an new folder name based on a order reference created on the online system. Initialy this will be then manually handled by an operator but stage two is to integrate with API of our publishing systems.

For a newly created DVD (Multiple titles), I need to produce a Dispatch note on a lase printer on network with order ref on it
I need to produce a mailing label on a Brother label printer on network. with order ref on it. I need to produce a track list of all individual componets on the newly created disc. This list must be in play order as to that created from the online system.
I need the system to grab a the individual video files, send these to Toast Titamium and automatically for toast to create a VideoTS file based on certain authoring templates set up for each online store. Then it will follow a process similar to above, .........Video TS file Disc image .btw file and associated wrap image and place on a "cache drive" on a seperate drive under an new folder name based on a order reference created on the online system. Initialy this will be then manually handled by an operator but stage two is to integrate with API of our publishing systems.

I then need capability for order reports to be created per online store each month based from the Filemaker Pro environment.

Phil