http://www.youtube.com/user/activestoragevideos?feature=mhum

Let’s say you’ve created user accounts from either Mac OS X Open Directory or Active Directory and these users have logged into Final Cut Server (FCSvr).

Each time a user logs into FCSvr a new row is added to the pxuser table in the FCSvr Postgres DB containing the users Full Name and Short Name

This also adds the users shortname i.e. “xplatfomconsulting” to the user list available from the Created By drop down list in the FCSvr Advanced Search.

Well for every user that logs in, another entry is added to this drop down regardless if that user actually every created an asset.

What happens when you delete a user account?  The user remains in the list.

What happens if you have 100+ users?  A very long list right.

How do I rid myself of this long list?

Here are some ways.

Approach 1:

Use the Final Cut Server Command line tools to delete the user

Step 1. Run the following command at the terminal

cd “/Library/Application Support/Final Cut Server/Final Cut Server.bundle/Contents/Resources/sbin/”

Step 2. Run the following command at the terminal

./fcsvr_run psql -d px -p 8820 -U postgres -c “delete from pxuser where name = ’shortnameofuseryouwishtodelete’”

Approach 2:

Use a Postgres DB GUI DBMS to delete the record

Step 1. Download your Postgres DB GUI tool of choice and connect to FCSvr on port 8820

Step 2. Delete the row containing the user from the pxuser table.

If you wish to search against the directories on a device do the following

fcsvr_client search /dev

next select the device id and use the –dirs switch ie.

fcsvr_client search –dirs /dev/4

Sometimes you may need to start and stop the Final Cut Server deamons

fcsvr_stored

fcsvr_ldsd

and supported postgresql process

remotely from a ssh connection.

Here’s the procedure

1. Navigate to the following directory

cd “/Library/Application Support/Final Cut Server/Final Cut Server.bundle/Contents/Resources/sbin/”

Stopping the Final Cut Server services

2. Run the following command sudo ./fcsvr_ctl.sh stop

Starting the Final Cut Server services

2. Run the following command sudo ./fcsvr_ctl.sh start

FCS Cloud-Based Workflow Series

Wednesday, June 16, 2010 10:00 AM – 11:00 AM PDT

Sign up here: http://tinyb.it/4BFC22667665C

Final Cut Server On-Demand

-Multi-Location Source/Proxy Workflow
-Client-Selected Clip Selection and Sharing
-E-Commerce Solutions for Direct Delivery of Stock Footage

Learn how to expand Final Cut Server’s framework and XML architecture for content management and distribution in a cloud-based, on-demand workflow.  See the configuration options that will allow clients to request specific clips and receive assets in multiple file formats online, through the cloud, direct from FCS.

Audience:  Production pros using or considering Final Cut Server solutions can see cost-effective solutions for cloud-based workflows.  The Final Cut Server cloud-based, on-demand system not only extends search functionality, but expands workflow and increases efficiency.  From anywhere in the world, users can review assets and add frame-accurate in and out points to create sub-clips.  Full or edited clips can be requested online and delivered in user-selected transcoded formats.  The FCS on-demand system is particularly attractive to companies looking to leverage existing assets and creating new revenue streams.

Presenters:  Kai Pradel, CEO MediaSilo, Nicholas Stokes, XPlatform Consulting, Dan Green, BizDev MediaSilo

Wednesday, June 16, 2010 10:00 AM – 11:00 AM PDT

Sign up here: http://tinyb.it/4BFC22667665C

Final Cut Server 1.5 – Updating Lookups

So, here what you want to do.

1. Login to Final Cut Server (FCSvr) Java client as a user with Administrative privleges. Next from the Server Popup menu go to the Advance Administration Pane

2. Go to Lookups, search for the Lookup you wish to update, please note the Lookup ID. In this example I’ll use the Lookup for Asset Status i.e. PA_ENUM_CUST_ASSET_STATUS

3. Next from the Terminal navigate to the following location if the fcsvr_client binary it’s not already added to your bash path

cd /Library/Application Support/Final Cut Server/Final Cut Server.bundle/Contents/MacOS/

4. Run the following command

./fcsvr_client getmd –xml /enum/PA_ENUM_CUST_ASSET_STATUS > ~/Desktop/assetstatus_lookup.xml

5. Navigate to the desktop, there you’ll see a xml file named assetstatus_lookup.xml.
I would download a trial version of TextMate if you don’t have a license for it already.
TextMate is very nice with xml files

6. Open and inspect the file, you’ll notice many pairs of XML elements i.e.

Rejected

Rejected

ENUM_LABEL is the Lookup Name
ENUM_VALUE is the Lookup Value

Don’t know what the Lookup Name & Lookup Value is, look in the Java Administration GUI

You can add a new pair of XML elements, if you want to add value to the lookup just be sure no typos.

7. When you don’t having fun, remember to save the file.

8. Next run the following command to update the Lookup
sudo ./fcsvr_client setmd /enum/PA_ENUM_CUST_ASSET_STATUS –xml ~/Desktop/assetstatus_lookup.xml

Be sure to enter your password when prompted.

9. You need to log in an out of the FCSvr Java Gui to see the changes reflected against the lookup.

The command line client sometimes calls for “–linktype <id>”.  Here are all of the Link Type IDs as of v1.5.1:

0  = None

1  = Member (of Production)

2  = Primary Representation (Original Media)

3  = Representation

4  = Clip Proxy

5  = Thumbnail Proxy

6  = Frame Proxy

7  = Keyframe Proxy (Poster with alpha channel)

8 = Primary Representation Cache

9 = Backup Version

10 = Project Directory

11 = Modified XML

12 = Master Asset (for Element)

13 = Archived Representation

14 = Archive Modified XML

15 = Edit Proxy

16 = Production

Today Apple released Final Cut Server 1.5.2

For more information visit the following link

http://support.apple.com/kb/DL1034