Software required on Jenkins server

Add-in Express™ Support Service
That's what is more important than anything else

Software required on Jenkins server
Prerequisite to build excel addin project in Jenkins  
Priya GN




Posts: 22
Joined: 2023-08-01
Hi Team,

We have purchased 2 license keys which is attached to my profile(Version: 9.4.4644).
Our project is an Excel Add-in project. Now we are configuring Jenkins to do automated deployment on Jenkins.
While publishing the project in Jenkins, I am getting the following error,



H:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\MSBuild\Current\Bin\Microsoft.Common.CurrentVersion.targets(5202,5): error MSB3211: The assembly 'AddinExpress.MSO.2005, Version=9.4.4644.0, Culture=neutral, PublicKeyToken=4416dd98f0861965' is not registered for COM Interop. Please register it with regasm.exe /tlb. [/[C:\Users\sgomathinayagam\AppData\Local\Jenkins\.jenkins\workspace\Horizon_Test\HorizonAddin\HorizonAddin.csproj]
H:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\MSBuild\Current\Bin\Microsoft.Common.CurrentVersion.targets(5202,5): error MSB3212: The assembly "C:\Users\sgomathinayagam\AppData\Local\Jenkins\.jenkins\workspace\Horizon_Test\HorizonAddin\bin\Release\horizonaddin.dll" could not be converted to a type library. Type library exporter encountered an error while processing 'HorizonApplication.AddinModule, horizonaddin'. Error: Error loading type library/DLL. [C:\Users\sgomathinayagam\AppData\Local\Jenkins\.jenkins\workspace\Horizon_Test\HorizonAddin\HorizonAddin.csproj]





Please let me know instead of installing Addin express is there a way to get this built successfully in Jenkins?


Regards,
Priya
CGI
Posted 01 Aug, 2023 08:07:32 Top
Andrei Smolin


Add-in Express team


Posts: 19122
Joined: 2006-05-11
Hello Priya,

It looks like your add-in project has the Register for COM Interop check box selected. Clear it and check whether the project builds correctly.

Regards from Poland (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 01 Aug, 2023 10:12:52 Top
Priya GN




Posts: 22
Joined: 2023-08-01
Hi,

The project is building successfully now, but it is not getting published. In the environment where Jenkins is installed,

- I have visual studio 2019 installed. I am using that MSBuild. And the project was built on VS 2017.
- Add-in Express is not installed.
- I need to publish that Excel Add-in project and place the files in a folder.
- When I opened the solution in the Jenkins server, I am not seeing the option of Add-in Express on right click of the project.

Please advice me that if add-in express has to be installed in the Jenkins server as well
Regards,
Priya
Posted 01 Aug, 2023 14:19:34 Top
Priya GN




Posts: 22
Joined: 2023-08-01
Kindly provide me an update for the above query..Currently Jenkins is skipping the publish by leaving this message.
_DeploymentUnpublishable:
Skipping unpublishable project.
Posted 02 Aug, 2023 11:29:48 Top
Andrei Smolin


Add-in Express team


Posts: 19122
Joined: 2006-05-11
Hello Priya,

Then you need to install Add-in Express on that server.

Regards from Poland (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 02 Aug, 2023 15:30:05 Top
Priya GN




Posts: 22
Joined: 2023-08-01
Thank you very much. One more query, to install Add-in Express in the server, dotnet framework is only enough from software perspective or Visual studio is required? Because I have seen in the installation wizard, visual studio versions are listed.

And do we need office to be installed in Jenkins server to publish it successfully in Jenkins.
Posted 02 Aug, 2023 16:48:25 Top
Priya GN




Posts: 22
Joined: 2023-08-01
Could you please provide an update on my above query.

Thanks,
Priya
Posted 04 Aug, 2023 17:19:29 Top
Andrei Smolin


Add-in Express team


Posts: 19122
Joined: 2006-05-11
Hello Priya,

I'm sorry for my previous input; I've found it misleading. I suppose I misread your questions.

First off, you can publish an Add-in Express project in two ways: 1) from the Visual Studio UI - this requires that both VS and Add-in Express are installed; 2) using the command line utility called adxpublisher.exe.

This utility requires a .config file. The simplest way of generating such a .config file is to publish an Add-in Express project using the UI having selected the check box titled "Generate 'adxpublisher.exe.config' file".

This check box is shown in two sections of the Add-in Express manual; see the PDF file in the folder {Add-in Express}\Docs on your development PC. Or, you can download the PDF file at https://www.add-in-express.com/downloads/documentation.php; see the top item.

The sections are
- 'Step #4 – Preferences' under 'ClickOnce. On the development PC'
- 'Preferences' under 'ClickTwice. Publishing'

To avoid installing VS and Add-in Express, copy the Add-in Express\Bin folder from a development machine and use it on the server.

You can find a bit more details in section 'Publishing from command prompt'

Regards from Poland (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 07 Aug, 2023 11:41:47 Top
Priya GN




Posts: 22
Joined: 2023-08-01
I will try this and come back for any queries..Does deployment work with Linux.. can you please shed some light with some documentation..

Regards,
Priya
Posted 10 Aug, 2023 08:11:06 Top
Andrei Smolin


Add-in Express team


Posts: 19122
Joined: 2006-05-11
Hello Priya,

Priya GN writes:
Does deployment work with Linux


No, this is a Windows-oriented product.

Regards from Poland (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 10 Aug, 2023 08:37:46 Top