Import Excel Spreadsheet using UWC

John Guerra June 27, 2012

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

1 vote
Jodie Miners
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 17, 2012

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

Pascal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 2, 2015

Very clever approach. Thanks for the valuable tip!

0 votes
Renjith Pillai
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 25, 2012

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

Bob Swift
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 26, 2012

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.

0 votes
Lev Sturmer December 24, 2012

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

0 votes
Bob Swift
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 28, 2012

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"

John Guerra June 28, 2012

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?

Bob Swift
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 28, 2012

The command is confluence. To test use:

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

John Guerra June 28, 2012

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.

Bob Swift
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 17, 2012

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events