Icon

KNIME_​Demo Simple XML Generator

KNIME_Demo Simple XML Generator
XML Generator Demo 1 - Read a CSV and output xmlwith zero configuration of the XML generator components.REQUIRES PYTHON 3 to be installed in your KNIMEenvironment For demo purposes, launch the output filein the associated xml app in your environment.Remove this node if you have no associatedapp, or you don't wish to launch it. The basic XML generation is performed by a collaboration of these twocomponents.My aim is that for any given table data source, it should be possible to generatebasic xml with near- zero configuration. Once that has been achieved, we canlook at providing changes to the Control Table to adapt the output.If you set your Python Console Logging level to INFO, you will see a progressmessage every 1000 rows logged by the XML Generator.File-Preferences-> KNIME-> KNIME GUI -> Console View Log Level (o)INFO The XML Writer is supplied an output folder, andthat's pretty much it. It creates the file namebased on the RowID of the input data. "Local File Name Variables" components allow meto quickly provide a file name relative to theworkflow's data folder, or a link to the data folderitself. It then creates variables of type String, Pathand URL so there is a variable suitable for bothlegacy (deprecated) and newer file componentswithout me having to care! UPDATED: November 2022 with newcomponents The upper output port on XML Generator is the data in single XML format,declared as KNIME XML data typeThe lower middle port is the same data but in multiple rows, as KNIMEString data type. The lower port does not contain reference to the ROOTxml node, as it represents only individual rowsThe bottom port is a String table of individual lines of the XML - providedfor flexibility in further manipulation or writing of the xml This is just my quick way to providelocal file name variables that work withboth old and new file read/write components"born_outside_US.csv"Replace withyour data, and see if this willcontinue to work with no config changesrequired for basic table/row xml output...(That's the aim!)provides quick link variable toworkflow's data folderView the generatedXML in a browser or other appassociated with .xmlfilesGenerates XML from source tablebased on supplied control tableConfig for this node is simply the name of the output file(without the .xml extension). This is the name that will beused by the XML WriterZero config default:output_xmlGenerates basic "Control Table"for interpretation by XML Generator.Configuration on this node, if requiredis simply to specify name of root node and row nodeZero config default:table, rowWrite XML.This needs to be configuredwith the required outputFolder.The filename is as specifiedon the config of XML Generator Local FileName Variables CSV Reader Local FileName Variables Java Edit Variable XML Generator Create XML GeneratorControl Table XML Writer XML Control Table- Finalizer XML Generator Demo 1 - Read a CSV and output xmlwith zero configuration of the XML generator components.REQUIRES PYTHON 3 to be installed in your KNIMEenvironment For demo purposes, launch the output filein the associated xml app in your environment.Remove this node if you have no associatedapp, or you don't wish to launch it. The basic XML generation is performed by a collaboration of these twocomponents.My aim is that for any given table data source, it should be possible to generatebasic xml with near- zero configuration. Once that has been achieved, we canlook at providing changes to the Control Table to adapt the output.If you set your Python Console Logging level to INFO, you will see a progressmessage every 1000 rows logged by the XML Generator.File-Preferences-> KNIME-> KNIME GUI -> Console View Log Level (o)INFO The XML Writer is supplied an output folder, andthat's pretty much it. It creates the file namebased on the RowID of the input data. "Local File Name Variables" components allow meto quickly provide a file name relative to theworkflow's data folder, or a link to the data folderitself. It then creates variables of type String, Pathand URL so there is a variable suitable for bothlegacy (deprecated) and newer file componentswithout me having to care! UPDATED: November 2022 with newcomponents The upper output port on XML Generator is the data in single XML format,declared as KNIME XML data typeThe lower middle port is the same data but in multiple rows, as KNIMEString data type. The lower port does not contain reference to the ROOTxml node, as it represents only individual rowsThe bottom port is a String table of individual lines of the XML - providedfor flexibility in further manipulation or writing of the xml This is just my quick way to providelocal file name variables that work withboth old and new file read/write components"born_outside_US.csv"Replace withyour data, and see if this willcontinue to work with no config changesrequired for basic table/row xml output...(That's the aim!)provides quick link variable toworkflow's data folderView the generatedXML in a browser or other appassociated with .xmlfilesGenerates XML from source tablebased on supplied control tableConfig for this node is simply the name of the output file(without the .xml extension). This is the name that will beused by the XML WriterZero config default:output_xmlGenerates basic "Control Table"for interpretation by XML Generator.Configuration on this node, if requiredis simply to specify name of root node and row nodeZero config default:table, rowWrite XML.This needs to be configuredwith the required outputFolder.The filename is as specifiedon the config of XML GeneratorLocal FileName Variables CSV Reader Local FileName Variables Java Edit Variable XML Generator Create XML GeneratorControl Table XML Writer XML Control Table- Finalizer

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: @takbb Brian Bates
Created at: 2021-05-09
On NodePit since: 2021-09-11
Last update: 2024-04-18
Created with KNIME version: v4.6.3
Tags: XMLXML GeneratorWriting XML

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!