{"id":250,"date":"2010-08-23T05:34:00","date_gmt":"2010-08-23T05:34:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=250"},"modified":"2010-08-23T05:34:00","modified_gmt":"2010-08-23T05:34:00","slug":"fop-shell-command","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/","title":{"rendered":"FOP shell command"},"content":{"rendered":"

Apache FOP is the tool being used in Standard CRM installation to generate the PDF reports. The phenomenon works on the basis of Extended Style sheet Transformation methodology. We had posted the detailed information on this topic before. Please go through the below link to refer the same.<\/p>\n

http:\/\/sagecrmaddons.blogspot.com\/2009\/07\/file-to-pdf-conversion-using-fop.html<\/a><\/p>\n

As per the block diagram in above post, we need to provide XML file as well as style sheet file as input to FOP server and apply fonts level styling to achieve the output in PDF format. There is java command that we can run at command prompt to achieve this. Now as this is command being run on windows level how feasible it is to make it work on web level. Yes, this can be achieved using Shell object of WScript. The below example explains how to achieve the same in ASP.<\/p>\n

Asp code :<\/strong><\/p>\n

var xslcompletestylesheetpath=”“;
var xmlfullpath=”“;
var pdffullpath=”“<\/p>\n

\/\/Intialize string for Java command
var javastr=””;<\/p>\n

\/\/’Create object of shell command
var oShell=new ActiveXObject(“WScript.Shell”);<\/p>\n

\/\/’Create a string to be passed to FOP
javastr = “java -Xmx128m -cp C:\\PROGRA~1\\FOP\\build\/fop.jar;”
javastr += “C:\\PROGRA~1\\FOP\\lib\\xml-apis.jar;”
javastr += “C:\\PROGRA~1\\FOP\\lib\\xercesImpl-2.2.1.jar;”
javastr += “C:\\PROGRA~1\\FOP\\lib\\xalan-2.4.1.jar;”
javastr += “C:\\PROGRA~1\\FOP\\lib\\batik.jar;”
javastr += “C:\\PROGRA~1\\FOP\\lib\\avalon-framework-cvs-20020806.jar org.apache.fop.apps.Fop”
javastr += ” -xsl “”+ xslcompletestylesheetpath + “” -xml “”+ xmlfullpath + “” -pdf “” + pdffullpath +”””
javastr += ” -c C:\\Progra~1\\FOP\\conf\/userconfig.xml” <\/p>\n

\/\/’Run shell command to generate PDF from fop
var intReturn1 = oShell.run(javastr,3,true)
The good thing here is, the conversion takes place on CRM server side that too in silent mode. Only thing you need to have is the XML and FOP based style sheet file to be passed as an input to FOP server. These are required to achieve the required XSL transformation.<\/p>\n

Happy scripting!! \ud83d\ude42<\/p>\n

If you find this content useful, please feel free to drop us an email at crm@greytrix.com<\/a>. <\/b><\/marquee><\/p>\n","protected":false},"excerpt":{"rendered":"

Apache FOP is the tool being used in Standard CRM installation to generate the PDF reports. The phenomenon works on the basis of Extended Style sheet Transformation methodology. We had posted the detailed information on this topic before. Please go through the below link to refer the same. http:\/\/sagecrmaddons.blogspot.com\/2009\/07\/file-to-pdf-conversion-using-fop.html As per the block diagram in\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":[1],"tags":[1120,1753,1920,2366],"class_list":["post-250","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-exportexport-to-pdf","tag-pdf","tag-report","tag-summary-report"],"yoast_head":"\nFOP shell command - 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\/2010\/08\/23\/fop-shell-command\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FOP shell command - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Apache FOP is the tool being used in Standard CRM installation to generate the PDF reports. The phenomenon works on the basis of Extended Style sheet Transformation methodology. We had posted the detailed information on this topic before. Please go through the below link to refer the same. http:\/\/sagecrmaddons.blogspot.com\/2009\/07\/file-to-pdf-conversion-using-fop.html As per the block diagram in\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2010-08-23T05:34:00+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\/2010\/08\/23\/fop-shell-command\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/\",\"name\":\"FOP shell command - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"datePublished\":\"2010-08-23T05:34:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FOP shell command\"}]},{\"@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":"FOP shell command - 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\/2010\/08\/23\/fop-shell-command\/","og_locale":"en_US","og_type":"article","og_title":"FOP shell command - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Apache FOP is the tool being used in Standard CRM installation to generate the PDF reports. The phenomenon works on the basis of Extended Style sheet Transformation methodology. We had posted the detailed information on this topic before. Please go through the below link to refer the same. http:\/\/sagecrmaddons.blogspot.com\/2009\/07\/file-to-pdf-conversion-using-fop.html As per the block diagram in\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2010-08-23T05:34:00+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\/2010\/08\/23\/fop-shell-command\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/","name":"FOP shell command - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"datePublished":"2010-08-23T05:34:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2010\/08\/23\/fop-shell-command\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"FOP shell command"}]},{"@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\/250","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=250"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/250\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}