Graphics

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

Matt (or anyone paying attention to this thread),

May I ask what version of XPression you are using where this works? I am trying to do the exact same thing you have provided a screen grab of, but it is breaking at the @text object@ macro. I have also tried a %datalinqkey% in that same spot with no success. If I type the referenced string in quotes it works fine, however. I am using XPression Designer v10.0 build 5275.

Thanks for posting,

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

Matt (or anyone paying attention to this thread),

May I ask what version of XPression you are using where this works? I am trying to do the exact same thing you have provided a screen grab of, but it is breaking at the @text object@ macro. I have also tried a %datalinqkey% in that same spot with no success. If I type the referenced string in quotes it works fine, however. I am using XPression Designer v10.0 build 5275.

Thanks for posting,

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

I am on version 11.5, but I believe I first started using this at version 10 or 10.5. 

I should've mentioned that "WHERE [JERSEY] =" section is referencing the column name of the player number. In my case, the Excel column is called "JERSEY". Yours may be different.

------------------------------
Matt Finlayson
Brigham Young University

Original Message:
Sent: 01-30-2024 11:37
From: J.R. Schulz
Subject: Referencing an Excel Row via a Column

Matt (or anyone paying attention to this thread),

May I ask what version of XPression you are using where this works? I am trying to do the exact same thing you have provided a screen grab of, but it is breaking at the @text object@ macro. I have also tried a %datalinqkey% in that same spot with no success. If I type the referenced string in quotes it works fine, however. I am using XPression Designer v10.0 build 5275.

Thanks for posting,

------------------------------
J.R. Schulz
Real-Time Graphics Developer
The E.W. Scripps Company

Original Message:
Sent: 01-30-2024 10:50
From: Matt Finlayson
Subject: Referencing an Excel Row via a Column

------------------------------
Matt Finlayson
Brigham Young University

Original Message:
Sent: 01-29-2024 12:07
From: John Spitznagel
Subject: Referencing an Excel Row via a Column

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

You should also consider your jersey number may be a string, not an integer so it needs to be in quotes. 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom

Original Message:
Sent: 01-30-2024 12:04
From: Matt Finlayson
Subject: Referencing an Excel Row via a Column

I am on version 11.5, but I believe I first started using this at version 10 or 10.5. 

I should've mentioned that "WHERE [JERSEY] =" section is referencing the column name of the player number. In my case, the Excel column is called "JERSEY". Yours may be different.

------------------------------
Matt Finlayson
Brigham Young University

Original Message:
Sent: 01-30-2024 11:37
From: J.R. Schulz
Subject: Referencing an Excel Row via a Column

Matt (or anyone paying attention to this thread),

May I ask what version of XPression you are using where this works? I am trying to do the exact same thing you have provided a screen grab of, but it is breaking at the @text object@ macro. I have also tried a %datalinqkey% in that same spot with no success. If I type the referenced string in quotes it works fine, however. I am using XPression Designer v10.0 build 5275.

Thanks for posting,

------------------------------
J.R. Schulz
Real-Time Graphics Developer
The E.W. Scripps Company

Original Message:
Sent: 01-30-2024 10:50
From: Matt Finlayson
Subject: Referencing an Excel Row via a Column

------------------------------
Matt Finlayson
Brigham Young University

Original Message:
Sent: 01-29-2024 12:07
From: John Spitznagel
Subject: Referencing an Excel Row via a Column

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

Thanks, Simon. The field I'm trying to access with a macro is also a string. Where would the quotes you've mentioned go in this scenario (in my 'Non-Working' example below, where @Area@ should yield the same result as 'United States')?

Not working:

Working:

------------------------------
J.R. Schulz
Real-Time Graphics Developer
The E.W. Scripps Company

Original Message:
Sent: 01-30-2024 12:05
From: Simon Redmile
Subject: Referencing an Excel Row via a Column

You should also consider your jersey number may be a string, not an integer so it needs to be in quotes. 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom

Original Message:
Sent: 01-30-2024 12:04
From: Matt Finlayson
Subject: Referencing an Excel Row via a Column

I am on version 11.5, but I believe I first started using this at version 10 or 10.5. 

I should've mentioned that "WHERE [JERSEY] =" section is referencing the column name of the player number. In my case, the Excel column is called "JERSEY". Yours may be different.

------------------------------
Matt Finlayson
Brigham Young University

Original Message:
Sent: 01-30-2024 11:37
From: J.R. Schulz
Subject: Referencing an Excel Row via a Column

Matt (or anyone paying attention to this thread),

May I ask what version of XPression you are using where this works? I am trying to do the exact same thing you have provided a screen grab of, but it is breaking at the @text object@ macro. I have also tried a %datalinqkey% in that same spot with no success. If I type the referenced string in quotes it works fine, however. I am using XPression Designer v10.0 build 5275.

Thanks for posting,

------------------------------
J.R. Schulz
Real-Time Graphics Developer
The E.W. Scripps Company

Original Message:
Sent: 01-30-2024 10:50
From: Matt Finlayson
Subject: Referencing an Excel Row via a Column

------------------------------
Matt Finlayson
Brigham Young University

Original Message:
Sent: 01-29-2024 12:07
From: John Spitznagel
Subject: Referencing an Excel Row via a Column

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

Thanks, Simon. The field I'm trying to access with a macro is also a string. Where would the quotes you've mentioned go in this scenario (in my 'Non-Working' example below, where @Area@ should yield the same result as 'United States')?

Not working:

Working:

------------------------------
J.R. Schulz
Real-Time Graphics Developer
The E.W. Scripps Company

Original Message:
Sent: 01-30-2024 12:05
From: Simon Redmile
Subject: Referencing an Excel Row via a Column

You should also consider your jersey number may be a string, not an integer so it needs to be in quotes. 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom

Original Message:
Sent: 01-30-2024 12:04
From: Matt Finlayson
Subject: Referencing an Excel Row via a Column

I am on version 11.5, but I believe I first started using this at version 10 or 10.5. 

I should've mentioned that "WHERE [JERSEY] =" section is referencing the column name of the player number. In my case, the Excel column is called "JERSEY". Yours may be different.

------------------------------
Matt Finlayson
Brigham Young University

Original Message:
Sent: 01-30-2024 11:37
From: J.R. Schulz
Subject: Referencing an Excel Row via a Column

Matt (or anyone paying attention to this thread),

May I ask what version of XPression you are using where this works? I am trying to do the exact same thing you have provided a screen grab of, but it is breaking at the @text object@ macro. I have also tried a %datalinqkey% in that same spot with no success. If I type the referenced string in quotes it works fine, however. I am using XPression Designer v10.0 build 5275.

Thanks for posting,

------------------------------
J.R. Schulz
Real-Time Graphics Developer
The E.W. Scripps Company

Original Message:
Sent: 01-30-2024 10:50
From: Matt Finlayson
Subject: Referencing an Excel Row via a Column

------------------------------
Matt Finlayson
Brigham Young University

Original Message:
Sent: 01-29-2024 12:07
From: John Spitznagel
Subject: Referencing an Excel Row via a Column

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

Thanks Matt! This worked perfectly. Appreciate the help!

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

I am now in good shape as well! Appreciate the help, fellas. Adding the quotation marks plus assigning the Name column to an additional Text Object seems to have done the trick. Hitting the browse button still makes it look like it's not working (that was throwing me off) but it is now passing the correct fields to the assigned column text object when I'm in sequencer mode. Thanks again. I'm a longtime Vizrt user and have really enjoyed my transition to XPression, btw.

Thanks Matt! This worked perfectly. Appreciate the help!

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------

Okay, so now I have it working without the additional text object. I think it was really just the quotation marks that were necessary for this to work. I'm also able to add more statements to the query with great success. Thanks again!

I am now in good shape as well! Appreciate the help, fellas. Adding the quotation marks plus assigning the Name column to an additional Text Object seems to have done the trick. Hitting the browse button still makes it look like it's not working (that was throwing me off) but it is now passing the correct fields to the assigned column text object when I'm in sequencer mode. Thanks again. I'm a longtime Vizrt user and have really enjoyed my transition to XPression, btw.

Thanks Matt! This worked perfectly. Appreciate the help!

I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.

------------------------------
John Spitznagel
Video Production Engineer
Elon University
------------------------------