{"id":289,"date":"2011-01-06T09:48:00","date_gmt":"2011-01-06T09:48:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=289"},"modified":"2023-10-06T09:18:40","modified_gmt":"2023-10-06T09:18:40","slug":"data-upload-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/","title":{"rendered":"Data Upload in Sage CRM"},"content":{"rendered":"<p style=\"text-align: justify;\">Few years back most of the organizations maintained their employees, customers, leads, prospects etc details in an excel file for their reference. Then Sage introduced an advance application called <strong>Customer Relationship Management<\/strong> (CRM). Sage CRM provided users a platform to maintain their new information in the structured and well formed way.<\/p>\n<p style=\"text-align: justify;\">In CRM user can make manual entries like new companies, persons etc and use them. But some of the companies still maintain their data in the excel sheet and then make the entries manually in the CRM. For those users CRM has provided a feature of <strong>Data Upload<\/strong>. In standard CRM we can upload Companies, Persons and Leads data.<\/p>\n<p style=\"text-align: justify;\">But have you ever come across an error like \u201cData Headers are not too long\u2026.\u201d in the standard upload? As shown below:<\/p>\n<div class=\"separator\" style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s1600\/clip_image002.jpg\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone\" src=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s320\/clip_image002.jpg\" alt=\"Data Headers are not too long error\" width=\"701\" height=\"46\" border=\"0\" \/><\/a><\/div>\n<p>If yes then you can try the below steps to resolve the same.<br \/>\n1) Go to Start | Run.<br \/>\n2) Enter dcomcnfg and click OK button.<br \/>\n3) Go to Component Services | Computer | My Computer | DCOM Config |Microsoft Excel Application (refer the below screenshot)<\/p>\n<div class=\"separator\" style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNwpaHUSI\/AAAAAAAABPI\/_YhMQr5A_wM\/s1600\/clip_image003.jpg\" target=\"_blank\" rel=\"noopener\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone\" src=\"http:\/\/1.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNwpaHUSI\/AAAAAAAABPI\/_YhMQr5A_wM\/s320\/clip_image003.jpg\" alt=\"Component services Tab\" width=\"320\" height=\"230\" border=\"0\" \/><\/a><\/div>\n<p>4) Right Click on Microsoft Excel Application and Select Properties<br \/>\n5) Go to Security tab<br \/>\n6) Go to Launch and Activation Permissions.<br \/>\n7) Select Customize radio button and click on Edit button.<br \/>\n8) Set user (e.g Everyone) access rights. (Refer the below screenshot)<br \/>\n9) Follow the steps #6, #7, #8 for the Access Permissions section.<br \/>\n10) Run the iisreset command.<\/p>\n<div class=\"separator\" style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWN4WnfFdI\/AAAAAAAABPQ\/CtmiIQIi_c0\/s1600\/clip_image004.jpg\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone\" src=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWN4WnfFdI\/AAAAAAAABPQ\/CtmiIQIi_c0\/s320\/clip_image004.jpg\" alt=\"Ms Excel application Properties\" width=\"286\" height=\"320\" border=\"0\" \/><\/a><\/div>\n<p style=\"text-align: justify;\">For queries regarding the functionality, please feel free to drop us an email at <a title=\"mailto:crm@greytrix.com\" href=\"mailto:crm@greytrix.com\">crm@greytrix.com<\/a>.<\/p>\n<p><strong>About Us<\/strong><\/p>\n<p style=\"text-align: justify;\">Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0has some unique integration solutions for Sage CRM with Sage ERP\u2019s (<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage X3<\/a>,\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100<\/a>,\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-500-erp-integration\">Sage 500<\/a>\u00a0and\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-300-erp-integration\">Sage 300<\/a>).We also offer best-in-class\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\">Sage ERP<\/a> and <a href=\"http:\/\/www.greytrix.com\/product\/crm-development\/sage-crm\">Sage CRM<\/a> customization and development services\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users and Sage PSG worldwide. <a href=\"http:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0helps in\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/act-sage-crm-migration\">migrating to Sage CRM from ACT<\/a>,\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/goldmine-sage-crm-migration\">Goldmine<\/a>\u00a0and other CRM\u2019s.<\/p>\n<p style=\"text-align: justify;\">For more information on our integration solutions, please contact us at\u00a0<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Few years back most of the organizations maintained their employees, customers, leads, prospects etc details in an excel file for their reference. Then Sage introduced an advance application called Customer Relationship Management (CRM). Sage CRM provided users a platform to maintain their new information in the structured and well formed way. In CRM user can\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[332],"tags":[833,916,919,1450],"class_list":["post-289","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-crm7-0","tag-data-upload","tag-data-upload-in-sage-crm","tag-invalid-varient-operation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Upload in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Upload in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Few years back most of the organizations maintained their employees, customers, leads, prospects etc details in an excel file for their reference. Then Sage introduced an advance application called Customer Relationship Management (CRM). Sage CRM provided users a platform to maintain their new information in the structured and well formed way. In CRM user can\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2011-01-06T09:48:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-06T09:18:40+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s320\/clip_image002.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/\",\"name\":\"Data Upload in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s320\/clip_image002.jpg\",\"datePublished\":\"2011-01-06T09:48:00+00:00\",\"dateModified\":\"2023-10-06T09:18:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#primaryimage\",\"url\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s320\/clip_image002.jpg\",\"contentUrl\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s320\/clip_image002.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Upload in Sage CRM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Upload in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Data Upload in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Few years back most of the organizations maintained their employees, customers, leads, prospects etc details in an excel file for their reference. Then Sage introduced an advance application called Customer Relationship Management (CRM). Sage CRM provided users a platform to maintain their new information in the structured and well formed way. In CRM user can\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2011-01-06T09:48:00+00:00","article_modified_time":"2023-10-06T09:18:40+00:00","og_image":[{"url":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s320\/clip_image002.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/","name":"Data Upload in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s320\/clip_image002.jpg","datePublished":"2011-01-06T09:48:00+00:00","dateModified":"2023-10-06T09:18:40+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#primaryimage","url":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s320\/clip_image002.jpg","contentUrl":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/TSWNmZn_7FI\/AAAAAAAABPA\/BfbrDQJ2qjI\/s320\/clip_image002.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2011\/01\/06\/data-upload-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Data Upload in Sage CRM"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=289"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/289\/revisions"}],"predecessor-version":[{"id":27886,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/289\/revisions\/27886"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}