I want to import excel spread sheets I have into Conflunce. The Confluence Documentation says you can: https://confluence.atlassian.com/display/DOC/Importing+Content+Into+Confluence. However, I see nothing on the UWC Documantation or in some web searches.
Here is is what I am aiming to do:
I want each row of the spreadsheet to be a page. So...
I have UWC 3.13.0 running on My Windows 7 PC. Just have no idea what to do to import the spreadsheet. If there is an alternative solution, I am down for that, as well.
Thanks for the help. Oh, I am not a developer, as I am sure the question implies, so be easy.
Confluence Command Line Interface can be used - you will need to install it on your PC. The following assume you have customized the confluence command to provide your server and user credentials or just add them directly to the command below. Refer to the Documentation for more information on the actions:
confluence --action runFromCsv --file importPages.csv --common "--action addPage --space john --parent home"
Bob, thanks for the response. Here is where I am at, and stuck.
Conflunce Remote API is on
I went to Conflunce Admin > General Configuration > Feature Settings and it is Checked next to Remote API (XML-RPC & SOAP).
Download CLI & Run
...Nothing. Here is a screen shot. What am I doing wrong?
Sorry, I am using Windows after having a Mac for 5 years, so I am sure I am doing something wrong, but here is the command line I tried. I assumed that "http://your_server" means the url the Conflunce is hosted on and where I go to log in. Tried it both with the "www" and without.
Oh, I have a 3rd party managing the hosting for this Conflunce Instance. Thought you should know that. Anything they need to do, I will have to contact them.
I'm trying to connect with the cli and getting:
java.net.ConnectException: Connection refused: connect
Here it is:
D:\Tools\cli>confluence --action getServerInfo --server http://domain --user user@domain --password Passw0rd Unable to log in to server: http://domain/rpc/soap-axis/confluenceservice-v1 with user: user@domain
Cause: ; nested exception is: java.net.ConnectException: Connection refused: connect
When trying to connect with https getting another error:
Unable to log in to server: https://domain/rpc/soap-axis/confluen ceservice-v1 with user: user@domain Cause: ; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Aren't the errors clear enough? While using HTTP there seems nothing running at port 80 at 'domain'. Are you able to access Confluence from a browser in the machine you running the CLI? Is there a proxy server configured in the browser?
And for HTTPS, it appears to be running with self signed certificates, hence follow this article for importing the certificates to the local JRE keystore
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG