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)
|
My mistake
Commas indicate a field, each line a record in a csv file
sadly in vMix one can not change the delimiter for say a comma to a ";" (our number notations use commas instead of points)
this would work in a csv file
Lot 20 110.000 GBP
Lot 19 30.000 GBP
Lot 18 50.000 GBP
Lot 17 200.000 GBP
Lot 16 Not Sold
Sorry
|
|
|
|
|
|
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)
|
Don't be sad - be happy!
CSV is not a generally defined format. Sort of implemented differently by different apps, including how the app supports delimiters. For vMix, if you want to include commas (,) use the CSV format you get when you Export title data. In this case, using your example, as below. This works when you Import data to the Title and when you open the CSV-file as a Data Source.
"Lot 20","110,000 GBP"
"Lot 19","30,000 GBP"
"Lot 18","50,000 GBP"
"Lot 17","200,000 GBP"
"Lot 16","Not Sold"
|
 1 user thanked richardgatarski for this useful post.
|
|
|
|
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)
|
Originally Posted by: richardgatarski  Don't be sad - be happy!
CSV is not a generally defined format. Sort of implemented differently by different apps, including how the app supports delimiters. For vMix, if you want to include commas (,) use the CSV format you get when you Export title data. In this case, using your example, as below. This works when you Import data to the Title and when you open the CSV-file as a Data Source.
"Lot 20","110,000 GBP"
"Lot 19","30,000 GBP"
"Lot 18","50,000 GBP"
"Lot 17","200,000 GBP"
"Lot 16","Not Sold" Sweet or "Lot 20 110,000 GBP" "Lot 19 30,000 GBP" "Lot 18 50,000 GBP" "Lot 17 200,000 GBP" "Lot 16 Not Sold" with a ticker speed of 5 and a auto next of 4 it looks pretty good :-)  ticker.JPG (31kb) downloaded 1 time(s).
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 11/22/2018(UTC) Posts: 94  Location: Worthing Thanks: 1 times
Was thanked: 4 time(s) in 3 post(s)
|
Thanks Dodgy,
Does really work as a solution as we need the commas as it is for currency.
Also I couldn't get the different lines to appear together on the ticker line the first row would get half way across the screen then then disappear and the next line would appear. On you video it showed only a few spaces gap between each row which I couldn't replicate.
Frank
|
|
|
|
|
|
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)
|
You have the thank Richard for the hint
for spacing one has to play with the ticker speed and the autonext timing , it depends also on the lenght of the text
if the auto next is to quick in relation to the speed the data wil really stick together but also sort of fill buffer making an update of the dat not as responsive
imo for data like this i like a little bit of spacing for clarity
one can also add some chars to the datasource format of the title( ticker) like "{0} - "(without the quotes)
as noted in previous post of mine (image) i had the ticker speed set at 5 and the autonext of the datasource to 4
btw , thanks for calling me dodgy ;-)
|
|
|
|
|
|
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)
|
Originally Posted by: FrankLeggett first row would get half way across the screen then then disappear and the next line would appear. change the ticker type to "add" see video
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 11/22/2018(UTC) Posts: 94 Location: Worthing Thanks: 1 times
Was thanked: 4 time(s) in 3 post(s)
|
Thank you Doggy for all your persistance. I have got it to work and have even altered the code so it outputs a CSV with carriage returns and "" around the data so I can use commas.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 4/23/2017(UTC) Posts: 1,243  Location: Germany Thanks: 3 times
Was thanked: 170 time(s) in 152 post(s)
|
The problem is with the commas in the csv file
If the csv reads something like this:
Please, can you add me.,And there we go, just a rush...
Output= 4 fields
needs to be formatted into
"Please, can you add me.","And there we go, just a rush..."
Output = 2 fields
|
|
|
|
|
|
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)
|
Originally Posted by: mavik The problem is with the commas in the csv file
If the csv reads something like this:
Please, can you add me.,And there we go, just a rush...
Output= 4 fields
needs to be formatted into
"Please, can you add me.","And there we go, just a rush..."
Output = 2 fields Been solved 6 posts ago ;-)
|
|
|
|
|
|
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
