Search
 

Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Tags

[userimage] 64 bit Active Forums Analytics ARB asp.net asp.net validation AuthARB Authorize.NET Back Button Basecamp Blog blog posts Browser Back Browser Close Browser History Browser Script cascading style sheet chip levinson client side validation Close Browser Close Window completion event content localization Count Timer Countdown CRM css csv Cursor customer feedback Data Data Springs data springs collection datasprings Date Time JavaScript Debug Info default value Demonstration DNN DNN Authentication DNN Blog DNN Core Profile Property dnn html module dnn modules dnn schedule error dnn schedule multiple dotnetnuke dotnetnuke 5.4.4 DotNetNuke Forums DotNetNuke Modules dotnetnuke reporting dotnetnuke scheduler dotnetnuke user image DropDown Login dynamic Dynamic Data dynamic fields dynamic forms dynamic forms silent post Dynamic Forms Tutorial Dynamic Login Dynamic PDF Form Completion Event dynamic registration dynamic registration silent post dynamic registration user image dynamic user directory dynamic views DynamicRegistration_Question DynamicRegistration_QuestionResponse email email issues Event Viewer Excel Export Export to Excel Facebook Facebook Connect Form Post Formatting Forms Forum Flow guides hidden field Highrise Highrise API HTTP Post Integration Interface iPAD iPAD App for Highrise iPAD Highrise App Items JavaScript Lead Generation LinkedIn list import Live Blog localization Login login module login skin object Mandeeps Microsoft Live Writer module configuration Modules oAuth2 Open Web Studio opt in email OWS Part 1 Part 2 payment gateway paypal Phone Number Products profile question fields Recurring Billing Redirect registration replace html text report views reports resource files resx Sales Force SalesForce Script Scripting server side validation Silent Post Single Sign On skin object Springs sql 2005 pivot sql default value sql import sql query sql replace statement sql reports SQL Server sql server 2005 SSL SSO stored procedure style sheet stylesheet success story Support technical techwise research test credit card numbers testimonial thumbnail image Time Timer Transaction TSQL T-SQL Tutorial Twitter Update Highrise user user directory user profile image users online Web Based writer writing xls xlsx XML

In the Flow

rss

Data Springs, Inc. - An online diary and web log from staff and customers for premium DotNetNuke resources, Data Springs Modules, and Data Springs Services.


Importing / Updating Contacts into 37Signals Highrise CRM system via SQL

We have started using 37Signals applications and more and such as Basecamp and Highrise lately for our own CRM needs. Many of our module for DotNetNuke and SharePoint have already integrated with Highrise and Basecamp for a while (via the HTTP Post feature in components such as Dynamic Forms and Dynamic Registration etc…) Our components and integration has worked great for many of our clients so that each time a user registers or submits a form that information is then posted into the Highrise contacts, notes, cases, etc… For our needs though and because we were already working with their API for integration with a new iPAD App we have been working on, we begin to realize that there is a real need for a much more integrated importing and updating tool for Highrise contacts. I think the importing tool that they have is “ok” I guess (I would love to see a direct SQL Query option or even newer versions of Excel) but it gets the job done… for us the challenge though was that we found it limited to ever update from our existing systems, tables, and queries that are housed in-house and we would have to clear out our contacts and build a new import each time we needed to “Refresh” some of these properties and custom fields within Highrise. For example, we like to manage things such as sales counts, issues, and customer history for contacts within Highrise however our existing systems cannot directly update these into Highrise. Furthermore (and pretty frustrating for us) has been that for imports if the contact already exists that contact is skipped during the import (I think it would be much better if you could import contacts and it would only overwrite new custom fields or fields that are brought in on that specific import).
 
 

Join our mailing list...

Get current news and events the easy way

 

 

   
Subscribe Me

Recent Blogs...

 
Copyright 2005 - 2011 by Data Springs, Inc.