Importing CSV with Image References

[RobTX]

I am considering moving from the iOS application MyStuff to Airtable. My only struggle is with importing images linked to the records.

When exporting from MyStuff, the result is a CSV file and then folders with related images. Does Airtable have the ability to import images based on file location references in a file in the CSV? Do the images need to be in the same directory as the CSV?

Thanks for any insight.

Regards,
Rob

[Tom_Keysers]

I am looking for this as well.

I suppose using a local filepath to the images wont work, since the csv file gets uploaded for an import while the images will just remain local.

Maybe this is possible to do through the API and using a url to the images which are somewhere in the cloud?

@RobTX did you already find a solution for this?

[R_Felciano_QIAGEN]

Would love to see this as well!

Ramon

[Marcio_Souza]

Has anyone been able to find a way to get this done? I’m needing it as well

[remerkle]

I need a fix for this ASAP. Needed to migrate a table from one base to another, can’t find a way to reattach images except one-by-one (unacceptable).

[M_k]

Hi @remerkle

There are a few ways to do this.

One is by reading suggestions from this thread:

How to add photos in bulk to a table?

I’m new to Airtable, probably this is super basic, but… How to add photos in bulk to a table, so that each one becomes a separate record? I have a file of 100 photos, and I want to bring them into my base so that each one is a separate record that I can then add keywords and text to describe it. Thanks!

The other way is by using Integromat, for both images and table.

I just created this scenario, a week or so ago, to update records from one table to another, but it can be reworked for creating new records. Instead of using the Update a record module, you would use Create a record module and you would need to change the filter (just before the last module) to: Id Does Not Exist. Integromat has a free plan that gives you 1,000 operations.

I also have a scenario that you could attach photos from either Google Sheets or GDrive. Let me know if this might be helpful.

Here is the post link. The scenario is post #21:

Update Records Airtable Base to Airtable Base w Integromat

I have 2 different AT bases with the same information in both bases (columns are named the same and the general content of each record is the same). One is considered our main base (Base A) and the second is client-access views with no editing (Base B). I’d like to use Integromat or Zapier to update records in Base B as the records change in Base A. Please advise. I’ve tried several attempts with Integromat and always come up with errors and incomplete functions. Thank you!

Hope these suggestions help.

Mary K

[Moe]

@Tom_Keysers

Maybe this is possible to do through the API and using a url to the images which are somewhere in the cloud?

We built a tool that converts file URLs to attachments:

Convert URLs to Attachments in Bulk on Airtable - miniExtensions