vMix Forums
»
General
»
General Discussion
»
Title Editor Excel Edit single file instead of 200 entries?
Rank: Member
Groups: Registered
Joined: 3/22/2021(UTC) Posts: 11 Thanks: 2 times
|
I have a title that has 120 individual entries that reference cells in an Excel sheet. Is there a way to edit the title without have to go through the title editor to make 120 individual changes to selct column, row and cell? Maybe an XML file or something, that the title is referencing? it takes forever to change all 120 entries if I have to add another field to the Title In this example, I have to make 60 entries int he "driver" column, then another 60 entries int he right hand column. If I am referencing another sheet using a virtual input of this title, I have to go through all 120 entries by hand, and change which sheet it uses. Also, if I want to add a 3rd column to each section, I have to do another manual 60 entries. Image: Screenshot 2023-06-05 221439.jpg (246kb) downloaded 3 time(s).
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,248 Location: Belgium Thanks: 294 times Was thanked: 961 time(s) in 795 post(s)
|
Originally Posted by: presidiodog I have a title that has 120 individual entries that reference cells in an Excel sheet. Is there a way to edit the title without have to go through the title editor to make 120 individual changes to selct column, row and cell? Maybe an XML file or something, that the title is referencing? it takes forever to change all 120 entries if I have to add another field to the Title
Assuming it's a GT title and copy /paste (autonumbers) is not an option, save it as a *.gtxml file and edit with a texteditor
|
|
|
|
Rank: Member
Groups: Registered
Joined: 3/22/2021(UTC) Posts: 11 Thanks: 2 times
|
I extracted the file, but everything in these files is just long numbers. The "Document XML" file is the only one that references anything that i recognize, but doesn't seem to show the reference to the Excel sheet. I changed the file extension to .txt so it can be uploaded. I appreciate your help in advance. :-) document.txt (45kb) downloaded 8 time(s). 721ef52a-e603-4cf5-b77a-9b3270c0177b.txt (2,119kb) downloaded 8 time(s).
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/24/2021(UTC) Posts: 546 Location: athens Thanks: 130 times Was thanked: 74 time(s) in 70 post(s)
|
Originally Posted by: presidiodog I extracted the file, but everything in these files is just long numbers. The "Document XML" file is the only one that references anything that i recognize, but doesn't seem to show the reference to the Excel sheet. I changed the file extension to .txt so it can be uploaded. I appreciate your help in advance. :-) document.txt (45kb) downloaded 8 time(s). 721ef52a-e603-4cf5-b77a-9b3270c0177b.txt (2,119kb) downloaded 8 time(s). Hello. What kind of are the changes you need to make?
|
|
|
|
Rank: Member
Groups: Registered
Joined: 3/22/2021(UTC) Posts: 11 Thanks: 2 times
|
Each line has 3 pieces of info that the Title will pull from the Excel spreadsheet. Driver name, team name and fastest lap time. In some cases, a few more pieces of info such as an image path link for a country flag and a driver image. Each of those individual inputs, requires me to click each individual text block, then select the Excel sheet, then tab, then column, then row, and I have to do that for every single entry. Multiply those entries by 4-6 entries per driver, and 60+ drivers (115 last season) and I can easily spend 1.5 hours on that 1 tile. Example.jpg (352kb) downloaded 3 time(s).
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,248 Location: Belgium Thanks: 294 times Was thanked: 961 time(s) in 795 post(s)
|
Originally Posted by: presidiodog I extracted the file, but everything in these files is just long numbers. The "Document XML" file is the only one that references anything that i recognize, but doesn't seem to show the reference to the Excel sheet. I changed the file extension to .txt so it can be uploaded. I appreciate your help in advance. :-) document.txt (45kb) downloaded 8 time(s). 721ef52a-e603-4cf5-b77a-9b3270c0177b.txt (2,119kb) downloaded 8 time(s). Did i not mention to save the title as a *.gtxml file (instead of a .gtzip? which is a readable (with notepad) xml type file? btw if you name the fields in the title the same as the columns of your datasource one can automate it a bit ( see helpfiles) Also converting the datasource rows to columns is also an option (especially for naming purposes (see helpfiles)
|
|
|
|
Rank: Member
Groups: Registered
Joined: 3/22/2021(UTC) Posts: 11 Thanks: 2 times
|
I guess I am not getting what your saying. I saved the file (see attached). I open in in notepad, and still looks like the xml file when saved as a zip. It is showing me the names of the fields when created in GT Title Designer, but there is no info in regards to the Data Fields. I attached a screenshot, hoping it better explains what I am doing. If the system can only let me edit using the Title Editor, then that;s fine, I just need to carve out all of the time to do it. test.gtxml (45kb) downloaded 0 time(s). Screen Shot All.jpg (430kb) downloaded 1 time(s).
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,248 Location: Belgium Thanks: 294 times Was thanked: 961 time(s) in 795 post(s)
|
Originally Posted by: presidiodog I guess I am not getting what your saying. I saved the file (see attached). I open in in notepad, and still looks like the xml file when saved as a zip. It is showing me the names of the fields when created in GT Title Designer, but there is no info in regards to the Data Fields. I attached a screenshot, hoping it better explains what I am doing. If the system can only let me edit using the Title Editor, then that;s fine, I just need to carve out all of the time to do it.
Titles do (can) not contain info regarding datasources , those are 2 separate enteties. To avoid having to specify each detaail in connecting both having same names ( columns of datasource and textfield names ) helps having datasource row change to colums ( datasource option) can also help ease the work to make connections, will demand a lot of prep in naming all the fields correctly though , but might be worth it in the end In general having so many fields can have a negative effect on a production for one it will be important to NOT update the datasource to frequently or one could be stuck in just (re)loading the title data
|
1 user thanked doggy for this useful post.
|
|
|
Rank: Member
Groups: Registered
Joined: 3/22/2021(UTC) Posts: 11 Thanks: 2 times
|
Most (if not all) of my titles are only updated once the races are completed, so nothing is updated live really. I use a single Excel file, and have different "Titles" that access different pieces of info from the sheet when it is sorted by a certain column, then saved. See my example, where I pull the results to show the race results and then the podium image, which are both pulling from the same Excel file, and grabbing driver images, flag, text, division labels and such. It makes creating images so fast, since I never have to manually enter any names. I just enter the finishing results int he sheet, hit save, and all of my tiles update. It is cool when live on broadcast, I can quickly put in the results just as the race is ending, and have a race result and podium picture to bring up during the driver interviews. This software is just super RAD! it does almost everything I need. Example Results and Podium.jpg (489kb) downloaded 8 time(s).
|
|
|
|
vMix Forums
»
General
»
General Discussion
»
Title Editor Excel Edit single file instead of 200 entries?
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