mandag den 27. juni 2011

How to import many-to-many relationships to CRM Online

I’ve had a challenge the other day.
I’ve got to import around 120 Marketing lists and 120000 contacts and accounts to CRM Online using the standard importing tool in CRM Online.
-          Import marketing lists: check
-          Import accounts and contacts related to each other: check
-          Add accounts and contacts to the imported marketing lists: ehh… shit!
You (still) can’t import relationships to CRM online using the standard import tool – only data, and 1-N relationships (or N-1 for that matter)
I found a way around this issue in the current situation where I only had a relatively limited amount of marketing lists:
I created a new entity called accountmarketinglists and related this entity tor account.
Then I created a new entity called contactmarketinglists and related this entity to contact.
Then I created two spreadsheets where accounts and marketing lists Ire referenced together (a crosstab spreadsheet) and one for contact in the same way.
Then I imported these two spreadsheets into the two new entities.
During the import of the two new spreadsheets I created a new Boolean field for each marketing list, indicating whether the corresponding account or contact should be a part of the marketing list or not.
After the import, I had all the information I needed to import accounts and contacts into the marketing lists, by using the advanced find tool in CRM Online.
When I searched for accounts by the related entity accountmarketinglists and by the Boolean field containing the same name as my marketing lists equals yes, I’ve got a long lists of accounts I’ve just added to the marketing list. This task was done 120 times (for each marketing list), and then I was finished!
It’s not a pretty solution, and it’s certainly not scalable either, but I’ve got the job done. I hope you can use this approach.

126 kommentarer:

  1. I can see that you possess a degree of expertise on CRM Online, I would very a lot like to hear much more from you on this subject matter – I have bookmarked this page and will return soon to hear additional about it.
    Free crm software

    SvarSlet
  2. Microsoft Dynamics CRM training will help you manage and prioritize your business goals, customize.we teach MS Dynamics CRM training and class available at Hyderabad.
    Microsoft Dynamics CRM training in Hyderabad | Microsoft Dynamics CRM online training

    SvarSlet
  3. IMHO you'd of been beter using a tool that uses the SDK to add the relationships. There's a tool called Data Sync from a company called www.Simego.com that can read from nearly any format and mirror the data on the other side. It has a 15 day trail and would of made you life a lot easier :)

    SvarSlet
  4. Aads Education offers Microsoft Dynamics CRM training for individuals to build professional career in Microsoft dynamics CRM, in this program we cover all the modules (Functional, Technical, Administrative) required for implementing successful customer relationship management program in your organization or for your clients.

    Microsoft Dynamic CRM Training in AADS Education

    SvarSlet
  5. Most dating sites that I have tried have been quite disappointing. They are ok for a laugh but not if you really are looking for something. So I searched for dating website for real relationship and I found this globogirls.com and it was really good, it is a good way to see what is out there. There are a lot of different people in different countries, but some good ones too. The good thing about it is that it's totally secure because they have the feature of video chatting with these girls so you'll not share your personal contacts unless you're 100% sure , One thing that I really liked was the tips on how to avoid scam and fraud.

    SvarSlet
  6. I have read your post, it was good to read & i am getting some useful info's through your blog keep sharing...
    Salesforce is a new technology which helps you to get your career destination. Learn salesforce from corporate professionals with very good experience in Salesforce CRM.
    Salesforce training in Chennai|Salesforce courses in Chennai

    SvarSlet
  7. The information you have given here is truly helpful to me. CCNA- It’s a certification program based on routing & switching for starting level network engineers that helps improve your investment in knowledge of networking & increase the value of employer’s network, if you want to take ccna course in Chennai get into FITA, thanks for sharing…
    ccna training in Chennai | ccna training institute in Chennai | ccna training chennai

    SvarSlet
  8. Your blog is really awesome and I got some useful information from your blog. This is really useful for me. Thanks for sharing such a informative blog. Keep posting.

    Regards..
    Cloud Computing Training in Chennai


    SvarSlet
  9. Salesforce is a cloud based CRM software. Today's most of the IT industry use this software for customer relationship management. To get more details about salesforce please refer this site.

    Regards..

    Salesforce.com Training in Chennai

    SvarSlet
  10. Your blog is really nice and informative. Thanks for sharing this post. Keep posting..

    Regards..
    Salesforce Training in Chennai

    SvarSlet
  11. brillant piece of information, I had come to know about your web-page from my friend hardkik, chennai,i have read atleast 9 posts of yours by now, and let me tell you, your webpage gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a million once again, Regards, obiee training in hyderabad,informatica training in hyderabad

    SvarSlet
  12. Cloud is one of the tremendous technology that any company in this world would rely on(cloud computing training in chennai). Using this technology many tough tasks can be accomplished easily in no time. Your content are also explaining the same(Best Institute for Cloud Computing in Chennai). Thanks for sharing this in here. You are running a great blog, keep up this good work.

    SvarSlet
  13. Nice blog...Very useful information is providing by ur blog..here is a way to find Oracle Training In Chennai

    SvarSlet
  14. I have read your blog and I got very useful and knowledgeable information from your blog. It’s really a very nice article Greens Technologies Training In Chennai

    SvarSlet
  15. Excellent post, I agree with you 100%! I’m always scouring the oracle for new information and learning whatever I can, and in doing so I sometimes leave comments on blogs.Oracle Training In Chennai

    SvarSlet
  16. I have read this content it is very nice with unique content and keep updating us.
    Salesforce Training in Chennai | salesforce course in Chennai | FITA Velachery | FITA Training

    SvarSlet


  17. your blog is really good thanks for sharing those information it is really helpful and useful too.



    php Training in Chennai

    SvarSlet
  18. Helpful as always. Every post you write produce a massive value to your readers that is the only reason it is so popular and has great authority.
    Oracle Fusion Financials Online Training

    SvarSlet

  19. This was an nice and amazing and the given contents were very useful and the precision has given here is good.
    Selenium Training Institute in Chennai

    SvarSlet
  20. Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.


    MEAN stack training in Chennai

    MEAN stack training in bangalore

    MEAN stack training in tambaram

    MEAN stack training in annanagar

    MEAN stack training in Velachery

    MEAN stack training Sholinganallur

    SvarSlet
  21. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    Devops Training in Chennai

    Devops Training in Bangalore

    SvarSlet
  22. I simply want to give you a huge thumbs up for the great info you have got here on this post.
    python training institute in chennai
    python training in velachery
    python training institute in chennai


    SvarSlet
  23. That was a great message in my carrier, and It's wonderful commands like mind relaxes with understand words of knowledge by information's.

    java training in tambaram | java training in velachery

    java training in omr | oracle training in chennai

    SvarSlet
  24. Awesome post! A very good step-by-step guide especially for a beginner like me. It’s overwhelming with information, thank you for making it easy and very detailed.. I’ll pop some questions here, if I need help, hope that’s okay.
    Document Management Software
    Document Management Software India
    Document Management Software Chennai

    SvarSlet
  25. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article. thank you for sharing such a great blog with us.

    Data Science course in rajaji nagar | Data Science with Python course in chenni
    Data Science course in electronic city | Data Science course in USA
    Data science course in pune | Data science course in kalyan nagar


    SvarSlet
  26. This blog is more effective and it is very much useful for me.
    we need more information please keep update more.
    best python course in bangalore
    best python training bangalore
    Python Training in Vadapalani

    SvarSlet
  27. I would assume that we use more than the eyes to gauge a person's feelings. Mouth. Body language. Even voice. You could at least have given us a face in this test.

    angularjs Training in chennai
    angularjs Training in chennai

    angularjs-Training in tambaram

    angularjs-Training in sholinganallur

    angularjs-Training in velachery

    SvarSlet
  28. We are Offerining DevOps Training in Bangalore,Chennai, Pune using Class Room. myTectra offers Live Online DevOps Training Globally

    SvarSlet

  29. Microsoft CRM online is now converted to Microsoft Dynamic 365. I loved the old one as it was very easy to learn.;

    SvarSlet
  30. Denne kommentar er fjernet af forfatteren.

    SvarSlet
  31. I appreciate your efforts because it conveys the message of what you are trying to say. It's a great skill to make even the person who doesn't know about the subject could able to understand the subject . Your blogs are understandable and also elaborately described. I hope to read more and more interesting articles from your blog. All the best.

    Selenium training in Chennai | Selenium training institute in Chennai | Selenium course in Chennai

    Selenium training in Bangalore | Selenium training institute in Bangalore | Selenium course in Bangalore

    Selenium interview questions and answers

    Selenium training in Pune | Selenium training institute in Pune | Selenium course in Pune

    SvarSlet
  32. Actually i am searching information on AWS on internet. Just saw your blog on AWS and feeling very happy becauase i got all the information of AWS in a single blog. Not only the full information about AWS but the quality of data you provided about AWS is very good. The person who is looking for the quality information about AWS , its very helpful for that person.Thank you for sharing such a wonderful information on AWS .
    Thanks and Regards,
    aws solution architect training in chennai
    best aws training in chennai
    best aws training institute in chennai
    best aws training center in chennai
    aws best training institutes in chennai
    aws certification training in chennai
    aws training in velachery

    SvarSlet
  33. I really thank you for your innovative post.I have never read a creative ideas like your posts.here after i will follow your posts which is very much help for my career.
    Android Training Institutes in OMR
    Android Courses in T nagar
    Android Training in Ambattur
    android coaching in bangalore

    SvarSlet
  34. Amazing information,thank you for your ideas.after along time i have studied an interesting information's.we need more updates in your blog.
    best selenium training in bangalore
    selenium course in bangalore
    Selenium Training in Nungambakkam
    Selenium Training in Navalur

    SvarSlet
  35. I am really enjoying reading your well-written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    RPA courses in Chennai
    RPA Training Institute in Chennai
    Robotic Process Automation training in bangalore
    Robotics courses in bangalore
    RPA Training in Chennai

    SvarSlet
  36. your blog information's are really creative and It contains full of new innovative ideas.thank you for sharing with us.please update more data.
    best devops training in bangalore
    devops course in bangalore
    devops Training in Chennai Anna Nagar
    devops Course in Anna Nagar

    SvarSlet
  37. Thanks for your great and helpful presentation I like your good service. I always appreciate your post. That is very interesting I love reading and I am always searching for informative information like this.AngularJS Training in Chennai | Best AngularJS Training Institute in Chennai| AngularJS Training in Velachery |
    Angular4 Training Institute in Chennai

    SvarSlet
  38. Great Article, very useful information, thank you !!

    redbeardpress
    Guest posting sites

    SvarSlet
  39. Thanks for your post. This is excellent information. The list of your blogs is very helpful for those who want to learn, It is amazing!!! You have been helping many application.
    best selenium training in chennai | best selenium training institute in chennai selenium training in chennai | best selenium training in chennai | selenium training in Velachery

    SvarSlet
  40. Outstanding blog thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.

    best training insitute for machine learning
    best machine learning institutes in chennai
    top institutes for machine learning in chennai
    Android training in velachery
    PMP training in chennai

    SvarSlet
  41. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
    Selenium training in Chennai

    SvarSlet
  42. Very nice post here thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.
    artificial intelligence and machine learning course in chennai
    machine learning with python course in Chennai
    machine learning certification in chennai

    SvarSlet
  43. It's A Great Pleasure reading your Article, learned a lot of new things, we have to keep on updating it Mini Militia Pro Pack Hack Apk, Mini Militia hack Version Thanks for posting.

    SvarSlet
  44. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Telephony System
    Mobile Device
    ted

    SvarSlet
  45. Thanks for all information really awesome services in india level your packers and movers services is very useful for everyone great services keep update.
    java software development company
    hire java developer
    Java web development company
    Java development companies
    Java development companies
    java web development services

    SvarSlet
  46. Thanks for such a great article here. I was searching for something like this for quite a long time and at last, I’ve found it on your blog. It was definitely interesting for me to read about their market situation nowadays.angularjs best training center in chennai | angularjs training in velachery | angular 4 training in chennai | angularjs training in chennai

    SvarSlet
  47. Alot of blogs I see these days don't really provide anything that I'm interested in, but I'm most definitely interested in this one. Just thought that I would post and let you know. Nice! thank you so much! Thank you for sharing.
    honor mobile service center in chennai
    honor mobile service center
    honor mobile service centre in Chennai

    SvarSlet
  48. Amazing! I like to share it with all my friends and hope they will like this information.
    Regards,
    Python Training in Chennai | Python Programming Classes | Python Classes in Chennai

    SvarSlet
  49. Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
    Clinical SAS training in Chennai | Clinical SAS training institute in Chennai

    SvarSlet
  50. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live.
    IT Training Institute in KK nagar | angularjs training in chennai | angularjs course in chennai | angularjs training institute in chennai | angularjs training institutes in chennai

    SvarSlet


  51. Get the most advanced Hadoop Course by Professional expert. Just attend a FREE Demo session.
    call us @ 9884412301 | 9600112302
    Hadoop training in chennai | Hadoop training in velachery

    SvarSlet
  52. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Training in Chennai. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.citrix training in bangalore

    SvarSlet
  53. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly..

    apex tutorial

    SvarSlet
  54. Great post!I am actually getting ready to across this information,i am very happy to this commands.Also great blog here with all of the valuable information you have.Well done,its a great knowledge.IMSBI Training in Bangalore

    SvarSlet


  55. Great post.I really liked you article,your writing style is simply awesome with useful information. Best python certification course in Bangalore is offering Python training with 100% Placement assistance.Get certification under certified experts

    SvarSlet
  56. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..

    oracle erp training online

    SvarSlet
  57. Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. You’re doing a great job,Keep it up.

    Try Our Horoscope Reading In Toronto Services and Get All the benefits of it in your life, we make All your Personal problems solved in just minutes.

    SvarSlet
  58. Wow!! Really a nice Article. Thank you so much for your efforts. Definitely, it will be helpful for others. I would like to follow your blog. Share more like this. Thanks Again.
    AWS training in Chennai

    AWS Online Training in Chennai

    AWS training in Bangalore

    AWS training in Hyderabad

    AWS training in Coimbatore

    AWS training


    SvarSlet
  59. Thanks for sharing information awesome blog post Online Education Quiz website For Exam Follow this website Gk in Hindi

    SvarSlet
  60. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.i want to share about ibm websphere training .

    SvarSlet
  61. Denne kommentar er fjernet af forfatteren.

    SvarSlet
  62. I have really enjoyed reading your blog posts. This information is impressive. I am inspired with your post.
    DevOps Training in Chennai

    DevOps Course in Chennai

    SvarSlet

  63. ITS Wonderful,Pretty informative Blog, well summarized. If you're looking for THE BEST DIGITAL MARKETING AGENCY in chennai,
    I would recommend you to check out THE MAMMAL DIGITAL website.
    Mammal Digital

    Click here to know more

    SvarSlet
  64. Amazing opportunities came with amazing time and here is our institution offering you CS executive classes and a free of cost CSEET classes. So what are you waiting for contact us or visit our website at https://uniqueacademyforcommerce.com/

    SvarSlet
  65. This is an awesome post. Really very informative and creative content. These concept is a good way to enhance the knowledge. I likeed it. Thanks for this brief explanation and very nice information. Well, got a good knowledge. We are also providing the best services click on below links to visit our website.

    Oracle Fusion HCM Training
    Workday Training
    Okta Training
    Palo Alto Training
    Adobe Analytics Training

    SvarSlet
  66. hi thanku so much this information this blog is very useful
    cs executive
    freecseetvideolectures/

    SvarSlet
  67. Good Post. I like your blog. Thanks for Sharing.
    RHCE Certification Training

    SvarSlet
  68. If You Are Looking For A Reliable Fx Broker, Don't Rush And Read This XM REVIEW Review First. This Is A Serious Warning Against The Broker's Illegal Activities.

    SvarSlet
  69. AVATRADE REVIEW Is A Relatively New Forex Broker, Which Offers Its Customers A Wide Range Of Trading Opportunities. Read All The Facts About This Broker In This Detailed Fx Choice Review.

    SvarSlet
  70. Very Informative blog thank you for sharing. Keep sharing.

    Best software training institute in Chennai. Make your career development the best by learning software courses.

    best php training in chennai
    rpa training in chennai
    DevOps Training in Chennai
    cloud computing training in chennai
    Uipath training in chennai
    blue prism training institute in chennai
    microsoft azure training in chennai

    SvarSlet
  71. It’s always so sweet and also full of a lot of fun for me personally and
    my office colleagues to search your blog a minimum of thrice in a
    week to see the new guidance you have got.
    oracle dba training in Chennai
    best java training in Chennai
    node js certification training in Chennai

    SvarSlet
  72. I came across your blog and wanted to take a moment to express my appreciation for the quality of your content. Your writing is informative, insightful, and engaging, and I find myself returning to your blog time and time again for fresh perspectives on a variety of topics.
    How can I connect two computers with an Ethernet cable?

    SvarSlet