vMix Forums
»
General
»
General Discussion
»
CSV Data Source Number Format
Rank: Member
Groups: Registered
Joined: 12/11/2018(UTC) Posts: 10   Was thanked: 3 time(s) in 2 post(s)
|
We have seen this most of the year, but are just now sitting down to further investigate why leading Zero's on player Numbers are being dropped when using the EXCEL/CSV data source for our overlays.
ALL of the player numbers are correct in the Raw CSV file from the scoring software shown as 01, 02, 03, but in the Vmix Data Source, they only show as 1,2,3.
Are there any Format parameters we can add in the Data Source properties window to have the data source keep the original number with the leading "0's?
I know that some other graphic programs offer a translation property for items like 1st, 2nd, and such, maybe something similar to translation the 01 numbers correctly?
Any info or small script would be great if anyone has run across this in the past.
Thanks,
Matt
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,290  Location: Belgium Thanks: 296 times
Was thanked: 967 time(s) in 801 post(s)
|
Quote:I know that some other graphic programs offer a translation property for items like 1st, 2nd, and such, maybe something similar to translation the 01 numbers correctly? Has been addressed in this forum before so maybe try that
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 12/11/2018(UTC) Posts: 10 Was thanked: 3 time(s) in 2 post(s)
|
Posting in the forum, I should have expected a reply from the experts with no link or solution. Yes, we have searched the VMix forum, and the web with all of the questions/topics posed, with no posted solutions. Maybe we just have to live with the bug, or someone will actually post a solution to why data Source 0's are dropped. Data Source 0's question posed
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,290 Location: Belgium Thanks: 296 times
Was thanked: 967 time(s) in 801 post(s)
|
sorry , we like to help and if things have been addressed searching for a link takes as much of our precious time as a poster but we know it has been addressed people have solved 1st, 2nd trivia for titles with scripts for example (and posted this in the forum or even on fb user groups ) Personally i solved the dropped zeros but adding some code behind in the (xaml) titles to reformat the data fun fact if you use vMix i search terms in Google its often easier to find relevant posts in this forum ;-) https://forums.vmix.com/...rs-as-1st--2nd--3rd--4thhttps://forums.vmix.com/...Downs-from-1-to-1st--etceven if it is not exactly what you are looking for it often give one a lead to go from
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,290 Location: Belgium Thanks: 296 times
Was thanked: 967 time(s) in 801 post(s)
|
following up on previous respons the fun thing about vMix one can "fake" things a bit (what do you know , never happens in movies ;-) ) as a workaround nothing prevents one from having "unused" textboxes as an intermediate to change things, add some scripting and what is standard not possible as magic ...... so why not add the zeros ourselves ?? load a basic title enter a number ( integer in this case) in the first textblock do following script and check result in second textblock Quote:Code:dim j as integer
dim i As string = ""
dim mystring as string = ""
i = Input.Find("mytitle").Text("Headline.Text")
j = CInt(i)
myString = String.Format("{0:0000}", j)
API.Function("SetText",Input:="mytitle",SelectedName:="Description.Text",Value:=myString )
oh mytitle is the name of your title input ! perform the script using shortcut or program a loop into it so it keeps checking for a change to convert your welcome
|
|
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
CSV Data Source Number Format
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
