CasparCGAddIn for Microsoft Excel

client
#27

Ok. They’re already on the same PC, as the folder image but it doesen’t work.

#28

Ok, and did that work before using another client? Probably the problem is in the template.

#29

Yes. With another client, the template works properly.

#30

Can you PM my a link to download your Excel file and the template?

#31

Is it possible thru a list to play 2 cues/querys? For example that i have a video on layer 20 and then a template/picture on layer 21 and i want to play and start these on the same time.

#32

Currently this is not possible. I don’t see a way to make this, as Excel does not have a way to group lines together. If you need this, I would suggest to build a (Flash) template, that plays the two images/videos together.

#33

Amazing tool! Congratulations!
Wanted to know if the add-in allows you to send data via Json from the HTML template? Is it possible, and how?

#34

You mean sending the data as JSON to the templates? No, currently not possible, but can be added easily. Sending data FROM the templates to Excel would need some kind of server in between, I guess.

#35

Amazing tool !!!

#36

Trying at bit with auto-update, question below.
Is it possible when i change data in a cell and press enter, then it make “save all” and updates data to server? Or is auto-update suppose to work only with dashboad buttons?

#37

When setup correctly it even updates a template, that is already playing. Therefor you need to set the channel and layer in the auto-update pane. For a Dataset, it updates it automatically without pressing “Save” or “Save All”. To function auto-update listens to Excels recalculate event. So if changes in a worksheet triggers Excel to recalculate all the formulas, the update will happen.

#39

Nice to hear that it should function like I hoped. But still it don´t update when i press enter after editing a cell.
When I have changed a value and pressed enter I can then play it from dashboard with correct changed data.

#40

For example if I look at another cell, then it updates when i change value in cell B2. See picture.
15

#41

The recalculate event is not triggered by keying in something in a cell, but if you add a worksheet as a “user interface” and another sheet for the output to Caspar, with auto-update enabled and bring the values from the UI sheet as formulas to the cells of the output sheet, it works.

See this example. The sheet called “EDITOR” is the UI, the two sheets “Scoreboard” and “BigScoreboard” are two differently designed templates, that were played/stopped by the buttons in the dashboard and auto updated on every change in the UI sheet.

#42

Hello,
am trying to download the setup but the link is broken i guess, will you be able to share the correct link,.

Thank you

#43

Sorry for that. I fixed it also above. For convenience here is it also.

#44

Nombre: CasparCGAddIn
De: file:///C:/Program Files (x86)/MediaSupport/CasparCGAddIn/CasparCGAddIn.vsto

************** Texto de la excepción **************
System.Deployment.Application.DeploymentDownloadException: No se realizó la descarga de file:///C:/Program Files (x86)/MediaSupport/CasparCGAddIn/Microsoft.Office.Tools.Excel.dll correctamente. —> System.Net.WebException: No se pudo encontrar el archivo ‘C:\Program Files (x86)\MediaSupport\CasparCGAddIn\Microsoft.Office.Tools.Excel.dll’. —> System.Net.WebException: No se pudo encontrar el archivo ‘C:\Program Files (x86)\MediaSupport\CasparCGAddIn\Microsoft.Office.Tools.Excel.dll’. —> System.IO.FileNotFoundException: No se pudo encontrar el archivo ‘C:\Program Files (x86)\MediaSupport\CasparCGAddIn\Microsoft.Office.Tools.Excel.dll’.
en System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
en System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
en System.IO.FileStream…ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
en System.Net.FileWebStream…ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
en System.Net.FileWebResponse…ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
— Fin del seguimiento de la pila de la excepción interna —

#45

What did you do, when the exeption raises?

#46

nothing just opened the program in visual studio and now

#47

Aha, you need to install the Office VSTO extensions in Visual Studio.