If you are currently developing portable freeware or planning to do so, use this forum to discuss technical implementation, seek out like-minded developers for partnership, or solicit interested users for beta testing.
Posts: 1
Joined: Fri Apr 09, 2021 9:05 am

Re: DropIt

#1516 Post by CAGLESWORTH » Fri Apr 09, 2021 9:23 am

Brand new to Drop It, but I'm loving it so far. I have a problem I'm trying to solve at work, and I think Drop It can fix it, but I have no idea how to do it. When I say "I don't know" I mean I'm aware that .bat files exist, and I googled enough to end up with Drop It, but I don't know anything about anything. I can't write scripts, but I'm good at following directions. Copying scripts from the internet is fine, but editing the scripts to do the exact thing I need is tough, as I don't really understand what I'm looking at (I mean, I DO, but not in a way that's helpful). I have so far downloaded File Watcher and made a daemon with a copied-from-the-internet .bat executable, with limited results, then found Drop It on a thread about powershell folder monitoring. Here's what I'm trying to do, and I think it's something I can automate, and I've automated parts, but...

I have a folder that has .zip files dropped into it automatically from my gmail (via Zapier, another googling find).
I need to watch this folder, and every time a new zip file is dropped in (or every minute), I need it to extract into it's component pdfs (I've managed this with Drop It, though I then have a folder full of pdfs, that are no longer grouped by .zip)
THEN, I need to combine the (two) pdfs of the zip file into one pdf.
THEN, I need to rename the pdf (I think this part will have to be manual, as the name has to be copied from the subject of the original email)
THEN, I need to go to a folder on the server that already exists (unless it doesn't, then it needs to be created, named after the first two digits in the combined pdf file name), and
THEN create a sub folder whose name is the whole name of the pdf, and
THEN, drop the combined, renamed file into the new subfolder.
THEN, draft an email with the pdf as an attachment, and the server file path in the body of the email (I assume this part would be manual too).

This entire process is long, complicated, tedious, and repetitive. Can anyone walk me through what to do, what's possible, and how to do it?

Post Reply