You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
I have attached a CSV file to a Confluence page and then used the Table from CSV macro (as described here) to display the file's contents as a table on the page. The file has 20 lines. The table on the page has 20 rows. So far, so good. Each line in the CSV file has two values separated by a comma. Each row in the table on the page has not two columns, but three. The line in the CSV file that says 2020-11-11, 3.145 is rendered in the table as:
| 2020 | 11 | 11, 3.145 |
It looks like the macro has decided that each line in the CSV file is not one of comma-separated values, but rather of hyphen-separated values.
How can I convince the macro otherwise?
Hi @Greg ,
It seems that your file is missing headers:
Try to add them and preview the result. Besides you'll need headers to create your chart.
Yes, that was it. Thanks.
If, @Katerina Kovriga _Stiltsoft_ , you have any influence on the contents of the documentation page at https://docs.stiltsoft.com/display/public/TFAC/How+to+use+Table+from+CSV+macro, may I suggest that it include mention of the requirement that a CSV file's top-most line must be a line of headers?
Also, for future readers of this thread, I'll mention here that I had to remove the space after each comma. So, in the header line, I had to change Date, Value to Date,Value. In the data lines, I had to change, for example, 2020-11-11, 3.145 to 2020-11-11,3.145.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the feedback, I'll pass it to the support team.
We've just never had such issues before: our clients often generate and upload CSV files from SQL databases and big Excel/Google spreadsheets tables, so there are no extra spaces between cell values and there are always column headers (their goal is to filter such tables/create pivots right in Confluence).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The manager’s daily activities include a list of challenges to reach high levels of efficiency for their teams. Part of these challenges is related to how to deal with the worklog systems sin...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.