It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Full text search for article list on confluence page

Steffen Heller Jan 31, 2013

Hello,

we have an article list in Excel that we would like to integrate in confluence. What is important is that the list

  • can be updated easily
  • can be searched with the results being highlighted

I thought about the following options:

  1. include the excel on the confluence page with a macro (couldn't test it since none of the macros has beeen activated yet)
  2. set a link from the confluence page to the original excel file
  3. copy all the entries from the excel file and include it as a table in confluence

I wanted to use variant 3 but wasn't happy with the search function. I included Livesearch, Page Tree Search and Search Box but all these searches seemed to be good for site wide searches but not for browsing a list on a single page. What seemed better still was the normal browser search (because it only searches the current page and can highlight results)

So here are the questions:

  1. Is there a better search function for searching a list on a single page
  2. Is there an elegant way to use the browser's search function instead, something like a search field on the page that activates the browser's search
  3. Any other ideas

Thanks

2 answers

1 accepted

0 votes
Answer accepted
Adam Laskowski Feb 01, 2013

I think the browser's "Find on page" search will be the best option. Since you're searching specific page content and want hilighting, this is the only way to really accomplish that effectively.

I think copying entries from the file and dropping them into the table could be a little tedious as it's not a "live" edit, and would require curating if you need to change content. You should be able to instead add the Excel doc to the page as an attachment, embed the attachment, and then edit the file in Excel using Confluence's WebDAV plugin (comes bundled and enabled by default). I'm not exactly sure if it fits the use case exactly, but it might save you some effort and pain on your "can be updated easily" requirement.

Steffen Heller Feb 03, 2013

Hi Adam,

thanks for your response. Your idea sounds interesting. I am just not familiar at all with WebDAV. How would that work exactly:

  • How would I embed the Excel? Will I need a macro for this or is that part of the WebDAV setting?
  • How will the embedded Excel appear on the page? Is it just a link or will the table with the entries appear on the page?
  • How will an update be like? Can I just open the EXCEL from the confluence file, update it and save and then it is done or will I need to temporarily store the Excel somewhere else and reinclude it as a new attachement?

Thanks for your help.

0 votes
Adam Laskowski Apr 15, 2013

After you upload the attachment, you can use the Viewfile Macro, which will embed the document content onto a page. Confluence also support editing of Office docs in a page, and if your browser supports it, you should see an Edit Document link above the file content. If not, you can edit the file directly by opening the file from its WebDAV location. Editing a file via WebDAV and saving over the original will create a new version of the file in Confluence just as if you had uploaded it via the UI.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

920 views 7 17
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you