What would be the suggestion method/steps of importing profile pic photos in bulk into a table? I have 1000’s of jpegs that correspond to each member in a google sheet I wish to import and have not found an efficient way of doing this. Thanks!
Hello JohnnyBoy,
It will depend a bit your data plan. And database architecture.
First, you don’t import images into a database if you can, you just record the URL of images (in a CDN, or Google Drive).
I can suggest https://bunny.net/ CDN for that. It’s very cheap in images hosting.
Then, make a plan of the database tables, you wish to import into Glide Tables.
Have fun with Glide,
François
There should really be a way to import a CSV, select a column as the “key”, and upsert other columns. We don’t have it now though.
1 Like
@ThinhDinh I agree Thinh. UPSERT is a basic database operation now, but not for images. Images are far more weight to be stored directly into a table.
People @Google and others never store images in database directly. (even in Firebase Firestore like here).
Have fun, François
1 Like
Fully agree. If Johnny has those images as URLs, or use a third party service like Bunny, he can copy them to the Glide Table. Must make sure they’re in the right order though.
@ThinhDinh Well it can be stored with a list of URL, like I said. Bunny.net is cheap like hell (0.01$ / gb). And very reliable, then make a list of images to bunny here in a Glide Table.
Just a suggestion, of course.
1 Like
I did try storing them in google drive but did not find a way of generating the links in a formulaic manner to use in my import column. Obviously getting the unique links one by one would take too long to create the images column in the import file. I’m sure the method exists I just haven’t found that yet. Thank you!
@JohnnyBoy Depends your plan/sub here. I strongly suggest to use a combination of here Maker Plan + Make + Google Sheets to start with.
After some time, you’ll learn how to put the list of all images URL from Bunny.net, in a Google Sheet, that is also in a Glide Table sync.
We use 3 tabs in the same Google Sheet and that’s 2000 product variants every day.