Importing and adding data into Confluence database

Matt.Lightbourn August 15, 2024

I have created some dated statistics in Excel which I had to export as a csv file as it is a supported file type for Confluence database import option.

I found that I couldn't use the import to also create the necessary columns, I had to do those first, which was ok.

However, upon reviewing the import, I noted that all the dates had been read as if they were M/D/YYYY which, in New Zealand is incorrect, it is D/M/YYYY. In the import, there is no way to correct this.

Either Confluence should accept Excel files which would tell Confluence the format of a date, or the import option should include setting the format of the date of the csv file.

As an alternative to import, I attempted to copy and paste from Excel into the database which resulted in the entire table pasting into the first cell of the first row.

All in all, I am finding this database quite frustrating, a backwards step in functionality from tables which I loathed before but compared to the usability of this, at least I could get data into it, even if I didn't have the ability to set up views based on filters of it.

I don't think there is a user workaround or fix to this, but I consider it to be a bug, even a showstopper of Confluence databases. Is there a roadmap for fixing such issues? Thanks

Update

I got ChatGPT to convert all my dates as text to US format (because Excel reinterprets as a date again) and on the import, it reads it in the format that it wants to but every date is one month out - what is wrong with this import function? Terrible

import data.png

2 answers

1 vote
Juliette Lallement _Elements Apps_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
September 26, 2024

Hi @Matt_Lightbourn 

If you're open to Marketplace alternatives, I can suggest you the app Elements Spreadsheet. It's very simple to use, you can import Excel spreadsheets and edit them directly in Confluence. You can do all the basic stuff Excel allows you to do.

We recently added another macro - Project Tables - that has a Confluence table look and feel with the added value of Excel formulas and conditional coloring which is quite powerful for data insights. It can be quite useful for project management or collaborative trackers. 

I hope this helps!

 

Matt.Lightbourn September 26, 2024

Thanks for your response, unfortunately marketplace pricing model doesn't work for an enterprise, per user licenses is not doable and Atlassian has bitten the bullet by adding a database functionality, it's just their MVP falls short of it being usable.

I also wish they had considered the ability to be relational, lookup values from one table in another for things like dropdowns to link records to each other. This would be especially useful for what I want it to be for which is to relate the attributes from Reports to data sources as a part of my documentation set.

The only way I've been able to achieve this is using AirTable but yet again, it would require onboarding all my Confluence users into AirTable which the business definitely will not do.

I'm just stuck with half-baked tools that don't do quite enough to add value.

0 votes
Matt.Lightbourn August 15, 2024

Oh my goodness, I see what it's tried to do, tried to be clever, tried to convert my NZT time zone. So if my date is the 1st of Jan it imports it as the 31st Dec. This is bonkers! I give up on this rubbish

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events