PostgreSQL viewing/administration

I'm not sure if this answers any questions for this post, but here is some info on the XML. If you configure FCS to output an XML file, it will show you the exact format that you need to use to format your XML files to be read in by FCS. So, here is what it looks like:

<?xml version="1.0"?>
<FinalCutServer>
<getMdReply>
*<entity entityType="asset" entityId="/asset/1046">*
<metadata>
<mdValue fieldName="Location" dataType="string">Orlando, Florida</mdValue>
</metadata>
</entity>
</getMdReply>
</FinalCutServer>



To be able to read in XML data, however, you need to know the specific ID number of the asset and/or production that you are working with. That's under the EntityID line. Most likely, you will need to run a script or command search to find the production or asset that you want to work with and then have that script write out an xml file using this format.

Keep in mind that the format above is an outputted XML file. For the bolded parts of the code, you will need to change it to the following to format an input XML data file:

<request reqId="setMd" entityId = "/asset/153">
<params>

Make sure your closeout tags correspond to those as well. You can have as many mdValue tags as you want - but they all have to correspond to fields in FCS.

To integrate with Ruby, PHP, or CGI for a web interface, I'm thinking that you'd need to either parse out this file using a program, or I'm sure there is an easier way to get around it. I know there are a wide range of command-line programs built into FCS that will output this data without having to parse out an XML file. The getMd command is available from the command line thought the unix FCS client, where the return is simply the value of the field you are looking for (much easier to work with). I'm really hoping that Apple comes out with some docs on this. I'm going to keep an eye on the developer site.

I just realized how confusing that read, so let me clarify about the input file. It would need to be formatted this way:

<?xml version="1.0"?>
<FinalCutServer>
<request reqId="setMd" entityId = "/asset/153">
<params>
<mdValue fieldName="Location" dataType="string">Orlando, Florida</mdValue>
</params>
</request>
</FinalCutServer>

If I can find the specific commands for finding assets or productions based on certain criteria, I'll post here.

Hi, you can connect using this information:
-port 5433
-user postgres, password is blank
-database px
It works only on localhost, I'm using Navicat for PostgreSQL.

right on... database is here...

/var/db/finalcutserver

my 2 cents

The easiest way to build a web front-end to your PostgreSQL database is to use a tool like Servoy: http://www.servoy.com

Servoy will let you connect to any SQL database with a JDBC driver, which PostgreSQL has, and build AJAX web-based or java-base front ends with a simple WYSIWYG environment. And of course, it will run on Mac 🙂

Wow, thanks for the information.

here is my contribution.

you can connect to the postgresSQL remotely using Navicats SSH Tunneling.
-Enable Remote Access on the FCS
-On Navicat use "Localhost" as the host on the General tab, then configure SSH Tunneling.

Now to locate the Metadata Table.


---
Ted Simbajon

Which table are the metadata located?

Yikes!!!

How exactly did you connect remotely? I have a FCS running, but no client. I saw no way to "enable remote access" in FCS. How did you configure SSH tunneling?

Thanks!

Not "IN" FCS but "ON" the FCS.
Go into sharing prefs and turn it on.

bustback wrote:
Where is the documentation on importing/exporting XML definitions of assets in Final Cut Server?

I have to web-enable the Final Cut Server installation and am looking for resources on how I might go about this. I think there was a ruby/php driven web interface that was demoed at NAB but that it's currently unavailable and is an internal Apple project (why would that be... Artbox had some of those capabilities already?!).

Anyway, if anyone can point me in the right direction I'd appreciate it. There's no documentation on the low level capabilities of Final Cut Server (command-line, XML handling, etc.).

cheers,

jon

You can download the Rails app that Apple demoed at NAB2008 here. The documentation accompanying it has complete XML specs for the outgoing and incoming XML.

I'm still confused. There is nothing in my System Preferences for FCS. Inside of preferences for FCS while using the client I find nothing related to sharing and there is nothing on the general FCS icon on the "Other" category of Sys Prefs.

What am I missing? I'm not running Serverm but regular OS X.

Thanks!

This is a SYSTEM option, not FCS.

1. got to "System Prefs"
2. click on "Sharing"
3. select "Remote Login"

Configure SSH for user that has admin rights for FCS.

First of all, thank you so much for your help with this.

I have configured the remote login in Sys prefs and can see that ssh is turned on. However, I keep getting a "SSH Tunnel: 2 Conenct failed, Connection Refused" error trying to connect. Any ideas? I'm putting in the right IP, username and password.

I can use Putty and can log in to the machine no problem. Navicat is giving me fits though!