Graphics

I set up my lower thirds to an excel workbook and want to be able to type in the jersey number to pull up there information. I set up the datalinq key correctly but it only lets me link to the row value. I have jersey numbers that aren't for instance (1-20) there are numbers that skip (2,5,6,8) so when I put the value of 4 it gives me jersey number 8 anyway I can work this out?

Datalinq keys pull by row, not by number so when you make your datalinq key 1, it looks up row 1 in excel. If you make your datalinq key 22, it looks up row 22, not number 22. The easiest way to fix this is to just format your excel sheet to have numbers ranging from 1-99 and only populate the rows that correspond to the jerseys you want
#XPression

If your sport allows the numbers 0 and 00 (looking at you basketball), then things get a little messier.
#XPression

It can be even easier than this.
As long as you're data is formatted properly, you can set the row to your datalinq key (%jerseynumber%) for example.
For this to work, you have to have a column in your data with the jersey number. So instead of having blank rows in your table, you will only have the exact number of players and it won't matter which row they're in.
Your datalinq will look in the "NO" column instead of the true table column.
This should also work for 0 and 00 players.

Edit: Also attached the Datalinq setup...
Table reads: SELECT [NAME] FROM [ROSTER] WHERE [NO] = %jerseynumber%
Might take some playing around to make this work properly though.
#XPression

Very nice, but wouldn't this make it more difficult to call up take ids based off jersey numbers? I don't think it'd work for duplicate jersey numbers either.
#XPression

@plantassassin - I dont understand why people make X-number of scenes with take-IDs to have one for each player.
All your nameplates etc should look the same regardless of what player it is. If you should change one detail, you would have to change all X-number of IDs.

Make one scene, one take-ID and replace the text elements and/or images to reflect the player info with DataLinq...
#XPression

A lot of it comes down to workflow. Many folks want to be able to call up specific graphics for specific players based solely on take id. They know that 30XX are away bios and 40XX are home bios. The producer calls for the bio for #17 red and all they have to do is type 3017[enter], and it's on air. No stopping to find the jersey field to swap out players. Per-player customization are easy as well. Is #17 doing great at the free throw line? Swap out rebounds for free throws on his 3-stat.

You are correct that consistency is important, but that's easy to handle. Make the first graphic how you want it, add %relid% where appropriate and duplicate it 98 times.

Making one scene and swapping out data is something I would do if I had another program controlling Xpression (as in the case of a bug box), or if I was using Dashboard. Even then, since you can't datalinq in a key field (without scripting), it can get a bit messy.
#XPression

"Edit: Also attached the Datalinq setup...
Table reads: SELECT [NAME] FROM [ROSTER] WHERE [NO] = %jerseynumber%
Might take some playing around to make this work properly though."

I know this is 2 years old.. but can you explain WHERE you put this in?

and what do the [ ] correspond to?... I have a tab delimited file that has data at increments of 10.  that Data is lablelled "Page #"

I want to use %Page #% as my reference but it's just pulling up the exact row numbers at the moment.

#XPression

Hi Teresa, sorry for the slow response. I see the new forum didn't transfer my image attachment.

The value goes in the Datalinq like this:

#XPression

You can actually take this a step further if you have Xpression v9 or above now...

When you set the DataLinq Properties, the window has changed slightly now, and you have a few more information fields and a few more options.

Specifically the support of the @TextObject@ macro and the "Requery scene datalinqs on data change" option.
Now, the solution above explained by Wes works perfectly for anyone working from Xpression and using the sequencer like that.

However, in my case I'm trying to get this as efficient as possible from a simplified user interface, and then DashBoard comes into mind quite easily. I also try to make as many "templates" as possible, leaving out the need for several, if not hundreds of entries in the sequencer.

Using the examples from above, and combining them with DashBoard and data from the DashBoard, you can in theory make one template with just one entry in the sequencer, and then have a scene where you show all the information from an Excel sheet (ADODB style), but you can choose the player with a single jersey entry parameter in DashBoard, and you can have the entire scene populate with the correct information.
Information that can, in theory, be worked on by a third party live as you call data from it.

It will get the row data based on what jersey number is picked, and the jersey number is set in DashBoard.
Here is where you check the "Re-query scene datalinqs on change", meaning every time the jersey number changes from DashBoard, the other data is also re-queried from the Excel sheet.
Voila, you've just married two DataLinq sources in one and you can finally pick the player jersey and corresponding collumns in Excel through DashBoard.
So finally, you can do what Grenier said was messy two years ago (and it really was back then).

#XPression

We're at 8 at the moment.. but I'll tag this for when we upgrade.  Meanwhile.

Wes.. thanks for the update.  I'll give that a try.  that was very helpful...

#XPression

SELECT [NAME] FROM [ROSTER] WHERE [NO] = %jerseynumber%

Sorry.. still not there.  are all of these [ ] columns?

Here are my columns.  I want to use "Page #" as the reference and my records are in 10 unit increments mainly.  I have over 10 text boxes or graphics being filled.  the file is named "Member"

Page #

Title

Line

Fr Title

full name

Party

EnFr-1pg

En-1pg

divider line

Fr-1pg

EnMin1-2pg

FrMin1-2Pg

Board

10

Hon.

_

L'hon.

Bill Walker

PC

Associate Minister of Energy

_____

Ministre associé de l’Énergie

F:\42nd Legislature\Images\Name Templates\PC Banner.png

30

Hon.

_

L'hon.

Todd Smith

PC

Minister of Children, Community and Social Services

Ministre des Services à l’enfance et des Services sociaux et communautaires

F:\42nd Legislature\Images\Name Templates\PC Banner.png

40

Hon.

_

L'hon.

Lisa M. Thompson

PC

Minister of Government and Consumer Services

Ministre des Services gouvernementaux et des Services aux consommateurs

F:\42nd Legislature\Images\Name Templates\PC Banner.png

50

Hon.

_

L'hon.

Peter Bethlenfalvy

PC

President of the Treasury Board

_____

Président du Conseil du Trésor

F:\42nd Legislature\Images\Name Templates\PC Banner.png

#XPression

Hi again Teresa!

Take a look here: https://www.rossvideo.com/gallery/xpression-u/setting-up-microsoft-excel-to-work-with-xpression-datalinq/

This video explains how the excel sheets are set up, with what collumns and how to set it up as an ADODB link in DataLinq. :)

#XPression

Thanks Aleksander.. I've got that part.. it's the part where I can have increments of 10 that I don't get using the formula that Wes used.

#XPression

Aleksander here's where I need help... in Wes's example.

SELECT [NAME] FROM [ROSTER] WHERE [NO] = %jerseynumber%

I get that [Name] is referring to the colum we are pulling from and I would change that for each field that is referring to a column.

and Where [NO] is the number I put into the "Keys value" area

WHERE [No]=%Page #%  in my case.

What I don't understand is what does [roster] refer to? on Wes's example or what [Players] refers to in yours.

 

#XPression

"ROSTER" or "PLAYER" refers to the actual table it will pull data from in the ADODB scheme.
Hence why I linked you the video. It is the area he marks and names "ROSTER" for selection.

You can have several selections/tables in one Excel sheet, and each of these can be addressed in the DataLinq, so you can pull from "ROSTER" or "PLAYERS" or "NATIONALITY" or what not that you define as a selection in Excel first.

Or to translate the query:
"Select the name of the player from the table roster, where the number of that player is the same as the value in %jerseynumber".

#XPression

that may be part of my issue then... we haven't figured out how to use an excel file yet.   I've been unable to connect properly so I'm using a tab delimited file.  but I appreciate the update

#XPression

Again... Watch the video, and try a smaller version. From there on out it's just about organizing data and using the excel sheet for what it's worth.

#XPression

Ok..I think I have my issue.. .maybe.  You and wes are actually USING the jersey numbers in your graphics.. and then it loads the rest of the data.. is that correct?

In my case the number I'm using is only referencing the row number.  It doesn't appear in a text object anywhere on the page.

Because I have the excel link working.  and I can pick that selection Roster in your case MXP in mine. Oh well.. time to pick the ditch to die in... this isn't it... 

I'll just have to go back to having blank entires to separate my data.

I appreciate all the help though. 

 

#XPression

Sorry to bump an old thread, but if you haven't done it yet, Teresa, you could add an invisible text field to your template and link that to the jersey field and call the player based on that...I think? I'm very interested in this number-based approach over the giant long list in XPression, although I do see advantages for all of them! I am going to do some playing around with this in the future!

#XPression

So, I've had some people ask me about this one.
I figured I'd give it a go making something of a video tutorial about this...

I assume you allready know how to set up DataLinq and Xpression, and how to create a generic lower third with name, number and statistics.

Anyways, here you go:
https://youtu.be/l8_MvBwhI3E 

(English is not my first language, but I think I make myself understood).

#XPression

I'm working on something right now and the discovery of textobject macro sounds amazing. When testing though, I found the data updates to not be nearly as responsive as I would like.

Was very happy to find this thread and see that 'Requery scene datalinqs on data change' checkbox; but I don't see it in any of my XPression installs!

 

I've checked Designer 9.0 (build 4842), Graphite Studio 9.5 (4934) and Prime 9.0 (4849).

Any thoughts on this?
Getting these @TextObject@ working would be a game changer.

Appreciate any help! Thanks!

#XPression

It seems that the option is not available when we are using it through a visual logic "datalinq" bloc , but is present when configuring data source from object inspector panel.

 

@Aleksander : your english is very good , thank you for the video tutorial .

#XPression

Aah, that seems right.

I wonder why it's only available the one way..

Kind of disappointing, but might be a worthy concession for the benefits.

Thanks <x-zendesk-user data-user-name="Mignon Antoine">372662221712</x-zendesk-user>!

#XPression