Keeping a "Live" office document current in confluence

We have certain excel docs that we'd like to reflect current data in confluence that are updated nearly daily. Is there a way that we can have confluence use the current version of the document without the document being manually reimported confluence?

4 answers

2 votes
Davin Studer Community Champion Jan 21, 2014

You should look into the WebDav components of Confluence. It lets you map you confluence structure as if it were folders and files. At the top level there will be a folder for each space. In each space folder there will be a folder for each page. In each page folder there will be a file called {pagename}.txt that has the actual page data. All other files in the page folder are page attachments. You can click on these files and edit them directly in excel, word, powerpoint, notepad, etc. ... whatever program you normally use to edit that file type. Basically it just makes it so you can edit Confluence as if it were a file system. Any edits are also versioned. So, you could have a scheduled job to copy the Confluence version of the Excel file out to a network share each day ... or you could just set up the WebDav stuff on all the people who would look at the excel file and they can directly access the Confluence version. I know if you are on a Windows box you can map Confluence as a drive letter. The link to the documentation is below. To borrow a word from Stever Jobs I would say this feature is truly "magical".

https://confluence.atlassian.com/display/DOC/Configuring+a+WebDAV+client+for+Confluence

David, this sounds brilliant. Thanks very much.

And a great interface to do mass-manipulations as well, e.g. together with Notepad++ and "Search&Replace for all files" :)

Thanks for teaching me something new Davin :)

Hi Adam,

If you attach the document to your Confluence page and use the Microsoft Excel Macro to make it viewable in your page you will also got a button to edit the document.

This will open the document in Excel and when you save it it will be automatically saved into Confluence, so your document will always be up to date.

I think that's the easiest solution.

Best regards,

Peter

Adam,

this will store the document into the Confluence Attachement folder, so not the network shared folder. (Why is your company using this structure? there are many better ways to organize documents that need sharing). So it will not automatically keep the version outside of confluence up to date.

Best regards,

Peter

Peter is right Adam, the only thing I'd add is that you have to use IE or FireFox to run this functionality. It doesn't work in Chrome.

Cheers.

Will this keep the version outside of confluence up to date? The company has a strict policy here for keeping all documents directly accessable in a network shared folder. If so - amazing, thanks very much.

Peter, they say it is an ISO standard issue (I know nothing about ISO standards). I'll be meeting with them later today to find out if they can comprimise at all (possibly link or sync the document in the confluence attachment folder from the documentation folder

Peter, they say it is an ISO standard issue (I know nothing about ISO standards). I'll be meeting with them later today to find out if they can comprimise at all (possibly link or sync the document in the confluence attachment folder from the documentation folder

Sidenote: updating EXCEL sheets can also happen through Database queries, stored in the Excel sheet, when the user opens the file. That requires him having networkaccess to the database path, however.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,526 views 25 14
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you