Martyn Houghton Posted November 14, 2018 Share Posted November 14, 2018 We are potentially looking at importing open requests from Sales Force 'Desk' system and wondered if anyone else has already done this and has any advice/guidance on the best approach? Cheers Martyn Link to comment Share on other sites More sharing options...
Steve G Posted November 14, 2018 Share Posted November 14, 2018 Hi @Martyn Houghton, I don't think we've had a requirement to import requests from a Desk.com instance as yet, but it should be relatively straightforward to build something to help you do that. As Desk is in the cloud, do you have access to the data directly (for example a dump of the database that we can read records from), or would you be looking to grab the data via their REST APIs? Cheers, Steve Link to comment Share on other sites More sharing options...
Martyn Houghton Posted November 15, 2018 Author Share Posted November 15, 2018 @Steve G At the moment it is a live instance in the cloud, so in theory we could gain access from the API, however given the potential short turn around required if it does go ahead we may be more looking to extract data via CSV. The aim is to append this into our existing live instance, so there would need to be some mapping of services between the current system and Service Manager. Cheers Martyn Link to comment Share on other sites More sharing options...
Steve G Posted November 15, 2018 Share Posted November 15, 2018 @Martyn Houghton One of my colleagues recently released an ODBC request import tool, that can use a CSV as its data source, so that may do what you need. It's in beta at the moment, but it lives here if you wanted to take a look: https://github.com/hornbill/goODBC_RequestImport I'll have a look at the code and see how far away it is from being promoted out of beta. Will let you know once done. Thanks, Steve Link to comment Share on other sites More sharing options...
Martyn Houghton Posted November 16, 2018 Author Share Posted November 16, 2018 @Steve G I had spotted that and will no doubt be using that. Cheers Martyn Link to comment Share on other sites More sharing options...
Martyn Houghton Posted November 16, 2018 Author Share Posted November 16, 2018 @Steve G Just a further update, we been given the go ahead to proceed so we will be looking to use the ODBC importer for a Test migration within then next week and Live one middle of December. Cheers Martyn Link to comment Share on other sites More sharing options...
Steve G Posted November 21, 2018 Share Posted November 21, 2018 @Martyn Houghton Just a quick note - I've written and released a generic request import tool, which you will be able to use to import your Desk.com data from using ODBC (so can access CSV, XLS data etc), or a direct database source. Details and link to download are on the Hornbill wiki . This is the tool that should be used going forward, as the previous ODBC-only tool that only reached beta will be deprecated. Unlike the previous ODBC import tool, this utility doesn't require a merge of your request data and historic update data into the same CSV or XLS worksheet, so it's much easier to get your data to an import-ready state. With Excel spreadsheets, the request and diary update data are stored in different worksheets, and with CSV files they can be stored in completely different CSV's - just as long as the CSV's are in the same folder and the ODBC connection to them is configured as such. I've supplied demo config files for SQL, CSV and XLS imports as part of the release, so it should hopefully be self-explanatory, have a look at how the RequestQuery and RequestHistoricUpdateQuery params are structured. Give me a tag on here if you have any issues with it Cheers,Steve Link to comment Share on other sites More sharing options...
Martyn Houghton Posted November 21, 2018 Author Share Posted November 21, 2018 @Steve G Thanks for the pointer. I got a few questions but I will start a fresh post. What is the best forum section to raise them under. This one or System Administration? Cheers Martyn Link to comment Share on other sites More sharing options...
Steve G Posted November 21, 2018 Share Posted November 21, 2018 @Martyn Houghton , The Integration Connectors, API & Webhooks forum would be the best place. Cheers, Steve Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now