Help

Re: (BULK IMAGE UPLOADER) KB+Mouse Macro to reupload your ImageURLS / LocalFilePath Images to Airtable

3413 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Vincent_Tang
6 - Interface Innovator
6 - Interface Innovator

There wasn’t a bulk image uploader with airtable so I just made my own autohotkey macro to do this. There’s a substantial amount of users on this forum requesting a feature such as this, myself included, but for now this macro will do

Basically, I have a bunch of imgur.com URL’s already and wanted to reupload it into airtable to get the image thumbnail preview

This is what it looks like in action: (I am not pressing any buttons here asides the “Play Button”, this is macro doing all the work)

This is how i initialize the macro:

45b8ae4ad0c82baceaf221b7bccd1ef82b7a4899.png

This is what the actual macro looks like

746JILB.png

This is what my actual macro file is

This is the program I use (Easy-to-use Applications that runs off AutoHotkey)

http://www.mouserecorder.com/

My macro only works for my computer + network settings (Windows 10), so you might not get the same results I will.

But this is how you would recreate the macro SPECIFIC to your settings:

First, understand how the macro works in a nutshell

PRE-SETUP

(A) Have two columns setup. RIGHT SIDE your image host URL, LEFT SIDE is resulting airtable upload
(B) Start on an image host URL

MACRO IN ACTION:
(1) CTRL+C
(2) Left key
(3) Enter (opens up file upload area)
(4) Enter (opens up windows explorer to browse for file)
(5) CTRL+V (to paste the image URL directly in)
(6) Enter (to tell Airtable to grab the image from your imagehost)
(7) Enter (this physically uploads the file to airtable)
(8)
(9) (this brings you back to the next set of images)
(10) Go back to step 1

Also, after step 5

(5.5.) ENTER On some windows PCs, windows will display a security message asking you to login to your image host. I make my macro press enter again just in case this comes up

Inbetween each step, there’s a pause delay. After step 7 will have the longest delay, because the file is being physically uploaded to airtable. If your files big, it will take longer. I personally find on my network settings, 30 mpbs download 10 mbps upload, that 8000 ms or 8 seconds is good up to a 4 mB image size

Also, with some MouseRecording functions, you can run PixelChecks (e.g. your macro checks if a pixel on your application / window changes to determine what steps to do next). This is good if your file uploads are inconsistent in nature (e.g. you have some 4mB files, some 300 kB files, in no particular order)

Now to setup macro in MouseRecorder

First thing you want to do is download the program if you haven’t already

You can download it here:

http://www.mouserecorder.com/

There’s many other mouse recording macro solutions (Pulover’s macro) but I personally like mouserecorder a lot, because its not horribly complicated to learn

Initial setup:

The first thing you want to do when setting up your macro is setting up binding hotkeys

These are what mine look like:

9e50ca06df76f1d9ab4d3209c8188ae4697d2058.png

I personally only use CTRL+ALT+R and CTRL+ALT+E in this example

Its important to set a hotkey for these because any mouse + keyboard movement gets added into your macro while its recording, giving you lots of bad data to work with

How to create your own macro

(1)

First, think about the shortest number of potential keys to run the macro. Ideally, the macro should be entirely run with keyboard strokes as a best practice, and minimal mouse movement for robust / reliability / reproduceability on different PCs. If you looked at my 10 steps above on what my macro looks like, its highly optimized to take an image host URL and reupload it into airtable. Basically, figure out the least number of steps you would do to normally do the repetitive task . Do this a few times to forsee any problems your macro might have

(2)

Second. When you feel comfortable you optimized your macro by doing it repetitively over and over, now you want to record it. Put your mouse where it needs to be to start the macro (over image URL). Press your start/stop recording (CTRL+ALT+R) for the hotkey initialization I discussed above. Don’t try to do it as quickly as possible, do the task at a consistent pace

(3)

Third. When you feel comfortable your macro is done, now its time to go test it out if it works. Now its time to do some dry runs / optimizations

3d816a5f0fd54729ca3ff461560b5898867f8476.png

Start changing the SPEED down to 50 (%), this increases the delay between each task by double. It helps so you can analyze exactly how long your macro is actually taking

You also want to set the macro to repeat, personally I would set this to a value of 3, so you can really see if your macro is working

You’ll know when your macro fails because it will show what step it gets stuck on, usually the issue is because you have to adjust the “Wait” delay between each steps to be a little bit higher.

(4)

Save the macro somewhere so you can just use it whenever you want.

Other applications of running macro

If you want to have a denormalized column in airtable (Multiple image attachments to one cell), learn to use your filter+view settings to control what images are going to be uploaded to airtable. E.G. you can upload multiple images to one cell, by running the macro twice for 2 seperate columns of image URLS to put into it

E.G.

when I ran this macro, I applied the following settings to ensure my macro would succeed:

[Filter: Where ImageLink is NOT EMPTY]

E3eB7tf.png

This way I could just run the macro from top to bottom. Since some of my cells inside the column are NULL, this entirely negates this problem using filters

You should be aware of your GB limit uploads as well depending on what service you are running

I keep my macro to take about ~20 seconds to do one image upload. I set lots of delays on it to ensure robustness. I’d rather it work 100% of the time and be slower than be twice as fast with a 95% success rate. Because preferably I just want to go on lunch, come back, and all my work to be done

This is a temporary solution to use before bulk file uploading is implement if it is going to be at all, or =Image(URL) thumbnail previewing functions similar to that of google spreadsheets

Also, if you work with lots of product spreadsheets this is a very good tool for parsing CSV-list data http://txtformat.com/

ALSO you could run this macro, if you had the local file location for each image. E.G C:\Users\Vincent\Google Drive\foo.png. You could take it even further, and use a file-location regex tools/ excel VBA / phraseexpress/ bulk image downloading / file path maker / bulk rename utility for more macroing based options adding onto the above workflows I outlined.

This could be used for both personal and or work use. For instance, if you download a list of every movie on IMDB, you can run a webscraping application to grab the image URLs, use a bulk image downloader + proxy, paste the resulting csv file into airtable, and macro reupload it into airtable using the above method. Then you can use that data, make notes about which movies you watched, tag items, etc

Also, if you want to have even more functions with everything + all these other tools I named, you can also use airtables API too after the fact. To integrate into a website, create printable spreadsheets using something like excel’s image downloader options, etc. Or use something like flashcards with anki to help you learn a new subject faster, etc

It just depends how consistent your system is, formatting, what tools you know, what your trying to do , etc

The 10 steps I laid out works exactly the same for this as well

TL;DR

This is software download: EDIT: I neglected to mention, this is a windows only program. see comments below for Mac OS program equivalents

http://www.mouserecorder.com/

Here’s my actual macro file

Basically, this is a bulk image macro uploader. you have two columns, one side has your local file location / image host url. The other side is where the macro reuploads to airtable to get image thumbnail previews

12 Replies 12

thanks @Chris_Veenstra , you can definitely it use for many things besides just airtable.

All you need is a direct image weblink and whatever you want to rename to, thats it :slightly_smiling_face:

Nat
6 - Interface Innovator
6 - Interface Innovator

good work on this @Vincent_Tang! we added to resource directory here: https://builtonair.com/resources

datasofi
4 - Data Explorer
4 - Data Explorer

I know it is many years later, but I used the "Mini Mouse Macro" tool and it took me 5 min to set up a macro that takes the UTL from a cell and uses it to load the image in the next cell.