Bulk Import Photos to records

1

Hi Tulip Team,

Is it possible to import photos to a tulip table? The format I currently have the data in is an csv sheet that contains the file path. I can run some code to get the images into the excel view of the csv but that doesn’t carry over to the tulip table, is there another way to accomplish this?

2

Is there any way to do this currently?

3

Hey @btsang

Sorry for the delay getting back to you, this one slipped through.

This is very possible with the Tables API. Here is a good document that will get you started using the tables api:

My preferred language to do basic software work like this is Python. Here is some example code that encodes images to text, then uploads them to a table.

If this is your first time playing with the api, or python, this would be a great topic to cover in a future office hours session:
Tuesday 10AM EST - Meet - New User Office Hours

Thursday 11AM EST - Meet - General Office Hours

Thursday 4PM EST - Meet - New User Office Hours

Hope this helps!
Pete

4

Just want to update this thread in case anyone else is trying to use the API to import photos:

  • Line 17 of imagesToTable.py if firstLetter in prefixLookup.keys needs to be if firstLetter in prefixLookup.keys() Pretty easy, but if someone is newer to python they may be confused about the error that results.
  • There is a maximum size of images that Tulip will accept via this method, in my (not very thorough) testing it was smaller than what could be uploaded via Tulip App, so I’d suggest testing your code with a very small image, e.g. 100x100 jpg.
  • Otherwise, thanks Pete for the code, definitely saved a lot of time!