Help

Bulk import images into an existing table

Solved
Jump to Solution
6777 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