Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Bulk import images into an existing table

Solved
Jump to Solution
8361 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Donnie_Wang
4 - Data Explorer
4 - Data Explorer

I have an existing table with 800+ records (imported from a CSV). Now, I’d like to add an image for each record (import from a folder of PNGs–with matching file names). Is there a way to do this in bulk?

Example Records:
Name, Type1, Type2, Image
Abomasnow, Grass, Ice, [to add: abomasnow.png]
Aerodactyl, Rock, Flying, [to add: aerodactyl.png]
Aggron, Steel, Rock, [to add: aggron.png]
etc.

1 Solution

Accepted Solutions
Donnie_Wang
4 - Data Explorer
4 - Data Explorer

Figured out a workaround. This assumes you have one file/image for every Record AND filenames that match a Name field:

  1. Create an empty table
  2. Change to Gallery View
  3. Batch drag the files you want to upload to the “+” icon in the bottom-right corner (this was the key step I kept missing)
  4. You’ll be asked whether to “Create X records” or “Create one record (with X attachments)”. Choose the first one.
  5. Sort records by Name, then copy the column they’re in
  6. In the original table, sort by Name and create a new Attachments column
  7. Paste the image attachments into the new column

See Solution in Thread

2 Replies 2
Donnie_Wang
4 - Data Explorer
4 - Data Explorer

Figured out a workaround. This assumes you have one file/image for every Record AND filenames that match a Name field:

  1. Create an empty table
  2. Change to Gallery View
  3. Batch drag the files you want to upload to the “+” icon in the bottom-right corner (this was the key step I kept missing)
  4. You’ll be asked whether to “Create X records” or “Create one record (with X attachments)”. Choose the first one.
  5. Sort records by Name, then copy the column they’re in
  6. In the original table, sort by Name and create a new Attachments column
  7. Paste the image attachments into the new column

Dear Donny,

I used to use this feature a lot before, but I see that it is not possible anymore. Have you found a way to import series of images again?

Thanks