can i import data from a project file into confluence?

Question

I'd like to use Confluence as the summary status page, and import some dates from the project schedule (Open project) which I use to track the details, dependencies, etc.. Can Confluence do this from a file such as a spreadsheet, pdf, MS office? Just the milestones section would be great.

Peter Robertson_7pu1m2 · Answer

Hi,

I was interested in the same thing and I think I've found a workaround.

In Project Libre you can create and export reports. So you can export Task information into a .csv file.

From this file you can import issues into Jira. Search for "Create issues using the CSV importer"

You can map column names and column values with this importer so probably you don't even need a script.

In Project Libre you also have the option to create custom columns, so you can fill out information that is not really relevant in Project Libre but would be more important in Jira. For example you can create a column for your Epic names, so you would see your newly created tasks under the correct Epic in your road-map.

I hope that helps.

marqueses · Answer

Hello,

I have more or less the same need, want to plan in project libre and the syncronize with JIRA to create tasks and/or update information in project libre for created issues in JIRA. Is the same that already makes JIRA connector for MS Project, but for free software Project Libre.

Anyone has any clue about existing tooling or libraries (preferible in python) to perform it?

Thanks.

Paul Pasler [Seibert] · Answer

So you are looking for a OfficeImporter and similiar things?
https://confluence.atlassian.com/display/DOC/Configuring+the+Office+Connector