How to import food databases?

Get Help Database
1

Working on a cookbook app, I want to have all the ingredients saved locally in my app, so I can search and edit the ingredients in my recipe, tried importing a large food database Foundation Foods.csv from us department of agriculture, but adalo don´t seem to like the size of 7.2mb, has anyone else done some similar food apps and know of an easy solution?

Or is it problematic to get this to work, and should I use an external api to connect to an external food database, lifesum/macrofactor style search?

2

I’m working with ornamental horticulture..

I’m building the product database by hand, for quality reasons.

It would be nice to have .csv files for countries, cities, etc…

..looking for plug-n-play compatibility, with zero editing / tinkering / api, to make it work

3

Hi @Challe77,

Welcome to the community! :tada:

Since you have the csv file, using SheetBridge would be good here. : SheetBridge for Google Sheets | Adalo Resources (New sheet > import the csv file data into the sheet > connect the sheet with SheetBridge > connect SheetBridge with the Adalo app) How many rows does the csv file contains? (Google sheets have limits so make sure to check that)

You could also look at DreamFactory or use an API integration. (API Guide | USDA FoodData Central, Introduction to Open Food Facts API documentation - Product Opener (Open Food Facts Server), …)

Thank you and have a great day!

4

@Dilon @Challe77 given the file size of >7MB, and after some research, such file can contain somewhere from 50K+ to 250K+ entries. IMO Google Sheets isn’t the best place to store it :slight_smile:

5

I asked Adalo Ai to create a list of all countries; a couple different ways.

It would not make a .csv or a simple list.

Instead, it searched my database.

6

In one of the apps we’ve developed, we used the Spoonacular and FatSecret APIs as external data sources for food and nutrition information.

Depending on your needs, it may be worth looking at an API-based approach rather than importing and maintaining a massive food database locally. It keeps the data more up to date and avoids storing hundreds of thousands of food records inside your Adalo database.