Updating records selectively during CSV import [Jun 28]

Discord-Discussions
1

:raising_hand_man: niroknox asked

Hello, newbie here.

My question is possibly to do with primary key but i am not sure:

I uploaded a CSV with 100,000 users - works fast and very happy - search and filter works great

I now wish to enrich them as I got more info about 50,000 of the users, but i can’t seem to find a way to do an Update. so it would add duplicated records, is there a way when importing to ask it to update records if USERNAME field (for example) already exists? if the answer is not - is there another way to do what i want to achieve?

2

:man_bald: dstala replied

<@990927987765563392> That’s not possible from UI. You will have to write a script & use SDK / API to update records selectively.

3

:raising_hand_man: niroknox replied

I see. are there any ready-made scripts or tools for that?

4

:raising_hand_man: niroknox replied

I am on postgres - perhaps PGAdmin can do that?

5

:person_tipping_hand: o1lab replied

Have not tried to upload csv anytime

6

:person_tipping_hand: o1lab replied

How to Import CSVs to PostgreSQL Using PgAdmin | LearnSQL.com

7

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs