logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
XML Data Source and Filtering
Options
Go to last post Go to first unread
Previous Topic Next Topic
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 53 time(s).
vmix data 2.PNG (204kb) downloaded 52 time(s).

You cannot view/download attachments. Try to login or register.
Back to top
WWW

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
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,209
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
your xml structure is not complete (Not well formed) as posted!
Back to top
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.
Back to top
WWW
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,209
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 955 time(s) in 790 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
Back to top
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
Back to top
WWW
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
Back to top
WWW
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,209
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 955 time(s) in 790 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 36 time(s).

You cannot view/download attachments. Try to login or register.
Back to top
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.
    		•
    Back to top
    WWW
    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,209
    Belgium
    Location: Belgium

    Thanks: 291 times
    Was thanked: 955 time(s) in 790 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}
    Back to top
    Users browsing this topic
    Guest (5)
    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.

    Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
    This page was generated in 0.175 seconds.