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.

132 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. Arrowsol Training offers on online Learning courses and manuals are optimized to help you and your team gain in-depth knowledge of your deployment
    Microsoft Dynamics Training | Microsoft Dynamics online Training | Microsoft Dynamics Training online

    SvarSlet
  4. 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
  5. 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
  6. 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
  7. Pinga solutions is the no 1 software providing company in Delhi Ncr that's providing online CRM software, payment collection software, Construction management software, construction erp with affordable price.Customer can choose and purchase online crm software,real estate software,payment collection software,Construction management software etc.
    Online CRM Software

    SvarSlet
  8. Thanks for updating new information about CRM. As an application developer you have shared lot of details about CRM. Also share your updated details about cloud in this website.
    Cloud computing training in Chennai

    SvarSlet
  9. 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
  10. 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
  11. 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
  12. 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
  13. Your blog is really nice and informative. Thanks for sharing this post. Keep posting..

    Regards..
    Salesforce Training in Chennai

    SvarSlet
  14. There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this.

    SvarSlet
  15. 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
  16. 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
  17. There are lots of information about latest technology and how to get trained in them, like Big Data Training in Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Big Data Training). By the way you are running a great blog. Thanks for sharing this.

    Hadoop Training in Chennai | Big Data Training in Chennai

    SvarSlet
  18. There are lots of information about latest technology and how to get trained in them, like Best Hadoop Training In Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies Hadoop Training in Chennai By the way you are running a great blog. Thanks for sharing this blogs..

    SvarSlet
  19. I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
    SalesForce Training in Chennai

    SvarSlet
  20. 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..
    Unix Training In Chennai

    SvarSlet
  21. This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks
    for taking the time to discuss this, I feel happy about it and I love learning more about this topic
    Android Training In Chennai In Chennai

    SvarSlet
  22. I have read your blog and i got a very useful and knowledgeable information from your blog.You have done a great job.
    SAP Training in Chennai

    SvarSlet
  23. Oracle Training in chennai
    Thanks for sharing such a great information..Its really nice and informative..

    SvarSlet
  24. Selenium Training in Chennai
    Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

    SvarSlet
  25. Data warehousing Training in Chennai
    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..

    SvarSlet
  26. Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
    Websphere Training in Chennai

    SvarSlet
  27. Oracle DBA Training in Chennai
    Thanks for sharing this informative blog. I did Oracle DBA Certification in Greens Technology at Adyar. This is really useful for me to make a bright career..

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

    SvarSlet
  29. i wondered keep share this sites .if anyone wants realtime training Greens technolog chennai in Adyar visit this blog..performance tuning training In Chennai and more Oracle Training In Chennai

    SvarSlet
  30. once again sharing this informative blog .Datastage training In Chennai It uses a graphical notation to construct data integration solutions and is available in various versions may visit greens technology chennai in adyar Greens Technologys Training In Chennai

    SvarSlet
  31. i gain the knowledge of Java programs easy to add functionalities play online games, chating with others and industry oriented coaching available from greens technology chennai in Adyar may visit.Core java training In Chennai

    SvarSlet
  32. 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
  33. fantastic presentation .We are charging very competitive in the market which helps to bring more oracle professionals into this market. may update this blog . Oracle training In Chennai which No1:Greens Technologies In Chennai

    SvarSlet
  34. 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
  35. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..
    Selenium Training in Chennai

    SvarSlet
  36. Thanks for Information Oracle Apps Technical is a collection of a bunch of collected applications like accounts payables, purchasing, inventory, accounts receivables, human resources, order management, general ledger and fixed assets, etc which have its own functionality for serving the business
    Oracle Apps Training In Chennai

    SvarSlet
  37. Oracle Training in chennai | Oracle D2K Training In chennai
    This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..

    SvarSlet
  38. Excellent information with unique content and it is very useful to know about the information based on blogs.
    Hadoop Training In Chennai | oracle apps financials Training In Chennai | advanced plsql Training In Chennai

    SvarSlet
  39. 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


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



    php Training in Chennai

    SvarSlet
  41. Wonderful bloggers like yourself who would positively reply encouraged me to be more open and engaging in commenting.So know it's helpful.

    digital marketing company in india

    SvarSlet
  42. Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving..
    iOS Training in Chennai
    Android Training in Chennai
    php Training in Chennai

    SvarSlet
  43. Very Nice Blog I like the way you explained these things.
    LOCAL BUSINESS DIRECTORY

    SvarSlet
  44. GREEN WOMEN HOSTELGreen Women hostel is one of the leading Ladies hostel in Adyar and we serving an excellent service to Staying people, We create a home atmosphere, it is the best place for Working WomenOur hostel Surrounded around bus depot, hospital, atm, bank, medical Shop & 24 hours Security Facility



    SvarSlet
  45. 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
  46. Its really an Excellent post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog. Thanks for sharing....

    Carwash in omr
    usedcars in omr
    automotors in omr
    car accessories in omr
    secondhand car in omr

    SvarSlet

  47. 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
  48. 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
  49. 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
  50. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.

    rpa training in Chennai | rpa training in pune

    rpa training in tambaram | rpa training in sholinganallur

    rpa training in Chennai | rpa training in velachery

    rpa online training | rpa training in bangalore

    SvarSlet
  51. 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
  52. 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
  53. 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
  54. 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
  55. 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
  56. 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
  57. We are Offerining DevOps Training in Bangalore,Chennai, Pune using Class Room. myTectra offers Live Online DevOps Training Globally

    SvarSlet
  58. The blog is well written and Thanks for your information. Java is one of the widely accepted language. The reason is it's features and it is platform independent.
    Advanced JAVA Training
    JAVA Training Classes
    Core JAVA Certification
    JAVA Language Course
    Core JAVA Course

    SvarSlet
  59. Awwsome informative blog ,Very good information thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.
    Aviation Academy in Chennai | Aviation Courses in Chennai | Best Aviation Academy in Chennai | Aviation Institute in Chennai | Aviation Training in Chennai

    SvarSlet
  60. Good job in presenting the correct content with the clear explanation. The content looks real with valid information. Good Work

    DevOps is currently a popular model currently organizations all over the world moving towards to it. Your post gave a clear idea about knowing the DevOps model and its importance.

    Good to learn about DevOps at this time.


    devops training in chennai | devops training in chennai with placement | devops training in chennai omr | devops training in velachery | devops training in chennai tambaram | devops institutes in chennai | devops certification in chennai

    SvarSlet
  61. Good job in presenting the correct content with the clear explanation. The content looks real with valid information. Good Work

    DevOps is currently a popular model currently organizations all over the world moving towards to it. Your post gave a clear idea about knowing the DevOps model and its importance.

    Good to learn about DevOps at this time.


    devops training in chennai | devops training in chennai with placement | devops training in chennai omr | devops training in velachery | devops training in chennai tambaram | devops institutes in chennai | devops certification in chennai

    SvarSlet

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

    SvarSlet
  63. 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..
    Spoken English Classes in Bangalore
    Spoken English Class in Chennai
    Spoken English Training in Bangalore
    English Coaching Classes in Chennai
    Spoken English Class in Bangalore
    Spoken English classes in Chennai
    English Speaking Course in Bangalore

    SvarSlet
  64. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.
    rpa training in chennai
    rpa training in bangalore
    rpa course in bangalore
    best rpa training in bangalore
    rpa online training

    SvarSlet
  65. When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.

    AWS Interview Questions And Answers

    AWS Training in Chennai | Best AWS Training in Chennai

    AWS Training in Pune | Best Amazon Web Services Training in Pune

    SvarSlet
  66. Denne kommentar er fjernet af forfatteren.

    SvarSlet
  67. Hey, Wow all the posts are very informative for the people who visit this site. Good work! We also have a Website. Please feel free to visit our site. Thank you for sharing.Well written article Thank You Sharing with Us pmp training Chennai | pmp training centers in Chennai | pmp training institutes in Chennai | pmp training and certification in Chennai | pmp training in velachery

    SvarSlet
  68. Your post is really awesome. Your blog is really helpful for me to develop my skills in a right way. Thanks for sharing this unique information with us.
    - Learn Digital Academy

    SvarSlet
  69. 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. Well written article Thank You for Sharing with Us pmp training courses online | pmp training fee | project management training certification | project management training in chennai | project management certification online |

    SvarSlet
  70. Thanks a lot for sharing us about this update. Hope you will not get tired on making posts as informative as this. 
    Python training in bangalore
    Python course in pune
    Python training in bangalore

    SvarSlet
  71. 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
  72. 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
  73. 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
  74. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    Online DevOps Certification Course - Gangboard
    Best Devops Training institute in Chennai

    SvarSlet
  75. 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
  76. 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
  77. 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
  78. 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
  79. 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
  80. Great Article, very useful information, thank you !!

    redbeardpress
    Guest posting sites

    SvarSlet
  81. 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
  82. 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
  83. Such a Great Article!! I learned something new from your blog. Amazing stuff. I would like to follow your blog frequently. Keep Rocking!!
    Blue Prism training in chennai | Best Blue Prism Training Institute in Chennai

    SvarSlet
  84. 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
  85. 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.
    iot training in Chennai | Best iot Training Institute in Chennai

    SvarSlet
  86. 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
  87. When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.
    Amazon Web Services Training in Pune | Best AWS Training in Pune
    AWS Online Training | Online AWS Certification Course - Gangboard
    Top 110 AWS Interview Question and Answers | Advanced AWS interview Questions and Answers – AWS jobs

    SvarSlet
  88. 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.
    machine learning training center in Chennai
    machine learning training in velachery
    machine learning certification course in Chennai
    Android training in chennai
    PMP training in chennai

    SvarSlet
  89. You rock particularly for the high caliber and results-arranged offer assistance. I won't reconsider to embrace your blog entry to anyone who needs and needs bolster about this region.
    iosh safety course in chennai

    SvarSlet
  90. Some us know all relating to the compelling medium you present powerful steps on this blog and therefore strongly encourage
    contribution from other ones on this subject while our own child is truly discovering a great deal.
    Have fun with the remaining portion of the year.

    Selenium training in bangalore | best selenium training in bangalore

    SvarSlet