elstar IT

Fullstack | Java | Tech Speaker | Tech Coach | Frank van der Linden

  • About me
  • Blog license
  • My Open source projects

Bulk import in a Cloudant database

27-04-2017 no responses flinden68 bluemix business community development

After some issues with HR Assistant I was thinking it would be a good idea to create a separate database with only the Design documents as schema database.

So I replicated all the documents from the original database to a brand new one and called it hrassistant_schema. After the successful replication I kept all only the design documents.

 

Today I got a question about the schemas and discovered it should also be a good idea to add all the configuration documents to the schema database of HR Assistant

In that case I have a basic set up and can use it all the time to generate a new instance of the database.

 

Prepare the JSON

In a Cloudant database it easy to get all the documents in JSON format from a certain view via the build in REST API. In my case I needed the configurations view JSON.

The documentation of Cloudant helped me to prepare the JSON to a certain format to remove everything before the doc entry and the } add the end of each document entry in the JSON. Include all the entries in array and assign it to docs keyword.

[dropshadowbox align=”none” effect=”lifted-both” width=”auto” height=”” background_color=”#ffffff” border_width=”1″ border_color=”#dddddd” ][/dropshadowbox]

 

Insert the JSON in Cloudant

Using Postman on my MacBook to post the JSON directly into the Cloudant database. You need the url to the database on Cloudant and add to the url ‘/_bulk_docs’

At the authorization, select Basic Authentication and add your username and password.

In the Request body you add the prepared JSON and press post. In the Response body you get feedback of the operation. In my case all the documents, 24, are inserted successfull.

[dropshadowbox align=”none” effect=”lifted-both” width=”auto” height=”” background_color=”#ffffff” border_width=”1″ border_color=”#dddddd” ][/dropshadowbox]

 

Meanwhile in Cloudant

When I checked the configuration view in the hrassistant_schema database I see all the new documents.

[dropshadowbox align=”none” effect=”lifted-both” width=”auto” height=”” background_color=”#ffffff” border_width=”1″ border_color=”#dddddd” ][/dropshadowbox]

 

Happy coding and come to see me at my session at Engage on 9:00 Tuesday 9th of May, where I will show more technical details about the development of HR Assistant.

Tags: BlueMix, business, development, hrassistant

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • « IBM InterConnect 2017 as a developer
  • Learn, share and Engage in Antwerp »

Contact me

My name is Frank van der Linden and I am an independent software developer based in the Netherlands. The last 2 years I was awarded as IBM Champion. Also I am on the board of OpenNTF. My specialisations are Java, Web development and Domino.


If you want to hire me, please fill in the Contact form


IBM Champion web badge
Apache Logo

All the code on this blog are under the Apache License 2.0. For more details, see Apache License 2.0

Most recent posts

  • Engage 2020: Hello are you listening, There is stream for everything
  • Spring Cloud Function on Azure run locally
  • Deploy Spring Cloud Function to IBM Cloud
  • Speaking (again) at Engage in a Zoo
  • Congratulations, you’re an IBM Champion (again)!

Latest reactions

  • Spring Cloud Function on Azure run locally - elstar IT on Deploy Spring Cloud Function to IBM Cloud
  • flinden68 on Quick XPages tip: add Fullcalendar plugin to your application
  • Rajesh samal on Quick tip: Swagger support for Spring Webflux
  • dsieyx on Quick XPages tip: add Fullcalendar plugin to your application
  • John on Named as IBM Champion 2019

Archive

  • March 2020
  • February 2020
  • January 2020
  • October 2019
  • September 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • January 2019
  • December 2018
  • October 2018
  • September 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • December 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014

Category

  • bluemix
  • business
  • cloudant
  • community
  • development
  • hrassistant
  • openntf
  • running
  • salesforce
  • Springboot
  • Tesla
  • trailrunning
  • Uncategorized
  • watson
  • OpenNTF
  • Collaboration Today
  • XSnippets
  • Stackoverflow
  • IBM Collaboration Solutions
  • Social Business Toolkit
  • About me
  • Dutch curriculum vitae
  • English curriculum vitae
  • Google+
  • LinkedIn profile
  • Twitter
  • Slideshare
  • Blog license
  • My open source projects