Import Excel Spreadsheet using UWC

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...

  • The first column (A) is the Page Title
  • The content in the cells in the rows to the right (B and maybe C - but usually just 2 columns in the spreadsheets) go in each new page that was created from column A's content

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.

4 answers

This widget could not be displayed.

I may be late to the party on this one, but can you just copy the CSV content into Word, format the content as Heading 1 and then import the word document? Here's a video I made of this process yesterday http://t.co/znCGNy00

Very clever approach. Thanks for the valuable tip!

This widget could not be displayed.

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:

  1. Save the excel file to CSV
  2. Make sure the first line (column headings) has: title, content, content2
  3. Identify the space key and parent page title for where the pages will go - we will use john and home in our example below
  4. Run the following command
    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

  1. downloaded the CLI 2.4.0 to my PC, on my desktop
  2. unzipped it and renamed the file CLI, because I figured conflunce-cli-2.5.0-distribution would be harder to type out. This should not matter, correct?
  3. CD into the directory CD "desktop/cli"
  4. Once in I tried to run
    • run_confluence
    • run_confluence.bat
    • run confuence

...Nothing. Here is a screen shot. What am I doing wrong?

The command is confluence. To test use:

confluence --action getServerInfo --server http://your_server --user your_id --password your_password

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.

Sorry, I missed this one. CLI requires JAVA be installed and on your path or directory qualified.

This widget could not be displayed.

Hi,

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

This widget could not be displayed.

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

https://confluence.atlassian.com/display/CONFKB/Unable+to+Connect+to+SSL+Services+due+to+PKIX+Path+Building+Failed+sun.security.provider.certpath.SunCertPathBuilderException

I would add that the user id you should use should NOT be qualified by your windows domain. It needs to be the user id as known by JIRA.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published Tuesday in Confluence

Add-on evaluation with confluence templates

Atlassian market place contains number of Apps/Addons which improves the capability of out of the box Atlassian products. It is good to follow a plugin evaluation process before install add-ons. So t...

101 views 12 6
Read article

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you