How do i check that my confluence storage format is correct?

Question

I am trying to develop a Python program to parse content from an XLS file and present it as a set of Confluence tables. Unfortunately the Confluence documentation is poor regarding the Confluence storage format.  I have, by trial an error over several days, put together a reasonable picture of what to do.  Unfortunately when I run the whole script I just get the blanket error:

HTTPError: com.atlassian.confluence.api.service.exceptions.BadRequestException: Content body cannot be converted to new editor format

Since the file is 1 MByte its going to take some more days of trial an error to find the remaining issue.

Are there any atlassian tools (Or third party tools) that can parse my file and point to where the error is at?  Any other help would be greatly appreciated.

Stephen Ellwood · Answer

Hi @Matt Reiner _K15t_ I have now been able to generate a file that is accepted but I am running into another problem, which is the page size is to big.  I will open another issue on this.

Robert Reiner _smartics_ · Answer

In the comments of https://jira.atlassian.com/browse/CONFSERVER-24884 a user mentions a schema file. I haven't tried it myself, but maybe it helps to locate the issue in the generated XML file?

This seems to be the tool's webpage: http://www.amnet.net.au/~ghannington/confluence/readme.html

Stephen Ellwood · Answer

Hi @Matt Reiner _K15t_ I saw this yesterday while looking for solutions.  If its really free then I will definitely ask the admin to install it - Thanks. Unfortunately it does not help in this case since the source data is in excel and its translated to storage format and then uploaded to confluence, which just rejects it, so it never gets as far as the editor.

I had a thought last night about how to do a "binary chop" on my output and feed it in to find the errors.  In fact I broke it down into ~250 sub-blocks and fired them at Confluence one by one.  I found that certain characters in the Excel were creating problems in the output. I have had to create work-arounds for these errors.  As I type I am just trying again to see if I solved them all.