logo

Live Production Software Forums

www.vmix.com

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

Notification

Icon
Error
Starting list from Excel in Title Editor
Options
Go to last post Go to first unread
Previous Topic Next Topic
eventljud  
#1 Posted : Tuesday, June 14, 2016 12:25:17 PM(UTC)
eventljud

Rank: Newbie

Groups: Registered
Joined: 2/22/2016(UTC)
Posts: 3
Location: Sweden
Hi, all you guys and girls!
(sorry for my bad english...I think)


I'm going to broadcast a motorsport event and I would like to make a nice graphic with all the drivers in each heat they are going to race in.

From the marshals I will get a big excel file containing the heat number, starting number, drivers name and name of his/hers race club for EVERY ONE in this competition (18 heats with 6 drivers in every heat)

One row with four columns for each driver in this excel file.
For example:

1,45,Peter Smith,Sweden Racing Club
1,47,Roger Andersson,Fast Speed Racing Club
1....and so on....


I have made a layout in Title Editor with the heat number in the upper left corner, then each driver on their own row with their number, name and club
(three inputs/driver in Title Editor...."HeatNR", "#1", "Name1", "Club1", "#2", "Name2", "Club2", "#3"....and so on)

How can I import this the easiest way so I get ALL six drivers in the same heat at my screen at the same time?
Use an extern software?

Many thank's in advance!
Back to top
WWW

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
Henny  
#2 Posted : Tuesday, June 14, 2016 1:48:26 PM(UTC)
Henny

Rank: Advanced Member

Groups: Registered
Joined: 5/14/2013(UTC)
Posts: 140
Man
Location: uk

Thanks: 2 times
Was thanked: 24 time(s) in 20 post(s)
In the past I've knocked up a php script that eats the excel and drives the graphics
Back to top
eventljud  
#3 Posted : Tuesday, June 14, 2016 1:56:22 PM(UTC)
eventljud

Rank: Newbie

Groups: Registered
Joined: 2/22/2016(UTC)
Posts: 3
Location: Sweden
Henny wrote:
In the past I've knocked up a php script that eats the excel and drives the graphics



Oh, it sounds like something I'm looking for.

I need something like this software:

http://www.finishlynx.co...esultv-display-software/
Back to top
WWW
IceStream  
#4 Posted : Tuesday, June 14, 2016 4:53:32 PM(UTC)
IceStream

Rank: Advanced Member

Groups: Registered
Joined: 3/7/2012(UTC)
Posts: 2,636
Man
Location: Canada

Thanks: 33 times
Was thanked: 506 time(s) in 475 post(s)
@ eventljud

You might want to also explore Richard Gatarski's "SmartTitler" (if it is still available for beta testing)

http://forums.vmix.com/d....aspx?g=posts&t=2958

It sounds like it might be right up that alley...


Ice
Back to top
WWW
richardgatarski  
#5 Posted : Tuesday, June 14, 2016 8:28:38 PM(UTC)
richardgatarski

Rank: Advanced Member

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

Thanks: 144 times
Was thanked: 297 time(s) in 250 post(s)
It's still up. You need to export from xls to csv, and do an ansii to utf8 conversation (eg in Notepad).
Back to top
WWW
eventljud  
#6 Posted : Wednesday, June 15, 2016 2:29:43 AM(UTC)
eventljud

Rank: Newbie

Groups: Registered
Joined: 2/22/2016(UTC)
Posts: 3
Location: Sweden
richardgatarski wrote:
It's still up. You need to export from xls to csv, and do an ansii to utf8 conversation (eg in Notepad).


I have done that, but the problem is that I can not figure out how to use the contens in my csv-file and get it work in Title Editor or SmartTitler because of the differens in format, if I say.

My csv-file looks like this now:

1,1,"John Andersson","Racing Club Sweden"
1,2,"Peter Best","Team Fast"
1,3,"Mikael Svensson","Anderstorp Racing Club"
1,4,(driver no4 in heat 1)
1,5,(driver no5 in heat 1)
1,6,(driver no6 in heat 1)
2,7,(driver no1 in heat 2)
2,8,(driver no2 in heat 2).....and so on....and on.....down to

18,150,"Fredrik Andersson","Mantorp Racing Club"
18,151,"Steve Fast","Sweden Racing Club"

Now SmartTitler says "Title Fields do not match"

I can not import the csv file direct in to Title Editor because there it only changes one row and not six as I need.

Feels like I am stupid at the moment, or stuck in some wrong thinking!

Maby I made my layout in Title Editor in a wrong way.....

Thank you guys for all your help!
Back to top
WWW
SportsNetUSA.net  
#7 Posted : Wednesday, June 15, 2016 2:31:54 AM(UTC)
SportsNetUSA.net

Rank: Advanced Member

Groups: Registered
Joined: 10/7/2015(UTC)
Posts: 635
Location: California

Thanks: 122 times
Was thanked: 123 time(s) in 115 post(s)
Any time frame on when SmartTitler will be officially released?
Back to top
WWW
desmar  
#8 Posted : Wednesday, June 15, 2016 7:55:12 AM(UTC)
desmar

Rank: Advanced Member

Groups: Registered
Joined: 8/21/2015(UTC)
Posts: 324
Man
Canada
Location: Cornwall, Ontario, Canada

Thanks: 18 times
Was thanked: 80 time(s) in 60 post(s)
Back to top
thanks 1 user thanked desmar for this useful post.
SportsNetUSA.net on 6/15/2016(UTC)
Users browsing this topic
Guest (3)
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-2024, Yet Another Forum.NET
This page was generated in 0.103 seconds.