# Problem with upload CSV **URL:** \ **Category:** Database\ **Created:** [December 8, 2023, 10:17am UTC](https://forum.adalo.com/t/problem-with-upload-csv/43813 "2023-12-08T10:17:05Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Deinstall](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@Deinstall](https://forum.adalo.com/u/Deinstall)\ **Post date:** [December 8, 2023, 10:17am UTC](https://forum.adalo.com/t/problem-with-upload-csv/43813/1 "2023-12-08T10:17:05Z")
Hi all! I had a task to load a list of products (1,500) into the application. I’ve never worked with Adalo before, so I’m a little confused about how to do this better. All products are collected in the database “Collect”, but there are 3 more related databases “Category”, “Subcategory” and “Gallery” (relationships many to many and the last one is images). I already realized that this import does not work, but what could be the solution? ---
**Author:** ![Ali-Bazzi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ali-bazzi/32/40359_2.png) [@Ali-Bazzi](https://forum.adalo.com/u/Ali-Bazzi)\ **Post date:** [December 8, 2023, 10:26am UTC](https://forum.adalo.com/t/problem-with-upload-csv/43813/2 "2023-12-08T10:26:23Z")
Hello, you mean that you’d like to upload a CSV File of a collection that has relationships? Thank you! ---
**Author:** ![Deinstall](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@Deinstall](https://forum.adalo.com/u/Deinstall)\ **Post date:** [December 8, 2023, 11:07am UTC](https://forum.adalo.com/t/problem-with-upload-csv/43813/3 "2023-12-08T11:07:37Z")
[Screenshot by Lightshot](https://prnt.sc/orn8cVH75L0F) - each product has relationships with other DBs and when importing CSV you cannot use connections with other DBs Each product has its own category and subcategory, but they cannot be selected during import. How can I get around this limitation? ---
**Author:** ![Deinstall](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@Deinstall](https://forum.adalo.com/u/Deinstall)\ **Post date:** [December 8, 2023, 11:14am UTC](https://forum.adalo.com/t/problem-with-upload-csv/43813/4 "2023-12-08T11:14:47Z")
Its a little clear here - [Screenshot by Lightshot](https://prnt.sc/LADlrO-7c9aa) ---
**Author:** ![Rozza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rozza/32/22780_2.png) [@Rozza](https://forum.adalo.com/u/Rozza)\ **Post date:** [December 8, 2023, 1:26pm UTC](https://forum.adalo.com/t/problem-with-upload-csv/43813/5 "2023-12-08T13:26:25Z")
Many to many is a hard one. I have in the past used some kind of list in list setup, that resolves the relationship via text filters and updates it based on a countdown timer. You could maybe do batches of 20 in a list, updating one relationship at a time. It will crash the page from time to time but just reload it. This is just for batch input, not for production grade apps. You can also commit a many to many relationship via the Collections API. eg "relationship\_id’: [31,50,67] You could also ignore the adalo relationships and rely on a second ID field. It’s kind of how External collections work. ---
**Author:** ![Deinstall](https://avatars.discourse-cdn.com/v4/letter/d/aca169/32.png) [@Deinstall](https://forum.adalo.com/u/Deinstall)\ **Post date:** [December 8, 2023, 2:23pm UTC](https://forum.adalo.com/t/problem-with-upload-csv/43813/6 "2023-12-08T14:23:37Z")
> [@Rozza](#): > > that resolves the relationship via text filters and updates it based on a countdown timer How did you do that? Can you write in more detail please? I saw that there is a solution through Zapier or [Make.com](http://Make.com), but for some reason it didn’t work for me