Confluence Database CSV import mapping to Entity in other database

Question

I have a two Confluence databases

1. Schemata. This is the parent table to the Tables database and I have already populated it.

2. Tables This is the "logical" child database of Schemata. I want to populate this with a CSV

Schemata has a column/field called schema

I want Tables to have a schema column as well

I have been unable to figure out how to get the import CSV functionality to map incoming values with the schema column using an Entity Link field. I've tried several different approaches including importing it as text and then trying to convert the field type. But nothing has succeeded. I have 244 rows to import so doing this manually would be very error prone not to mention super tedious.

Rhett Clement · Answer

Based on this and poor performance inside the browser, I'm switching my project to a different tool. Would revisit this feature in the future if performance and some more advanced use cases are handled better. Seems a bit like a toy at present.

Rhett Clement · Answer

but this linked answer falls short of the mark. At the very least it leaves me with very little in the way of actually making real progress towards interoperating with the Confluence cloud. There's nothing specific to the Confluence database feature that is readily apparent in the linked content that appears in the answer to the question I linked above.

Rhett Clement · Answer

Oh this might be relevant. This suggests that it's a limitation that can only be resolved (maybe) with using the API 😞

Solved: Confluence Database Import with Entry Link / Entry...