logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
XML on data sources
Options
Go to last post Go to first unread
Previous Topic Next Topic
davidcallahan  
#1 Posted : Friday, March 6, 2020 11:50:29 PM(UTC)
davidcallahan

Rank: Advanced Member

Groups: Registered
Joined: 1/22/2020(UTC)
Posts: 47
France
Location: Montpellier

Thanks: 14 times
Was thanked: 2 time(s) in 2 post(s)
Hi everyone !
I'm currently trying to use XML to fetch a lot of datas, but I'm unable to see multiple rows when importing my file.
Here's the code :
Code:
<?xml version="1.0" encoding="UTF-8"?>

<results>

  <city>
    <name>Paris</name>
    <namecitizen1>Person 1</namecitizen1>
    <namecitizen2>Person 2</namecitizen2>
    <result1>12</result1>
    <result2>8</result2>
</city>
  <city>
    <name>Toulouse</name>
    <namecitizen1>Person 1</namecitizen1>
    <namecitizen2>Person 2</namecitizen2>
    <result1>12</result1>
    <result2>8</result2>
</city>
</results>


And here is the result : UserPostedImage

But I need each city to be a row. How can I achieve that ?
I tried with JSON also and wasn't able to have multiple rows as well.

Thanks a lot,

David
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
MartLeib  
#2 Posted : Saturday, March 7, 2020 12:51:10 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)
Just uncheck the "Convert rows to columns"
Back to top
thanks 1 user thanked MartLeib for this useful post.
davidcallahan on 3/10/2020(UTC)
davidcallahan  
#3 Posted : Tuesday, March 10, 2020 9:31:23 PM(UTC)
davidcallahan

Rank: Advanced Member

Groups: Registered
Joined: 1/22/2020(UTC)
Posts: 47
France
Location: Montpellier

Thanks: 14 times
Was thanked: 2 time(s) in 2 post(s)
That's exactly the problem..... Thanks a lot !!
Back to top
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.

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