{"id":6098,"date":"2013-12-21T13:29:40","date_gmt":"2013-12-21T13:29:40","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=6098"},"modified":"2024-12-13T05:43:06","modified_gmt":"2024-12-13T05:43:06","slug":"xml-based-fusion-charts-in-com-api","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/","title":{"rendered":"XML based Fusion charts in COM API"},"content":{"rendered":"

Fusion charts component added to SageCRM improves the overall visual experience of reports. We can display fusion charts on dashboards too. There are already methods explained in Developer guide to build the charts using API methods. In this blog I will explain how we can use fusion widget xml to build the chart and display it using COM API ASP.
\nYou can get xml syntax for all fusion chart widgets here.
\nRelated Post :<\/strong><\/em><\/span>\u00a0View Real-time Sage 100 data charts on GUMU Dashboard in Sage CRM
\nLet\u2019s consider that we want to display the bar chart for forecast achieved in current quarter. Now let us create our xml data source in one file named data.xml<\/b> as follows. This is just the hardcoded xml which we are picking up from file. If you want you can write logic in your ASP page to generate this xml and pass it to charting logic.
\n<chart showBorder=”1″ imageSave=”1″ numberPrefix=”$” caption=”Forecast Achieved in Current Quarter”><\/i>
\n\u00a0 <set label=”October” value=”5000″ \/><\/i>
\n\u00a0 <set label=”November” value=”3000″ \/><\/i>
\n\u00a0 <set label=”December” value=”9000″ \/><\/i>
\n<\/chart><\/i>
\n\u00a0<\/i>Before moving forward please ensure that FusionCharts.asp<\/b>, FusionCharts.js<\/b> and the above Data.xml<\/b> files are placed inside the FusionCharts<\/b> folder under WWWRoot<\/b>.
\nFollow the below steps to call the Data.xml<\/b> file using COM API ASP.
\n1. Create one ASP page (For e.g. Fusion.asp<\/b>) and include \u201cFusionCharts.asp<\/b>\u201d page in the same using following syntax.
\n<!– #INCLUDE FILE=”..\\FusionCharts\\FusionCharts.asp”–><\/i>
\n2. <\/i>Include \u201cFusionCharts.js<\/b>\u201d file using following syntax.
\n<HTML><\/i>
\n\u00a0\u00a0 <HEAD><\/i>
\n\u00a0\u00a0\u00a0 <SCRIPT LANGUAGE=”Javascript” SRC=”..\/FusionCharts\/FusionCharts.js”><\/SCRIPT><\/i>
\n\u00a0 <\/HEAD><\/i>
\n<BODY><\/i>
\n\u00a0<\/i>Call below function to render fusion chart.
\n3. Call renderChart(“..\/FusionCharts\/Column3D.swf”, “..\/FusionCharts\/Chart.xml”, “”, “myFirst”,”100%”, “100%”, false, false)<\/i>
\n4.<\/i>Create another asp page through which we will call our above Fusion.asp<\/b> page to display Fusion chart in iframe<\/b>. Please refer following syntax.
\n\/\/’Get block\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/i>
\nblkContent = eWare.GetBlock(“Content”);<\/i>
\nvar ChartURL = eWare.URL(“Fusion.asp”);<\/i>
\n\u00a0<\/i>blkContent.Contents = “<iframe src='”+ChartURL+”‘ id=framechart name=framechart width=800 height=600 frameBorder=0><\/iframe>”<\/i>
\n\u00a0<\/i>\/\/’Add block to container<\/i>
\nwith (ocontainer)<\/i>
\n{<\/i>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AddBlock(blkContent);<\/i>
\n}<\/i>
\n\u00a0<\/i>\/\/’Execute container<\/i>
\neWare.AddContent(ocontainer.Execute());
\nBy following above steps fusion chart will looks like as follows.
\n\"Fusion\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Fusion charts component added to SageCRM improves the overall visual experience of reports. We can display fusion charts on dashboards too. There are already methods explained in Developer guide to build the charts using API methods. In this blog I will explain how we can use fusion widget xml to build the chart and display\u2026 Read More »<\/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":[2,29,54,332,346],"tags":[663,907,1189],"class_list":["post-6098","post","type-post","status-publish","format-standard","hentry","category-net-api","category-asp","category-chart-sage-crm","category-sage-crm","category-sales-funnel","tag-charts","tag-dashboard","tag-fusion-charts"],"yoast_head":"\nXML based Fusion charts in COM 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\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"XML based Fusion charts in COM API - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Fusion charts component added to SageCRM improves the overall visual experience of reports. We can display fusion charts on dashboards too. There are already methods explained in Developer guide to build the charts using API methods. In this blog I will explain how we can use fusion widget xml to build the chart and display\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-21T13:29:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-13T05:43:06+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/Fusion.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\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/\",\"name\":\"XML based Fusion charts in COM API - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/Fusion.jpg\",\"datePublished\":\"2013-12-21T13:29:40+00:00\",\"dateModified\":\"2024-12-13T05:43:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/Fusion.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/Fusion.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"XML based Fusion charts in COM 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":"XML based Fusion charts in COM 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\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/","og_locale":"en_US","og_type":"article","og_title":"XML based Fusion charts in COM API - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Fusion charts component added to SageCRM improves the overall visual experience of reports. We can display fusion charts on dashboards too. There are already methods explained in Developer guide to build the charts using API methods. In this blog I will explain how we can use fusion widget xml to build the chart and display\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2013-12-21T13:29:40+00:00","article_modified_time":"2024-12-13T05:43:06+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/Fusion.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\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/","name":"XML based Fusion charts in COM API - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/Fusion.jpg","datePublished":"2013-12-21T13:29:40+00:00","dateModified":"2024-12-13T05:43:06+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/Fusion.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2013\/12\/Fusion.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2013\/12\/21\/xml-based-fusion-charts-in-com-api\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"XML based Fusion charts in COM 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\/6098","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=6098"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/6098\/revisions"}],"predecessor-version":[{"id":28978,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/6098\/revisions\/28978"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=6098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=6098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=6098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}