ASCII - Revision history

Dgarratt: /* ASCII Map Output Configuration */

2024-12-30T13:28:06Z

ASCII Map Output Configuration

← Older revision		Revision as of 15:28, 30 December 2024
Line 94:		Line 94:
	===ASCII Map Output Configuration===		===ASCII Map Output Configuration===
	<syntaxhighlight lang="xml">		<syntaxhighlight lang="xml">
	<map id="Map09" enabled~~="Y"~~ description="XML to ASCII Flat File">		<map>
	<input id="in1" description="Read XML File">		<id>Map09</id>
	<type>XML</type>		<enabled>true</enabled>
	<path>./interface/input/Map09 XML to ASCII</path>		<description>XML to ASCII Flat File</description>
	<mask/>		<enableEmailNotifications>true</enableEmailNotifications>
	<pollingInterval>1000</pollingInterval>		<connectors>
	<XSLT>Map09_XML_to_ASCII.xsl</XSLT>		<input>
	</input>		<id>in1</id>
	<output id="out1" enabled~~="Y"~~ description="Write ASCII File">		<description>Read XML File</description>
	<path>./interface/output/Map09 XML to ASCII</path>		<type>XML</type>
	<~~type~~>~~ASCII~~</~~type~~>		<url>
	<~~outputPattern~~>1-10,12-21,23-53</~~outputPattern~~>		<path>./interface/input/Map09 XML to ASCII</path>
	<~~XSLT~~/>		<mask/>
	</~~output~~>		<prefix/>
	</map>		<pollingInterval>1000</pollingInterval>
			</url>
			<xsl>
			<XSLTPath/>
			<XSLT>Map09_XML_to_ASCII.xsl</XSLT>
			</xsl>
			</input>
			<output>
			<id>out1</id>
			<enabled>true</enabled>
			<description>Write ASCII File</description>
			<type>ASCII</type>
			<url>
			<path>./interface/output/Map09 XML to ASCII</path>
			<prefix/>
			<fileExtension/>
			<use83GUID>false</use83GUID>
			</url>
			<ascii>
			<pattern>1-10,12-21,23-53</pattern>
			</ascii>
			</output>
			</connectors>
			</map>
	</syntaxhighlight>		</syntaxhighlight>

Dgarratt: /* ASCII Input Map Configuration */

2024-12-30T13:27:38Z

ASCII Input Map Configuration

← Older revision		Revision as of 15:27, 30 December 2024
Line 48:		Line 48:
	'''config.xml'''		'''config.xml'''
	<syntaxhighlight lang="xml">		<syntaxhighlight lang="xml">
	<map id="Map02" enabled~~="Y"~~ description="ASCII File Fixed Column to XML">		<map>
	<input id="in1" description="Read ASCII Flat File">		<id>Map02</id>
	<type>ASCII</type>		<enabled>true</enabled>
	<path>./interface/input/Map02 ASCII to XML</path>		<description>ASCII File Fixed Column to XML</description>
	<mask/>		<enableEmailNotifications>true</enableEmailNotifications>
	~~<inputPattern>1-4,18-21~~</~~inputPattern~~>		<connectors>
	<pollingInterval>1000</pollingInterval>		<input>
	<XSLT>Map02_ASCII_to_XML.xsl</XSLT>		<id>in1</id>
	</input>		<description>Read ASCII Flat File</description>
	<output id="out1" enabled~~="Y"~~ description="Write XML">		<type>ASCII</type>
	<path>./interface/output/Map02 ASCII to XML</path>		<url>
	<~~type~~>~~XML~~</~~type~~>		<path>./interface/input/Map02 ASCII to XML</path>
	<~~XSLT~~/>		<mask/>
	</~~output~~>		<prefix/>
	</map>		<pollingInterval>1000</pollingInterval>
			</url>
			<xsl>
			<XSLTPath/>
			<XSLT>Map02_ASCII_to_XML.xsl</XSLT>
			</xsl>
			<ascii>
			<pattern>1-4,18-21</pattern>
			</ascii>
			</input>
			<output>
			<id>out1</id>
			<enabled>true</enabled>
			<description>Write XML</description>
			<type>XML</type>
			<url>
			<path>./interface/output/Map02 ASCII to XML</path>
			<prefix/>
			<fileExtension/>
			<use83GUID>false</use83GUID>
			</url>
			</output>
			</connectors>
			</map>>
	</syntaxhighlight>		</syntaxhighlight>

Dgarratt at 13:27, 30 December 2024

2024-12-30T13:27:12Z

← Older revision		Revision as of 15:27, 30 December 2024
Line 5:		Line 5:

	<syntaxhighlight lang="xml">		<syntaxhighlight lang="xml">
	<map id="Map02" enabled~~="Y"~~ description="ASCII File Fixed Column to XML">		<map>
	<input id="in1" description="Read ASCII Flat File">		<id>Map02</id>
	<type>ASCII</type>		<enabled>true</enabled>
	<path>./interface/input/Map02 ASCII to XML</path>		<description>ASCII File Fixed Column to XML</description>
	<mask/>		<enableEmailNotifications>true</enableEmailNotifications>
	~~<inputPattern>1-4,18-21~~</~~inputPattern~~>		<connectors>
	<pollingInterval>1000</pollingInterval>		<input>
	<XSLT>Map02_ASCII_to_XML.xsl</XSLT>		<id>in1</id>
	</input>		<description>Read ASCII Flat File</description>
	<output id="out1" enabled~~="Y"~~ description="Write XML">		<type>ASCII</type>
	<path>./interface/output/Map02 ASCII to XML</path>		<url>
	<~~type~~>~~XML~~</~~type~~>		<path>./interface/input/Map02 ASCII to XML</path>
	<~~XSLT~~/>		<mask/>
	</~~output~~>		<prefix/>
	</map>		<pollingInterval>1000</pollingInterval>
			</url>
			<xsl>
			<XSLTPath/>
			<XSLT>Map02_ASCII_to_XML.xsl</XSLT>
			</xsl>
			<ascii>
			<pattern>1-4,18-21</pattern>
			</ascii>
			</input>
			<output>
			<id>out1</id>
			<enabled>true</enabled>
			<description>Write XML</description>
			<type>XML</type>
			<url>
			<path>./interface/output/Map02 ASCII to XML</path>
			<prefix/>
			<fileExtension/>
			<use83GUID>false</use83GUID>
			</url>
			</output>
			</connectors>
			</map>
	</syntaxhighlight>		</syntaxhighlight>

Dgarratt at 09:25, 25 August 2024

2024-08-25T09:25:40Z

← Older revision		Revision as of 11:25, 25 August 2024
Line 1:		Line 1:
			[[Category: Middleware4j]]
	See [[Middleware4j Example Configuration\|Example Configuration]] for more information on the ASCII Input option.		See [[Middleware4j Example Configuration\|Example Configuration]] for more information on the ASCII Input option.

Dgarratt: /* Output ASCII */

2024-08-24T19:18:14Z

Output ASCII

← Older revision		Revision as of 21:18, 24 August 2024
Line 181:		Line 181:
	===Output ASCII===		===Output ASCII===

	20725187 43170672 Self Sealing Stem Bolt		<syntaxhighlight lang="Plaintext">
			20725187 43170672 Self Sealing Stem Bolt
			</syntaxhighlight>

	This is the output from the transformation. The intermediate files can be found in the interface/log directory. For more information see the [[Middleware4j Example Configuration\|Example Configuration]]		This is the output from the transformation. The intermediate files can be found in the interface/log directory. For more information see the [[Middleware4j Example Configuration\|Example Configuration]]

Dgarratt at 18:53, 24 August 2024

2024-08-24T18:53:36Z

← Older revision		Revision as of 20:53, 24 August 2024
Line 23:		Line 23:
	===ASCII Input Map Configuration===		===ASCII Input Map Configuration===
	'''config.xml'''		'''config.xml'''
			<syntaxhighlight lang="xml">
	<map id="Map02" enabled="Y" description="ASCII File Fixed Column to XML">		<map id="Map02" enabled="Y" description="ASCII File Fixed Column to XML">
	<input id="in1" description="Read ASCII Flat File">		<input id="in1" description="Read ASCII Flat File">
Line 38:		Line 39:
	</output>		</output>
	</map>		</map>
			</syntaxhighlight>

	The unique setting which is important above is the `<inputPattern>1-4,18-21</inputPattern>`. This determines the columns within the input file which are to be read into memory and optionally processed by the XSLT Style Sheet.		The unique setting which is important above is the `<inputPattern>1-4,18-21</inputPattern>`. This determines the columns within the input file which are to be read into memory and optionally processed by the XSLT Style Sheet.
Line 44:		Line 46:

	===ASCII Map Output Configuration===		===ASCII Map Output Configuration===
			<syntaxhighlight lang="xml">
	<map id="Map09" enabled="Y" description="XML to ASCII Flat File">		<map id="Map09" enabled="Y" description="XML to ASCII Flat File">
	<input id="in1" description="Read XML File">		<input id="in1" description="Read XML File">
Line 59:		Line 62:
	</output>		</output>
	</map>		</map>
			</syntaxhighlight>

	The output connector is very similar to configure and in this example we use a XSL file called to create a Flat ASCII file from a standard Commander4j XML message. The XSL source in this example looks like this. In this scenario we want to extract and export the order, material and description from the xml and write to a flat ascii file. We are going to write the data to 3 column ranges define in `<outputPattern>1-10,12-21,23-53</outputPattern>`		The output connector is very similar to configure and in this example we use a XSL file called to create a Flat ASCII file from a standard Commander4j XML message. The XSL source in this example looks like this. In this scenario we want to extract and export the order, material and description from the xml and write to a flat ascii file. We are going to write the data to 3 column ranges define in `<outputPattern>1-10,12-21,23-53</outputPattern>`
Line 64:		Line 68:
	===Sample XSL File===		===Sample XSL File===
	'''Map09_XML_to_ASCII.xsl'''		'''Map09_XML_to_ASCII.xsl'''
			<syntaxhighlight lang="xml">
	<?xml version="1.0" encoding="UTF-8"?>		<?xml version="1.0" encoding="UTF-8"?>
	<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"		<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
Line 96:		Line 101:
	</xsl:template>		</xsl:template>
	</xsl:stylesheet>		</xsl:stylesheet>
			</syntaxhighlight>

	The above style sheet creates a intermediate XML file which is then passed to the ASCII connector to write the flat file. It is important to match the number of columns extracted with the XSL to the number of columns defined in the output connector. You will notice that the XSL includes some functions. The description for example uses a function to remove commas. You can find more information regardin these functions in [[XSLT Extension Functions]]		The above style sheet creates a intermediate XML file which is then passed to the ASCII connector to write the flat file. It is important to match the number of columns extracted with the XSL to the number of columns defined in the output connector. You will notice that the XSL includes some functions. The description for example uses a function to remove commas. You can find more information regardin these functions in [[XSLT Extension Functions]]
Line 103:		Line 109:
	===Sample XML Input File (Commander4j Production Declaration message)===		===Sample XML Input File (Commander4j Production Declaration message)===
	'''XML to ASCII Flat File 1.xml'''		'''XML to ASCII Flat File 1.xml'''
			<syntaxhighlight lang="xml">
	<?xml version="1.0" encoding="UTF-8"?>		<?xml version="1.0" encoding="UTF-8"?>
	<message>		<message>
Line 143:		Line 150:
	</messageData>		</messageData>
	</message>		</message>
			</syntaxhighlight>

	===Intermediate XML (result of appling XSL to input XML message)===		===Intermediate XML (result of appling XSL to input XML message)===

			<syntaxhighlight lang="xml">
	<?xml version="1.0" encoding="UTF-8"?>		<?xml version="1.0" encoding="UTF-8"?>
	<data cols="15" rows="1" type="CSV">		<data cols="15" rows="1" type="CSV">
Line 166:		Line 175:
	</row>		</row>
	</data>		</data>
			</syntaxhighlight>


	When the XSL executed against the input XML the above intermediate file is created. This is then passed to the output connector which matches the data found in the xml above to the column definitions.		When the XSL executed against the input XML the above intermediate file is created. This is then passed to the output connector which matches the data found in the xml above to the column definitions.

Dgarratt at 18:52, 24 August 2024

2024-08-24T18:52:02Z

← Older revision		Revision as of 20:52, 24 August 2024
Line 2:		Line 2:

	The ASCII Connector can be used for input and output.		The ASCII Connector can be used for input and output.

			<syntaxhighlight lang="xml">
			<map id="Map02" enabled="Y" description="ASCII File Fixed Column to XML">
			<input id="in1" description="Read ASCII Flat File">
			<type>ASCII</type>
			<path>./interface/input/Map02 ASCII to XML</path>
			<mask/>
			<inputPattern>1-4,18-21</inputPattern>
			<pollingInterval>1000</pollingInterval>
			<XSLT>Map02_ASCII_to_XML.xsl</XSLT>
			</input>
			<output id="out1" enabled="Y" description="Write XML">
			<path>./interface/output/Map02 ASCII to XML</path>
			<type>XML</type>
			<XSLT/>
			</output>
			</map>
			</syntaxhighlight>

	===ASCII Input Map Configuration===		===ASCII Input Map Configuration===

Dgarratt at 19:21, 23 August 2024

2024-08-23T19:21:10Z

← Older revision		Revision as of 21:21, 23 August 2024
Line 148:		Line 148:
	</row>		</row>
	</data>		</data>



	When the XSL executed against the input XML the above intermediate file is created. This is then passed to the output connector which matches the data found in the xml above to the column definitions.		When the XSL executed against the input XML the above intermediate file is created. This is then passed to the output connector which matches the data found in the xml above to the column definitions.

Dgarratt at 19:19, 23 August 2024

2024-08-23T19:19:13Z

← Older revision		Revision as of 21:19, 23 August 2024
Line 5:		Line 5:
	===ASCII Input Map Configuration===		===ASCII Input Map Configuration===
	'''config.xml'''		'''config.xml'''

	<map id="Map02" enabled="Y" description="ASCII File Fixed Column to XML">		<map id="Map02" enabled="Y" description="ASCII File Fixed Column to XML">
	<input id="in1" description="Read ASCII Flat File">		<input id="in1" description="Read ASCII Flat File">
Line 27:		Line 26:

	===ASCII Map Output Configuration===		===ASCII Map Output Configuration===

	<map id="Map09" enabled="Y" description="XML to ASCII Flat File">		<map id="Map09" enabled="Y" description="XML to ASCII Flat File">
	<input id="in1" description="Read XML File">		<input id="in1" description="Read XML File">
Line 48:		Line 46:
	===Sample XSL File===		===Sample XSL File===
	'''Map09_XML_to_ASCII.xsl'''		'''Map09_XML_to_ASCII.xsl'''

	<?xml version="1.0" encoding="UTF-8"?>		<?xml version="1.0" encoding="UTF-8"?>
	<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"		<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
Line 88:		Line 85:
	===Sample XML Input File (Commander4j Production Declaration message)===		===Sample XML Input File (Commander4j Production Declaration message)===
	'''XML to ASCII Flat File 1.xml'''		'''XML to ASCII Flat File 1.xml'''

	<?xml version="1.0" encoding="UTF-8"?>		<?xml version="1.0" encoding="UTF-8"?>
	<message>		<message>

Dgarratt at 18:07, 23 August 2024

2024-08-23T18:07:58Z

← Older revision		Revision as of 20:07, 23 August 2024
Line 159:		Line 159:
	20725187 43170672 Self Sealing Stem Bolt		20725187 43170672 Self Sealing Stem Bolt

	This is the output from the transformation. The intermediate files can be found in the interface/log directory. For more information see the [[Example Configuration]]		This is the output from the transformation. The intermediate files can be found in the interface/log directory. For more information see the [[Middleware4j Example Configuration\|Example Configuration]]