Update relationships from CSV or Excel [May 15]

[dummy title body text appended to avoid empty title body]

:raising_hand_man: IvanDrago replied

I have a database with two tables with a large amount of rows each. I’d like to add a LinkToAnotherRecord column from one to the other so that I can create a few other lookup columns. Instead of adding them manually, is there a way to import an CSV or Excel file that has the values that I need to link?

:raising_hand_man: wkw replied

you may take a look if this s your case. if u hv the existing project, n u want to have a lookup

Lookup - NocoDB

:raising_hand_man: IvanDrago replied

That’s what I want to do, however, it’s my understanding that before I can do that I have to do a Link To Another Record (Link To Another Record - NocoDB)

:raising_hand_man: IvanDrago replied

without doing that I dont see anything in the child table drop down

:raising_hand_man: wkw replied

What’s the reason not creating it in GUI?

:raising_hand_man: wkw replied

If your existing DB has the corresponding relations, then nocodb will create LinkToAnotherRecord column.

:raising_hand_man: wkw replied

when u import excel file, u can also choose LinkToAnotherRecord for some fields

:raising_hand_man: wkw replied

if u already hv a nocodb project, I’d suggest u to add it manually n it ll get the corresponding data

:raising_hand_man: IvanDrago replied

The DB doesn’t have them. Before I went ahead and did anything I wanted to see if Nocodb can do it.

I’ve tried importing an Excel spreadsheet and setting that column to LinkToAnotherRecord but when I do that Nocodb imports the column as blank. I wasn’t sure if I was doing something wrong.

:raising_hand_man: wkw replied

before importing an excel, u can fine tune the column to choose the column type. hv u done that ?

:raising_hand_man: wkw replied

besides, adding LinkToAnotherRecord in GUI directly seems the easiest way to do it. any concern for this approach?

:raising_hand_man: IvanDrago replied

I’ve done that. To double check myself, I’m trying to replicate the example shown here:

Link To Another Record - NocoDB

I’ve downloaded the following CSV file:

https://raw.githubusercontent.com/icyrockcom/country-capitals/master/data/country-list.csv

So now I have a table called “Countries” with just the country list and a table called “Capitals” with just the capitals list.

Then, in the “Countries” table I’ve created a LinkToAnotherRecord column with a “Has Many” relationship pointing to the “Capitals” table.

Both of the new columns are blank. My question is, instead of populating the columns by hand, can I do that automatically by importing a CSV or similar? When I try to upload a CSV to the table by clicking on “More” => “Upload CSV”, the new relationship table doesn’t show up.

image0

:raising_hand_man: wkw replied

just checked with the team. currently importing relations with values to be linked is not supported

:raising_hand_man: IvanDrago replied

Thank you! Do you know if it’s a feature that would be implemented down the road?

:raising_hand_man: wkw replied

probably in the future. currently virtual col s not supported.

Autogenerated from discord


Join NocoDB’s community

DiscordTwitterRedditDocs