Extracting Zip Files

[Pit Gebeyaw]

Ihave a Microsoft Form with a dozen questions that all allow for multiple file uploads. These files are uploaded to a SharePoint site. Upon completion of the form, I'm trying to send an email with links to the forms loaded into SharePoint. I attempted to follow the following post:

My problem is, I can't figure out how to convert the output of the Parse JSON step into a string array using only the "name" and "link" elements, nor how I can dynamically reference those array components in the body of the email.

Please remember mark this topic as "Solved" by clicking "Accept as a solution". This way other community members facing this same problem in the future have the chance to find a solution faster. Please note you can even select several replies as as 'Solution', even from different community members!

"Regarding your last comment about OneDrive, I have moved this form to a Microsoft Team site, so the form submission stores the uploaded files on the Team's SharePoint, and the recipients of the email are all members of that Team. Therefore, there is no need to email the attachments since a link works fine. "

@efialttes, thank you for your response! Your approach covers most of what I was looking for. However, my goal is not to keep the filename and link as separate columns in the email, but rather list the filenames as links in a single column. What I attempted to do with your solution was to replace the "value" in the "Append to array variable" with a single column. Since it's still a JSON object, I'm forced to give it a column heading, so I'm using:

After the "Create HTML Table" step, I insert the output into the body of the email. I would prefer not to include the the "Filename" header as I'm inserting this HTML table into a larger table, but I can live with it. However, I would prefer the email to include just the image filenames as links to the files.

Regarding your last comment about OneDrive, I have moved this form to a Microsoft Team site, so the form submission stores the uploaded files on the Team's SharePoint, and the recipients of the email are all members of that Team. Therefore, there is no need to email the attachments since a link works fine.

One final thought. Please bear in mind that, uploaded files are stored in your OneDriveForBusiness, meaning the links I am currently injecting in the HTML Table are OneDriveForBusiness links. If you wish to send this email to your teammates, you need to manually assign permissions to anyone else to access these files.

Or... move the files into a Sharepoint Library, so you can use action block 'Grant access to item or file' to automatically grant permissions. If this last one is your goal, then you need to share Sharepoint links instead

So I am assuming more complex scenario... in your form you offer the possibility to upload files through two different questions. In the Forms Survey I just implemented as example, questions are called 'Release Notes' and 'Self Cetification Test Results'. Both of these questions allow multiple attachments upload (up to 4 in my example).

I opted to process in paralel both responses (please refer to 'Condition Self Certification Test Starus', and 'Condition Release Notes'), but you can process them sequentially. If you just have one question for file upload, then just need one.

99% of the time the archiver works normally, but when you run into issues using the terminal is easier. Go into the directory with the archive through the file explorer and right click an empty space in the folder. select open terminal here.

If they are .sh files, they are shell script files.You can right click the file and then go to permissions tab. Check the box for allowing it to be executed. And then do a ./filename.sh to execute the script.

We have just transitioned our Monday boards into a new tenant, that we now share with a sister company. I used the cross account copier and integromat to facilitate 90% of the work.

The challenge however is that I now need to extract a number of files that have been uploaded into Monday using the pulse update functionality. Can anyone please shed some light on the most effective strategy that I can apply to extracting the files and uploading them into the new tenant, which we now access.

I cant seem to find any related (productive) feedback on the best step to take, and which is the best technology to achieve that?

Thank you

For the sake of webstart and cleanliness, I've been trying to load these resources from a Jar instead. I've got it working, but the load time went from instantaneous to a few seconds, and that's not acceptable. Here's the code I tried (again, error checking stripped):

(This isn't the best way to do what I want to do, it's a mock-up to see if the idea worked. It didn't. The two for-loops is in no way the source of the problem; it's the process of creating all those InputStreams that slows it down)

Anyone know of a better way to work with .jar files besides the way I've tried here? Here's the AngelCodeFont API. If it was absolutely necessary I could submit a patch for that, but I'd rather not have to. It seems to me that there's probably a way to do what I want to do, I'm just not familiar with it.

I'm not terribly against quickly dumping the jar to a temporary directory and then reading the files from there, but if there's a way to do it reading directly from the jar quickly, I'd much rather do that.

Opening a JAR is a very expensive operation. So you may want to open the JAR once and keep the JarFile instance in a static field somewhere. In your case, you will also want to read all entries and keep them in a hashmap for instant access of the resource you need.

The Image loader class inside the library uses the file extension of the name to identify which image loader to use. If there is no file extension, it uses a slower, basic image loader. When I changed this line:

Thanks for the help anyway guys. It took me a few hours to figure this out, but if not for your posts, I probably would have continued to assume the blame was Java's rather than the Library I'm using.

There is no difference between copying files from a zip file (or any archive) or extracting them. The reason is, copying the files still requires the files to be extracted and decompressed. The same amount of work and time will be needed for both to accomplish the same task.

As the title says I got stuck straight away with the USB creator. After waiting quite a while to download at only 2 MB/s (I am on 400+ connection) it is stuck at "Extracting Files". I have waited a long time with minimal processor activity on a powerful pc and nothing happens. There does not seem to be any help out there about this.

I found many videos telling me how to fix the syncing filesystem issue - which I tried but they did not help (the fact that there are so many videos out there worries me slightly that such a widespread issue wasn't fixed).

On average I get 15 mb/s; I have a 500 GB seagate hybrid drive disk. I feel like this speed is very slow but I'm not sure. I also have a 1 TB HDD installed, however, I only use it to install programs and games and store the gameplay + audio I record.

If you're extracting a file with large files within. You'll see the extraction speed increase as HDDs can write large files quickly. However if you are extracting a folder with lots of small files in it may take sometime due to the overhead in writing small files to a HDD.

So how can you speed up file extraction. Well you can write the extracted files to a different disk from which the extracted folder is being red. If its smaller files being extracted, then an SSD would greatly speed things along.

I recently ran into lots of trouble extracting metadata from CZI files. I have multiple images created on the same date, by the same system. CellProfiler seems to be unable to extract the metadata from most of them, although when analyzing them using Fiji, all the metadata seems to be available.

Attached to this post you will find a screenshot from Fiji (showing the metadata), one from the Images module and one from the Metadata module as well as an archive containing the two files used to demonstrate the issue.

It actually works for me. Can you try hitting the Update button in the top left corner of the table (next to Path / URL)?

It is new to me that CellProfiler can actually handle metadata extraction from .czi files well. I split them into individual files and name them (with a macro in Zen) with the info I need, which I then extract with a regular expression from the file name in CellProfiler.

The metadata is only recognised if all the images are in the same folder. Please see the two screenshots attached to my post. Also it seems that I have to - first - only add one singe image file, then - secondly - let CellProfiler do its metadata update thingy and then thereafter add the second file. I hope you understand what I mean.

Hey, i'm new to the advanced features of autoit programming and my knowledge is basic at best but i've made use of the predefined functions to make a program which searches and pulls files from certain computers on a network.

Problem i'm facing now is some of the data is zipped using the .tar.bz2 compression format and i'm supposed to find a way to get my program to extract it. I've tried using some UDF's I searched but they didn't seem to work for me, even the examples provided inside weren't working(I assume it's a problem with the .dll's): '?do=embed' frameborder='0' data-embedContent>>

in this thread: '?do=embed' frameborder='0' data-embedContent>>

It dawned on me then that there's much more to the 'run' family of functions that I initially thought. Provided I had 7zip installed, I wouldn't have to externally run and compile into my exe the .dll file using autoit. Unfortunately the run code didn't run for me as well, even after changing @ScriptDIr to @ProgramfilesDir and changing from 7z.exe to 7zG.exe(And yes, i'm sure 7z is installed in my program files directory and has both those exe files.).

Will some of you pros here help a newbie like myself by explaining how to read and understand what was stated in the run? Where can I learn more about controlling programs this way without accessing their GUI's? The help file was useful but only partly, maybe because I don't know where to look.

3a8082e126