How to Display an Attached CSV File as a Confluence Table
On this page
Recipe overview
This recipe provides step-by-step instructions on how to display an attached CSV file as a table on a Confluence page. Because this recipe is using a very large (3,000 record) CSV file, it will leverage the Cache for Confluence add-on to ensure the rendering of the page occurs as quickly as possible. This add-on features these macros:
- The Cache macro, which allows a page to be saved in a cache after being rendered so that subsequent users viewing the page benefit from a much faster page rendering. The Cache macro "wraps around" the page content to be cached, and its parameters allow you to control the length of time the data is cached or optionally allow the user to manually refresh the cache.
- The Future macro, which allows the page to be rendered as it becomes available. This allows the user to see quickly rendered content immediately, while the output of longer running macros is being rendered in the background. This macro also "wraps around" the content it controls. The list of macros that work with the Future macro, including the Cache macro, is listed here.
Please read Page display performance tips and techniques to learn more about what can affect the performance of a Confluence page.
It will take you approximately 4 minutes to complete this recipe.
Recipe level
Ingredients
Preparation
Download the attached SalesLeads.csv file to your computer. The file contains contact information for 3,000 potential sales leads. It was randomly generated using an online tool called Mockaroo so it does not reflect real people or companies. Here is an excerpt from that file, with the first row identifying each field.
first_name,last_name,job_title,email,company,address,state_province,country,postal_code,phone
Aaron,Baker,Analyst Programmer,abakerny@mysql.com,Edgeify,22 Tony Crossing,Florida,US,33777,9-(109)171-6690
Aaron,Chapman,Compensation Analyst,achapman5e@weather.com,Twitterlist,7 Basil Circle,Florida,US,34949,7-(568)437-0309
Aaron,Christopher,Senior Editor,achristopher@bloglovin.com,Jabberbean,5 Arapahoe Lane,Stockholm,SE,100 73,8-(598)183-3882
Aaron,Collins,Structural Engineer,acollins1a@theguardian.com,Avamba,8569 Old Gate Alley,,TN,,2-(467)631-4826
Aaron,George,Senior Developer,ageorgero@odnoklassniki.ru,Roodel,777 Hallows Trail,New York,US,10079,7-(581)862-9457
...
Steps
More recipes
View all our Recipes for Business Intelligence & Automation. Here are some of our latest updates:
Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.