logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Datasources use first row as name issue (convert rows to columns)
Options
Go to last post Go to first unread
Previous Topic Next Topic
gokily  
#1 Posted : Sunday, May 17, 2020 8:50:30 PM(UTC)
gokily

Rank: Member

Groups: Registered
Joined: 2/2/2019(UTC)
Posts: 13
Croatia

Was thanked: 2 time(s) in 1 post(s)
I have difficult time understanding why sometimes this option seems fine for example:

Naming A,B,C
Result A1,B1,C1

But sometimes it gives

Naming A,B,C
Result A.1,B.1,C.1


Is it some formating issue? Am I missing something?

UserPostedImage
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
doggy  
#2 Posted : Sunday, May 17, 2020 9:00:54 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 295 times
Was thanked: 965 time(s) in 799 post(s)
looks to be dependent if one is using an excel source or xml source for example (at least here it does)
Back to top
gokily  
#3 Posted : Sunday, May 17, 2020 9:16:12 PM(UTC)
gokily

Rank: Member

Groups: Registered
Joined: 2/2/2019(UTC)
Posts: 13
Croatia

Was thanked: 2 time(s) in 1 post(s)
Its an excel xlsx, I really can not figure it out

UserPostedImage

Sometimes its random, but I cannot depend on it because maybe it can mess the data (GT Template) while on air. It happened pre show one time, so I'm not using it. I just want to figure out what is causing it

This are both screenshots from Vmix database
Back to top
doggy  
#4 Posted : Sunday, May 17, 2020 9:30:58 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 295 times
Was thanked: 965 time(s) in 799 post(s)
Suggest you report/ask this to vMix and report back here , they know the details
Back to top
gokily  
#5 Posted : Monday, May 18, 2020 12:28:40 AM(UTC)
gokily

Rank: Member

Groups: Registered
Joined: 2/2/2019(UTC)
Posts: 13
Croatia

Was thanked: 2 time(s) in 1 post(s)
I've finally managed to find and fix the issue, well its more a workaround

The problem seems to be total number of columns and rows, even in some software you cannot change that but in google sheets you can remove them.
After limiting number of columns and rows it works every time without ANY issue.

The problem I had was with excel, google sheet, csv everything.

UserPostedImage
After limiting (its mostly connected to columns rather than rows) everything is fine. Tried it 30 times, created new templates. Perfect every time.
Even with downloading it as xlsx works (previously nothing).
Back to top
gokily  
#6 Posted : Monday, May 18, 2020 4:38:21 PM(UTC)
gokily

Rank: Member

Groups: Registered
Joined: 2/2/2019(UTC)
Posts: 13
Croatia

Was thanked: 2 time(s) in 1 post(s)
Still not fixed but the issue is tracked down, if there are more than 10 columns defined it gets bugged. In the project above if I add 3 more columns naming becomes Name.1 Name.2 etc. I've reported the problem to support.

Edit: Got respond from the support, this behavior is by design to avoid conflict with naming.
Back to top
Users browsing this topic
Guest (2)
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-2025, Yet Another Forum.NET
This page was generated in 0.133 seconds.