# Data sync from airtabled \[Mar 03\] **URL:** \ **Category:** Discord-Discussions\ **Created:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328 "2022-11-03T08:27:40Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/1 "2022-11-03T08:27:40Z")
> 🙋‍♂️ **Vlas** _asked_ ## Hello! I’ve moved 40 000 records from the Airtable into the PostgreSQL. Then I synchronised data in Nocodb to make the table visible. But it doesn’t show my records in the table. I can see it in PostgreSQL, but not in Nocodb. What can be the reason of this issue? ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/2 "2022-11-03T08:27:41Z")
> 💁 **o1lab** _replied_ #### I wonder whether you have synced data to NC\_DB database ? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/3 "2022-11-03T08:27:43Z")
> 💁 **o1lab** _replied_ #### The database NC\_DB points to and the database to which you have synced data from airtable can’t be same. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/4 "2022-11-03T08:27:44Z")
> 🙋‍♂️ **Vlas** _replied_ #### o1lab@discord yes, I synced data with Nocodb. Other tables from the same database with lower amount of rows works good. But the table with 40 000 rows doesn’t show its rows. ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/00aeb5512d9f72a9941dde1bd7ab7573949c1452.jpeg) ![image1](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/5c14a7f001a1144da3e4d58e39e37c9927fb165a.jpeg) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/5 "2022-11-03T08:27:45Z")
> 💁 **o1lab** _replied_ #### Can u paste project info (right top menu) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/6 "2022-11-03T08:27:46Z")
> 💁 **o1lab** _replied_ #### Ahok, only one table is not showing the rows # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/7 "2022-11-03T08:27:47Z")
> 🙋‍♂️ **Vlas** _replied_ #### Node: **v12.22.6** #### Arch: **x64** #### Platform: **linux** #### Docker: **true** #### Database: **pg** #### ProjectOnRootDB: **true** #### RootDB: **pg** #### PackageVersion: **0.84.10** # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/8 "2022-11-03T08:27:48Z")
> 💁 **o1lab** _replied_ #### Happy to help over zoom, will DM # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/9 "2022-11-03T08:27:50Z")
> 💁 **o1lab** _replied_ #### Thanks you for taking through the details. Looks like there is a column with name “done?” in it which might be causing the problem. May be it happened while you were editing the column names. #### #### Either ways, if you can think of the setup I mentioned earlier where you sync the data to a new database in postgres - it might be good way to do things. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/10 "2022-11-03T08:27:51Z")
> 🙋‍♂️ **Vlas** _replied_ #### o1lab@discord I’ve tried to connect table as you ordered. It doesn’t work too. I will try to copy table structure with no data and put data with .csv-upload function # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/11 "2022-11-03T08:27:55Z")
> 💁 **o1lab** _replied_ #### Our CSV upload on a table where column has relations won’t work # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/12 "2022-11-03T08:27:56Z")
> 🙋‍♂️ **Vlas** _replied_ #### o1lab@discord I know, but UI Bakery’s tool doesn’t keep relations too. It just save them like a text with related record’s ID. I will try to restore connections after that with n8n. As I saw, Nocodb’s API has m2m-function, where I can set first table’s ID and id of the second table. I will try to use this way # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/13 "2022-11-03T08:27:58Z")
> 🙋‍♂️ **Vlas** _replied_ #### OMG, it works! I used PGadmin and change column’s names: delete from them symbols “+” and “?”. After that nocodb shows all rows. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:27am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/14 "2022-11-03T08:27:59Z")
> 🙋‍♂️ **Vlas** _replied_ #### Also I changed environment variable “DB\_QUERY\_LIMIT\_MAX” to 100000 # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:28am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/15 "2022-11-03T08:28:00Z")
> 💁 **o1lab** _replied_ #### 🙂 # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:28am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/16 "2022-11-03T08:28:01Z")
> 💁 **o1lab** _replied_ #### can you see why those extra + and ? were coming # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:28am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/17 "2022-11-03T08:28:03Z")
> 💁 **o1lab** _replied_ #### is that an issue with the tool you used to migrate data # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:28am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/18 "2022-11-03T08:28:04Z")
> 🙋‍♂️ **Vlas** _replied_ #### It happened because we called some fields in the Airtable like “+7 days” and “Done?”. Airtable doesn’t has strong rules for the fields naming. # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:28am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/19 "2022-11-03T08:28:06Z")
> 🙋‍♂️ **woaxis** _replied_ #### Hello o1lab@discord / Vlas@discord # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 8:28am UTC](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328/20 "2022-11-03T08:28:07Z")
> 🙋‍♂️ **woaxis** _replied_ #### It seems that I have the same problem as you. Following a GraphQL query, I have my “Contact” table empty, while in the PostgreSQL database the data is present. #### I installed NocoDB on Heroku in 1click. Can you help me to solve this problem? Thank you very much # [Next page](https://community.nocodb.com/t/data-sync-from-airtabled-mar-03/328.md?page=2)