XML Transform (Activity) - Revision history

Dgreenwood: /* About */

2025-07-01T18:31:23Z

About

← Older revision		Revision as of 13:31, 1 July 2025
Line 13:		Line 13:
	# Configure the "XML Transform" setting. This is where your XSLT goes (Supports XSLT 1.0 syntax only).		# Configure the "XML Transform" setting. This is where your XSLT goes (Supports XSLT 1.0 syntax only).
	#* You can paste the XSLT directly in this property's editor.		#* You can paste the XSLT directly in this property's editor.
	#* Or, you can use an XML Transform step's "XSLT Editor" tab to edit and the XSLT. The XSLT you save in the XSLT Editor will be saved to the XML Transform setting.		#* Or, you can use an XML Transform step's "XSLT Editor" tab to edit and test the XSLT. The XSLT you save in the XSLT Editor will be saved to the XML Transform setting.
	#**<li class="fyi-bullet"> You can use the "[[AI_Productivity_Helpers#AI_XML_Transform_Helper:_Get_help_making_XSLT_transforms\|AI XML Transform Helper]]" to get help making an XSLT from an AI.		#**<li class="fyi-bullet"> You can use the "[[AI_Productivity_Helpers#AI_XML_Transform_Helper:_Get_help_making_XSLT_transforms\|AI XML Transform Helper]]" to get help making an XSLT from an AI.
	# Configure the "Target" setting. This determines how the output file generated by XML Transform is saved. This can be:		# Configure the "Target" setting. This determines how the output file generated by XML Transform is saved. This can be:

Dgreenwood: /* About */

2025-07-01T13:33:39Z

About

← Older revision		Revision as of 08:33, 1 July 2025
Line 15:		Line 15:
	#* Or, you can use an XML Transform step's "XSLT Editor" tab to edit and the XSLT. The XSLT you save in the XSLT Editor will be saved to the XML Transform setting.		#* Or, you can use an XML Transform step's "XSLT Editor" tab to edit and the XSLT. The XSLT you save in the XSLT Editor will be saved to the XML Transform setting.
	#**<li class="fyi-bullet"> You can use the "[[AI_Productivity_Helpers#AI_XML_Transform_Helper:_Get_help_making_XSLT_transforms\|AI XML Transform Helper]]" to get help making an XSLT from an AI.		#**<li class="fyi-bullet"> You can use the "[[AI_Productivity_Helpers#AI_XML_Transform_Helper:_Get_help_making_XSLT_transforms\|AI XML Transform Helper]]" to get help making an XSLT from an AI.
	# Configure the "Target". This determines how the output file generated by XML Transform is saved. This can be:		# Configure the "Target" setting. This determines how the output file generated by XML Transform is saved. This can be:
	#* File - The output XML will be saved to a named file.		#* '''File''' - The output XML will be saved to a named file.
	#* Attachment - The output XML will be saved as the document's attachment.		#* '''Attachment''' - The output XML will be saved as the document's attachment.
	#* Data - The output XML will be saved into the document's index data.		#* '''Data''' - The output XML will be saved into the document's index data.
	#* LastChild - The output XML will be appended as the last child document.		#* '''LastChild''' - The output XML will be appended as the last child document.
	#* FirstChild - The output XML will be prepended as the first child document.		#* '''FirstChild''' - The output XML will be prepended as the first child document.

Dgreenwood: /* Create an HTML report from a documents extracted data */

2025-06-30T21:33:10Z

Create an HTML report from a documents extracted data

← Older revision		Revision as of 16:33, 30 June 2025
Line 61:		Line 61:
	<?xml version="1.0" encoding="UTF-8"?>		<?xml version="1.0" encoding="UTF-8"?>
	<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="html" ~~indent~~="~~yes~~"/>		<xsl:output method="html" encoding="UTF-8" />
	<xsl:template match="/">		<xsl:template match="/">
	<html>		<html>
Line 67:		Line 67:
	<title>Invoice Report</title>		<title>Invoice Report</title>
	<style>		<style>
	body { font-family: Arial, sans-serif~~; margin: 20px~~; }		body { font-family: Arial, sans-serif; }
	h1 { color: #~~333333~~; }		h1 { background-color: #f2f2f2; padding: 10px; }
	table { border-collapse: collapse; width: 100%~~; margin-bottom: 20px~~; }		.section { margin-bottom: 20px; }
	th, td { border: 1px solid #~~dddddd~~; text-align: left~~; padding: 8px~~; }		table { border-collapse: collapse; width: 100%; }
	th { background-color: #~~f2f2f2; }~~		th, td { border: 1px solid #ccc; padding: 8px; text-align: left; }
	~~.section-title { background-color: #666666; color: white; padding: 8px; margin-top: 30px~~;}		th { background-color: #e2e2e2; }
	</style>		</style>
	</head>		</head>
	<body>		<body>
	<h1>Invoice Report</h1>		<h1>Invoice Report</h1>
	~~<!-- Invoice Basic Info -->~~		<div class="section">
	<div>		<h2>Invoice Details</h2>
	<h2 ~~class="section-title"~~>Invoice ~~Information~~</h2>
	<table>		<table>
	<tr><th>Invoice Number</th><td><xsl:value-of select="Document/Field[@Name='Invoice Number']"/></td></tr>		<tr><th>Invoice Number</th><td><xsl:value-of select="Document/Field[@Name='Invoice Number']"/></td></tr>
Line 87:		Line 86:
	</table>		</table>
	</div>		</div>
	~~<!-- Supplier and Customer Info -->~~		<div class="section">
	<div>		<h2>Supplier Information</h2>
	<h2 ~~class="section-title"~~>Supplier ~~and Customer~~</h2>
	<table>		<table>
	<tr>		<tr><th>Supplier Name</th><td><xsl:value-of select="Document/Field[@Name='Supplier Name']"/></td></tr>
	<th>Supplier Name</th>		<tr><th>Supplier Address</th><td><xsl:value-of select="Document/Field[@Name='Supplier Address']"/></td></tr>
	~~<th>Supplier Address</th>~~		</table>
	~~</tr>~~		</div>
	~~<tr>~~		<div class="section">
	<td><xsl:value-of select="Document/Field[@Name='Supplier Name']"/></td>		<h2>Customer Information</h2>
	<td><xsl:value-of select="Document/Field[@Name='Supplier Address']"/></td>		<table>
	</tr>		<tr><th>Customer Name</th><td><xsl:value-of select="Document/Field[@Name='Customer Name']"/></td></tr>
	<tr>		<tr><th>Customer Address</th><td><xsl:value-of select="Document/Field[@Name='Customer Address']"/></td></tr>
	<th>~~Customer Name~~<~~/th~~>
	<th>Customer ~~Address~~</th>
	<~~/tr~~>
	<tr>
	<td><xsl:value-of select="Document/Field[@Name='Customer Name']"/></td>
	<td><xsl:value-of select="Document/Field[@Name='Customer Address']"/></td>
	</tr>
	</table>		</table>
	</div>		</div>
	~~<!-- Invoice Line Items -->~~		<div class="section">
	<div>		<h2>Invoice Line Items</h2>
	<h2 ~~class="section-title"~~>Invoice Line Items</h2>
	<table>		<table>
	<tr>		<tr>
Line 129:		Line 119:
	</table>		</table>
	</div>		</div>
	~~<!-- Summary -->~~		<div class="section">
	<div>		<h2>Summary</h2>
	<h2 ~~class="section-title"~~>Summary</h2>
	<table>		<table>
	<tr><th>Subtotal</th><td><xsl:value-of select="Document/Field[@Name='Subtotal']"/></td></tr>		<tr><th>Subtotal</th><td><xsl:value-of select="Document/Field[@Name='Subtotal']"/></td></tr>
Line 148:		Line 137:

	[[File:2025Wiki-AIProductivityHelpers-XMLTransform.png]]		[[File:2025Wiki-AIProductivityHelpers-XMLTransform.png]]


	=== Strip out unwanted XML attributes from Grooper's XML Metadata format ===		=== Strip out unwanted XML attributes from Grooper's XML Metadata format ===

Dgreenwood at 21:29, 30 June 2025

2025-06-30T21:29:56Z

← Older revision		Revision as of 16:29, 30 June 2025
Line 3:		Line 3:

	== About ==		== About ==

	~~[[File:2025Wiki-AIProductivityHelpers-XMLTransform.png]]~~

	XML Transform is an activity that transforms XML data to a new file using an XSLT (eXtensible Stylesheet Language Transformations) stylesheet. A source XML file is used to generate a different text-based file format (XML, TXT, HTML, etc) according to the transformation rules in the XSLT code.		XML Transform is an activity that transforms XML data to a new file using an XSLT (eXtensible Stylesheet Language Transformations) stylesheet. A source XML file is used to generate a different text-based file format (XML, TXT, HTML, etc) according to the transformation rules in the XSLT code.
Line 146:		Line 144:
	</xsl:stylesheet>		</xsl:stylesheet>
	</pre>		</pre>

			The result of XML Transform using this XSLT is described by the image below:

			[[File:2025Wiki-AIProductivityHelpers-XMLTransform.png]]


	=== Strip out unwanted XML attributes from Grooper's XML Metadata format ===		=== Strip out unwanted XML attributes from Grooper's XML Metadata format ===

Dgreenwood: /* Strip out unwanted XML attributes from Grooper's XML Metadata format */

2025-06-30T21:27:54Z

Strip out unwanted XML attributes from Grooper's XML Metadata format

← Older revision		Revision as of 16:27, 30 June 2025
Line 154:		Line 154:
	The following XSLT would simplify the XML by striping out all attributes except "Name" for each XML element.		The following XSLT would simplify the XML by striping out all attributes except "Name" for each XML element.
	:*<li class="fyi-bullet">The result of this transformation would be something like this.		:*<li class="fyi-bullet">The result of this transformation would be something like this.
	:*: Before transformation: <code><Field Name="fieldName" Confidence="1" Page="1" Valid="True" Location="1.1111, 2.22, .3333, .4444">fieldValue</Field></code>		:** Before transformation: <code><Field Name="fieldName" Confidence="1" Page="1" Valid="True" Location="1.1111, 2.22, .3333, .4444">fieldValue</Field></code>
	:*~~: AFter~~ transformation: <code><Field Name="fieldName">fieldValue</Field></code>		:** After transformation: <code><Field Name="fieldName">fieldValue</Field></code>

Dgreenwood at 20:45, 30 June 2025

2025-06-30T20:45:45Z

Show changes

Randallkinard: Randallkinard moved page XML Transform to XML Transform (Activity): Misspelled title

2024-03-14T19:20:08Z

Randallkinard moved page XML Transform to XML Transform (Activity): Misspelled title

← Older revision	Revision as of 14:20, 14 March 2024
(No difference)

Dgreenwood: Removed redirect to 2.72:XML Transform

2024-01-03T19:04:58Z

Removed redirect to 2.72:XML Transform

← Older revision		Revision as of 14:04, 3 January 2024
Line 1:		Line 1:
	~~#REDIRECT [[~~2.72:~~XML Transform]]~~		{{Migrated}}
			{{2.72:{{PAGENAME}}}}

Dgreenwood: Dgreenwood moved page XML Transform to 2.72:XML Transform

2024-01-03T19:04:25Z

Dgreenwood moved page XML Transform to 2.72:XML Transform

New page

#REDIRECT [[2.72:XML Transform]]