Jump to content

Bulk import of Contracts

Darren Rose

Recommended Posts

Hi Darren,

 thanks for your post. Looking at the API's available I would expect that if all you require is a single contract adding to each organisation this would only be a couple of hours work. We would simply need a spreadsheet containing the following information for each contract:


orgId xs:integer required once Organisation ID
name xs:string optional Name of the Contract
description xs:string optional Description of the Contract
dateFrom xs:dateTime optional Date the contract starts
dateTo xs:dateTime optional Date the contract ends
value xs:decimal optional Value for the Contract
contractType xs:string optional The type of contract. Stores the key from a Profile 'cm-contract-types'


We would then prepare an API sequence by looping through the rows and add each contract.

Of course, if there were subsequent elements required such as contacts associating to contracts this would need further consideration and will of course increase the time required.

If you would like a formal estimate and Statement of works preparing, please don't hesitate to get in touch with your specific requirements via the Hornbill Success Portal: https://success.hornbill.com/hornbill/ and we would be more than happy to discuss further.



Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...