Confluence Database: How to overwrite or update database data without adding duplicates?

[Morgan Watts]

Hello all, 

Question:

I am wondering if anyone has found a way in Confluence Databases (DB) to overwrite existing data in a DB through a CSV import?

What happens/What I tried:

When using the "import -> CSV -> Add to existing fields" option, even if the CSV is formatted the exact same as the DB, then it'll just duplicate those entries rather than overwriting existing data. Simply doubling the size of the DB :D

When using "Replace the entire database" you lose your formatting for the DB and thus can't create multiple uniformed databases with the same color mapping for tags. 

I've also tried copy & pasting the data from a CSV into the DB, locking the structure of the DB, selecting specific information to be overwritten but nothing seems to work. 

Further context:

I'm trying to create a "Contract and Project" DB where some departments can track our contracts, what projects go to said contracts, and other data related to these efforts. In order to save on time manually updating, I'd like to update with a CSV incase a large amount of data changes. Per above, I don't think that's possible. 

[marc -Collabello--Phase Locked- · Accepted solution]

Indeed, this is currently not possible.

[Morgan Watts]

What a lovely answer haha. Hopefully Atlassian adds it as a feature. I'll go and check if there's already a ticket for it. 

[Varsha Joshi]

Agree with @marc -Collabello--Phase Locked- , hence I just use the confluence tables.

[Morgan Watts]

Okay, I'll look into those. Thank you.

[Morgan Watts]

For anyone who finds this post- 

What I'm doing as a workaround (of sorts) is using a combination of Jira cards, and Confluence Databases (DB).

I'm storing the information I want in fields of a Jira card then using the Jira link and Jira work item detail features of the DB to form a table of information. This allows me to import a CSV to the Jira cards which then updates the DB. It's similar to using the "work item" widget in Confluence, but the databases allow different views and some other features that I like.