What is the key value for a relation?

[rjordanriley]

Where do I find that? I am wanting to import relation column.

[vzhd1701]

Do you have relation configured in the Notion table?

[vzhd1701]

It is the title. Do you get "ERROR: CSV [row number]: Value 'column value' for relation 'column name [column] -> table name [DB]' is not a valid value."?

[rjordanriley]

Yes, exactly, that's the error. Phew, it is the title? That will be very helpful...

[rjordanriley]

What do I have wrong then? Formatting? Thank you...

[vzhd1701]

Yes, bad formatting is most probable cause, text should match exactly. Check for trailing spaces in the destination table title column values and your CSV file. Columns in CSV must be separated by comma without extra spaces.

Wrong:

Column 1, Column 2, Column 3
value11, value12, value13
value21, value22, value23

Correct:

Column 1,Column 2,Column 3
value11,value12,value13
value21,value22,value23

[rjordanriley]

I have double checked that and do not see any issue. This is the CSV:

Title,Start,End,Case
value,value,value,Kateryna
value,value,value,Fanning
value,value,value,Serrano

And this is the error:

ERROR: CSV [2]: Value 'Kateryna' for relation 'Case [column] -> Matters [DB]' is not a valid value.
ERROR: CSV [3]: Value 'Fanning' for relation 'Case [column] -> Matters [DB]' is not a valid value.
ERROR: CSV [4]: Value 'Serrano' for relation 'Case [column] -> Matters [DB]' is not a valid value.

That's it, just one word page names in the matters database, and one word in the column to match.("Case"). The help is much appreciated!