Import Excel Spreadsheet using UWC

[John Guerra [TID]]

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.

[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

[plindelauf]

Very clever approach. Thanks for the valuable tip!

[Bob Swift [Bob Swift Atlassian Add-ons]]

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 [TID]]

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 [Bob Swift Atlassian Add-ons]]

The command is confluence. To test use:

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

[John Guerra [TID]]

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 [Bob Swift Atlassian Add-ons]]

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

[Lev Sturmer]

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

[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 [Bob Swift Atlassian Add-ons]]

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.