Simple Client for Excel files


#1

For a job i made a very simple but also very quick working client that imports Excel files.

Idea very simple.
Firstline of the excel file contains the template field names (like ‘f0’)
all other excel lines contain the data to be shown.
You can select one of these lines and show.
Making data delivery by 3rd parties fast and easy to understand.

Just for inspiration for all client builders here.
if you like I am willing to share

big thankyou to team “superfly” for making casparcg-connection


#2

Have you seen this? Whit it you can do the same from whit in Excel itself. And you can use all sort of formulas and stuff…


#3

Yep i guess it was a source off inspiration :wink:

Really like your plug-in / approach !! :+1:

My approach here was to make it “ultra” simple / very basic.
As it fit’s more in the operation i made it for.

yes it is certainly less versatile then your plug-in.


#4

That is nice to hear, thanks.

Mine was to make it as flexible as possible, so that “power” users of Excel can use all of their know how to shape data the way they need it. The price is, that it’s not so easy to use.

I just reticently made a quick client for live subtitling of an opera (!) that imports Excel data and updates a simple template. So, as you said, sometimes the best approach is to build something for a particular use case.


#5

Hi Maurice78,
It looks very useful. Will be great if you share it.
Thank you in advance.


#6

When I find time I will clean it up a bit and post it here


#7

sounds very interesting , what is the language you used ? Would be even more interesting to be able to work on gsheet (for my needs :slight_smile: since anyone can update it at any time during the show way easier than an excel file.)

On my side I worked on a node-js interface that was using google API to retrieve data from gsheet, then update casparcg template in real time. Never finished and it stayed a demo purpose, but interesting enough


#8

You could use a power query in Excel to pull the data from gsheet and my AddIn to update a Caspar template with the data.


#9

here it is :wink:
i am by far not the best coder soo stuff can be ugly inside :wink:
feel free to use or change

ls
Maurice


#10

Any hints to do things simpler / better are very welcome


#11

Hi Maurice78,
Thanks for sharing, but I’ve got a little problem. When i test it there is a error:

20 error code ELIFECYCLE
21 error errno 1
22 error xlstoccg@1.0.2 unit: karma start test/unit/karma.conf.js
22 error Exit status 1
23 error Failed at the xlstoccg@1.0.2 unit script.
23 error This is probably not a problem with npm. There is likely additional logging output above.
24 verbose exit [ 1, true ]

When i try to play a template server back error too:

[2019-09-18 10:57:38.257] [1560] [info] Sent message to 127.0.0.1: 400 ERROR\r\nREQ 2lgtvxn CG 1-20 ADD 1 “FOOTBALL\Ploch” 1 “{}”\r\n

May be I do something wrong?


#12

hmm did you use NPM or YARN to install package’s ?
i used yarn.

is there a template named “FOOTBALL\Ploch” in your template folder.

i will put a example excel file in the repo later.
maybe it is formatted different then it supposed to.

grt
maurie