search

nfdi4plants / Swate

Excel Add-In for annotation of experimental data and computational workflows.
https://swate-alpha.nfdi4plants.org
MIT License
31 stars 6 forks source link

[BUG] Swate install [collection] #181

Closed Freymaurer closed 1 year ago

Freymaurer commented 2 years ago

Describe the bug Swtae installer too hardcoded in shared folder path. Needs to be done with flexible variable.

Freymaurer commented 2 years ago

If user is not admin and grants admin access: Swate creates folder in admin appdata:

image

elisenger commented 2 years ago

Dear Freymaurer, I am trying to install Swate again , but the installer does not work. I use Excel 2019 and the installer that was present on 8-Dec is working, but not the new one you uploaded later. Any suggestions? I have uninstalled Swate and also cleared the cache folder as indicated, does not work anyway. I am getting an error that makes no sense when I want to add new building blocks to an existing table with annotation blocks. This is why I want to install the newest version of swate.

Freymaurer commented 2 years ago

Hello! No worries, I'll try my best to help you. Let's start with the basics:

  1. Can you send me the link to the installer you used?
  2. Executing the installer should open a window with some text for you. Could you Screenshot this window with the installer output for me?

PS: Screenshot with the "Snip & Scatch" tool in Windows 10. You can then Ctrl + V the image into this issue window or drag'n'drop any saved files.

Feel free to ask if anything is unclear!

Freymaurer commented 2 years ago

I am getting an error that makes no sense when I want to add new building blocks to an existing table with annotation blocks. This is why I want to install the newest version of swate.

I use Excel 2019 and the installer that was present on 8-Dec is working.

I am not 100% sure, but there should be no Swate changes, which require a new installation, since 8-Dec. So we might need to look into the error.

elisenger commented 2 years ago

Great, thank you so much! I accessed the installer here: https://github.com/nfdi4plants/Swate/blob/developer/.assets/swate-win.zip?raw=true When I double click on the installer-cmd, a commandline box pops up, put closes down after 1 sec without any result...

elisenger commented 2 years ago

I have downloaded the Plant growth data template with all annotation blocks. Now I want to add more blocks, for instance "Nitrogen fertilizer exposure". When I click on "add ann. block", the error I get says: "Swate encountered an error while processing the active annotation table.Swate found a reference column (Term Source REF [microeinstein per square meter per second] (#h; #tUO:0000160; #u)) with a core name (Term Source REF), that is already assigned to the previous building block.Building block main column: Characteristics [light intensity exposure], already assigned column: Term Source REF [light intensity exposure] (#h; #tPECO:0007224)"

Freymaurer commented 2 years ago

When I double click on the installer-cmd, a commandline box pops up, put closes down after 1 sec without any result...

  1. Open a fresh Command Prompt (Type Command Prompt in your windows search bar and it should show you the app)
  2. right click on the Swate installer -> Properties . Then you can find the Location with a path to the folder in which the installer is.
  3. Copy (Ctrl + C) this path.
  4. Go back to your fresh Command Prompt and type cd here\comes\your\path, in which you will replace "here\comes\your\path" with the path you just copied. You can insert it with Ctrl + V. Press Enter, this will move the command prompt to the folder in which the installer is.
  5. Type install.cmd and press Enter. This will execute the installer without the window closing.
  6. Sorry for the difficulties, we are working on a more established installer.

I have downloaded the Plant growth data template with all annotation blocks. Now I want to add more blocks, for instance "Nitrogen fertilizer exposure". When I click on "add ann. block", the error I get says: "Swate encountered an error while processing the active annotation table.Swate found a reference column (Term Source REF [microeinstein per square meter per second] (#h; #tUO:0000160; #u)) with a core name (Term Source REF), that is already assigned to the previous building block.Building block main column: Characteristics [light intensity exposure], already assigned column: Term Source REF [light intensity exposure] (#h; #tPECO:0007224)"

I think i might know the problem. When you say download, do you mean actually downloading the .xlsx Excel file? The error message references the old Swate tag array, which we stopped using a few months ago. So my guess is, you downloaded an old .xlsx file with the Swate table and the new Swate version can't handle that table. IF that is the case, worry not you will have several options to solve this.

elisenger commented 2 years ago

Ok, I just opened a new excel file, imported the template annotation table and started to insert additional annotation blocks from scratch without problems. Maybe I was using an older template version, I´m not sure about the differences between the versions... Problem solved/avoided :) Thanks for you immediate help!

Freymaurer commented 2 years ago

You can always find the most recent templates in our template database and insert them right from Swate. These will always work!

If you are not sure what i refer to, always feel free to ask 😄

Freymaurer commented 2 years ago

image

andreaschrader commented 1 year ago

Can Swate 0.6.2 be used with Microsoft 365? During consulting we could not install this on a Windows Laptop. After installing, Swate could not be found inside Excel in the add-ins. Do we need to specifically place the manifest.xml somewhere?

Freymaurer commented 1 year ago

Hey! This should work with Microsoft 365. Have you looked here? image

andreaschrader commented 1 year ago

Thanks, forwarded the information. I am very sure that we opened all 3 options and did not find Swate. We downloaded "the latest version" from here: https://github.com/nfdi4plants/Swate/releases/download/v0.6.2/swate-win.zip

Maybe unrelated? Is 0.6.2 the correct current version? My installation from November tells me that it updated to v0.7.1.

Freymaurer commented 1 year ago

I am very sure that we opened all 3 options and did not find Swate.

So you can replicate the image from my answer?

Maybe unrelated? Is 0.6.2 the correct current version? My installation from November tells me that it updated to v0.7.1.

Swate is a webservice sideloaded in Excel. So even if you install 0.6.2 it will automatically update if it points to the correct url and Swate gets updated. So you should currently see Swate v 0.7.1

Freymaurer commented 1 year ago

All tries to create a robust Swate installer will be stopped for now. We instead focus on providing a Swate option without installation and getting Swate into the official microsoft add-in store.