{"id":10120,"date":"2015-05-08T09:30:34","date_gmt":"2015-05-08T09:30:34","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=10120"},"modified":"2015-05-08T09:30:34","modified_gmt":"2015-05-08T09:30:34","slug":"use-open-xml-in-sage-crm-net-api","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/","title":{"rendered":"Use Open XML in Sage CRM .Net API"},"content":{"rendered":"

Sage CRM has made the functional development much easier by providing enhanced .Net API<\/strong> development kit with recent versions. Developers can use wide range of packages to build enhanced solutions for business needs with better flexibility.<\/p>\n

Related Post:<\/em><\/span>\u00a0<\/strong>Create log file using .net API<\/a><\/p>\n

In most of the implementations of Sage CRM, a common requirement which comes is to upload existing data in CRM. Well, we do have standard data upload utility for entities like Company, Person and Lead by default. But in case of custom entities, we need to write our own custom routines to upload the data using .Net API.<\/p>\n

Now, one of the well-known approaches to upload data is using Microsoft Interop Assembly<\/strong> which uses excel application object to perform required operations to import data. But this often leads to error, few of them are listed below.<\/p>\n

1.<\/strong> You need to make sure that version of assembly and version of excel installed on relevant machine are same.
\n2.<\/strong> Issues related to DCOM rights.<\/p>\n

To overcome all these issues, there is a simple and elegant way to use \u201cOpen XML\u201d.<\/strong> Open XML is a open file format which is related to Microsoft office application. Open XML document is actually represented by using a collection of related files, called Parts<\/strong> that are stored in a package. We need to include \u201cDocumentFormat.OpenXml<\/strong>\u201d assembly in our project.<\/p>\n

One of the main advantages is Open XML file formats ensure that data that is contained in documents can be accessed by any program that understands the file format. Another benefit is, there is no need to install Office Client Applications on server related environment.<\/p>\n

Also Read:<\/strong><\/span><\/em>
\n1.<\/strong> Save time with Case Suggestions on Customer Portal<\/a>
\n2.<\/strong> Troubleshooting Export to PDF issue with Sage CRM<\/a>
\n3.<\/strong> Managing Knowledge Base in the Self Service Portal<\/a>
\n4.<\/strong> Boost Knowledge Base with Download links in Customer Portal<\/a>
\n5.<\/strong> Confirm Button using .NET API<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Sage CRM has made the functional development much easier by providing enhanced .Net API development kit with recent versions. Developers can use wide range of packages to build enhanced solutions for business needs with better flexibility. Related Post:\u00a0Create log file using .net API In most of the implementations of Sage CRM, a common requirement which\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,122,125,332,1,440],"tags":[446,929,1609,1707],"class_list":["post-10120","post","type-post","status-publish","format-standard","hentry","category-net-api","category-document-sage-crm","category-dot-net","category-sage-crm","category-uncategorized","category-xml","tag-net-api","tag-dcom-2","tag-microsoft-interop-assembly","tag-open-xml"],"yoast_head":"\nUse Open XML in Sage CRM .Net API - 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\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use Open XML in Sage CRM .Net API - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage CRM has made the functional development much easier by providing enhanced .Net API development kit with recent versions. Developers can use wide range of packages to build enhanced solutions for business needs with better flexibility. Related Post:\u00a0Create log file using .net API In most of the implementations of Sage CRM, a common requirement which\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-08T09:30:34+00:00\" \/>\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\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/\",\"name\":\"Use Open XML in Sage CRM .Net API - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2015-05-08T09:30:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use Open XML in Sage CRM .Net API\"}]},{\"@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 & 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":"Use Open XML in Sage CRM .Net API - 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\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/","og_locale":"en_US","og_type":"article","og_title":"Use Open XML in Sage CRM .Net API - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Sage CRM has made the functional development much easier by providing enhanced .Net API development kit with recent versions. Developers can use wide range of packages to build enhanced solutions for business needs with better flexibility. Related Post:\u00a0Create log file using .net API In most of the implementations of Sage CRM, a common requirement which\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2015-05-08T09:30:34+00:00","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\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/","name":"Use Open XML in Sage CRM .Net API - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2015-05-08T09:30:34+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/05\/08\/use-open-xml-in-sage-crm-net-api\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Use Open XML in Sage CRM .Net API"}]},{"@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 & 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\/10120","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=10120"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/10120\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=10120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=10120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=10120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}