/*! ****************************************************************************** * * Pentaho Data Integration * * Copyright (C) 2002-2016 by Pentaho : http://www.pentaho.com * ******************************************************************************* * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * ******************************************************************************/ package org.pentaho.di.ui.trans.steps.xmlinput; import java.util.ArrayList; import java.util.List; import org.eclipse.swt.SWT; import org.eclipse.swt.custom.CTabFolder; import org.eclipse.swt.custom.CTabItem; import org.eclipse.swt.events.ModifyEvent; import org.eclipse.swt.events.ModifyListener; import org.eclipse.swt.events.SelectionAdapter; import org.eclipse.swt.events.SelectionEvent; import org.eclipse.swt.events.ShellAdapter; import org.eclipse.swt.events.ShellEvent; import org.eclipse.swt.layout.FormAttachment; import org.eclipse.swt.layout.FormData; import org.eclipse.swt.layout.FormLayout; import org.eclipse.swt.widgets.Button; import org.eclipse.swt.widgets.Composite; import org.eclipse.swt.widgets.DirectoryDialog; import org.eclipse.swt.widgets.Display; import org.eclipse.swt.widgets.Event; import org.eclipse.swt.widgets.FileDialog; import org.eclipse.swt.widgets.Label; import org.eclipse.swt.widgets.Listener; import org.eclipse.swt.widgets.MessageBox; import org.eclipse.swt.widgets.Shell; import org.eclipse.swt.widgets.TableItem; import org.eclipse.swt.widgets.Text; import org.pentaho.di.core.Const; import org.pentaho.di.core.util.Utils; import org.pentaho.di.core.Props; import org.pentaho.di.core.exception.KettleException; import org.pentaho.di.core.fileinput.FileInputList; import org.pentaho.di.core.row.RowMeta; import org.pentaho.di.core.row.RowMetaInterface; import org.pentaho.di.core.row.ValueMeta; import org.pentaho.di.core.row.ValueMetaAndData; import org.pentaho.di.core.row.ValueMetaInterface; import org.pentaho.di.core.util.StringUtil; import org.pentaho.di.core.xml.XMLHandler; import org.pentaho.di.i18n.BaseMessages; import org.pentaho.di.trans.Trans; import org.pentaho.di.trans.TransMeta; import org.pentaho.di.trans.TransPreviewFactory; import org.pentaho.di.trans.step.BaseStepMeta; import org.pentaho.di.trans.step.StepDialogInterface; import org.pentaho.di.trans.steps.xmlinput.XMLInputField; import org.pentaho.di.trans.steps.xmlinput.XMLInputFieldPosition; import org.pentaho.di.trans.steps.xmlinput.XMLInputMeta; import org.pentaho.di.ui.core.dialog.EnterNumberDialog; import org.pentaho.di.ui.core.dialog.EnterSelectionDialog; import org.pentaho.di.ui.core.dialog.EnterTextDialog; import org.pentaho.di.ui.core.dialog.ErrorDialog; import org.pentaho.di.ui.core.dialog.PreviewRowsDialog; import org.pentaho.di.ui.core.widget.ColumnInfo; import org.pentaho.di.ui.core.widget.TableView; import org.pentaho.di.ui.core.widget.TextVar; import org.pentaho.di.ui.trans.dialog.TransPreviewProgressDialog; import org.pentaho.di.ui.trans.step.BaseStepDialog; import org.w3c.dom.Node; public class XMLInputDialog extends BaseStepDialog implements StepDialogInterface { private static Class<?> PKG = XMLInputMeta.class; // for i18n purposes, needed by Translator2!! private CTabFolder wTabFolder; private FormData fdTabFolder; private CTabItem wFileTab, wContentTab, wFieldsTab; private Composite wFileComp, wContentComp, wFieldsComp; private FormData fdFileComp, fdContentComp, fdFieldsComp; private Label wlFilename; private Button wbbFilename; // Browse: add file or directory private Button wbdFilename; // Delete private Button wbeFilename; // Edit private Button wbaFilename; // Add or change private TextVar wFilename; private FormData fdlFilename, fdbFilename, fdbdFilename, fdbeFilename, fdbaFilename, fdFilename; private Label wlFilenameList; private TableView wFilenameList; private FormData fdlFilenameList, fdFilenameList; private Label wlFilemask; private Text wFilemask; private FormData fdlFilemask, fdFilemask; private Button wbShowFiles; private FormData fdbShowFiles; private Label wlInclFilename; private Button wInclFilename; private FormData fdlInclFilename, fdInclFilename; private Label wlInclFilenameField; private Text wInclFilenameField; private FormData fdlInclFilenameField, fdInclFilenameField; private Label wlInclRownum; private Button wInclRownum; private FormData fdlInclRownum, fdRownum; private Label wlInclRownumField; private Text wInclRownumField; private FormData fdlInclRownumField, fdInclRownumField; private Label wlLimit; private Text wLimit; private FormData fdlLimit, fdLimit; private Label wlSkip; private Text wSkip; private FormData fdlSkip, fdSkip; private Label wlFileBaseURI; private TextVar wFileBaseURI; private FormData fdlFileBaseURI, fdFileBaseURI; private Label wlIgnoreEntities; private Button wIgnoreEntities; private FormData fdlIgnoreEntities, fdIgnoreEntities; private Label wlNamespaceAware; private Button wNamespaceAware; private FormData fdlNamespaceAware, fdNamespaceAware; private Label wlPosition; private TableView wPosition; private FormData fdlPosition, fdPosition; private TableView wFields; private FormData fdFields; private XMLInputMeta input; public static final int[] dateLengths = new int[] { 23, 19, 14, 10, 10, 10, 10, 8, 8, 8, 8, 6, 6 }; public XMLInputDialog( Shell parent, Object in, TransMeta transMeta, String sname ) { super( parent, (BaseStepMeta) in, transMeta, sname ); input = (XMLInputMeta) in; } public String open() { Shell parent = getParent(); Display display = parent.getDisplay(); shell = new Shell( parent, SWT.DIALOG_TRIM | SWT.RESIZE | SWT.MAX | SWT.MIN ); props.setLook( shell ); setShellImage( shell, input ); ModifyListener lsMod = new ModifyListener() { public void modifyText( ModifyEvent e ) { input.setChanged(); } }; changed = input.hasChanged(); FormLayout formLayout = new FormLayout(); formLayout.marginWidth = Const.FORM_MARGIN; formLayout.marginHeight = Const.FORM_MARGIN; shell.setLayout( formLayout ); shell.setText( BaseMessages.getString( PKG, "XMLInputDialog.DialogTitle" ) ); int middle = props.getMiddlePct(); int margin = Const.MARGIN; // Stepname line wlStepname = new Label( shell, SWT.RIGHT ); wlStepname.setText( BaseMessages.getString( PKG, "System.Label.StepName" ) ); props.setLook( wlStepname ); fdlStepname = new FormData(); fdlStepname.left = new FormAttachment( 0, 0 ); fdlStepname.top = new FormAttachment( 0, margin ); fdlStepname.right = new FormAttachment( middle, -margin ); wlStepname.setLayoutData( fdlStepname ); wStepname = new Text( shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER ); wStepname.setText( stepname ); props.setLook( wStepname ); wStepname.addModifyListener( lsMod ); fdStepname = new FormData(); fdStepname.left = new FormAttachment( middle, 0 ); fdStepname.top = new FormAttachment( 0, margin ); fdStepname.right = new FormAttachment( 100, 0 ); wStepname.setLayoutData( fdStepname ); wTabFolder = new CTabFolder( shell, SWT.BORDER ); props.setLook( wTabFolder, Props.WIDGET_STYLE_TAB ); // //////////////////////// // START OF FILE TAB /// // //////////////////////// wFileTab = new CTabItem( wTabFolder, SWT.NONE ); wFileTab.setText( BaseMessages.getString( PKG, "XMLInputDialog.File.Tab" ) ); wFileComp = new Composite( wTabFolder, SWT.NONE ); props.setLook( wFileComp ); FormLayout fileLayout = new FormLayout(); fileLayout.marginWidth = 3; fileLayout.marginHeight = 3; wFileComp.setLayout( fileLayout ); // Filename line wlFilename = new Label( wFileComp, SWT.RIGHT ); wlFilename.setText( BaseMessages.getString( PKG, "XMLInputDialog.Filename.Label" ) ); props.setLook( wlFilename ); fdlFilename = new FormData(); fdlFilename.left = new FormAttachment( 0, 0 ); fdlFilename.top = new FormAttachment( 0, 0 ); fdlFilename.right = new FormAttachment( middle, -margin ); wlFilename.setLayoutData( fdlFilename ); wbbFilename = new Button( wFileComp, SWT.PUSH | SWT.CENTER ); props.setLook( wbbFilename ); wbbFilename.setText( BaseMessages.getString( PKG, "XMLInputDialog.FilenameBrowse.Button" ) ); wbbFilename.setToolTipText( BaseMessages.getString( PKG, "System.Tooltip.BrowseForFileOrDirAndAdd" ) ); fdbFilename = new FormData(); fdbFilename.right = new FormAttachment( 100, 0 ); fdbFilename.top = new FormAttachment( 0, 0 ); wbbFilename.setLayoutData( fdbFilename ); wbaFilename = new Button( wFileComp, SWT.PUSH | SWT.CENTER ); props.setLook( wbaFilename ); wbaFilename.setText( BaseMessages.getString( PKG, "XMLInputDialog.FilenameAdd.Button" ) ); wbaFilename.setToolTipText( BaseMessages.getString( PKG, "XMLInputDialog.FilenameAdd.Tooltip" ) ); fdbaFilename = new FormData(); fdbaFilename.right = new FormAttachment( wbbFilename, -margin ); fdbaFilename.top = new FormAttachment( 0, 0 ); wbaFilename.setLayoutData( fdbaFilename ); wFilename = new TextVar( transMeta, wFileComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER ); props.setLook( wFilename ); wFilename.addModifyListener( lsMod ); fdFilename = new FormData(); fdFilename.left = new FormAttachment( middle, 0 ); fdFilename.right = new FormAttachment( wbaFilename, -margin ); fdFilename.top = new FormAttachment( 0, 0 ); wFilename.setLayoutData( fdFilename ); wlFilemask = new Label( wFileComp, SWT.RIGHT ); wlFilemask.setText( BaseMessages.getString( PKG, "XMLInputDialog.RegExp.Label" ) ); props.setLook( wlFilemask ); fdlFilemask = new FormData(); fdlFilemask.left = new FormAttachment( 0, 0 ); fdlFilemask.top = new FormAttachment( wFilename, margin ); fdlFilemask.right = new FormAttachment( middle, -margin ); wlFilemask.setLayoutData( fdlFilemask ); wFilemask = new Text( wFileComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER ); props.setLook( wFilemask ); wFilemask.addModifyListener( lsMod ); fdFilemask = new FormData(); fdFilemask.left = new FormAttachment( middle, 0 ); fdFilemask.top = new FormAttachment( wFilename, margin ); fdFilemask.right = new FormAttachment( 100, 0 ); wFilemask.setLayoutData( fdFilemask ); // Filename list line wlFilenameList = new Label( wFileComp, SWT.RIGHT ); wlFilenameList.setText( BaseMessages.getString( PKG, "XMLInputDialog.FilenameList.Label" ) ); props.setLook( wlFilenameList ); fdlFilenameList = new FormData(); fdlFilenameList.left = new FormAttachment( 0, 0 ); fdlFilenameList.top = new FormAttachment( wFilemask, margin ); fdlFilenameList.right = new FormAttachment( middle, -margin ); wlFilenameList.setLayoutData( fdlFilenameList ); // Buttons to the right of the screen... wbdFilename = new Button( wFileComp, SWT.PUSH | SWT.CENTER ); props.setLook( wbdFilename ); wbdFilename.setText( BaseMessages.getString( PKG, "XMLInputDialog.FilenameRemove.Button" ) ); wbdFilename.setToolTipText( BaseMessages.getString( PKG, "XMLInputDialog.FilenameRemove.Tooltip" ) ); fdbdFilename = new FormData(); fdbdFilename.right = new FormAttachment( 100, 0 ); fdbdFilename.top = new FormAttachment( wFilemask, 40 ); wbdFilename.setLayoutData( fdbdFilename ); wbeFilename = new Button( wFileComp, SWT.PUSH | SWT.CENTER ); props.setLook( wbeFilename ); wbeFilename.setText( BaseMessages.getString( PKG, "XMLInputDialog.FilenameEdit.Button" ) ); wbeFilename.setToolTipText( BaseMessages.getString( PKG, "XMLInputDialog.FilenameEdit.Tooltip" ) ); fdbeFilename = new FormData(); fdbeFilename.right = new FormAttachment( 100, 0 ); fdbeFilename.top = new FormAttachment( wbdFilename, margin ); wbeFilename.setLayoutData( fdbeFilename ); wbShowFiles = new Button( wFileComp, SWT.PUSH | SWT.CENTER ); props.setLook( wbShowFiles ); wbShowFiles.setText( BaseMessages.getString( PKG, "XMLInputDialog.ShowFiles.Button" ) ); fdbShowFiles = new FormData(); fdbShowFiles.left = new FormAttachment( middle, 0 ); fdbShowFiles.bottom = new FormAttachment( 100, 0 ); wbShowFiles.setLayoutData( fdbShowFiles ); ColumnInfo[] colinfo = new ColumnInfo[2]; colinfo[0] = new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.Files.Filename.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ); colinfo[1] = new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.Files.Wildcard.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ); colinfo[0].setUsingVariables( true ); colinfo[1].setToolTip( BaseMessages.getString( PKG, "XMLInputDialog.Files.Wildcard.Tooltip" ) ); wFilenameList = new TableView( transMeta, wFileComp, SWT.FULL_SELECTION | SWT.SINGLE | SWT.BORDER, colinfo, 2, lsMod, props ); props.setLook( wFilenameList ); fdFilenameList = new FormData(); fdFilenameList.left = new FormAttachment( middle, 0 ); fdFilenameList.right = new FormAttachment( wbdFilename, -margin ); fdFilenameList.top = new FormAttachment( wFilemask, margin ); fdFilenameList.bottom = new FormAttachment( wbShowFiles, -margin ); wFilenameList.setLayoutData( fdFilenameList ); fdFileComp = new FormData(); fdFileComp.left = new FormAttachment( 0, 0 ); fdFileComp.top = new FormAttachment( 0, 0 ); fdFileComp.right = new FormAttachment( 100, 0 ); fdFileComp.bottom = new FormAttachment( 100, 0 ); wFileComp.setLayoutData( fdFileComp ); wFileComp.layout(); wFileTab.setControl( wFileComp ); // /////////////////////////////////////////////////////////// // / END OF FILE TAB // /////////////////////////////////////////////////////////// // //////////////////////// // START OF CONTENT TAB/// // / wContentTab = new CTabItem( wTabFolder, SWT.NONE ); wContentTab.setText( BaseMessages.getString( PKG, "XMLInputDialog.Content.Tab" ) ); FormLayout contentLayout = new FormLayout(); contentLayout.marginWidth = 3; contentLayout.marginHeight = 3; wContentComp = new Composite( wTabFolder, SWT.NONE ); props.setLook( wContentComp ); wContentComp.setLayout( contentLayout ); wlInclFilename = new Label( wContentComp, SWT.RIGHT ); wlInclFilename.setText( BaseMessages.getString( PKG, "XMLInputDialog.InclFilename.Label" ) ); props.setLook( wlInclFilename ); fdlInclFilename = new FormData(); fdlInclFilename.left = new FormAttachment( 0, 0 ); fdlInclFilename.top = new FormAttachment( 0, 0 ); fdlInclFilename.right = new FormAttachment( middle, -margin ); wlInclFilename.setLayoutData( fdlInclFilename ); wInclFilename = new Button( wContentComp, SWT.CHECK ); props.setLook( wInclFilename ); wInclFilename.setToolTipText( BaseMessages.getString( PKG, "XMLInputDialog.InclFilename.Tooltip" ) ); fdInclFilename = new FormData(); fdInclFilename.left = new FormAttachment( middle, 0 ); fdInclFilename.top = new FormAttachment( 0, 0 ); wInclFilename.setLayoutData( fdInclFilename ); wlInclFilenameField = new Label( wContentComp, SWT.LEFT ); wlInclFilenameField.setText( BaseMessages.getString( PKG, "XMLInputDialog.InclFilenameField.Label" ) ); props.setLook( wlInclFilenameField ); fdlInclFilenameField = new FormData(); fdlInclFilenameField.left = new FormAttachment( wInclFilename, margin ); fdlInclFilenameField.top = new FormAttachment( 0, 0 ); wlInclFilenameField.setLayoutData( fdlInclFilenameField ); wInclFilenameField = new Text( wContentComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER ); props.setLook( wInclFilenameField ); wInclFilenameField.addModifyListener( lsMod ); fdInclFilenameField = new FormData(); fdInclFilenameField.left = new FormAttachment( wlInclFilenameField, margin ); fdInclFilenameField.top = new FormAttachment( 0, 0 ); fdInclFilenameField.right = new FormAttachment( 100, 0 ); wInclFilenameField.setLayoutData( fdInclFilenameField ); wlInclRownum = new Label( wContentComp, SWT.RIGHT ); wlInclRownum.setText( BaseMessages.getString( PKG, "XMLInputDialog.InclRownum.Label" ) ); props.setLook( wlInclRownum ); fdlInclRownum = new FormData(); fdlInclRownum.left = new FormAttachment( 0, 0 ); fdlInclRownum.top = new FormAttachment( wInclFilenameField, margin ); fdlInclRownum.right = new FormAttachment( middle, -margin ); wlInclRownum.setLayoutData( fdlInclRownum ); wInclRownum = new Button( wContentComp, SWT.CHECK ); props.setLook( wInclRownum ); wInclRownum.setToolTipText( BaseMessages.getString( PKG, "XMLInputDialog.InclRownum.Tooltip" ) ); fdRownum = new FormData(); fdRownum.left = new FormAttachment( middle, 0 ); fdRownum.top = new FormAttachment( wInclFilenameField, margin ); wInclRownum.setLayoutData( fdRownum ); wlInclRownumField = new Label( wContentComp, SWT.RIGHT ); wlInclRownumField.setText( BaseMessages.getString( PKG, "XMLInputDialog.InclRownumField.Label" ) ); props.setLook( wlInclRownumField ); fdlInclRownumField = new FormData(); fdlInclRownumField.left = new FormAttachment( wInclRownum, margin ); fdlInclRownumField.top = new FormAttachment( wInclFilenameField, margin ); wlInclRownumField.setLayoutData( fdlInclRownumField ); wInclRownumField = new Text( wContentComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER ); props.setLook( wInclRownumField ); wInclRownumField.addModifyListener( lsMod ); fdInclRownumField = new FormData(); fdInclRownumField.left = new FormAttachment( wlInclRownumField, margin ); fdInclRownumField.top = new FormAttachment( wInclFilenameField, margin ); fdInclRownumField.right = new FormAttachment( 100, 0 ); wInclRownumField.setLayoutData( fdInclRownumField ); wlLimit = new Label( wContentComp, SWT.RIGHT ); wlLimit.setText( BaseMessages.getString( PKG, "XMLInputDialog.Limit.Label" ) ); props.setLook( wlLimit ); fdlLimit = new FormData(); fdlLimit.left = new FormAttachment( 0, 0 ); fdlLimit.top = new FormAttachment( wInclRownumField, margin ); fdlLimit.right = new FormAttachment( middle, -margin ); wlLimit.setLayoutData( fdlLimit ); wLimit = new Text( wContentComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER ); props.setLook( wLimit ); wLimit.addModifyListener( lsMod ); fdLimit = new FormData(); fdLimit.left = new FormAttachment( middle, 0 ); fdLimit.top = new FormAttachment( wInclRownumField, margin ); fdLimit.right = new FormAttachment( 100, 0 ); wLimit.setLayoutData( fdLimit ); wlSkip = new Label( wContentComp, SWT.RIGHT ); wlSkip.setText( BaseMessages.getString( PKG, "XMLInputDialog.Skip.Label" ) ); props.setLook( wlSkip ); fdlSkip = new FormData(); fdlSkip.left = new FormAttachment( 0, 0 ); fdlSkip.top = new FormAttachment( wLimit, margin ); fdlSkip.right = new FormAttachment( middle, -margin ); wlSkip.setLayoutData( fdlSkip ); wSkip = new Text( wContentComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER ); props.setLook( wSkip ); wSkip.addModifyListener( lsMod ); fdSkip = new FormData(); fdSkip.left = new FormAttachment( middle, 0 ); fdSkip.top = new FormAttachment( wLimit, margin ); fdSkip.right = new FormAttachment( 100, 0 ); wSkip.setLayoutData( fdSkip ); wlFileBaseURI = new Label( wContentComp, SWT.RIGHT ); wlFileBaseURI.setText( BaseMessages.getString( PKG, "XMLInputDialog.BaseURI.Label" ) ); props.setLook( wlFileBaseURI ); fdlFileBaseURI = new FormData(); fdlFileBaseURI.left = new FormAttachment( 0, 0 ); fdlFileBaseURI.top = new FormAttachment( wSkip, margin ); fdlFileBaseURI.right = new FormAttachment( middle, -margin ); wlFileBaseURI.setLayoutData( fdlFileBaseURI ); wFileBaseURI = new TextVar( transMeta, wContentComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER ); props.setLook( wFileBaseURI ); wFileBaseURI.addModifyListener( lsMod ); fdFileBaseURI = new FormData(); fdFileBaseURI.left = new FormAttachment( middle, 0 ); fdFileBaseURI.top = new FormAttachment( wSkip, margin ); fdFileBaseURI.right = new FormAttachment( 100, 0 ); wFileBaseURI.setLayoutData( fdFileBaseURI ); wlIgnoreEntities = new Label( wContentComp, SWT.RIGHT ); wlIgnoreEntities.setText( BaseMessages.getString( PKG, "XMLInputDialog.IgnoreEntities.Label" ) ); props.setLook( wlIgnoreEntities ); fdlIgnoreEntities = new FormData(); fdlIgnoreEntities.left = new FormAttachment( 0, 0 ); fdlIgnoreEntities.top = new FormAttachment( wFileBaseURI, margin ); fdlIgnoreEntities.right = new FormAttachment( middle, -margin ); wlIgnoreEntities.setLayoutData( fdlIgnoreEntities ); wIgnoreEntities = new Button( wContentComp, SWT.CHECK ); props.setLook( wIgnoreEntities ); wIgnoreEntities.setToolTipText( BaseMessages.getString( PKG, "XMLInputDialog.IgnoreEntities.Tooltip" ) ); fdIgnoreEntities = new FormData(); fdIgnoreEntities.left = new FormAttachment( middle, 0 ); fdIgnoreEntities.top = new FormAttachment( wFileBaseURI, margin ); wIgnoreEntities.setLayoutData( fdIgnoreEntities ); wlNamespaceAware = new Label( wContentComp, SWT.RIGHT ); wlNamespaceAware.setText( BaseMessages.getString( PKG, "XMLInputDialog.NamespaceAware.Label" ) ); props.setLook( wlNamespaceAware ); fdlNamespaceAware = new FormData(); fdlNamespaceAware.left = new FormAttachment( 0, 0 ); fdlNamespaceAware.top = new FormAttachment( wIgnoreEntities, margin ); fdlNamespaceAware.right = new FormAttachment( middle, -margin ); wlNamespaceAware.setLayoutData( fdlNamespaceAware ); wNamespaceAware = new Button( wContentComp, SWT.CHECK ); props.setLook( wNamespaceAware ); wNamespaceAware.setToolTipText( BaseMessages.getString( PKG, "XMLInputDialog.NamespaceAware.Tooltip" ) ); fdNamespaceAware = new FormData(); fdNamespaceAware.left = new FormAttachment( middle, 0 ); fdNamespaceAware.top = new FormAttachment( wIgnoreEntities, margin ); wNamespaceAware.setLayoutData( fdNamespaceAware ); wlPosition = new Label( wContentComp, SWT.RIGHT ); wlPosition.setText( BaseMessages.getString( PKG, "XMLInputDialog.Location.Label" ) ); props.setLook( wlPosition ); fdlPosition = new FormData(); fdlPosition.left = new FormAttachment( 0, 0 ); fdlPosition.top = new FormAttachment( wNamespaceAware, margin * 3 ); fdlPosition.right = new FormAttachment( middle, -margin ); wlPosition.setLayoutData( fdlPosition ); ColumnInfo[] locationColumns = new ColumnInfo[] { new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.Position.Elements.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ) }; int nrElements = input.getInputPosition() != null ? input.getInputPosition().length : 0; wPosition = new TableView( transMeta, wContentComp, SWT.FULL_SELECTION | SWT.MULTI, locationColumns, nrElements, lsMod, props ); wPosition.addModifyListener( lsMod ); fdPosition = new FormData(); fdPosition.left = new FormAttachment( middle, 0 ); fdPosition.top = new FormAttachment( wNamespaceAware, margin * 3 ); fdPosition.bottom = new FormAttachment( 100, -50 ); fdPosition.right = new FormAttachment( 100, 0 ); wPosition.setLayoutData( fdPosition ); fdContentComp = new FormData(); fdContentComp.left = new FormAttachment( 0, 0 ); fdContentComp.top = new FormAttachment( 0, 0 ); fdContentComp.right = new FormAttachment( 100, 0 ); fdContentComp.bottom = new FormAttachment( 100, 0 ); wContentComp.setLayoutData( fdContentComp ); wContentComp.layout(); wContentTab.setControl( wContentComp ); // /////////////////////////////////////////////////////////// // / END OF CONTENT TAB // /////////////////////////////////////////////////////////// // Fields tab... // wFieldsTab = new CTabItem( wTabFolder, SWT.NONE ); wFieldsTab.setText( BaseMessages.getString( PKG, "XMLInputDialog.Fields.Tab" ) ); FormLayout fieldsLayout = new FormLayout(); fieldsLayout.marginWidth = Const.FORM_MARGIN; fieldsLayout.marginHeight = Const.FORM_MARGIN; wFieldsComp = new Composite( wTabFolder, SWT.NONE ); wFieldsComp.setLayout( fieldsLayout ); props.setLook( wFieldsComp ); wGet = new Button( wFieldsComp, SWT.PUSH ); wGet.setText( BaseMessages.getString( PKG, "XMLInputDialog.GetFields.Button" ) ); fdGet = new FormData(); fdGet.left = new FormAttachment( 50, 0 ); fdGet.bottom = new FormAttachment( 100, 0 ); wGet.setLayoutData( fdGet ); final int FieldsRows = input.getInputFields().length; // Prepare a list of possible formats... String[] dats = Const.getDateFormats(); String[] nums = Const.getNumberFormats(); int totsize = dats.length + nums.length; String[] formats = new String[totsize]; for ( int x = 0; x < dats.length; x++ ) { formats[x] = dats[x]; } for ( int x = 0; x < nums.length; x++ ) { formats[dats.length + x] = nums[x]; } ColumnInfo[] colinf = new ColumnInfo[] { new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Name.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Type.Column" ), ColumnInfo.COLUMN_TYPE_CCOMBO, ValueMeta.getTypes(), true ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Format.Column" ), ColumnInfo.COLUMN_TYPE_CCOMBO, formats ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Length.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Precision.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Currency.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Decimal.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Group.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.TrimType.Column" ), ColumnInfo.COLUMN_TYPE_CCOMBO, XMLInputField.trimTypeDesc, true ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Repeat.Column" ), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { BaseMessages.getString( PKG, "System.Combo.Yes" ), BaseMessages.getString( PKG, "System.Combo.No" ) }, true ), new ColumnInfo( BaseMessages.getString( PKG, "XMLInputDialog.FieldsTable.Position.Column" ), ColumnInfo.COLUMN_TYPE_TEXT, false ), }; wFields = new TableView( transMeta, wFieldsComp, SWT.FULL_SELECTION | SWT.MULTI, colinf, FieldsRows, lsMod, props ); fdFields = new FormData(); fdFields.left = new FormAttachment( 0, 0 ); fdFields.top = new FormAttachment( 0, 0 ); fdFields.right = new FormAttachment( 100, 0 ); fdFields.bottom = new FormAttachment( wGet, -margin ); wFields.setLayoutData( fdFields ); fdFieldsComp = new FormData(); fdFieldsComp.left = new FormAttachment( 0, 0 ); fdFieldsComp.top = new FormAttachment( 0, 0 ); fdFieldsComp.right = new FormAttachment( 100, 0 ); fdFieldsComp.bottom = new FormAttachment( 100, 0 ); wFieldsComp.setLayoutData( fdFieldsComp ); wFieldsComp.layout(); wFieldsTab.setControl( wFieldsComp ); fdTabFolder = new FormData(); fdTabFolder.left = new FormAttachment( 0, 0 ); fdTabFolder.top = new FormAttachment( wStepname, margin ); fdTabFolder.right = new FormAttachment( 100, 0 ); fdTabFolder.bottom = new FormAttachment( 100, -50 ); wTabFolder.setLayoutData( fdTabFolder ); wOK = new Button( shell, SWT.PUSH ); wOK.setText( BaseMessages.getString( PKG, "System.Button.OK" ) ); wPreview = new Button( shell, SWT.PUSH ); wPreview.setText( BaseMessages.getString( PKG, "XMLInputDialog.Button.PreviewRows" ) ); wCancel = new Button( shell, SWT.PUSH ); wCancel.setText( BaseMessages.getString( PKG, "System.Button.Cancel" ) ); setButtonPositions( new Button[] { wOK, wPreview, wCancel }, margin, wTabFolder ); // Add listeners lsOK = new Listener() { public void handleEvent( Event e ) { ok(); } }; lsGet = new Listener() { public void handleEvent( Event e ) { get(); } }; lsPreview = new Listener() { public void handleEvent( Event e ) { preview(); } }; lsCancel = new Listener() { public void handleEvent( Event e ) { cancel(); } }; wOK.addListener( SWT.Selection, lsOK ); wGet.addListener( SWT.Selection, lsGet ); wPreview.addListener( SWT.Selection, lsPreview ); wCancel.addListener( SWT.Selection, lsCancel ); lsDef = new SelectionAdapter() { public void widgetDefaultSelected( SelectionEvent e ) { ok(); } }; wStepname.addSelectionListener( lsDef ); wLimit.addSelectionListener( lsDef ); wInclRownumField.addSelectionListener( lsDef ); wInclFilenameField.addSelectionListener( lsDef ); wIgnoreEntities.addSelectionListener( lsDef ); wNamespaceAware.addSelectionListener( lsDef ); // Add the file to the list of files... SelectionAdapter selA = new SelectionAdapter() { public void widgetSelected( SelectionEvent arg0 ) { wFilenameList.add( new String[] { wFilename.getText(), wFilemask.getText() } ); wFilename.setText( "" ); wFilemask.setText( "" ); wFilenameList.removeEmptyRows(); wFilenameList.setRowNums(); wFilenameList.optWidth( true ); } }; wbaFilename.addSelectionListener( selA ); wFilename.addSelectionListener( selA ); // Delete files from the list of files... wbdFilename.addSelectionListener( new SelectionAdapter() { public void widgetSelected( SelectionEvent arg0 ) { int[] idx = wFilenameList.getSelectionIndices(); wFilenameList.remove( idx ); wFilenameList.removeEmptyRows(); wFilenameList.setRowNums(); } } ); // Edit the selected file & remove from the list... wbeFilename.addSelectionListener( new SelectionAdapter() { public void widgetSelected( SelectionEvent arg0 ) { int idx = wFilenameList.getSelectionIndex(); if ( idx >= 0 ) { String[] string = wFilenameList.getItem( idx ); wFilename.setText( string[0] ); wFilemask.setText( string[1] ); wFilenameList.remove( idx ); } wFilenameList.removeEmptyRows(); wFilenameList.setRowNums(); } } ); // Show the files that are selected at this time... wbShowFiles.addSelectionListener( new SelectionAdapter() { public void widgetSelected( SelectionEvent e ) { try { XMLInputMeta tfii = new XMLInputMeta(); getInfo( tfii ); FileInputList fileInputList = tfii.getFiles( transMeta ); String[] files = fileInputList.getFileStrings(); if ( files != null && files.length > 0 ) { EnterSelectionDialog esd = new EnterSelectionDialog( shell, files, BaseMessages.getString( PKG, "XMLInputDialog.FilesReadSelection.DialogTitle" ), BaseMessages.getString( PKG, "XMLInputDialog.FilesReadSelection.DialogMessage" ) ); esd.setViewOnly(); esd.open(); } else { MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR ); mb.setMessage( BaseMessages.getString( PKG, "XMLInputDialog.NoFileFound.DialogMessage" ) ); mb.setText( BaseMessages.getString( PKG, "System.Dialog.Error.Title" ) ); mb.open(); } } catch ( KettleException ex ) { new ErrorDialog( shell, BaseMessages.getString( PKG, "XMLInputDialog.ErrorParsingData.DialogTitle" ), BaseMessages.getString( PKG, "XMLInputDialog.ErrorParsingData.DialogMessage" ), ex ); } } } ); // Enable/disable the right fields to allow a filename to be added to // each row... wInclFilename.addSelectionListener( new SelectionAdapter() { public void widgetSelected( SelectionEvent e ) { setIncludeFilename(); } } ); // Enable/disable the right fields to allow a row number to be added to // each row... wInclRownum.addSelectionListener( new SelectionAdapter() { public void widgetSelected( SelectionEvent e ) { setIncludeRownum(); } } ); // Whenever something changes, set the tooltip to the expanded version // of the filename: wFilename.addModifyListener( new ModifyListener() { public void modifyText( ModifyEvent e ) { wFilename.setToolTipText( transMeta.environmentSubstitute( wFilename.getText() ) ); } } ); // Listen to the Browse... button wbbFilename.addSelectionListener( new SelectionAdapter() { public void widgetSelected( SelectionEvent e ) { if ( wFilemask.getText() != null && wFilemask.getText().length() > 0 ) { // A mask: a directory! DirectoryDialog dialog = new DirectoryDialog( shell, SWT.OPEN ); if ( wFilename.getText() != null ) { String fpath = transMeta.environmentSubstitute( wFilename.getText() ); dialog.setFilterPath( fpath ); } if ( dialog.open() != null ) { String str = dialog.getFilterPath(); wFilename.setText( str ); } } else { FileDialog dialog = new FileDialog( shell, SWT.OPEN ); dialog.setFilterExtensions( new String[] { "*.xml;*.XML", "*" } ); if ( wFilename.getText() != null ) { String fname = transMeta.environmentSubstitute( wFilename.getText() ); dialog.setFileName( fname ); } dialog.setFilterNames( new String[] { BaseMessages.getString( PKG, "System.FileType.XMLFiles" ), BaseMessages.getString( PKG, "System.FileType.AllFiles" ) } ); if ( dialog.open() != null ) { String str = dialog.getFilterPath() + System.getProperty( "file.separator" ) + dialog.getFileName(); wFilename.setText( str ); } } } } ); // Whenever something changes, set the tooltip to the expanded version // of the wFileBaseURI: wFileBaseURI.addModifyListener( new ModifyListener() { public void modifyText( ModifyEvent e ) { wFileBaseURI.setToolTipText( transMeta.environmentSubstitute( wFileBaseURI.getText() ) ); } } ); // Detect X or ALT-F4 or something that kills this window... shell.addShellListener( new ShellAdapter() { public void shellClosed( ShellEvent e ) { cancel(); } } ); wTabFolder.setSelection( 0 ); // Set the shell size, based upon previous time... setSize(); getData( input ); input.setChanged( changed ); wFields.optWidth( true ); shell.open(); while ( !shell.isDisposed() ) { if ( !display.readAndDispatch() ) { display.sleep(); } } return stepname; } public void setMultiple() { /* * wlFilemask.setEnabled(wMultiple.getSelection()); wFilemask.setEnabled(wMultiple.getSelection()); * wlFilename.setText(wMultiple.getSelection()?"Directory":"Filename "); */ } public void setIncludeFilename() { wlInclFilenameField.setEnabled( wInclFilename.getSelection() ); wInclFilenameField.setEnabled( wInclFilename.getSelection() ); } public void setIncludeRownum() { wlInclRownumField.setEnabled( wInclRownum.getSelection() ); wInclRownumField.setEnabled( wInclRownum.getSelection() ); } /** * Read the data from the TextFileInputMeta object and show it in this dialog. * * @param in * The TextFileInputMeta object to obtain the data from. */ public void getData( XMLInputMeta in ) { if ( in.getFileName() != null ) { wFilenameList.removeAll(); for ( int i = 0; i < in.getFileName().length; i++ ) { wFilenameList.add( new String[] { in.getFileName()[i], in.getFileMask()[i] } ); } wFilenameList.removeEmptyRows(); wFilenameList.setRowNums(); wFilenameList.optWidth( true ); } wInclFilename.setSelection( in.includeFilename() ); wInclRownum.setSelection( in.includeRowNumber() ); // wMultiple.setSelection(in.wildcard); if ( in.getFilenameField() != null ) { wInclFilenameField.setText( in.getFilenameField() ); } if ( in.getRowNumberField() != null ) { wInclRownumField.setText( in.getRowNumberField() ); } wLimit.setText( "" + in.getRowLimit() ); wSkip.setText( "" + in.getNrRowsToSkip() ); if ( in.getFileBaseURI() != null ) { wFileBaseURI.setText( in.getFileBaseURI() ); } wIgnoreEntities.setSelection( in.isIgnoreEntities() ); wNamespaceAware.setSelection( in.isNamespaceAware() ); logDebug( BaseMessages.getString( PKG, "XMLInputDialog.Log.GettingFieldsInfo" ) ); for ( int i = 0; i < in.getInputFields().length; i++ ) { XMLInputField field = in.getInputFields()[i]; if ( field != null ) { TableItem item = wFields.table.getItem( i ); String name = field.getName(); String type = field.getTypeDesc(); String format = field.getFormat(); String length = "" + field.getLength(); String prec = "" + field.getPrecision(); String curr = field.getCurrencySymbol(); String group = field.getGroupSymbol(); String decim = field.getDecimalSymbol(); String trim = field.getTrimTypeDesc(); String rep = field.isRepeated() ? BaseMessages.getString( PKG, "System.Combo.Yes" ) : BaseMessages.getString( PKG, "System.Combo.No" ); if ( name != null ) { item.setText( 1, name ); } if ( type != null ) { item.setText( 2, type ); } if ( format != null ) { item.setText( 3, format ); } if ( length != null && !"-1".equals( length ) ) { item.setText( 4, length ); } if ( prec != null && !"-1".equals( prec ) ) { item.setText( 5, prec ); } if ( curr != null ) { item.setText( 6, curr ); } if ( decim != null ) { item.setText( 7, decim ); } if ( group != null ) { item.setText( 8, group ); } if ( trim != null ) { item.setText( 9, trim ); } if ( rep != null ) { item.setText( 10, rep ); } item.setText( 11, field.getFieldPositionsCode() ); } } for ( int i = 0; i < input.getInputPosition().length; i++ ) { TableItem item = wPosition.table.getItem( i ); if ( input.getInputPosition()[i] != null ) { item.setText( 1, input.getInputPosition()[i] ); } } wFields.removeEmptyRows(); wFields.setRowNums(); wFields.optWidth( true ); wPosition.removeEmptyRows(); wPosition.setRowNums(); wPosition.optWidth( true ); setMultiple(); setIncludeFilename(); setIncludeRownum(); wStepname.selectAll(); wStepname.setFocus(); } private void cancel() { stepname = null; input.setChanged( changed ); dispose(); } private void ok() { if ( Utils.isEmpty( wStepname.getText() ) ) { return; } try { getInfo( input ); } catch ( KettleException e ) { new ErrorDialog( shell, BaseMessages.getString( PKG, "XMLInputDialog.ErrorParsingData.DialogTitle" ), BaseMessages .getString( PKG, "XMLInputDialog.ErrorParsingData.DialogMessage" ), e ); } dispose(); } private void getInfo( XMLInputMeta in ) throws KettleException { stepname = wStepname.getText(); // return value // copy info to TextFileInputMeta class (input) in.setRowLimit( Const.toLong( wLimit.getText(), 0L ) ); in.setNrRowsToSkip( Const.toInt( wSkip.getText(), 0 ) ); in.setFilenameField( wInclFilenameField.getText() ); in.setRowNumberField( wInclRownumField.getText() ); in.setIncludeFilename( wInclFilename.getSelection() ); in.setIncludeRowNumber( wInclRownum.getSelection() ); in.setFileBaseURI( wFileBaseURI.getText() ); in.setIgnoreEntities( wIgnoreEntities.getSelection() ); in.setNamespaceAware( wNamespaceAware.getSelection() ); int nrFiles = wFilenameList.getItemCount(); int nrFields = wFields.nrNonEmpty(); int nrPositions = wPosition.nrNonEmpty(); in.allocate( nrFiles, nrFields, nrPositions ); in.setFileName( wFilenameList.getItems( 0 ) ); in.setFileMask( wFilenameList.getItems( 1 ) ); for ( int i = 0; i < nrFields; i++ ) { XMLInputField field = new XMLInputField(); TableItem item = wFields.getNonEmpty( i ); field.setName( item.getText( 1 ) ); field.setType( ValueMeta.getType( item.getText( 2 ) ) ); field.setFormat( item.getText( 3 ) ); field.setLength( Const.toInt( item.getText( 4 ), -1 ) ); field.setPrecision( Const.toInt( item.getText( 5 ), -1 ) ); field.setCurrencySymbol( item.getText( 6 ) ); field.setDecimalSymbol( item.getText( 7 ) ); field.setGroupSymbol( item.getText( 8 ) ); field.setTrimType( XMLInputField.getTrimTypeByDesc( item.getText( 9 ) ) ); field.setRepeated( BaseMessages.getString( PKG, "System.Combo.Yes" ).equalsIgnoreCase( item.getText( 10 ) ) ); field.setFieldPosition( item.getText( 11 ) ); //CHECKSTYLE:Indentation:OFF in.getInputFields()[i] = field; } for ( int i = 0; i < nrPositions; i++ ) { TableItem item = wPosition.getNonEmpty( i ); //CHECKSTYLE:Indentation:OFF in.getInputPosition()[i] = item.getText( 1 ); } } // check if the path is given private boolean checkInputPositionsFilled( XMLInputMeta meta ) { if ( meta.getInputPosition() == null || meta.getInputPosition().length < 1 ) { MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR ); mb.setMessage( BaseMessages.getString( PKG, "XMLInputDialog.SpecifyRepeatingElement.DialogMessage" ) ); mb.setText( BaseMessages.getString( PKG, "System.Dialog.Error.Title" ) ); mb.open(); return false; } else { return true; } } private void get() { boolean finished = false; int elementsFound = 0; try { XMLInputMeta meta = new XMLInputMeta(); getInfo( meta ); // check if the path is given if ( !checkInputPositionsFilled( meta ) ) { return; } EnterNumberDialog dialog = new EnterNumberDialog( shell, 1000, "Number of elements to scan", "Enter the number of elements to scan (0=all)" ); int maxElements = dialog.open(); // OK, let's try to walk through the complete tree RowMetaInterface row = new RowMeta(); // no fields found... // Keep the list of positions List<XMLInputFieldPosition> path = new ArrayList<XMLInputFieldPosition>(); // ArrayList of XMLInputFieldPosition FileInputList inputList = meta.getFiles( transMeta ); for ( int f = 0; f < inputList.getFiles().size() && !finished; f++ ) { // Open the file... Node rootNode = XMLHandler.loadXMLFile( inputList.getFile( f ), transMeta .environmentSubstitute( meta.getFileBaseURI() ), meta.isIgnoreEntities(), meta.isNamespaceAware() ); // Position to the repeating item for ( int p = 0; rootNode != null && p < meta.getInputPosition().length - 1; p++ ) { rootNode = XMLHandler.getSubNode( rootNode, meta.getInputPosition()[p] ); } if ( rootNode == null ) { // Specified node not found: return! return; } if ( meta.getInputPosition().length > 1 ) { // Count the number of rootnodes String itemElement = meta.getInputPosition()[meta.getInputPosition().length - 1]; int nrItems = XMLHandler.countNodes( rootNode, itemElement ); for ( int i = 0; i < nrItems && !finished; i++ ) { Node itemNode = XMLHandler.getSubNodeByNr( rootNode, itemElement, i, false ); if ( i >= meta.getNrRowsToSkip() ) { getValues( itemNode, row, path, 0 ); elementsFound++; if ( elementsFound >= maxElements && maxElements > 0 ) { finished = true; } } } } else { // Only search the root node // getValues( rootNode, row, path, 0 ); elementsFound++; if ( elementsFound >= maxElements && maxElements > 0 ) { finished = true; } } } // System.out.println("Values found: "+row); // add the values to the grid... for ( int i = 0; i < row.size(); i++ ) { ValueMetaInterface v = row.getValueMeta( i ); TableItem item = new TableItem( wFields.table, SWT.NONE ); item.setText( 1, v.getName() ); item.setText( 2, v.getTypeDesc() ); item.setText( 11, v.getOrigin() ); } wFields.removeEmptyRows(); wFields.setRowNums(); wFields.optWidth( true ); } catch ( KettleException e ) { new ErrorDialog( shell, BaseMessages.getString( PKG, "XMLInputDialog.ErrorParsingData.DialogTitle" ), BaseMessages .getString( PKG, "XMLInputDialog.ErrorParsingData.DialogMessage" ), e ); } } /** * Get all the values defined in a Node * * @param node * The node to examine * @param row * The */ private void getValues( Node node, RowMetaInterface row, List<XMLInputFieldPosition> path, int level ) throws KettleException { String baseName = ""; for ( int p = 0; p < path.size(); p++ ) { XMLInputFieldPosition pos = path.get( p ); String elementName = pos.getName() + pos.getElementNr(); if ( !elementName.startsWith( "#" ) ) { baseName += StringUtil.initCap( new ValueMetaAndData( "p", elementName ).toString() ); } } // Add the root element if ( level == 0 ) { if ( XMLHandler.getNodeValue( node ) != null ) { XMLInputFieldPosition attrPos = new XMLInputFieldPosition( node.getNodeName(), XMLInputFieldPosition.XML_ROOT ); path.add( attrPos ); String root = StringUtil.initCap( new ValueMetaAndData( "a", node.getNodeName() ).toString() ); String fieldName = baseName + root; if ( row.searchValueMeta( fieldName ) == null ) { // Not there yet: add it! // Add the fieldname... ValueMeta field = new ValueMeta( fieldName, ValueMeta.TYPE_STRING ); // Add the path to this attribute to the origin of the // field... String encoded = XMLInputFieldPosition.encodePath( path ); field.setOrigin( encoded ); row.addValueMeta( field ); } // Now remove the root from the path again, it's not needed // realy... path.remove( path.size() - 1 ); } } // First check out the attributes... String[] attributes = XMLHandler.getNodeAttributes( node ); if ( attributes != null ) { for ( int i = 0; i < attributes.length; i++ ) { XMLInputFieldPosition attrPos = new XMLInputFieldPosition( attributes[i], XMLInputFieldPosition.XML_ATTRIBUTE ); path.add( attrPos ); String attribute = StringUtil.initCap( new ValueMetaAndData( "a", attributes[i] ).toString() ); String fieldName = baseName + attribute; // See if this fieldname already exists in Row... if ( row.searchValueMeta( fieldName ) == null ) { // Add the fieldname... ValueMeta field = new ValueMeta( fieldName, ValueMeta.TYPE_STRING ); // Add the path to this attribute to the origin of the // field... String encoded = XMLInputFieldPosition.encodePath( path ); field.setOrigin( encoded ); row.addValueMeta( field ); } path.remove( path.size() - 1 ); } } // Then get the elements String[] elements = XMLHandler.getNodeElements( node ); if ( elements != null ) { for ( int e = 0; e < elements.length; e++ ) { // Count the number of occurrences of this element... int occurrences = XMLHandler.countNodes( node, elements[e] ); for ( int o = 0; o < occurrences; o++ ) { Node itemNode = XMLHandler.getSubNodeByNr( node, elements[e], o, false ); XMLInputFieldPosition xmlPos = new XMLInputFieldPosition( elements[e], XMLInputFieldPosition.XML_ELEMENT, o + 1 ); path.add( xmlPos ); getValues( itemNode, row, path, level + 1 ); path.remove( path.size() - 1 ); // remove the last one again } } } else { // No child nodes left: this is a value we want to grab if ( path.size() > 0 ) { int idxLast = path.size() - 1; XMLInputFieldPosition last = path.get( idxLast ); path.remove( idxLast ); if ( path.size() > 0 ) { String encoded = XMLInputFieldPosition.encodePath( path ); if ( row.searchValueMeta( baseName ) == null ) { ValueMeta value = new ValueMeta( baseName, ValueMeta.TYPE_STRING ); value.setOrigin( encoded ); row.addValueMeta( value ); } } path.add( last ); } } } // Preview the data private void preview() { try { // Create the XML input step XMLInputMeta oneMeta = new XMLInputMeta(); getInfo( oneMeta ); // check if the path is given if ( !checkInputPositionsFilled( oneMeta ) ) { return; } TransMeta previewMeta = TransPreviewFactory.generatePreviewTransformation( transMeta, oneMeta, wStepname.getText() ); EnterNumberDialog numberDialog = new EnterNumberDialog( shell, props.getDefaultPreviewSize(), BaseMessages.getString( PKG, "XMLInputDialog.NumberRows.DialogTitle" ), BaseMessages.getString( PKG, "XMLInputDialog.NumberRows.DialogMessage" ) ); int previewSize = numberDialog.open(); if ( previewSize > 0 ) { TransPreviewProgressDialog progressDialog = new TransPreviewProgressDialog( shell, previewMeta, new String[] { wStepname.getText() }, new int[] { previewSize } ); progressDialog.open(); if ( !progressDialog.isCancelled() ) { Trans trans = progressDialog.getTrans(); String loggingText = progressDialog.getLoggingText(); if ( trans.getResult() != null && trans.getResult().getNrErrors() > 0 ) { EnterTextDialog etd = new EnterTextDialog( shell, BaseMessages.getString( PKG, "System.Dialog.PreviewError.Title" ), BaseMessages .getString( PKG, "System.Dialog.PreviewError.Message" ), loggingText, true ); etd.setReadOnly(); etd.open(); } PreviewRowsDialog prd = new PreviewRowsDialog( shell, transMeta, SWT.NONE, wStepname.getText(), progressDialog.getPreviewRowsMeta( wStepname .getText() ), progressDialog.getPreviewRows( wStepname.getText() ), loggingText ); prd.open(); } } } catch ( KettleException e ) { new ErrorDialog( shell, BaseMessages.getString( PKG, "XMLInputDialog.ErrorPreviewingData.DialogTitle" ), BaseMessages .getString( PKG, "XMLInputDialog.ErrorPreviewingData.DialogMessage" ), e ); } } }