CSV - Revision history

Dgarratt: /* CSV Output Configuration */

2024-12-30T13:31:06Z

CSV Output Configuration

← Older revision		Revision as of 15:31, 30 December 2024
Line 69:		Line 69:
	=CSV Output Configuration=		=CSV Output Configuration=
	<syntaxhighlight lang="xml">		<syntaxhighlight lang="xml">
	<map id~~="map211i"~~ enabled~~="Y"~~		<map>
	description~~="Commander4j Production Declaration~~ to CSV">		<id>Map12</id>
	<input id="in1" description="Read ~~C4J~~ XML File">		<enabled>true</enabled>
	<type>XML</type>		<description>XML to CSV</description>
	<path>./interface/input/~~C4J Production Declaration~~</path>		<enableEmailNotifications>true</enableEmailNotifications>
	<mask/>		<connectors>
	<pollingInterval>1000</pollingInterval>		<input>
	<XSLT>~~C4J_PRODDEC_XML_to_CSV~~.xsl</XSLT>		<id>in1</id>
	</input>		<description>Read XML File</description>
	<output id="out1" enabled~~="Y"~~ description="Write CSV">		<type>XML</type>
	<path>./interface/output/CSV ~~Output~~</path>		<url>
	<~~type~~>~~CSV~~</~~type~~>		<path>./interface/input/Map12 XML to CSV</path>
	<~~optionDelimeter~~>^</~~optionDelimeter~~>		<mask/>
	<~~csvOptions~~>~~separator=,^quote="~~</~~csvOptions~~>		<prefix/>
	<~~outputFileExtension~~>csv</~~outputFileExtension~~>		<pollingInterval>1000</pollingInterval>
	<~~prefix~~>X</~~prefix~~>		</url>
	~~<use83GUID>Y~~</~~use83GUID~~>		<xsl>
	<~~XSLT~~/>		<XSLTPath/>
	</~~output~~>		<XSLT>Map12_XML_to_CSV.xsl</XSLT>
	</map>		</xsl>
			</input>
			<output>
			<id>out1</id>
			<enabled>true</enabled>
			<description>Write CSV</description>
			<type>CSV</type>
			<url>
			<path>./interface/output/Map12 XML to CSV</path>
			<prefix>X</prefix>
			<fileExtension>csv</fileExtension>
			<use83GUID>true</use83GUID>
			</url>
			<csv>
			<optionDelimeter>^</optionDelimeter>
			<csvOptions>separator=,^quote=none</csvOptions>
			</csv>
			</output>
			</connectors>
			</map>
	</syntaxhighlight>		</syntaxhighlight>

Line 112:		Line 131:
	\| XSLT \|\| filename \|\| Not used		\| XSLT \|\| filename \|\| Not used
	\|}		\|}


	=CSV Example Input=		=CSV Example Input=

Dgarratt at 13:29, 30 December 2024

2024-12-30T13:29:29Z

← Older revision		Revision as of 15:29, 30 December 2024
Line 3:		Line 3:
	'''config.xml'''		'''config.xml'''
	<syntaxhighlight lang="xml">		<syntaxhighlight lang="xml">
	<map id="Map04" enabled~~="Y"~~ description~~="GEN Comma Separated Variables"~~>		<map>
	<input id="in1" description="Read ~~GEN Comma Separated Variables"~~>		<id>Map04</id>
	<type>CSV</type>		<enabled>true</enabled>
	<path>./interface/input/~~403 (GEN Comma Separated Variables)~~</path>		<description>CSV to XML</description>
	<mask/>		<enableEmailNotifications>true</enableEmailNotifications>
	<pollingInterval>1000</pollingInterval>		<connectors>
	<~~XSLT~~>~~CSV_to_XML_Example.xsl~~<~~/XSLT~~>		<input>
	<optionDelimeter>^</optionDelimeter>		<id>in1</id>
	<csvOptions>separator=,^quote="</csvOptions>		<description>Read CSV</description>
	</input>		<type>CSV</type>
	<output id="out1" enabled~~="Y"~~ description="Write XML ~~Example"~~>		<url>
	<path>./interface/output/~~403 (GEN~~ XML)</path>		<path>./interface/input/Map04 CSV to XML</path>
	<~~type~~>~~XML~~</~~type~~>		<mask/>
	<XSLT/>		<prefix/>
	</output>		<pollingInterval>1000</pollingInterval>
	</map>		</url>
			<csv>
			<optionDelimeter>^</optionDelimeter>
			<csvOptions>separator=,^quote=none</csvOptions>
			</csv>
			</input>
			<output>
			<id>out1</id>
			<enabled>true</enabled>
			<description>Write XML</description>
			<type>XML</type>
			<url>
			<path>./interface/output/Map04 CSV to XML</path>
			<prefix/>
			<fileExtension/>
			<use83GUID>false</use83GUID>
			</url>
			<xsl>
			<XSLT>Map04_CSV_to_XML.xsl</XSLT>
			<XSLTPath/>
			</xsl>
			</output>
			</connectors>
			</map>
	</syntaxhighlight>		</syntaxhighlight>

Dgarratt at 15:58, 27 August 2024

2024-08-27T15:58:55Z

← Older revision		Revision as of 17:58, 27 August 2024
Line 35:		Line 35:
	In the <csvOptions>separator=,^quote="</csvOptions> element you will see that 2 values are set, '''separator''' and '''quote'''. These 2 settings are separated by a delimiter which happens to be ^ in this example. However if by some unfortunate coincedence your CSV file uses that character as a value separater then you might need to use a different delimited in the configuration - which is where the `<optionDelimeter>^</optionDelimeter>` can be used.		In the <csvOptions>separator=,^quote="</csvOptions> element you will see that 2 values are set, '''separator''' and '''quote'''. These 2 settings are separated by a delimiter which happens to be ^ in this example. However if by some unfortunate coincedence your CSV file uses that character as a value separater then you might need to use a different delimited in the configuration - which is where the `<optionDelimeter>^</optionDelimeter>` can be used.

	[[file:delimiter.png\|400px]]		[[file:delimiter.png\|link=\|400px]]

	NOTE that if you don't want a quote character this should be represented as shown below		NOTE that if you don't want a quote character this should be represented as shown below

Dgarratt at 15:57, 27 August 2024

2024-08-27T15:57:54Z

← Older revision		Revision as of 17:57, 27 August 2024
Line 89:		Line 89:
	\| XSLT \|\| filename \|\| Not used		\| XSLT \|\| filename \|\| Not used
	\|}		\|}


	=CSV Example Input=		=CSV Example Input=

Dgarratt at 09:27, 25 August 2024

2024-08-25T09:27:59Z

← Older revision		Revision as of 11:27, 25 August 2024
Line 1:		Line 1:
			[[Category: Middleware4j]]
	=CSV Map Configuration=		=CSV Map Configuration=
	'''config.xml'''		'''config.xml'''

Dgarratt at 19:00, 24 August 2024

2024-08-24T19:00:59Z

← Older revision		Revision as of 21:00, 24 August 2024
Line 2:		Line 2:
	=CSV Map Configuration=		=CSV Map Configuration=
	'''config.xml'''		'''config.xml'''
			<syntaxhighlight lang="xml">
	<map id="Map04" enabled="Y" description="GEN Comma Separated Variables">		<map id="Map04" enabled="Y" description="GEN Comma Separated Variables">
	<input id="in1" description="Read GEN Comma Separated Variables">		<input id="in1" description="Read GEN Comma Separated Variables">
Line 19:		Line 19:
	</output>		</output>
	</map>		</map>
			</syntaxhighlight>

	The CSV input connector uses the OpenCSV library and requires very little configuration. The are a pair of settings which you should review		The CSV input connector uses the OpenCSV library and requires very little configuration. The are a pair of settings which you should review

			<syntaxhighlight lang="xml">
	<optionDelimeter>^</optionDelimeter>		<optionDelimeter>^</optionDelimeter>
			</syntaxhighlight>

	and		and

			<syntaxhighlight lang="xml">
	<csvOptions>separator=,^quote="</csvOptions>		<csvOptions>separator=,^quote="</csvOptions>
			</syntaxhighlight>

	In the <csvOptions>separator=,^quote="</csvOptions> element you will see that 2 values are set, '''separator''' and '''quote'''. These 2 settings are separated by a delimiter which happens to be ^ in this example. However if by some unfortunate coincedence your CSV file uses that character as a value separater then you might need to use a different delimited in the configuration - which is where the `<optionDelimeter>^</optionDelimeter>` can be used.		In the <csvOptions>separator=,^quote="</csvOptions> element you will see that 2 values are set, '''separator''' and '''quote'''. These 2 settings are separated by a delimiter which happens to be ^ in this example. However if by some unfortunate coincedence your CSV file uses that character as a value separater then you might need to use a different delimited in the configuration - which is where the `<optionDelimeter>^</optionDelimeter>` can be used.
Line 35:		Line 40:
	with '''_none_''' used as the value.		with '''_none_''' used as the value.

			<syntaxhighlight lang="xml">
	<csvOptions>separator=,^quote=none</csvOptions>		<csvOptions>separator=,^quote=none</csvOptions>
			</syntaxhighlight>

	=CSV Output Configuration=		=CSV Output Configuration=
			<syntaxhighlight lang="xml">
	<map id="map211i" enabled="Y"		<map id="map211i" enabled="Y"
	description="Commander4j Production Declaration to CSV">		description="Commander4j Production Declaration to CSV">
Line 58:		Line 66:
	</output>		</output>
	</map>		</map>
			</syntaxhighlight>

	{\| class="wikitable" style="margin:auto"		{\| class="wikitable" style="margin:auto"
	\|+ System Keys		\|+ System Keys
Line 89:		Line 99:

	=CSV to XML Intermediate Format=		=CSV to XML Intermediate Format=
			<syntaxhighlight lang="xml">
	<?xml version="1.0" encoding="UTF-8"?>		<?xml version="1.0" encoding="UTF-8"?>
	<data cols="10" filename="GEN Comma Separated Variables 1.csv" rows="5" type="CSV">		<data cols="10" filename="GEN Comma Separated Variables 1.csv" rows="5" type="CSV">
Line 153:		Line 163:
	</row>		</row>
	</data>		</data>
			</syntaxhighlight>

	=XML Example Output from XSLT=		=XML Example Output from XSLT=
			<syntaxhighlight lang="xml">
	<?xml version="1.0" encoding="UTF-8"?>		<?xml version="1.0" encoding="UTF-8"?>
	<test>		<test>
Line 163:		Line 175:
	<barcode>01050213060215701000123780990210133980005</barcode>		<barcode>01050213060215701000123780990210133980005</barcode>
	</test>		</test>
			</syntaxhighlight>

Dgarratt: /* CSV Output Configuration */

2024-08-24T17:41:51Z

CSV Output Configuration

← Older revision		Revision as of 19:41, 24 August 2024
Line 58:		Line 58:
	</output>		</output>
	</map>		</map>

	{\| class="wikitable" style="margin:auto"		{\| class="wikitable" style="margin:auto"
	\|+ System Keys		\|+ System Keys

Dgarratt: /* XML Example Output from XSLT */

2024-08-24T17:41:25Z

XML Example Output from XSLT

← Older revision		Revision as of 19:41, 24 August 2024
Line 156:		Line 156:

	=XML Example Output from XSLT=		=XML Example Output from XSLT=

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

Dgarratt: /* CSV Example Input */

2024-08-24T17:40:40Z

CSV Example Input

← Older revision		Revision as of 19:40, 24 August 2024
Line 83:		Line 83:
	=CSV Example Input=		=CSV Example Input=
	'''GEN Comma Separated Variables 1.csv'''		'''GEN Comma Separated Variables 1.csv'''

	01050213060215701000123780990210133980001,150213061500000017,15,15000,0210133,5021306021570,1008369,LS 2D BLU,1000,00123780		01050213060215701000123780990210133980001,150213061500000017,15,15000,0210133,5021306021570,1008369,LS 2D BLU,1000,00123780
	01050213060215701000123780990210133980002,150213061500000017,15,15000,0210133,5021306021570,1008369,LS 2D BLU,1000,00123780		01050213060215701000123780990210133980002,150213061500000017,15,15000,0210133,5021306021570,1008369,LS 2D BLU,1000,00123780

Dgarratt: /* CSV Output Configuration */

2024-08-24T17:39:59Z

CSV Output Configuration

← Older revision		Revision as of 19:39, 24 August 2024
Line 64:		Line 64:
	! Element !! Value !! Description		! Element !! Value !! Description
	\|-		\|-
	\| path \|\| Path \|\| Specifies where output files are saved.		\| style="width: 150px"\|path \|\| style="width: 90px"\|Path \|\| Specifies where output files are saved.
	\|-		\|-
	\| type \|\| CSV \|\| Specify the output file format		\| type \|\| CSV \|\| Specify the output file format