importing data directly into scaffolds

  • 2
  • Question
  • Updated 1 year ago
Is there a way to import data into scaffolds?  Even a back-end database script or something?  We have data in Excel spreadsheets we are trying to get into scaffolds on the wiki but we have to get a person to enter each one manually using the forms.  It would be great if there were a way to insert the scaffold data without using the front end forms for the initial setups of these kinds of tools.  After the data is entered, the Excel sheet will no longer be used.
We have a great need also to be able to report on data in tables that are not scaffolds.  For instance, we receive a data dump, again in Excel, once a month from another company.  We would like to be able to paste the data into the wiki (thus creating a table) and then report on it.

Thanks!
Katy
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes

Posted 2 years ago

  • 2
Photo of Stephen Gramm

Stephen Gramm

  • 154 Posts
  • 6 Reply Likes
I am also interested in how this can be done.  Have any other users attempted this?
Photo of andrew.vaningen

andrew.vaningen

  • 587 Posts
  • 59 Reply Likes
Years ago with Confluence 3.5 I had an other party build a csv importer which made several pages with scaffolding data filled out 
Photo of Stephen Gramm

Stephen Gramm

  • 154 Posts
  • 6 Reply Likes
Does the csv importer still work and is it still available?

This type data import operation could be something that ServiceRocket would provide documentation and that would help other customers become successful.
Photo of andrew.vaningen

andrew.vaningen

  • 587 Posts
  • 59 Reply Likes
I believe it broke when Confluence 4 came out. But I can see if I have the plugin zip somewhere.
Photo of andrew.vaningen

andrew.vaningen

  • 587 Posts
  • 59 Reply Likes
the obr is here: https://dl.dropboxusercontent.com/u/101594/scaffolding-extensions-1.1.jar.zip it could contain an element called CSV-importer. do this in a test environment and it's from 2012 and haven't tested/used it since then
Photo of Stephen Gramm

Stephen Gramm

  • 154 Posts
  • 6 Reply Likes
Yes that would be helpful for sure. There must be other customers that need to populate Scaffolding fields from external data sources.

I hope ServiceRocket will help or at least comment with this request for help about  migration of data to Scaffolding fields.
Photo of andrew.vaningen

andrew.vaningen

  • 587 Posts
  • 59 Reply Likes
Have you ever used the Command Line Interface from Bob Swift? Sometimes it can do this kind of stuff. Specially in combination with wiki-markup
Photo of Stephen Gramm

Stephen Gramm

  • 154 Posts
  • 6 Reply Likes
I have not used the CLI from Bob Swift. One problem is that the child/grandchild pages would have to be created first and then the SQL would need to know the CONTENTID of the 'new page' before the database insert could be successful.
Photo of andrew.vaningen

andrew.vaningen

  • 587 Posts
  • 59 Reply Likes
you can create pages with CLI and simultaneously fill it with content.
I would think of a "run macro" with a cli-macro reading one line at a time from a sql table
Photo of Stephen Gramm

Stephen Gramm

  • 154 Posts
  • 6 Reply Likes
This may be possible and we are hoping ServiceRocket Support would help us out with detailed instructions.   It may be that the REST API could be exposed which would help with this effort?
(Edited)