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.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import Excel Spreadsheet using UWC

John Guerra

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.

Accepted answers

All comments

Bob Swift

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:

Save the excel file to CSV
Make sure the first line (column headings) has: title, content, content2
Identify the space key and parent page title for where the pages will go - we will use john and home in our example below

Run the following command

confluence --action runFromCsv --file importPages.csv --common "--action addPage --space john --parent home"

John Guerra

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

downloaded the CLI 2.4.0 to my PC, on my desktop
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?
CD into the directory CD "desktop/cli"
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

The command is confluence. To test use:

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

John Guerra

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.

Jodie Miners

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

Lev Sturmer

Hi,

I'm trying to connect with the cli and getting:

java.net.ConnectException: Connection refused: connect

Here it is:

\Tools\cli&gt;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

Renjith Pillai

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

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.

Pascal

Very clever approach. Thanks for the valuable tip!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

universal-wiki-converter