{"id":86,"date":"2012-08-10T22:58:48","date_gmt":"2012-08-10T22:58:48","guid":{"rendered":"http:\/\/tregner.com\/flare-blog\/?p=86"},"modified":"2012-10-11T00:12:24","modified_gmt":"2012-10-11T00:12:24","slug":"use-xslt-to-create-a-flare-topic-from-xml-data","status":"publish","type":"post","link":"https:\/\/tregner.com\/flare-blog\/use-xslt-to-create-a-flare-topic-from-xml-data\/","title":{"rendered":"Use XSLT to create a Flare Topic from XML Data"},"content":{"rendered":"

XSLT is language for transforming XML documents. The World Wide Web Consortium (W3C) published XSL Transformations (XSLT)<\/p>\n

Version 1.0 as recommendation in 1999 and XSL Transformations (XSLT) Version 2.0 in 2007. The W3C recommendations are posted at:<\/p>\n

http:\/\/www.w3.org\/TR\/xslt\/<\/a><\/p>\n

http:\/\/www.w3.org\/TR\/xslt20\/<\/a><\/p>\n

If you are lucky enough to have information housed as XML, you are just one transformation away from a Flare topic.\u00a0XSLT can be used to create XHTML files from XML files. Suppose you have this XML:<\/p>\n

\n
<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<root>\r\n  <jellybeans>\r\n    <jellybean>\r\n      <flavor>coffee<\/flavor>\r\n      <color>brown<\/color>\r\n    <\/jellybean>\r\n    <jellybean>\r\n      <flavor>orange<\/flavor>\r\n      <color>orange<\/color>\r\n    <\/jellybean>\r\n    <jellybean>\r\n      <flavor>mint<\/flavor>\r\n      <color>green<\/color>\r\n    <\/jellybean>\r\n  <\/jellybeans>\r\n<\/root><\/pre>\n<\/div>\n
You can use XSLT\u00a0to create this Flare topic:<\/p>\n
\n
<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<html xmlns:MadCap=\"http:\/\/www.madcapsoftware.com\/Schemas\/MadCap.xsd\">\r\n  <head \/>\r\n  <body>\r\n    <h1>Jellybeans<\/h1>\r\n    <p>This is the Jellybeans table generated with an XML transformation.<\/p>\r\n    <table style=\"width: 100%;border-collapse: separate;\">\r\n      <caption>Jellybeans<\/caption>\r\n      <col style=\"width: 33%;\" \/>\r\n      <col style=\"width: 33%;\" \/>\r\n      <thead>\r\n        <tr>\r\n          <th>Flavor<\/th>\r\n          <th>Color<\/th>\r\n        <\/tr>\r\n      <\/thead>\r\n      <tbody>\r\n        <tr>\r\n          <td>coffee<\/td>\r\n          <td>brown<\/td>\r\n        <\/tr>\r\n        <tr>\r\n          <td>orange<\/td>\r\n          <td>orange<\/td>\r\n        <\/tr>\r\n        <tr>\r\n          <td>mint<\/td>\r\n          <td>green<\/td>\r\n        <\/tr>\r\n      <\/tbody>\r\n    <\/table>\r\n  <\/body>\r\n<\/html><\/pre>\n<\/div>\n
The XSLT used is:<\/p>\n
\n
<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<xsl:stylesheet version=\"1.0\" xmlns:xsl=\"http:\/\/www.w3.org\/1999\/XSL\/Transform\"\r\n    xmlns:msxsl=\"urn:schemas-microsoft-com:xslt\" exclude-result-prefixes=\"msxsl\"\r\n>\r\n    <xsl:output method=\"xml\" indent=\"yes\"\/>\r\n\r\n    <xsl:template match=\"root\/jellybeans\">\r\n       <html xmlns:MadCap=\"http:\/\/www.madcapsoftware.com\/Schemas\/MadCap.xsd\">\r\n        <head>\r\n        <\/head>\r\n        <body>\r\n          <h1>Jellybeans<\/h1>\r\n          <p>This is the Jellybeans table generated with an XML transformation.<\/p>\r\n          <table style=\"width: 100%;border-collapse: separate;\">\r\n            <caption>Jellybeans<\/caption>\r\n            <col style=\"width: 33%;\" \/>\r\n            <col style=\"width: 33%;\" \/>\r\n            <thead>\r\n              <tr>\r\n                <th>Flavor<\/th>\r\n                <th>Color<\/th>\r\n              <\/tr>\r\n            <\/thead>\r\n            <tbody>\r\n              <xsl:for-each select=\"jellybean\">\r\n                <tr>\r\n                  <td>\r\n                    <xsl:value-of select=\"flavor\"\/>\r\n                  <\/td>\r\n                  <td>\r\n                    <xsl:value-of select=\"color\"\/>\r\n                  <\/td>\r\n                <\/tr>\r\n              <\/xsl:for-each>\r\n            <\/tbody>\r\n          <\/table>\r\n        <\/body>\r\n      <\/html>\r\n    <\/xsl:template>\r\n<\/xsl:stylesheet><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
XSLT is language for transforming XML documents. The World Wide Web Consortium (W3C) published XSL Transformations (XSLT) Version 1.0 as recommendation in 1999 and XSL Transformations (XSLT) Version 2.0 in 2007. The W3C recommendations are posted at: http:\/\/www.w3.org\/TR\/xslt\/ http:\/\/www.w3.org\/TR\/xslt20\/ If you are lucky enough to have information housed as XML, you are just one transformation… Continue reading Use XSLT to create a Flare Topic from XML Data<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[41],"_links":{"self":[{"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/posts\/86"}],"collection":[{"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/comments?post=86"}],"version-history":[{"count":3,"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/posts\/86\/revisions"}],"predecessor-version":[{"id":665,"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/posts\/86\/revisions\/665"}],"wp:attachment":[{"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/media?parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/categories?post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tregner.com\/flare-blog\/wp-json\/wp\/v2\/tags?post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}