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
sequence5  
#1 Posted : Wednesday, July 4, 2018 9:51:21 AM(UTC)
sequence5

Rank: Newbie

Groups: Registered
Joined: 7/4/2018(UTC)
Posts: 5
Location: Nigeria

Hello... i have an issue with my xml data.
i have added it using the data source manager. i can grab some fields easily but need to filter a certain field just to grab only one info from it. Anybody with an idea to fix this pls.

Sample of my XML structure
Code:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<Site>
	<Cinema_strCode>001</Cinema_strCode>
	<Cinema_strName>My circuit group</Cinema_strName>
	<Cinema_strAddress1></Cinema_strAddress1>
	<Cinema_strAddress2></Cinema_strAddress2>
	<Cinema_strAddress3></Cinema_strAddress3>
	<Cinema_strAddress4></Cinema_strAddress4>
	<Cinema_decLatitude>0.000000000000000e+000</Cinema_decLatitude><Cinema_decLongitude>0.000000000000000e+000</Cinema_decLongitude>
	<Operator>
		<CinOperator_strName>site A</CinOperator_strName>
			<Film>
				<Film_strCode>HO00000094</Film_strCode>
				<Film_strTitle>Deadpool 2</Film_strTitle>
				<Film_strOriginalAudio></Film_strOriginalAudio>
				<Sessions>
					<Session>
						<Session_lngSessionId>4913</Session_lngSessionId>
						<Session_strStatus>O</Session_strStatus>
						<Screen_strNum>2</Screen_strNum>
						<Screen_intRemoteSalesCutoff>0</Screen_intRemoteSalesCutoff>
						<Session_intSeatsAvail>65</Session_intSeatsAvail>
						<Session_dtmShowing>2018-07-03T13:00:00</Session_dtmShowing>
						<Session_dtmFeature>2018-07-03T13:20:00</Session_dtmFeature>
						<Session_dtmBusinessDate>2018-07-03T00:00:00</Session_dtmBusinessDate>
						<Session_strSalesChannels>|IVR|CALL|GSALE|WWW|KIOSK|CELL|PDA|POSBK|POS|RSP|</Session_strSalesChannels>
						<Session_strAttributes>2D,Premium,Signature</Session_strAttributes>
						<SType_strDescription>Normal Session</SType_strDescription>
						<Session_strAudioLanguage></Session_strAudioLanguage>
						<Session_strSubtitleLanguage></Session_strSubtitleLanguage>
						<Event_strCode></Event_strCode>
						<Session_strSneakPreviewFlag>N</Session_strSneakPreviewFlag>
						<Session_lngHOMarathonId>0</Session_lngHOMarathonId>
						<Session_lngPlaythruGroupId>0</Session_lngPlaythruGroupId>
					</Session>
					<Session>
						<Session_lngSessionId>4875</Session_lngSessionId>
						<Session_strStatus>O</Session_strStatus>
						<Screen_strNum>1</Screen_strNum>
						<Screen_intRemoteSalesCutoff>0</Screen_intRemoteSalesCutoff>
						<Session_intSeatsAvail>67</Session_intSeatsAvail>
						[color=red]<Session_dtmShowing>2018-07-03T15:20:00</Session_dtmShowing>[/color]
						<Session_dtmFeature>2018-07-03T15:40:00</Session_dtmFeature>
						<Session_dtmBusinessDate>2018-07-03T00:00:00</Session_dtmBusinessDate>
						<Session_strSalesChannels>|IVR|CALL|GSALE|WWW|KIOSK|CELL|PDA|POSBK|POS|RSP|</Session_strSalesChannels>
						<Session_strAttributes>2D,Premium,Signature</Session_strAttributes>
						<SType_strDescription>Normal Session</SType_strDescription>
						<Session_strAudioLanguage>
						</Session_strAudioLanguage>
						<Session_strSubtitleLanguage>
						</Session_strSubtitleLanguage>
						<Event_strCode></Event_strCode>
						<Session_strSneakPreviewFlag>N</Session_strSneakPreviewFlag>
						<Session_lngHOMarathonId>0</Session_lngHOMarathonId>
						<Session_lngPlaythruGroupId>0</Session_lngPlaythruGroupId>
					</Session>
				</Sessions>
			</Film>


I have been able to grab other info but i am not able to grab only the line in red colour [<Session_dtmShowing>2018-07-03T15:20:00</Session_dtmShowing>]

sequence5 attached the following image(s):
vmix data.PNG (33kb) downloaded 52 time(s).
vmix data 2.PNG (204kb) downloaded 51 time(s).

You cannot view/download attachments. Try to login or register.
doggy  
#2 Posted : Wednesday, July 4, 2018 10:07:50 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 283 times
Was thanked: 916 time(s) in 755 post(s)
your xml structure is not complete (Not well formed) as posted!
sequence5  
#3 Posted : Wednesday, July 4, 2018 10:10:17 AM(UTC)
sequence5

Rank: Newbie

Groups: Registered
Joined: 7/4/2018(UTC)
Posts: 5
Location: Nigeria

@doggy
that is the structure that the XML is delivered to me.
doggy  
#4 Posted : Wednesday, July 4, 2018 10:23:10 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 283 times
Was thanked: 916 time(s) in 755 post(s)
there are no closing tags like for Site , operator or what else that might be missing in the xml you posted

anyway here is a nice little tool to figure out your xpaths :-)

http://xmltoolbox.appspot.com/xpath_generator.html
thanks 1 user thanked doggy for this useful post.
corporatejames on 7/7/2018(UTC)
sequence5  
#5 Posted : Wednesday, July 4, 2018 10:27:16 AM(UTC)
sequence5

Rank: Newbie

Groups: Registered
Joined: 7/4/2018(UTC)
Posts: 5
Location: Nigeria

doggy wrote:
there are no closing tags like for Site , operator or what else that might be missing in the xml you posted

anyway here is a nice little tool to figure out your xpaths :-)

http://xmltoolbox.appspot.com/xpath_generator.html


while i try this, this is the url to one of the XML http://filmhouseit.com/t...a/VistaSessionslekki.xml
i just want to be able to grab an element in session as description while grabbing the title as header in Vmix

thanks
sequence5  
#6 Posted : Wednesday, July 4, 2018 10:35:30 AM(UTC)
sequence5

Rank: Newbie

Groups: Registered
Joined: 7/4/2018(UTC)
Posts: 5
Location: Nigeria

sequence5 wrote:
doggy wrote:
there are no closing tags like for Site , operator or what else that might be missing in the xml you posted

anyway here is a nice little tool to figure out your xpaths :-)

http://xmltoolbox.appspot.com/xpath_generator.html


while i try this, this is the url to one of the XML http://filmhouseit.com/t...a/VistaSessionslekki.xml
i just want to be able to grab an element in session as description while grabbing the title as header in Vmix

thanks


i have tried to use the xpath from the site (/Site/Operator/Film/Sessions/Session[1]/Session_dtmFeature) but still had every information in that path populated.
could it be that Vmix does not currently support filtering content from an XML
doggy  
#7 Posted : Wednesday, July 4, 2018 10:52:20 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 283 times
Was thanked: 916 time(s) in 755 post(s)
Not an expert but there seems to be a little issue here

testing with http://xmlgrid.net/xpath.html the result is
Quote:

2018-07-03T13:20:00


while vMix gives you 5 results indeed

doggy attached the following image(s):
filmxml.JPG (56kb) downloaded 35 time(s).

You cannot view/download attachments. Try to login or register.
sequence5  
#8 Posted : Wednesday, July 4, 2018 11:08:45 AM(UTC)
sequence5

Rank: Newbie

Groups: Registered
Joined: 7/4/2018(UTC)
Posts: 5
Location: Nigeria

doggy wrote:
Not an expert but there seems to be a little issue here

testing with http://xmlgrid.net/xpath.html the result is
Quote:

2018-07-03T13:20:00


while vMix gives you 5 results indeed



if i use xpath to hit the playing times directly, i will not be able to map it with its Film_strTitle. so i used /Site/Operator/Film
  • to grab everything under each Film. i thought i will be able to filter the times from format like the image
    sequence5 attached the following image(s):
    vmix data 2.PNG (154kb) downloaded 21 time(s).

    You cannot view/download attachments. Try to login or register.
  • doggy  
    #9 Posted : Wednesday, July 4, 2018 11:54:47 AM(UTC)
    doggy

    Rank: Advanced Member

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

    Thanks: 283 times
    Was thanked: 916 time(s) in 755 post(s)
    maybe open the xml twice?
    Data in a title is not restricted to one datasource table only

    watch out your formatting ! usually just {0}
    Users browsing this topic
    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.