logo

Live Production Software Forums


Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
slxxi  
#1 Posted : Thursday, September 13, 2018 4:08:09 AM(UTC)
slxxi

Rank: Advanced Member

Groups: Registered
Joined: 8/15/2017(UTC)
Posts: 36
Location: Berlin

Was thanked: 1 time(s) in 1 post(s)
I have a lot of Titles with ~10 fields each, like firstname, lastname, etc.
Those Fields are filled by an XML File - Data Source that contain a lot of entries.
So the Column-Dropdown shows me firstname1,firstname2,firstname3,lastname1,lastname2,lastname3, etc.

I already mapped Title 1 to firstname1,lastname1,.. Title 2 to firstname2,lastname2, ... ,etc.

Now I want to Duplicate those existing Titles and map them to a different XML File with the same Layout.

So i duplicated the Titles via "Create Virtual Input".

On the new Titles I open the Title Editor -> Data Source and set the Data Source of firstname1 to XML to XML, then i go to lastname1 and set XML to XML2.
Works so far and shows the new Data.

I know that if I set the column to "Auto", there is the option to "Apply to all Fields in this Title".
But then my already correctly mapped Columns in every Field in this Title are also overwritten with Auto.

Do i have to set the Data Source of every single Field by hand or is there a way to Apply only the Data Source to every Field, without changin the Table, Column, Format?
doggy  
#2 Posted : Thursday, September 13, 2018 5:07:33 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,219
Belgium
Location: Belgium

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
Maybe i am missing it but isn't the point of using datasources NOT to have multiple "same" titles with different data but a single title with changing content based on the row selected in a datasource ?

If the title field name is the same as the collumn name in a datasource file auto works beautifully
slxxi  
#3 Posted : Thursday, September 13, 2018 7:33:24 AM(UTC)
slxxi

Rank: Advanced Member

Groups: Registered
Joined: 8/15/2017(UTC)
Posts: 36
Location: Berlin

Was thanked: 1 time(s) in 1 post(s)
I use vMix to display Sport Results on Live Events.
So there are multiple Rankings in different Categories displayed at the same Time.
Thats why I have to go with multiple Titles.

The Data is delivered by a third Party as an XML on a Webserver, so no way for me to edit the match the field names in the Source.
MartLeib  
#4 Posted : Thursday, September 13, 2018 8:33:48 AM(UTC)
MartLeib

Rank: Advanced Member

Groups: Registered
Joined: 2/23/2017(UTC)
Posts: 189
Estonia

Thanks: 1 times
Was thanked: 52 time(s) in 42 post(s)
slxxi wrote:
I use vMix to display Sport Results on Live Events.
So there are multiple Rankings in different Categories displayed at the same Time.
Thats why I have to go with multiple Titles.

The Data is delivered by a third Party as an XML on a Webserver, so no way for me to edit the match the field names in the Source.


In the scenario, when I have no control over the XML or incoming data, I use my own parser (on my own webserver) which outputs XML the way I need.
DWAM  
#5 Posted : Thursday, September 13, 2018 8:38:20 AM(UTC)
DWAM

Rank: Advanced Member

Groups: Registered
Joined: 3/20/2014(UTC)
Posts: 2,721
Man
France
Location: Bordeaux, France

Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
Quote:
no way for me to edit the match the field names in the Source.

It's still possible to make the destination field names match the source names, no?
doggy  
#6 Posted : Thursday, September 13, 2018 8:42:40 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,219
Belgium
Location: Belgium

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
DWAM wrote:
Quote:
no way for me to edit the match the field names in the Source.

It's still possible to make the destination field names match the source names, no?


yes if you change them in the title itself to match with your xml ones ;-)
slxxi  
#7 Posted : Thursday, September 13, 2018 5:30:05 PM(UTC)
slxxi

Rank: Advanced Member

Groups: Registered
Joined: 8/15/2017(UTC)
Posts: 36
Location: Berlin

Was thanked: 1 time(s) in 1 post(s)
Thank you for the suggestions, I changed the Setup and matched the titles to the xml ones.

But now I encounter something weird:

As soon as my "XML Path" has more then 10 entries it adds a dot to the field name.

firstname1,firstname2,firstname3,...

becomes firstname.1, firstname.2,firstname.3,...

So now i can't Automap again, because some titles have a Datasource with less then 10, and some have one with more then 10 Entries

Is this a Bug or am i missing something again?
UserPostedImage
UserPostedImage
abtaster  
#8 Posted : Monday, May 17, 2021 4:25:30 PM(UTC)
abtaster

Rank: Member

Groups: Registered
Joined: 2/19/2017(UTC)
Posts: 17

Same here. Have you found a solution for that?
doggy  
#9 Posted : Monday, May 17, 2021 4:41:39 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,219
Belgium
Location: Belgium

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: abtaster Go to Quoted Post
Same here. Have you found a solution for that?


Be more specific in your goal/issue please , thread is 3 years old !
abtaster  
#10 Posted : Monday, May 17, 2021 5:07:43 PM(UTC)
abtaster

Rank: Member

Groups: Registered
Joined: 2/19/2017(UTC)
Posts: 17

Screenshot.png (42kb) downloaded 0 time(s).Hi doggy,

I have an XML file with a lot of fields (attached) and a title where I have named the fields the same like in the xml. But Auto mapping does not work. So I thought, it might be the problem, that to the XML field names have all an additional ".1".

My problem is, that every second field in my XML file gives me a rating (good, bad, equal) of the field before. I would like to use these fields to display an image but in the title editor all text fields are arranged first, so the manual maping of the first field and click on "apply to all" doesn't work.

Quote:

<?xml version='1.0' encoding='ISO-8859-1'?>
<Document>
<GameStats>
<stats>
<Q1HG>1</Q1HG>
<Q1HGG>1</Q1HGG>
<Q1HSOG>0</Q1HSOG>
<Q1HSOGG>0</Q1HSOGG>
<Q1HCE>0</Q1HCE>
<Q1HCEG>0</Q1HCEG>
<Q1HPC>1/1</Q1HPC>
<Q1HPCG>1</Q1HPCG>
<Q1HLC>0</Q1HLC>
<Q1HLCG>0</Q1HLCG>
<Q1HPS>0/0</Q1HPS>
<Q1HPSG>0</Q1HPSG>
<Q1HGC>0</Q1HGC>
<Q1HYC>0</Q1HYC>
<Q1HRC>0</Q1HRC>
<Q1AG>0</Q1AG>
<Q1AGG>2</Q1AGG>
<Q1ASOG>0</Q1ASOG>
<Q1ASOGG>0</Q1ASOGG>
<Q1ACE>0</Q1ACE>
<Q1ACEG>0</Q1ACEG>
<Q1APC>0/0</Q1APC>
<Q1APCG>2</Q1APCG>
<Q1ALC>0</Q1ALC>
<Q1ALCG>0</Q1ALCG>
<Q1APS>0/0</Q1APS>
<Q1APSG>0</Q1APSG>
<Q1AGC>1</Q1AGC>
<Q1AYC>0</Q1AYC>
<Q1ARC>0</Q1ARC>
<Q2HG>0</Q2HG>
<Q2HGG>0</Q2HGG>
<Q2HSOG>0</Q2HSOG>
<Q2HSOGG>0</Q2HSOGG>
<Q2HCE>0</Q2HCE>
<Q2HCEG>0</Q2HCEG>
<Q2HPC>0/0</Q2HPC>
<Q2HPCG>0</Q2HPCG>
<Q2HLC>0</Q2HLC>
<Q2HLCG>0</Q2HLCG>
<Q2HPS>0/0</Q2HPS>
<Q2HPSG>0</Q2HPSG>
<Q2HGC>0</Q2HGC>
<Q2HYC>0</Q2HYC>
<Q2HRC>0</Q2HRC>
<Q2AG>0</Q2AG>
<Q2AGG>0</Q2AGG>
<Q2ASOG>0</Q2ASOG>
<Q2ASOGG>0</Q2ASOGG>
<Q2ACE>0</Q2ACE>
<Q2ACEG>0</Q2ACEG>
<Q2APC>0/0</Q2APC>
<Q2APCG>0</Q2APCG>
<Q2ALC>0</Q2ALC>
<Q2ALCG>0</Q2ALCG>
<Q2APS>0/0</Q2APS>
<Q2APSG>0</Q2APSG>
<Q2AGC>0</Q2AGC>
<Q2AYC>0</Q2AYC>
<Q2ARC>0</Q2ARC>
<Q3HG>0</Q3HG>
<Q3HGG>0</Q3HGG>
<Q3HSOG>0</Q3HSOG>
<Q3HSOGG>0</Q3HSOGG>
<Q3HCE>0</Q3HCE>
<Q3HCEG>0</Q3HCEG>
<Q3HPC>0/0</Q3HPC>
<Q3HPCG>0</Q3HPCG>
<Q3HLC>0</Q3HLC>
<Q3HLCG>0</Q3HLCG>
<Q3HPS>0/0</Q3HPS>
<Q3HPSG>0</Q3HPSG>
<Q3HGC>0</Q3HGC>
<Q3HYC>0</Q3HYC>
<Q3HRC>0</Q3HRC>
<Q3AG>0</Q3AG>
<Q3AGG>0</Q3AGG>
<Q3ASOG>0</Q3ASOG>
<Q3ASOGG>0</Q3ASOGG>
<Q3ACE>0</Q3ACE>
<Q3ACEG>0</Q3ACEG>
<Q3APC>0/0</Q3APC>
<Q3APCG>0</Q3APCG>
<Q3ALC>0</Q3ALC>
<Q3ALCG>0</Q3ALCG>
<Q3APS>0/0</Q3APS>
<Q3APSG>0</Q3APSG>
<Q3AGC>0</Q3AGC>
<Q3AYC>0</Q3AYC>
<Q3ARC>0</Q3ARC>
<Q4HG>0</Q4HG>
<Q4HGG>0</Q4HGG>
<Q4HSOG>0</Q4HSOG>
<Q4HSOGG>0</Q4HSOGG>
<Q4HCE>0</Q4HCE>
<Q4HCEG>0</Q4HCEG>
<Q4HPC>0/0</Q4HPC>
<Q4HPCG>0</Q4HPCG>
<Q4HLC>0</Q4HLC>
<Q4HLCG>0</Q4HLCG>
<Q4HPS>0/0</Q4HPS>
<Q4HPSG>0</Q4HPSG>
<Q4HGC>0</Q4HGC>
<Q4HYC>0</Q4HYC>
<Q4HRC>0</Q4HRC>
<Q4AG>0</Q4AG>
<Q4AGG>0</Q4AGG>
<Q4ASOG>0</Q4ASOG>
<Q4ASOGG>0</Q4ASOGG>
<Q4ACE>0</Q4ACE>
<Q4ACEG>0</Q4ACEG>
<Q4APC>0/0</Q4APC>
<Q4APCG>0</Q4APCG>
<Q4ALC>0</Q4ALC>
<Q4ALCG>0</Q4ALCG>
<Q4APS>0/0</Q4APS>
<Q4APSG>0</Q4APSG>
<Q4AGC>0</Q4AGC>
<Q4AYC>0</Q4AYC>
<Q4ARC>0</Q4ARC>
<GHG>1</GHG>
<GHGG>1</GHGG>
<GHSOG>0</GHSOG>
<GHSOGG>0</GHSOGG>
<GHCE>0</GHCE>
<GHCEG>0</GHCEG>
<GHPC>1/1</GHPC>
<GHPCG>1</GHPCG>
<GHLC>0</GHLC>
<GHLCG>0</GHLCG>
<GHPS>0/0</GHPS>
<GHPSG>0</GHPSG>
<GHGC>0</GHGC>
<GHYC>0</GHYC>
<GHRC>0</GHRC>
<GAG>0</GAG>
<GAGG>2</GAGG>
<GASOG>0</GASOG>
<GASOGG>0</GASOGG>
<GACE>0</GACE>
<GACEG>0</GACEG>
<GAPC>0/0</GAPC>
<GAPCG>2</GAPCG>
<GALC>0</GALC>
<GALCG>0</GALCG>
<GAPS>0/0</GAPS>
<GAPSG>0</GAPSG>
<GAGC>1</GAGC>
<GAYC>0</GAYC>
<GARC>0</GARC>
</stats>
</GameStats>
</Document>
doggy  
#11 Posted : Monday, May 17, 2021 6:11:09 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,219
Belgium
Location: Belgium

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: abtaster Go to Quoted Post

I have an XML file with a lot of fields (attached) and a title where I have named the fields the same like in the xml. But Auto mapping does not work. So I thought, it might be the problem, that to the XML field names have all an additional ".1".

My problem is, that every second field in my XML file gives me a rating (good, bad, equal) of the field before. I would like to use these fields to display an image but in the title editor all text fields are arranged first, so the manual maping of the first field and click on "apply to all" doesn't work.



Most answer have been given in your post in the GT title section!

I assume you want all the data rows displayed in one title (hence the convert to row) . Alternatively one can now also select which row to display in a title without converting to row

it's not a good idea to try things out with such big data source to figure out your best approach

Auto mapping is based on the column names being equal to the ones in the title. ( hence the data source needs to have that being specified also , your xml does not have that, it's not really a table and why even bother converting rows to columns as it is only columns to start with, you have no rows!)

For images you have to add the location and file extension to the formatting in the titel datasource editor

There is a slight caveat however when applying to all fields that the formatting will be used for ALL items too and these are different for the text and the images.
If there is no need for regular updating one can do all for the images first with their specific formatting , and then the text with the standard formatting ( 2 steps instead of one)

Personally if all names are sequentially numbered anyways if would go for a script that would loop through them and select and place the items in appropriate places

Lot depends how frequently everything has to be used and updated

But i also would start with restructuring my data source xml ( if possible)

Then again i have no idea what it (title) is supposed to look like
abtaster  
#12 Posted : Monday, May 17, 2021 9:50:39 PM(UTC)
abtaster

Rank: Member

Groups: Registered
Joined: 2/19/2017(UTC)
Posts: 17

I corrected the fieldnames by .1 in the overlay and know it is working perfectly.

Thanks for your help!
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.