logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Data Sources separation lines , ; ?
Options
Go to last post Go to first unread
Previous Topic Next Topic
bgbenni  
#1 Posted : Friday, August 16, 2019 6:36:49 AM(UTC)
bgbenni

Rank: Advanced Member

Groups: Registered
Joined: 5/29/2018(UTC)
Posts: 76
Germany

Thanks: 25 times
Was thanked: 4 time(s) in 4 post(s)
Hallo is it possible to change the separation from vmix for the database from , to a other information ;


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 : Friday, August 16, 2019 6:52:31 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 296 times
Was thanked: 967 time(s) in 801 post(s)
Are you talking about CSV files? how do you create them?
Back to top
bgbenni  
#3 Posted : Friday, August 16, 2019 7:40:14 AM(UTC)
bgbenni

Rank: Advanced Member

Groups: Registered
Joined: 5/29/2018(UTC)
Posts: 76
Germany

Thanks: 25 times
Was thanked: 4 time(s) in 4 post(s)
Yes is is a csv file a can creat the file with , ore ; the problem is if I have a information inside the csv with 12,34 it’s splits the I formation.
Back to top
doggy  
#4 Posted : Friday, August 16, 2019 7:52:18 AM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 296 times
Was thanked: 967 time(s) in 801 post(s)
change the decimal depiction to a period instead in your excel setting (language)
Back to top
richardgatarski  
#5 Posted : Friday, August 16, 2019 3:56:48 PM(UTC)
richardgatarski

Rank: Advanced Member

Groups: Registered
Joined: 2/18/2014(UTC)
Posts: 1,838
Location: Stockholm

Thanks: 144 times
Was thanked: 297 time(s) in 250 post(s)
"vMix Basic","Free"
"vMix Basic HD","0,06 k$"
"vMix SD","0,15 k$"
Back to top
WWW
doggy  
#6 Posted : Friday, August 16, 2019 4:07:08 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 296 times
Was thanked: 967 time(s) in 801 post(s)
@Richard

doesn't work if you have

"vMix Basic","Free"
"vMix Basic HD","0,06"
"vMix SD","0,15"

drops the leading zero's and the comma for the numbers
Back to top
richardgatarski  
#7 Posted : Friday, August 16, 2019 6:57:15 PM(UTC)
richardgatarski

Rank: Advanced Member

Groups: Registered
Joined: 2/18/2014(UTC)
Posts: 1,838
Location: Stockholm

Thanks: 144 times
Was thanked: 297 time(s) in 250 post(s)
darn, you're right...

Found and old topic https://forums.vmix.com/...l-data-format-number-bug
Not sure if it's (still) a bug, or that some of us users don't know how to do it.
In any case, it seems to me that the formatting applies to how thinks are displayed in the Title. There is no corresponding formatting setting in DataSource Manager, nor possible to specify if a particular field is supposed to be a numeric or interpreted as a number.
Back to top
WWW
doggy  
#8 Posted : Friday, August 16, 2019 7:08:10 PM(UTC)
doggy

Rank: Advanced Member

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

Thanks: 296 times
Was thanked: 967 time(s) in 801 post(s)
Yeah but nit putting it in a title yet
IMO its a bug as technically the data comes from a textfile and i guess depends on how vMix treats that data in the first place. if it finds anything that is not a digit it treats the whole field as a text , else as a number disregarding the comma (i think)
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-2025, Yet Another Forum.NET
This page was generated in 0.145 seconds.