Enriching data is something we all want and which (originally) didn't make it to Dynamics CRM 4.0.
I have read that it has been added now which is fine. However, we often have several records which are not uniquely identified by their name, so I still like another idea posted by Yaniv Arditi a few weeks ago here.
Enriching data in Dynamics CRM
Data import to Dynamics CRM
Lately I realised that data import seems to be a constant issue, especially for newcomers to CRM.
So, you have two main options of importing data to Dynamics CRM, using a data map and automatic. A data map involves creating a test file, importing it to CRM while creating a new data map, and of course mapping the columns. This was the weapon of choice for me at first. Downside: You are unflexible to changes after adding attributes, changing anything in the attribute names and so on. Not fun, believe me, I tried it.
Well, automatic mapping works like a charm, as long as you keep the Display names as column names in your csv file. During the data import you just select the csv file and in the next step the record type. Data map changes to "Automatic" and you're done!
If your desired outcome "automatic" does not show up, you messed up with the column names. Yes you did. Export yourself a list of the correct display names and save it somewhere, write a Macro, whatever works for you.
Happy importing.
Workaround for Advanced Find shortcomings in Dynamics CRM
I recently found an interesting blog post on PowerObjects.com regarding finding accounts with no contacts. Actually the lack of this functionality in Advanced Find made me crazy,too.
My problem was rather finding Leads who had no related activities in a fast way. This works for my problem too.
The solution is really low-tech, and probably many are using it as a workaround. Anyway, I found it very useful.
So here's the link, and I'm looking forward to trying this out on some other entities.
http://blog.powerobjects.com/2009/05/04/accounts-with-no-contacts-and-fun-with-subqueries/
CRM project challenges in a small business
Some observations, strictly from my and a small business perspective. If this applies to you or you disagree, it would be great to hear about it. A few challenges in any CRM project replacing another solution:
- get the planning right
- assign the right people
- assign enough resources
- roll-out in reasonable time, get it working
- get back to the old productivity level
Henrik Schmidt is the Marketing Manager in charge of CRM at IEDC-Bled School of Management in Slovenia. This blog takes a small business perspective and is deliberately low-tech. This is a personal blog. The views presented are his own and not necessarily shared by his employer.