DropIt

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.
Message
Author
CAGLESWORTH
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?

Badthumbs
Posts: 1
Joined: Sat May 08, 2021 12:18 pm

Re: DropIt

#1517 Post by Badthumbs » Sat May 08, 2021 12:20 pm

hello i've been reading all day if i can sort by file size with dropit and i can't find a yes or no anywhere....

actually i just want files to be copied to my destination folder and if this file exists it checks if the new file is bigger than the existing...
if yes -> overwrite old file
if no -> delete new file

is this even possible with dropit?!?

User avatar
webfork
Posts: 9913
Joined: Wed Apr 11, 2007 8:06 pm
Location: US, Texas
Contact:

Re: DropIt

#1518 Post by webfork » Sun May 09, 2021 12:54 pm

CAGLESWORTH wrote:
Fri Apr 09, 2021 9:23 am
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?
I actually wouldn't try to solve this using DropIt, I'd go for a batch function with the following command line tools. Just paste the commands into a text file and then rename it .BAT and launch. It'll run many of those functions instantly.
  • I'd wait until I had a dozen or so files to update and then I'd paste all those subjects into a spreadsheet.
  • You can auto-extract the zips using 7zip's CLI program: https://7ziphelp.com/7zip-command-line
  • Combine PDFs - look into something like PDFBox http://www.pdfbox.org/
  • Sort by date (so they appear in the order downloaded) and then use a macro program like MouseRecoder https://www.portablefreeware.com/index.php?id=2726 to copy and paste the correct file names from the spreadsheet into the entry (press F2 to rename, down-arrow to go to the next item, repeat).
  • You can modify that same spreadsheet with the names you want to modify (literally create a column with "rename" to change filenames with extra characters and another column with "mkdir" to make directories).
I started out doing processes like this to avoid losing my mind on a super dull posting process and it ended up becoming my favorite part of the job. You can even get MORE fancy and provide more value with a program like FileOptimizer https://www.portablefreeware.com/index.php?id=2377 and further compress the PDFs before posting them.

I can go into a bit more detail here if that's interesting.

Post Reply