Graphics

Hi,

I'm attempting to make lower thirds in the sequencer using templates that call for data using Data Linq. If I pull the player names they come out as Last, First - Is there a script or a way in Xpression to flip the first and last and remove the comma? http://ppl.ug/ictXVh-3FQM/

Here are example OnSetText scripts that would flip the names around if it finds a comma in the name.

This is designed as two separate scripts to populate a firstname text object and a last name text object. If you want it all in one text box you'll need to combine the scripts and concatenate the results together.

First name OnSetText:

`dim list(3) as string

'Check for a comma

if( InStr(text,",") > 0) then

list = split(text,",",2)

text = ltrim(list(1))

else

list = split(text," ",2)

text = ltrim(list(0))

end if

`

LastName OnSetText:

`dim list(3) as string

'Check for a comma

if( InStr(text,",") > 0) then

list = split(text,",",2)

text = ltrim(list(0))

else

list = split(text," ",2)

text = ltrim(list(1))

end if

`

#XPression

Nick,

How are you pulling the data? I have tried adding a network location where the xml file lives on the FTP and it does not seem to update.

#XPression

Nick & Jeff-

We just conquered this task last week and are still testing with StatCrew. We had the StatCrew computer upload to our FTP site off campus, then set a network location on the XPression to that FTP Site to pull the data. It does seem to auto update, but I know that our athletic department did have an issue with StatCrew doing a consistent file upload. We are doing final tests tomorrow.

I've also heard you can buy an Amazon FTP Service which may be a little more stable.

#XPression

Is the statcrew machine on the same network as XPression? You could try just running the datalinq server application directly on the statcrew machine. XPression can connect to the datalinq server over the network and the datalinq server would pull the files from it's local machine using the XML datalinq plugin.

#XPression

Jeff, we downloaded a free piece of software called "FullSync" which will keep the local files on the XPression desktop in sync with the files uploaded to the FTP Site. You can set the sync intervals to a little as 1 second, and it will put the file on the desktop. We've tested it and it seems to work pretty well. Here's the link:

http://sourceforge.net/projects/fullsync/

Mike Forbes

Middle Tennessee State University, Murfreesboro, TN

#XPression

Mike,

I used this last weekend and it seemed to work pretty good. The only thing I did differently was ran Full Sync on my Utility PC and synced to a network drive. It does not auto update, but it updates quick enough.
#XPression

Hi Brian,

Hoping you can help out. Can you shed a little more light on the script you posted above? I'm not super familiar with how to setup scripts and I think I'm missing some steps to make it work. 

When I assign that script event to the the text box i get a number of error messages.

Thoughts?

thanks for any help you can provide

a

#XPression