Show whether the images successfully renamed into subfolder in command prompt.Duplicated the new image names into a subfolder.Showed whether the file downloaded successfully.Extracted out the airtable download link.Asks if you want to run the macro and for a subfolder name.It literally did the following all in 10 seconds Getting access to excel VBA and running a macro isn’t all that difficult, and I will explain how
#PNG AIRTABLE LOGO HOW TO#
Most people won’t have python installed on their computer, myself included, but everyone knows how to use excel. There’s only 2 ways to accomlpish this problem: Trust me here in that I’ve tested this out thoroughly. Not only that you have to download, setup / run multiple programs which is a lot of work If you look at column B, that URL (HTTPS) is the image server where we’re going to download our image assetsīUT, with any of those above programs (bulk renaming / downloading) is that it doesn’t really let you save duplicated copies, because what’s going to happen is on your computer you will have 3 files with the same name, making renaming VERY difficult if not impossible. Say you downloaded the CSV for that sample data I tested out practically almost every software program out there for bulk renaming (Bulk rename utility, Advanced Renamer, Renamer) and bulk downloading (bulk image downloader, ExtremePictureFinder) but the problem is the following: To do this properly, you need to have two different things
Where one row of data in airtable = one pictureĪnd each picture is based off the name in the first column Problem with current software out there to do this (you can skip this)īefore I get into the excel VBA macro, I should highlight what things I tried out before hand and why they don’t work The end result to look like this on your computer:
0 kommentar(er)
