VSTO: Deployment via ClickOnce screencast

V

Deploying an Excel application level VSTO add-in via ClickOnce

If you are new to VSTO deployment then this simple little screencast (just under 14 mins) may help. It covers the scenario of deploying an application level add-in via ClickOnce to a network share, and then the experience a user would have installing it.

TechEd 2008 – Session DEV320: Deploying VSTO v3 Applications

This is one of the demos Andrew Coates and I will be giving in our TechEd session (next Wed 3 Sep at 4pm for those interested).

In our session we cover all the security and trust issues around VSTO deployment (you can download an earlier version of the PowerPoint from Andrew’s blog here). We cover ClickOnce, MSI and SharePoint scenarios. However, we only have time to demo the ClickOnce and SharePoint scenarios. I’m planning on doing a screencast of the MSI process at a later stage (leave a comment if this is of interest to you).

Andrew and I had a practice run through last week, and I recorded the demo parts. The first demo is available now (below).

Screencast

You can view it a few ways.

Acknowledgements: Andrew came up with most of the examples, so if you find the demo helpful then chances are he’s the reason! And if there’s excessive woffle or mistakes, then that’d be my input :-)

Any comments?

I hope this helps.

I’m always keen to improve my demos and presentations. If you have any advice or feedback I’d love to hear it. In fact I might try to organise a little prize for the best bit of feedback… please leave comment against this post.

(UPDATE: Here’s the Deployment via SharePoint screencast)

15 comments

  • Hi Craig,

    First of all I want to tell you that your blog is excellent. Your first article, when you talk about vsot give me a understanding point. I’m really want to see the video of the deploy of a vsot add-in via clickOnce but the links are broken. Can you help me on this?

    On the other hand, I’m thinking in add-in for Word , particularly in a toolbar with some text boxes, a combo-box or similar and a button. It is very important to know your opinion if it is possible to create an add-in like this one that works in Word 2003 and Word 2007 using Visual Studio 2005 with VSOT 2007 SE.

    I will really appreciate your answer.

    By the way, I’m from Uruguay and I have a Software Factory that you can check in the website.

    Thanks and regards,
    Juan

  • Hi Craig,

    First of all I want to tell you that your blog is excellent. Your first article, when you talk about vsot give me a understanding point. I’m really want to see the video of the deploy of a vsot add-in via clickOnce but the links are broken. Can you help me on this?

    On the other hand, I’m thinking in add-in for Word , particularly in a toolbar with some text boxes, a combo-box or similar and a button. It is very important to know your opinion if it is possible to create an add-in like this one that works in Word 2003 and Word 2007 using Visual Studio 2005 with VSOT 2007 SE.

    I will really appreciate your answer.

    By the way, I’m from Uruguay and I have a Software Factory that you can check in the website.

    Thanks and regards,
    Juan

  • Hi Juan,

    Ahhh yes, the videos have been lost since SoapBox was closed down. I’ll see if I can find them and host them on another platform.

    In terms of an Add-In for Word, you will need to create two add-ins – one for 2003 and the other for 2007. Whilst they can share a large part of the code base, they will need to have separate projects and installers. SE will allow you to do this, but I recommend upgrading to VS 2008 Professional or above it possible – the developer experience is much better.

    Cheers,
    Craig

  • Hi Juan,

    Ahhh yes, the videos have been lost since SoapBox was closed down. I’ll see if I can find them and host them on another platform.

    In terms of an Add-In for Word, you will need to create two add-ins – one for 2003 and the other for 2007. Whilst they can share a large part of the code base, they will need to have separate projects and installers. SE will allow you to do this, but I recommend upgrading to VS 2008 Professional or above it possible – the developer experience is much better.

    Cheers,
    Craig

  • Thanks for the video, it’s great to see how all this ties together and how deployment is closer to a web app upgrade. As a web app developer, deployment was always the primary reason for not going back to client app development. However, with ClickOnce, I am now revisiting client side solutions. The one issue I have now is the trust and signing configurations, I can’t seem to deploy to my clients because of the following error:

    “System.Security.SecurityException: Customized functionality in this application will not work because the certificate used to sign the deployment manifest for MYExcelAddIn or its location is not trusted”

    I am clueless when it comes to these things and was wondering if you could point me to a good resource that would help me figure this out? A screen cast like yours would be fantastic. Thanks a bunch!

  • When we update the addin, publish it. and when we open the excel, it just updates the addin. Is there any way to make it prompt “If you want to update”?

    • I think the point is to force out the updates. I’m not aware of how to make this optional for end users – although perhaps they will make that available in a future update.

  • Hi Craig

    When we deploy the customized document on a sharepoint site, as I saw in your video and then a user opens it the first time from his machine, does he have to manually make the Trust Center settings in the MS word installed on his machine or will it be transparent to the user.

    Thanks
    Vartika

  • Hi Craig,

    Great tutorial.

    What i’m currently struggeling with is configuring the IIS. I can’t find a way to configure the IIS in a way the user have acess to the files. Also the files at the web page are not displayed which seems to be becuase the users have no access to this location. But the share behind the URL is acessable so it must have to do with the configuration. Does anybody know a good tutorial for configuring the IIS in the correct way to get that deployment way running?

    Kind regards
    Thomas

  • Hey Craig…
    Thanks for your Video…its really nice and easy way to learn…
    I tried what you showed with application level addin. Everything went well….but when I updated text and published it again and opened my excel to changed text…I got error message asking me to uninstall last version with below given exception text
    Would be grateful…please help out.
    Thanks…Vikram

    **************
    Exception Text **************
    Microsoft.VisualStudio.Tools.Applications.Deployment.AddInAlreadyInstalledException:
    The customization cannot be installed because another version is currently
    installed and cannot be upgraded from this location. To install this version of
    the customization, first use Add or Remove Programs to uninstall this program: ExcelDynamicControls.
    Then install the new customization from the following location:
    file:///C:/Users/vikram/Desktop/ExcelDynamicControls/ExcelDynamicControls/bin/Release/ExcelDynamicControls.vsto
       at
    Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.VerifySolutionCodebaseIsUnchanged(Uri
    uri, String subscriptionId, Boolean previouslyInstalled)
       at
    Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()

  • Hi  Craig,
    Do you have any material or video showing this exact same thing, but when you’ve referenced DLL’s? I’ve built a PowerPoint Add-in that uses the SharePoint Client Side Object Model to get data from SharePoint. It work perfectly on my machine, but when other users try it, it can’t find the Sharepoint client DLL. Is that as simple as setting it to COPY TO LOCAL” on the DLL’s or is there something deeper having to do with full trust that I need to setup? I’m also using ClickOnce. Thank You!

About Craig

I'm the co-host of HubShots and the CEO of XEN - helping mid-large B2B companies with their digital marketing and lead generation.

Craig Bailey

Archives

Posts