search

NexarDeveloper / nexar-supply-excel-cs

The Nexar Supply Excel Add-in
MIT License
18 stars 0 forks source link

Cant see the *.xll in the addins dialogue #21

Closed chrispearce1972 closed 1 year ago

chrispearce1972 commented 2 years ago

Just will not appear regarless of which i select or where i put the xll files

image

RobAltium commented 2 years ago

Hi @chrispearce1972,

Thanks for your note. That is odd. Where did you download the .XLL file to? Are you able to see it if you hit "Browse..." and navigate to the folder? On Windows this is the Downloads folder by default. Once you point Excel at the file it will be added to your list.

Note we have had an issue with some older anti-virus software falsely identifying one of the libraries we use as a trojan. This has impacted a number of add-ins, not just the Nexar Supply add-in. It's addressed now but do make sure you have the correct .XLL file and not one that has been quarantined. You can read more on this in this issue.

Many thanks,

Rob

chrispearce1972 commented 2 years ago

its downloaded to C:\git\nexar-supply-excel-cs\Nexar.Supply.Xll\bin\Release from the github repo - https://github.com/NexarDeveloper/nexar-supply-excel-cs.git

i suspect its some fail silent security policy pertaining to add ons - my am an admin on my machine though but am at a loss as to why it lets me navigate to the location but doesn't list or load it ?

image

On Thu, 6 Oct 2022 at 19:09, Rob Barton @.***> wrote:

Hi @chrispearce1972 https://github.com/chrispearce1972,

Thanks for your note. That is odd. Where did you download the .XLL file to? Are you able to see it if you hit "Browse..." and navigate to the folder? On Windows this is the Downloads folder by default. Once you point Excel at the file it will be added to your list.

Note we have had an issue with some older anti-virus software falsely identifying one of the libraries we use as a trojan. This has impacted a number of add-ins, not just the Nexar Supply add-in. It's addressed now but do make sure you have the correct .XLL file and not one that has been quarantined. You can read more on this in this issue https://github.com/NexarDeveloper/nexar-supply-excel-cs/issues/5.

Many thanks,

Rob

— Reply to this email directly, view it on GitHub https://github.com/NexarDeveloper/nexar-supply-excel-cs/issues/21#issuecomment-1270488145, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIY5K34DKGCR6BC2R6QLBILWB4IWVANCNFSM6AAAAAAQ62U7WA . You are receiving this because you were mentioned.Message ID: @.***>

chrispearce1972 commented 2 years ago

i did also try moving the xlls to c:\temp to no avail :-(

On Thu, 6 Oct 2022 at 19:09, Rob Barton @.***> wrote:

Hi @chrispearce1972 https://github.com/chrispearce1972,

Thanks for your note. That is odd. Where did you download the .XLL file to? Are you able to see it if you hit "Browse..." and navigate to the folder? On Windows this is the Downloads folder by default. Once you point Excel at the file it will be added to your list.

Note we have had an issue with some older anti-virus software falsely identifying one of the libraries we use as a trojan. This has impacted a number of add-ins, not just the Nexar Supply add-in. It's addressed now but do make sure you have the correct .XLL file and not one that has been quarantined. You can read more on this in this issue https://github.com/NexarDeveloper/nexar-supply-excel-cs/issues/5.

Many thanks,

Rob

— Reply to this email directly, view it on GitHub https://github.com/NexarDeveloper/nexar-supply-excel-cs/issues/21#issuecomment-1270488145, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIY5K34DKGCR6BC2R6QLBILWB4IWVANCNFSM6AAAAAAQ62U7WA . You are receiving this because you were mentioned.Message ID: @.***>

chrispearce1972 commented 2 years ago

image

this looks a bit suspicious - is your addin signed?

On Thu, 6 Oct 2022 at 19:09, Rob Barton @.***> wrote:

Hi @chrispearce1972 https://github.com/chrispearce1972,

Thanks for your note. That is odd. Where did you download the .XLL file to? Are you able to see it if you hit "Browse..." and navigate to the folder? On Windows this is the Downloads folder by default. Once you point Excel at the file it will be added to your list.

Note we have had an issue with some older anti-virus software falsely identifying one of the libraries we use as a trojan. This has impacted a number of add-ins, not just the Nexar Supply add-in. It's addressed now but do make sure you have the correct .XLL file and not one that has been quarantined. You can read more on this in this issue https://github.com/NexarDeveloper/nexar-supply-excel-cs/issues/5.

Many thanks,

Rob

— Reply to this email directly, view it on GitHub https://github.com/NexarDeveloper/nexar-supply-excel-cs/issues/21#issuecomment-1270488145, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIY5K34DKGCR6BC2R6QLBILWB4IWVANCNFSM6AAAAAAQ62U7WA . You are receiving this because you were mentioned.Message ID: @.***>

chrispearce1972 commented 2 years ago

last one promise !!!

looks lie that is the problem - if I double click the 64bit packaged xll i get

[image: image.png]

and if i "enable for this session" it at least makes the effort to appear to load but then however my client id and secret don't work :-( possibly cos the plugin is not trusted or some other reason.

image

so i think I've come to an end of this "time saving" escapade !!!

On Thu, 6 Oct 2022 at 19:09, Rob Barton @.***> wrote:

Hi @chrispearce1972 https://github.com/chrispearce1972,

Thanks for your note. That is odd. Where did you download the .XLL file to? Are you able to see it if you hit "Browse..." and navigate to the folder? On Windows this is the Downloads folder by default. Once you point Excel at the file it will be added to your list.

Note we have had an issue with some older anti-virus software falsely identifying one of the libraries we use as a trojan. This has impacted a number of add-ins, not just the Nexar Supply add-in. It's addressed now but do make sure you have the correct .XLL file and not one that has been quarantined. You can read more on this in this issue https://github.com/NexarDeveloper/nexar-supply-excel-cs/issues/5.

Many thanks,

Rob

— Reply to this email directly, view it on GitHub https://github.com/NexarDeveloper/nexar-supply-excel-cs/issues/21#issuecomment-1270488145, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIY5K34DKGCR6BC2R6QLBILWB4IWVANCNFSM6AAAAAAQ62U7WA . You are receiving this because you were mentioned.Message ID: @.***>

RobAltium commented 2 years ago

@chrispearce1972 - OK, I am determined to help you if you'll let me! :-)

Using your client credentials - please edit your post to obfuscate your client secret!! - I was able to use my version of the add-in and make a query. So you are set up correctly on Nexar.

I cannot see any of your images though, other than the very first one in the original post. However, I have found you in the system and will contact you privately. Let's get you running...

chrispearce1972 commented 2 years ago

Ah that's annoying they were in the emails ok

chrispearce1972 commented 2 years ago

I've embedded the screen shots from the emails - why it's not displaying them I have no idea !! it'd be great to get this working :-)

RobAltium commented 2 years ago

Thanks I see the images and things make more sense now.

  1. I use a very similar version here: "Microsoft® Excel® for Microsoft 365 MSO (Version 2209 Build 16.0.15629.20152) 64-bit"
  2. Our add-in is not digitally signed. This is something we want to do. However, it's still on our backlog list. It does not affect the add-in functionality.
  3. My Trust Centre settings for Add-ins allows "Require Application Add-ins to be signed by Trusted Publisher" to be unchecked.

image

I wonder if this is your issue?

Also, you have the correct 64-bit file can can I double check it is ~1MB in size? (Sorry if you know this already - you probably have checked, it's just that I've seen some AV just replace files with a text file with "This has been quarantined" content.)

Once successfully installed you should see something like this, along with the new ribbon entry.

image

chrispearce1972 commented 2 years ago

looks fine image

I cannot uncheck the "trusted addins must be signed" as this must be set in the group policy which requires arguing with IT people which is only one step away from arguing with HR people....

chrispearce1972 commented 2 years ago

HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\Cloud\Office\16.0\excel\security requireaddinsig=0 fixes it ... for this login session anyway - let me know when you have a signed add in !!

RobAltium commented 2 years ago

Hi @chrispearce1972 ,

I'm glad this issue is understood and resolved, and you've got the add-in working now.

Thanks for the registry tip about working around the requirement of a signed add-in.

Let me know if you have any further questions.

Best regards,

Rob

RobAltium commented 1 year ago

It's been a while, so I'm closing this issue as resolved.