# Bubble Data Upload Not Matching Existing Data in Database **URL:** \ **Category:** Database\ **Created:** [March 2, 2024, 8:39pm UTC](https://forum.bubble.io/t/bubble-data-upload-not-matching-existing-data-in-database/310325 "2024-03-02T20:39:48Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![anon4045300](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@anon4045300](https://forum.bubble.io/u/anon4045300)\ **Post date:** [March 2, 2024, 8:39pm UTC](https://forum.bubble.io/t/bubble-data-upload-not-matching-existing-data-in-database/310325/1 "2024-03-02T20:39:48Z")
I am building an app using [Bubble.io](http://Bubble.io) and I run into the following error when I upload data into a table: “found 0 entries with value Tirana in the table of City. Please fix: this is row 1.” I do have a row with the value Tirana in the table of City. I have verified this with a search in Bubble. Help please. It been a very frustrating experience over 2 days. ---
**Author:** ![maindola.yogini](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/maindola.yogini/32/153260_2.png) [@maindola.yogini](https://forum.bubble.io/u/maindola.yogini)\ **Post date:** [March 3, 2024, 9:28am UTC](https://forum.bubble.io/t/bubble-data-upload-not-matching-existing-data-in-database/310325/2 "2024-03-03T09:28:03Z")
Hi @anon4045300 I am assuming you are uploading a CSV? Can you share the mapping for fields for your upload. And the screenshot from data tab for this table ---
**Author:** ![georgecollier](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/georgecollier/32/182327_2.png) [@georgecollier](https://forum.bubble.io/u/georgecollier)\ **Post date:** [March 3, 2024, 1:19pm UTC](https://forum.bubble.io/t/bubble-data-upload-not-matching-existing-data-in-database/310325/3 "2024-03-03T13:19:35Z")
Case and white-space sensitivity could be the issue, are you sure it’s Tirana exactly with correct case sensitivity and no leading or trailing spaces? ---
**Author:** ![florianherzog](https://avatars.discourse-cdn.com/v4/letter/f/7bcc69/32.png) [@florianherzog](https://forum.bubble.io/u/florianherzog)\ **Post date:** [March 3, 2024, 5:16pm UTC](https://forum.bubble.io/t/bubble-data-upload-not-matching-existing-data-in-database/310325/4 "2024-03-03T17:16:42Z")
Are you using an option set? I have / had the same issue in recent days and it was very frustrating. Currently in contact with bubble support and awaiting a reply (probably Tomorrow or the day after that). When I wanted to modify data with a CSV upload I matched a field which referenced an option set. The values it couldn’t find were values of Option set entries where I changed the ‘Display’ value over time. In some views (eg modify existing database entry → where you can modify single entries in the database directly) it displayed the old ‘Display’ values of the option set. Everywhere else, the new values of the ‘Display’ value were displayed. I will let you know as soon as I get an update but it seems to be an issue on Bubbles side. I am currently not on the most recent version of Bubble with my app and did not update yet - perhaps the issue also comes from there. Let’s see what Bubble Support will reply… My workaround was to just match the unique id of the thing I wanted to enter as a record. For big datasets a very inconvenient process but for me it was necessary to proceed work. Here a schematic of the relevant tables I had problems with and a quick brief of my problem, and a screenshot of the “modify existing database entry” of one of the things I wanted to modify with my csv upload ![schematic ERD](https://us1.discourse-cdn.com/bubble/original/3X/3/7/378b82784b74cb823a72d7fb07bf68c14f0ba272.png) ![screenshot](https://us1.discourse-cdn.com/bubble/original/3X/5/7/575adff7d8c07fa8a83ab73747a95597ab75993c.png) ---
**Author:** ![georgecollier](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/georgecollier/32/182327_2.png) [@georgecollier](https://forum.bubble.io/u/georgecollier)\ **Post date:** [March 3, 2024, 6:18pm UTC](https://forum.bubble.io/t/bubble-data-upload-not-matching-existing-data-in-database/310325/5 "2024-03-03T18:18:34Z")
Likely explanation of your issue @florianherzog : > [@How To Return Data From Backend API Workflows (no manual API connector)](https://forum.bubble.io/t/how-to-return-data-from-backend-api-workflows-no-manual-api-connector/306357/7): > > The behavior you observed is a known issue with option sets where options sometimes use an underlying ID instead of the display value. The underlying ID is set when the option is first created, so there may be a discrepancy between the two if you have changed the display for the option. So, this may cause unexpected results when option sets are used within searches and in API calls. > > You can determine the underlying ID of an option by exporting your application’s JSON, opening the resulting file in a text editor, and doing a text search for the display of the option (or something else that would identify it). The object containing that display will be the definition of the option. If this contains a “db\_value” field, the value for that field is the underlying id. Otherwise, the underlying id is the key pointing to the option’s definition in the containing values object.