nfdi4plants / Swate

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

[Feature Request] FilePicker should allow to pick folder files #383

Closed ZimmerD closed 4 months ago

ZimmerD commented 4 months ago

Is your feature request related to a problem? Please describe. Some MS vendor formats (e.g. those of Bruker) report the run data as a folder instead of a single file. For this it would be great to have the filepicker be able to also select single or multiple folders.

Describe the solution you'd like Similar behaviour to picking files for folders

Freymaurer commented 4 months ago

What exactly is the requirement here? Add folders full of files or specifically referencing the folder?

@ZimmerD

ZimmerD commented 4 months ago

Sorry for not providing a better description. I had the latter case in mind, specifically referencing the folder.

Freymaurer commented 4 months ago

This is very difficult to implement, as websites do not have access to path. So at best i could return the name of the folder. But a quick search showed even this to be rather difficult.

Let me know what exactly you would need with an example and which alternatives you would be okay with. Thanks in advance!

ZimmerD commented 4 months ago

I think the name of the folder would be sufficient. I think a function like this would be needed since e.g. Bruker does not create a single file as an output for a MS run but rather a folder with many files.

The resulting data would look like this: image

This is how I like to reference it in the workbook sheet: image

For the user a workaround could be to simply zip the folder. However this is rather impractical since most tools only accept it unzipped.

Freymaurer commented 4 months ago

So here is the thing. There is an API to upload folders instead of files, but.. This API MUST upload the files inside the folder and then i can get the folder name from the relative paths of these files. For me on opera this process triggered a warning, asking me if i really want to upload all these files. In addition i think the file size can get quite large for something as simple as a folder name.

@ZimmerD of course you can give me additional input on this topic, but currently i think this is simply not possible to do in Swate. But(!) Swate in ARCitect should be able to solve this issue with Electron features!

Freymaurer commented 4 months ago

Added Relative paths and folder pick option for ARCitect ✨ Thanks to @JonasLukasczyk for the ARCitect side help