/*! ******************************************************************************
*
* 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 );
}
}
}