Generating HTML Output from xFusion

Author: Sheetal Dehadaraya, Software Labs Inc.

xFusion Studio 3.0 has a new integration utility to transform source data into HTML format. As per your requirement you can easily view or share your source data in HTML format. Here is some sample HTML data.




HTML processing from integration function supports three ways of viewing your data in HTML format –

1. Display – Opens a new window displaying your HTML formatted data.
   
   Here is an example in C# -
   
   IntegrationUtils.Initialize(theEngine);
IDataCachedTable tbl = theEngine.GetQuery("InTable");
HtmlTable ht = new HtmlTable(tbl);
ht.Display();
   
   
2. Save – Saves your data in a file in HTML format.
   
   Here is an example in C# -
   
   IntegrationUtils.Initialize(theEngine);
IDataCachedTable tbl = theEngine.GetQuery("InTable");
HtmlTable ht = new HtmlTable(tbl);
ht.Save(@"%FPDIR%\Final.htm");
   
   
3. SendEmail – Allows you to email your data in HTML format.
   
   Here is an example in C# -
   
   IntegrationUtils.Initialize(theEngine);
IDataCachedTable tbl = theEngine.GetQuery("InTable");
HtmlTable ht = new HtmlTable(tbl);
ht.SendMail("test@test.com", "test@test.com", null, "Sending HTML file from xFusion", "mail.test.com");
   
   

1. Create a query in xFusion Studio.
2. Right mouse click on the query node in the dataflow UI.
3. Select the Quick Export option and choose HTML from the drop down list.
4. Specify the file path and press F5 to the run the export and generate a .htm file.