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 54 time(s). vmix data 2.PNG (204kb) downloaded 53 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,243 Location: Belgium Thanks: 294 times Was thanked: 960 time(s) in 794 post(s)
|
your xml structure is not complete (Not well formed) as posted!
|
|
|
|
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.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,243 Location: Belgium Thanks: 294 times Was thanked: 960 time(s) in 794 post(s)
|
|
1 user thanked doggy for this useful post.
|
|
|
Rank: Newbie
Groups: Registered
Joined: 7/4/2018(UTC) Posts: 5 Location: Nigeria
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 7/4/2018(UTC) Posts: 5 Location: Nigeria
|
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
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,243 Location: Belgium Thanks: 294 times Was thanked: 960 time(s) in 794 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.
|
|
|
|
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 22 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,243 Location: Belgium Thanks: 294 times Was thanked: 960 time(s) in 794 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}
|
|
|
|
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.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close