logo

Live Production Software Forums


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

Notification

Icon
Error

2 Pages<12
Options
Go to last post Go to first unread
doggy  
#21 Posted : Sunday, March 3, 2019 6:12:46 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 1,069
Belgium
Location: Belgium

Thanks: 62 times
Was thanked: 186 time(s) in 167 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
richardgatarski  
#22 Posted : Monday, March 4, 2019 1:10:08 AM(UTC)
richardgatarski

Rank: Advanced Member

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

Thanks: 109 times
Was thanked: 209 time(s) in 174 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"
thanks 1 user thanked richardgatarski for this useful post.
doggy on 3/4/2019(UTC)
doggy  
#23 Posted : Monday, March 4, 2019 1:47:48 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 1,069
Belgium
Location: Belgium

Thanks: 62 times
Was thanked: 186 time(s) in 167 post(s)
Originally Posted by: richardgatarski Go to Quoted Post
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 0 time(s).

FrankLeggett  
#24 Posted : Monday, March 4, 2019 2:03:05 AM(UTC)
FrankLeggett

Rank: Advanced Member

Groups: Registered
Joined: 11/22/2018(UTC)
Posts: 32
United Kingdom
Location: Worthing

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
doggy  
#25 Posted : Monday, March 4, 2019 2:15:31 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 1,069
Belgium
Location: Belgium

Thanks: 62 times
Was thanked: 186 time(s) in 167 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 ;-)
doggy  
#26 Posted : Monday, March 4, 2019 2:23:49 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 1,069
Belgium
Location: Belgium

Thanks: 62 times
Was thanked: 186 time(s) in 167 post(s)
Originally Posted by: FrankLeggett Go to Quoted Post
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

FrankLeggett  
#27 Posted : Monday, March 4, 2019 6:53:13 AM(UTC)
FrankLeggett

Rank: Advanced Member

Groups: Registered
Joined: 11/22/2018(UTC)
Posts: 32
United Kingdom
Location: Worthing

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.
mavik  
#28 Posted : Tuesday, March 5, 2019 7:28:59 PM(UTC)
mavik

Rank: Advanced Member

Groups: Registered
Joined: 4/23/2017(UTC)
Posts: 130
Man
Location: Germany

Was thanked: 16 time(s) in 16 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
doggy  
#29 Posted : Tuesday, March 5, 2019 8:17:52 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 1,069
Belgium
Location: Belgium

Thanks: 62 times
Was thanked: 186 time(s) in 167 post(s)
Originally Posted by: mavik Go to Quoted Post
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 ;-)

Users browsing this topic
2 Pages<12
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.