/*! ******************************************************************************
*
* 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.job.entries.msaccessbulkload;
import org.eclipse.swt.SWT;
import org.eclipse.swt.custom.CCombo;
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.Group;
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.i18n.BaseMessages;
import org.pentaho.di.job.JobMeta;
import org.pentaho.di.job.entries.msaccessbulkload.JobEntryMSAccessBulkLoad;
import org.pentaho.di.job.entry.JobEntryDialogInterface;
import org.pentaho.di.job.entry.JobEntryInterface;
import org.pentaho.di.repository.Repository;
import org.pentaho.di.ui.core.gui.WindowProperty;
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.job.dialog.JobDialog;
import org.pentaho.di.ui.job.entry.JobEntryDialog;
import org.pentaho.di.ui.trans.step.BaseStepDialog;
/**
* This dialog allows you to edit the Microsoft Access Bulk Load job entry settings.
*
* @author Samatar Hassan
* @since 24-07-2008
*/
public class JobEntryMSAccessBulkLoadDialog extends JobEntryDialog implements JobEntryDialogInterface {
private static Class<?> PKG = JobEntryMSAccessBulkLoad.class; // for i18n purposes, needed by Translator2!!
private static final String[] FILETYPES = new String[] { BaseMessages.getString(
PKG, "JobEntryMSAccessBulkLoad.Filetype.All" ) };
private Label wlName;
private Text wName;
private FormData fdlName, fdName;
private Label WSourceFileFoldername;
private Button wbFileFoldername, wbaEntry, wbSourceFolder;
private TextVar wSourceFileFoldername;
private FormData fdlSourceFileFoldername, fdbSourceFileFoldername, fdbaEntry, fdSourceFileFoldername, fdbSourceFolder;
private Label wlTargetDbname;
private Button wbTargetDbname;
private TextVar wTargetDbname;
private FormData fdlTargetDbname, fdbTargetDbname, fdTargetDbname;
private Label wlTablename;
private TextVar wTablename;
private FormData fdlTablename;
private FormData fdTablename;
private Label wlWildcard;
private TextVar wWildcard;
private FormData fdlWildcard;
private FormData fdWildcard;
private Label wlDelimiter;
private TextVar wDelimiter;
private FormData fdlDelimiter;
private FormData fdDelimiter;
private Button wOK, wCancel;
private Listener lsOK, lsCancel;
private Label wlFields;
private TableView wFields;
private FormData fdlFields, fdFields;
private Button wbDelete; // Delete
private FormData fdbdDelete;
private Button wbEdit; // Edit
private CTabFolder wTabFolder;
private Composite wGeneralComp, wAdvancedComp;
private CTabItem wGeneralTab, wAdvancedTab;
private FormData fdGeneralComp, fdAdvancedComp;
private FormData fdTabFolder;
private Group wSourceGroup;
private FormData fdSourceGroup;
private Group wTargetGroup;
private FormData fdTargetGroup;
private FormData fdbeSourceFileFolder;
private Group wFileResult;
private FormData fdFileResult;
private Label wlSuccessCondition;
private CCombo wSuccessCondition;
private FormData fdlSuccessCondition, fdSuccessCondition;
private Group wSuccessOn;
private FormData fdSuccessOn;
private Label wlNrErrorsLessThan;
private TextVar wNrErrorsLessThan;
private FormData fdlNrErrorsLessThan, fdNrErrorsLessThan;
private Label wlAddFileToResult, wlincludeSubFolders;
private Button wAddFileToResult, wincludeSubFolders;
private FormData fdlAddFileToResult, fdAddFileToResult, fdlincludeSubFolders, fdincludeSubFolders;
private JobEntryMSAccessBulkLoad jobEntry;
private Shell shell;
private Label wlPrevious;
private Button wPrevious;
private FormData fdlPrevious, fdPrevious;
private SelectionAdapter lsDef;
private boolean changed;
public JobEntryMSAccessBulkLoadDialog( Shell parent, JobEntryInterface jobEntryInt, Repository rep,
JobMeta jobMeta ) {
super( parent, jobEntryInt, rep, jobMeta );
jobEntry = (JobEntryMSAccessBulkLoad) jobEntryInt;
if ( this.jobEntry.getName() == null ) {
this.jobEntry.setName( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Name.Default" ) );
}
}
public JobEntryInterface open() {
Shell parent = getParent();
Display display = parent.getDisplay();
shell = new Shell( parent, props.getJobsDialogStyle() );
props.setLook( shell );
JobDialog.setShellImage( shell, jobEntry );
ModifyListener lsMod = new ModifyListener() {
public void modifyText( ModifyEvent e ) {
jobEntry.setChanged();
}
};
changed = jobEntry.hasChanged();
FormLayout formLayout = new FormLayout();
formLayout.marginWidth = Const.FORM_MARGIN;
formLayout.marginHeight = Const.FORM_MARGIN;
shell.setLayout( formLayout );
shell.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Title" ) );
int middle = props.getMiddlePct();
int margin = Const.MARGIN;
// Name line
wlName = new Label( shell, SWT.RIGHT );
wlName.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Name.Label" ) );
props.setLook( wlName );
fdlName = new FormData();
fdlName.left = new FormAttachment( 0, 0 );
fdlName.right = new FormAttachment( middle, -margin );
fdlName.top = new FormAttachment( 0, margin );
wlName.setLayoutData( fdlName );
wName = new Text( shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
props.setLook( wName );
wName.addModifyListener( lsMod );
fdName = new FormData();
fdName.left = new FormAttachment( middle, 0 );
fdName.top = new FormAttachment( 0, margin );
fdName.right = new FormAttachment( 100, 0 );
wName.setLayoutData( fdName );
wTabFolder = new CTabFolder( shell, SWT.BORDER );
props.setLook( wTabFolder, Props.WIDGET_STYLE_TAB );
// ////////////////////////
// START OF GENERAL TAB ///
// ////////////////////////
wGeneralTab = new CTabItem( wTabFolder, SWT.NONE );
wGeneralTab.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Tab.General.Label" ) );
wGeneralComp = new Composite( wTabFolder, SWT.NONE );
props.setLook( wGeneralComp );
FormLayout generalLayout = new FormLayout();
generalLayout.marginWidth = 3;
generalLayout.marginHeight = 3;
wGeneralComp.setLayout( generalLayout );
// ////////////////////////
// START OF Source GROUP///
// /
wSourceGroup = new Group( wGeneralComp, SWT.SHADOW_NONE );
props.setLook( wSourceGroup );
wSourceGroup.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.SourceGroup.Group.Label" ) );
FormLayout SourceGroupgroupLayout = new FormLayout();
SourceGroupgroupLayout.marginWidth = 10;
SourceGroupgroupLayout.marginHeight = 10;
wSourceGroup.setLayout( SourceGroupgroupLayout );
// previous
wlPrevious = new Label( wSourceGroup, SWT.RIGHT );
wlPrevious.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Previous.Label" ) );
props.setLook( wlPrevious );
fdlPrevious = new FormData();
fdlPrevious.left = new FormAttachment( 0, 0 );
fdlPrevious.top = new FormAttachment( wName, margin );
fdlPrevious.right = new FormAttachment( middle, -margin );
wlPrevious.setLayoutData( fdlPrevious );
wPrevious = new Button( wSourceGroup, SWT.CHECK );
props.setLook( wPrevious );
wPrevious.setToolTipText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Previous.Tooltip" ) );
fdPrevious = new FormData();
fdPrevious.left = new FormAttachment( middle, 0 );
fdPrevious.top = new FormAttachment( wName, margin );
fdPrevious.right = new FormAttachment( 100, 0 );
wPrevious.setLayoutData( fdPrevious );
wPrevious.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
RefreshArgFromPrevious();
}
} );
// FileFoldername line
WSourceFileFoldername = new Label( wSourceGroup, SWT.RIGHT );
WSourceFileFoldername.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.FileFoldername.Label" ) );
props.setLook( WSourceFileFoldername );
fdlSourceFileFoldername = new FormData();
fdlSourceFileFoldername.left = new FormAttachment( 0, 0 );
fdlSourceFileFoldername.top = new FormAttachment( wPrevious, margin );
fdlSourceFileFoldername.right = new FormAttachment( middle, -margin );
WSourceFileFoldername.setLayoutData( fdlSourceFileFoldername );
// Browse Destination folders button ...
wbSourceFolder = new Button( wSourceGroup, SWT.PUSH | SWT.CENTER );
props.setLook( wbSourceFolder );
wbSourceFolder.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.BrowseFolders.Label" ) );
fdbSourceFolder = new FormData();
fdbSourceFolder.right = new FormAttachment( 100, 0 );
fdbSourceFolder.top = new FormAttachment( wPrevious, margin );
wbSourceFolder.setLayoutData( fdbSourceFolder );
wbSourceFolder.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
DirectoryDialog ddialog = new DirectoryDialog( shell, SWT.OPEN );
if ( wSourceFileFoldername.getText() != null ) {
ddialog.setFilterPath( jobMeta.environmentSubstitute( wSourceFileFoldername.getText() ) );
}
// Calling open() will open and run the dialog.
// It will return the selected directory, or
// null if user cancels
String dir = ddialog.open();
if ( dir != null ) {
// Set the text box to the new selection
wSourceFileFoldername.setText( dir );
}
}
} );
// Browse source file button ...
wbFileFoldername = new Button( wSourceGroup, SWT.PUSH | SWT.CENTER );
props.setLook( wbFileFoldername );
wbFileFoldername.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.BrowseFiles.Label" ) );
fdbSourceFileFoldername = new FormData();
fdbSourceFileFoldername.right = new FormAttachment( wbSourceFolder, -margin );
fdbSourceFileFoldername.top = new FormAttachment( wPrevious, margin );
wbFileFoldername.setLayoutData( fdbSourceFileFoldername );
wSourceFileFoldername = new TextVar( jobMeta, wSourceGroup, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
props.setLook( wSourceFileFoldername );
wSourceFileFoldername.addModifyListener( lsMod );
fdSourceFileFoldername = new FormData();
fdSourceFileFoldername.left = new FormAttachment( middle, 0 );
fdSourceFileFoldername.top = new FormAttachment( wPrevious, margin );
fdSourceFileFoldername.right = new FormAttachment( wbFileFoldername, -margin );
wSourceFileFoldername.setLayoutData( fdSourceFileFoldername );
// Whenever something changes, set the tooltip to the expanded version:
wSourceFileFoldername.addModifyListener( new ModifyListener() {
public void modifyText( ModifyEvent e ) {
wSourceFileFoldername.setToolTipText( jobMeta.environmentSubstitute( wSourceFileFoldername.getText() ) );
}
} );
wbFileFoldername.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
FileDialog dialog = new FileDialog( shell, SWT.OPEN );
dialog.setFilterExtensions( new String[] { "*" } );
if ( wSourceFileFoldername.getText() != null ) {
dialog.setFileName( jobMeta.environmentSubstitute( wSourceFileFoldername.getText() ) );
}
dialog.setFilterNames( FILETYPES );
if ( dialog.open() != null ) {
wSourceFileFoldername.setText( dialog.getFilterPath() + Const.FILE_SEPARATOR + dialog.getFileName() );
}
}
} );
// Include sub folders
wlincludeSubFolders = new Label( wSourceGroup, SWT.RIGHT );
wlincludeSubFolders
.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.includeSubFolders.Label" ) );
props.setLook( wlincludeSubFolders );
fdlincludeSubFolders = new FormData();
fdlincludeSubFolders.left = new FormAttachment( 0, 0 );
fdlincludeSubFolders.top = new FormAttachment( wSourceFileFoldername, margin );
fdlincludeSubFolders.right = new FormAttachment( middle, -margin );
wlincludeSubFolders.setLayoutData( fdlincludeSubFolders );
wincludeSubFolders = new Button( wSourceGroup, SWT.CHECK );
props.setLook( wincludeSubFolders );
wincludeSubFolders.setToolTipText( BaseMessages.getString(
PKG, "JobEntryMSAccessBulkLoad.includeSubFolders.Tooltip" ) );
fdincludeSubFolders = new FormData();
fdincludeSubFolders.left = new FormAttachment( middle, 0 );
fdincludeSubFolders.top = new FormAttachment( wSourceFileFoldername, margin );
fdincludeSubFolders.right = new FormAttachment( 100, 0 );
wincludeSubFolders.setLayoutData( fdincludeSubFolders );
wincludeSubFolders.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
jobEntry.setChanged();
}
} );
// Wildcard
wlWildcard = new Label( wSourceGroup, SWT.RIGHT );
wlWildcard.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Wildcard.Label" ) );
props.setLook( wlWildcard );
fdlWildcard = new FormData();
fdlWildcard.left = new FormAttachment( 0, 0 );
fdlWildcard.top = new FormAttachment( wincludeSubFolders, margin );
fdlWildcard.right = new FormAttachment( middle, -margin );
wlWildcard.setLayoutData( fdlWildcard );
wWildcard = new TextVar( jobMeta, wSourceGroup, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
props.setLook( wWildcard );
wWildcard.setToolTipText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Wildcard.Tooltip" ) );
wWildcard.addModifyListener( lsMod );
fdWildcard = new FormData();
fdWildcard.left = new FormAttachment( middle, 0 );
fdWildcard.top = new FormAttachment( wincludeSubFolders, margin );
fdWildcard.right = new FormAttachment( wbFileFoldername, -margin );
wWildcard.setLayoutData( fdWildcard );
// Whenever something changes, set the tooltip to the expanded version:
wWildcard.addModifyListener( new ModifyListener() {
public void modifyText( ModifyEvent e ) {
wWildcard.setToolTipText( jobMeta.environmentSubstitute( wWildcard.getText() ) );
}
} );
// Delimiter
wlDelimiter = new Label( wSourceGroup, SWT.RIGHT );
wlDelimiter.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Delimiter.Label" ) );
props.setLook( wlDelimiter );
fdlDelimiter = new FormData();
fdlDelimiter.left = new FormAttachment( 0, 0 );
fdlDelimiter.top = new FormAttachment( wWildcard, margin );
fdlDelimiter.right = new FormAttachment( middle, -margin );
wlDelimiter.setLayoutData( fdlDelimiter );
wDelimiter = new TextVar( jobMeta, wSourceGroup, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
props.setLook( wDelimiter );
wDelimiter.setToolTipText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Delimiter.Tooltip" ) );
wDelimiter.addModifyListener( lsMod );
fdDelimiter = new FormData();
fdDelimiter.left = new FormAttachment( middle, 0 );
fdDelimiter.top = new FormAttachment( wWildcard, margin );
fdDelimiter.right = new FormAttachment( wbFileFoldername, -margin );
wDelimiter.setLayoutData( fdDelimiter );
// Whenever something changes, set the tooltip to the expanded version:
wDelimiter.addModifyListener( new ModifyListener() {
public void modifyText( ModifyEvent e ) {
wDelimiter.setToolTipText( jobMeta.environmentSubstitute( wDelimiter.getText() ) );
}
} );
fdSourceGroup = new FormData();
fdSourceGroup.left = new FormAttachment( 0, margin );
fdSourceGroup.top = new FormAttachment( wName, margin );
fdSourceGroup.right = new FormAttachment( 100, -margin );
wSourceGroup.setLayoutData( fdSourceGroup );
// ///////////////////////////////////////////////////////////
// / END OF Source GROUP
// ///////////////////////////////////////////////////////////
// ////////////////////////
// START OF Target GROUP///
// /
wTargetGroup = new Group( wGeneralComp, SWT.SHADOW_NONE );
props.setLook( wTargetGroup );
wTargetGroup.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.TargetGroup.Group.Label" ) );
FormLayout TargetGroupgroupLayout = new FormLayout();
TargetGroupgroupLayout.marginWidth = 10;
TargetGroupgroupLayout.marginHeight = 10;
wTargetGroup.setLayout( TargetGroupgroupLayout );
// Target Db name line
wlTargetDbname = new Label( wTargetGroup, SWT.RIGHT );
wlTargetDbname.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.TargetDbname.Label" ) );
props.setLook( wlTargetDbname );
fdlTargetDbname = new FormData();
fdlTargetDbname.left = new FormAttachment( 0, 0 );
fdlTargetDbname.top = new FormAttachment( wSourceGroup, margin );
fdlTargetDbname.right = new FormAttachment( middle, -margin );
wlTargetDbname.setLayoutData( fdlTargetDbname );
wbTargetDbname = new Button( wTargetGroup, SWT.PUSH | SWT.CENTER );
props.setLook( wbTargetDbname );
wbTargetDbname.setText( BaseMessages.getString( PKG, "System.Button.Browse" ) );
fdbTargetDbname = new FormData();
fdbTargetDbname.right = new FormAttachment( 100, 0 );
fdbTargetDbname.top = new FormAttachment( wSourceGroup, margin );
wbTargetDbname.setLayoutData( fdbTargetDbname );
wTargetDbname = new TextVar( jobMeta, wTargetGroup, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
props.setLook( wTargetDbname );
wTargetDbname.addModifyListener( lsMod );
fdTargetDbname = new FormData();
fdTargetDbname.left = new FormAttachment( middle, 0 );
fdTargetDbname.top = new FormAttachment( wSourceGroup, margin );
fdTargetDbname.right = new FormAttachment( wbTargetDbname, -margin );
wTargetDbname.setLayoutData( fdTargetDbname );
// Whenever something changes, set the tooltip to the expanded version:
wTargetDbname.addModifyListener( new ModifyListener() {
public void modifyText( ModifyEvent e ) {
wTargetDbname.setToolTipText( jobMeta.environmentSubstitute( wTargetDbname.getText() ) );
}
} );
wbTargetDbname.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
FileDialog dialog = new FileDialog( shell, SWT.OPEN );
dialog.setFilterExtensions( new String[] { "*" } );
if ( wTargetDbname.getText() != null ) {
dialog.setFileName( jobMeta.environmentSubstitute( wTargetDbname.getText() ) );
}
dialog.setFilterNames( FILETYPES );
if ( dialog.open() != null ) {
wTargetDbname.setText( dialog.getFilterPath() + Const.FILE_SEPARATOR + dialog.getFileName() );
}
}
} );
// Tablename
wlTablename = new Label( wTargetGroup, SWT.RIGHT );
wlTablename.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Tablename.Label" ) );
props.setLook( wlTablename );
fdlTablename = new FormData();
fdlTablename.left = new FormAttachment( 0, 0 );
fdlTablename.top = new FormAttachment( wTargetDbname, margin );
fdlTablename.right = new FormAttachment( middle, -margin );
wlTablename.setLayoutData( fdlTablename );
wTablename = new TextVar( jobMeta, wTargetGroup, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
props.setLook( wTablename );
wTablename.setToolTipText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Tablename.Tooltip" ) );
wTablename.addModifyListener( lsMod );
fdTablename = new FormData();
fdTablename.left = new FormAttachment( middle, 0 );
fdTablename.top = new FormAttachment( wTargetDbname, margin );
fdTablename.right = new FormAttachment( wbTargetDbname, -margin );
wTablename.setLayoutData( fdTablename );
// Whenever something changes, set the tooltip to the expanded version:
wTablename.addModifyListener( new ModifyListener() {
public void modifyText( ModifyEvent e ) {
wTablename.setToolTipText( jobMeta.environmentSubstitute( wTablename.getText() ) );
}
} );
fdTargetGroup = new FormData();
fdTargetGroup.left = new FormAttachment( 0, margin );
fdTargetGroup.top = new FormAttachment( wSourceGroup, margin );
fdTargetGroup.right = new FormAttachment( 100, -margin );
wTargetGroup.setLayoutData( fdTargetGroup );
// ///////////////////////////////////////////////////////////
// / END OF Target GROUP
// ///////////////////////////////////////////////////////////
// add button ...
wbaEntry = new Button( wGeneralComp, SWT.PUSH | SWT.CENTER );
props.setLook( wbaEntry );
wbaEntry.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.FilenameAdd.Button" ) );
wbaEntry.setToolTipText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.FilenameAdd.Button.Tooltip" ) );
fdbaEntry = new FormData();
fdbaEntry.left = new FormAttachment( 0, 0 );
fdbaEntry.right = new FormAttachment( 100, -margin );
fdbaEntry.top = new FormAttachment( wTargetGroup, margin );
wbaEntry.setLayoutData( fdbaEntry );
// Buttons to the right of the screen...
wbDelete = new Button( wGeneralComp, SWT.PUSH | SWT.CENTER );
props.setLook( wbDelete );
wbDelete.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.FilenameDelete.Button" ) );
wbDelete.setToolTipText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.FilenameDelete.Tooltip" ) );
fdbdDelete = new FormData();
fdbdDelete.right = new FormAttachment( 100, 0 );
fdbdDelete.top = new FormAttachment( wbaEntry, 10 * margin );
wbDelete.setLayoutData( fdbdDelete );
wbEdit = new Button( wGeneralComp, SWT.PUSH | SWT.CENTER );
props.setLook( wbEdit );
wbEdit.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.FilenameEdit.Button" ) );
fdbeSourceFileFolder = new FormData();
fdbeSourceFileFolder.right = new FormAttachment( 100, 0 );
fdbeSourceFileFolder.left = new FormAttachment( wbDelete, 0, SWT.LEFT );
fdbeSourceFileFolder.top = new FormAttachment( wbDelete, margin );
wbEdit.setLayoutData( fdbeSourceFileFolder );
wlFields = new Label( wGeneralComp, SWT.NONE );
wlFields.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Fields.Label" ) );
props.setLook( wlFields );
fdlFields = new FormData();
fdlFields.left = new FormAttachment( 0, 0 );
fdlFields.right = new FormAttachment( middle, -margin );
fdlFields.top = new FormAttachment( wbaEntry, margin );
wlFields.setLayoutData( fdlFields );
int rows =
jobEntry.source_filefolder == null ? 1 : ( jobEntry.source_filefolder.length == 0
? 0 : jobEntry.source_filefolder.length );
final int FieldsRows = rows;
ColumnInfo[] colinf =
new ColumnInfo[] {
new ColumnInfo(
BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Fields.SourceFileFolder.Label" ),
ColumnInfo.COLUMN_TYPE_TEXT, false ),
new ColumnInfo(
BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Fields.Wildcard.Label" ),
ColumnInfo.COLUMN_TYPE_TEXT, false ),
new ColumnInfo(
BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Fields.FieldsDelimiter.Label" ),
ColumnInfo.COLUMN_TYPE_TEXT, false ),
new ColumnInfo(
BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Fields.TargetDb.Label" ),
ColumnInfo.COLUMN_TYPE_TEXT, false ),
new ColumnInfo(
BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Fields.TargetTable.Label" ),
ColumnInfo.COLUMN_TYPE_TEXT, false ), };
colinf[0].setUsingVariables( true );
colinf[0]
.setToolTip( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Fields.SourceFileFolder.Tooltip" ) );
colinf[1].setUsingVariables( true );
colinf[1].setToolTip( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Fields.Wildcard.Tooltip" ) );
colinf[2].setUsingVariables( true );
colinf[2].setToolTip( BaseMessages.getString( PKG, "JobCopyFiles.Fields.FieldsDelimiter.Tooltip" ) );
colinf[3].setUsingVariables( true );
colinf[3].setToolTip( BaseMessages.getString( PKG, "JobCopyFiles.Fields.TargetDb.Tooltip" ) );
colinf[4].setUsingVariables( true );
colinf[4].setToolTip( BaseMessages.getString( PKG, "JobCopyFiles.Fields.TargetTable.Tooltip" ) );
wFields =
new TableView(
jobMeta, wGeneralComp, SWT.BORDER | SWT.FULL_SELECTION | SWT.MULTI, colinf, FieldsRows, lsMod, props );
fdFields = new FormData();
fdFields.left = new FormAttachment( 0, 0 );
fdFields.top = new FormAttachment( wlFields, margin );
fdFields.right = new FormAttachment( wbDelete, -margin );
fdFields.bottom = new FormAttachment( 100, -margin );
wFields.setLayoutData( fdFields );
fdGeneralComp = new FormData();
fdGeneralComp.left = new FormAttachment( 0, 0 );
fdGeneralComp.top = new FormAttachment( 0, 0 );
fdGeneralComp.right = new FormAttachment( 100, 0 );
fdGeneralComp.bottom = new FormAttachment( 100, 0 );
wGeneralComp.setLayoutData( fdGeneralComp );
wGeneralComp.layout();
wGeneralTab.setControl( wGeneralComp );
props.setLook( wGeneralComp );
// ///////////////////////////////////////////////////////////
// / END OF GENERAL TAB
// ///////////////////////////////////////////////////////////
// ////////////////////////
// START OF ADVANCED TAB ///
// ////////////////////////
wAdvancedTab = new CTabItem( wTabFolder, SWT.NONE );
wAdvancedTab.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Tab.Advanced.Label" ) );
wAdvancedComp = new Composite( wTabFolder, SWT.NONE );
props.setLook( wAdvancedComp );
FormLayout advancedLayout = new FormLayout();
advancedLayout.marginWidth = 3;
advancedLayout.marginHeight = 3;
wAdvancedComp.setLayout( generalLayout );
// SuccessOngrouping?
// ////////////////////////
// START OF SUCCESS ON GROUP///
// /
wSuccessOn = new Group( wAdvancedComp, SWT.SHADOW_NONE );
props.setLook( wSuccessOn );
wSuccessOn.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.SuccessOn.Group.Label" ) );
FormLayout successongroupLayout = new FormLayout();
successongroupLayout.marginWidth = 10;
successongroupLayout.marginHeight = 10;
wSuccessOn.setLayout( successongroupLayout );
// Success Condition
wlSuccessCondition = new Label( wSuccessOn, SWT.RIGHT );
wlSuccessCondition.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.SuccessCondition.Label" ) );
props.setLook( wlSuccessCondition );
fdlSuccessCondition = new FormData();
fdlSuccessCondition.left = new FormAttachment( 0, 0 );
fdlSuccessCondition.right = new FormAttachment( middle, 0 );
fdlSuccessCondition.top = new FormAttachment( 0, margin );
wlSuccessCondition.setLayoutData( fdlSuccessCondition );
wSuccessCondition = new CCombo( wSuccessOn, SWT.SINGLE | SWT.READ_ONLY | SWT.BORDER );
wSuccessCondition
.add( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.SuccessWhenAllWorksFine.Label" ) );
wSuccessCondition.add( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.SuccessWhenAtLeat.Label" ) );
wSuccessCondition.add( BaseMessages
.getString( PKG, "JobEntryMSAccessBulkLoad.SuccessWhenErrorsLessThan.Label" ) );
wSuccessCondition.select( 0 ); // +1: starts at -1
props.setLook( wSuccessCondition );
fdSuccessCondition = new FormData();
fdSuccessCondition.left = new FormAttachment( middle, 0 );
fdSuccessCondition.top = new FormAttachment( 0, margin );
fdSuccessCondition.right = new FormAttachment( 100, 0 );
wSuccessCondition.setLayoutData( fdSuccessCondition );
wSuccessCondition.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
activeSuccessCondition();
}
} );
// Success when number of errors less than
wlNrErrorsLessThan = new Label( wSuccessOn, SWT.RIGHT );
wlNrErrorsLessThan.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.NrErrorsLessThan.Label" ) );
props.setLook( wlNrErrorsLessThan );
fdlNrErrorsLessThan = new FormData();
fdlNrErrorsLessThan.left = new FormAttachment( 0, 0 );
fdlNrErrorsLessThan.top = new FormAttachment( wSuccessCondition, margin );
fdlNrErrorsLessThan.right = new FormAttachment( middle, -margin );
wlNrErrorsLessThan.setLayoutData( fdlNrErrorsLessThan );
wNrErrorsLessThan =
new TextVar( jobMeta, wSuccessOn, SWT.SINGLE | SWT.LEFT | SWT.BORDER, BaseMessages.getString(
PKG, "JobEntryMSAccessBulkLoad.NrErrorsLessThan.Tooltip" ) );
props.setLook( wNrErrorsLessThan );
wNrErrorsLessThan.addModifyListener( lsMod );
fdNrErrorsLessThan = new FormData();
fdNrErrorsLessThan.left = new FormAttachment( middle, 0 );
fdNrErrorsLessThan.top = new FormAttachment( wSuccessCondition, margin );
fdNrErrorsLessThan.right = new FormAttachment( 100, -margin );
wNrErrorsLessThan.setLayoutData( fdNrErrorsLessThan );
fdSuccessOn = new FormData();
fdSuccessOn.left = new FormAttachment( 0, margin );
fdSuccessOn.top = new FormAttachment( 0, margin );
fdSuccessOn.right = new FormAttachment( 100, -margin );
wSuccessOn.setLayoutData( fdSuccessOn );
// ///////////////////////////////////////////////////////////
// / END OF Success ON GROUP
// ///////////////////////////////////////////////////////////
// fileresult grouping?
// ////////////////////////
// START OF LOGGING GROUP///
// /
wFileResult = new Group( wAdvancedComp, SWT.SHADOW_NONE );
props.setLook( wFileResult );
wFileResult.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.FileResult.Group.Label" ) );
FormLayout fileresultgroupLayout = new FormLayout();
fileresultgroupLayout.marginWidth = 10;
fileresultgroupLayout.marginHeight = 10;
wFileResult.setLayout( fileresultgroupLayout );
// Add file to result
wlAddFileToResult = new Label( wFileResult, SWT.RIGHT );
wlAddFileToResult.setText( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.AddFileToResult.Label" ) );
props.setLook( wlAddFileToResult );
fdlAddFileToResult = new FormData();
fdlAddFileToResult.left = new FormAttachment( 0, 0 );
fdlAddFileToResult.top = new FormAttachment( wSuccessOn, margin );
fdlAddFileToResult.right = new FormAttachment( middle, -margin );
wlAddFileToResult.setLayoutData( fdlAddFileToResult );
wAddFileToResult = new Button( wFileResult, SWT.CHECK );
props.setLook( wAddFileToResult );
wAddFileToResult.setToolTipText( BaseMessages.getString(
PKG, "JobEntryMSAccessBulkLoad.AddFileToResult.Tooltip" ) );
fdAddFileToResult = new FormData();
fdAddFileToResult.left = new FormAttachment( middle, 0 );
fdAddFileToResult.top = new FormAttachment( wSuccessOn, margin );
fdAddFileToResult.right = new FormAttachment( 100, 0 );
wAddFileToResult.setLayoutData( fdAddFileToResult );
wAddFileToResult.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
jobEntry.setChanged();
}
} );
fdFileResult = new FormData();
fdFileResult.left = new FormAttachment( 0, margin );
fdFileResult.top = new FormAttachment( wSuccessOn, margin );
fdFileResult.right = new FormAttachment( 100, -margin );
wFileResult.setLayoutData( fdFileResult );
// ///////////////////////////////////////////////////////////
// / END OF FilesRsult GROUP
// ///////////////////////////////////////////////////////////
fdAdvancedComp = new FormData();
fdAdvancedComp.left = new FormAttachment( 0, 0 );
fdAdvancedComp.top = new FormAttachment( 0, 0 );
fdAdvancedComp.right = new FormAttachment( 100, 0 );
fdAdvancedComp.bottom = new FormAttachment( 100, 0 );
wAdvancedComp.setLayoutData( fdGeneralComp );
wAdvancedComp.layout();
wAdvancedTab.setControl( wAdvancedComp );
props.setLook( wAdvancedComp );
// ///////////////////////////////////////////////////////////
// / END OF ADVANCED TAB
// ///////////////////////////////////////////////////////////
fdTabFolder = new FormData();
fdTabFolder.left = new FormAttachment( 0, 0 );
fdTabFolder.top = new FormAttachment( wName, margin );
fdTabFolder.right = new FormAttachment( 100, 0 );
fdTabFolder.bottom = new FormAttachment( 100, -50 );
wTabFolder.setLayoutData( fdTabFolder );
// Add the file to the list of files...
SelectionAdapter selA = new SelectionAdapter() {
public void widgetSelected( SelectionEvent arg0 ) {
wFields.add( new String[] {
wSourceFileFoldername.getText(), wWildcard.getText(), wDelimiter.getText(), wTargetDbname.getText(),
wTablename.getText() } );
wSourceFileFoldername.setText( "" );
wWildcard.setText( "" );
wDelimiter.setText( "" );
wTargetDbname.setText( "" );
wTablename.setText( "" );
wFields.removeEmptyRows();
wFields.setRowNums();
wFields.optWidth( true );
}
};
wbaEntry.addSelectionListener( selA );
wSourceFileFoldername.addSelectionListener( selA );
// Delete files from the list of files...
wbDelete.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent arg0 ) {
int[] idx = wFields.getSelectionIndices();
wFields.remove( idx );
wFields.removeEmptyRows();
wFields.setRowNums();
}
} );
// Edit the selected file & remove from the list...
wbEdit.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent arg0 ) {
int idx = wFields.getSelectionIndex();
if ( idx >= 0 ) {
String[] string = wFields.getItem( idx );
wSourceFileFoldername.setText( string[0] );
wWildcard.setText( string[1] );
wDelimiter.setText( string[2] );
wTargetDbname.setText( string[3] );
wTablename.setText( string[4] );
wFields.remove( idx );
}
wFields.removeEmptyRows();
wFields.setRowNums();
}
} );
wOK = new Button( shell, SWT.PUSH );
wOK.setText( BaseMessages.getString( PKG, "System.Button.OK" ) );
wCancel = new Button( shell, SWT.PUSH );
wCancel.setText( BaseMessages.getString( PKG, "System.Button.Cancel" ) );
BaseStepDialog.positionBottomButtons( shell, new Button[] { wOK, wCancel }, margin, wTabFolder );
// Add listeners
lsCancel = new Listener() {
public void handleEvent( Event e ) {
cancel();
}
};
lsOK = new Listener() {
public void handleEvent( Event e ) {
ok();
}
};
wCancel.addListener( SWT.Selection, lsCancel );
wOK.addListener( SWT.Selection, lsOK );
lsDef = new SelectionAdapter() {
public void widgetDefaultSelected( SelectionEvent e ) {
ok();
}
};
wName.addSelectionListener( lsDef );
wSourceFileFoldername.addSelectionListener( lsDef );
wTargetDbname.addSelectionListener( lsDef );
// Detect X or ALT-F4 or something that kills this window...
shell.addShellListener( new ShellAdapter() {
public void shellClosed( ShellEvent e ) {
cancel();
}
} );
getData();
activeSuccessCondition();
RefreshArgFromPrevious();
wTabFolder.setSelection( 0 );
BaseStepDialog.setSize( shell );
shell.open();
while ( !shell.isDisposed() ) {
if ( !display.readAndDispatch() ) {
display.sleep();
}
}
return jobEntry;
}
private void RefreshArgFromPrevious() {
wlFields.setEnabled( !wPrevious.getSelection() );
wFields.setEnabled( !wPrevious.getSelection() );
wbSourceFolder.setEnabled( !wPrevious.getSelection() );
wSourceFileFoldername.setEnabled( !wPrevious.getSelection() );
wlTargetDbname.setEnabled( !wPrevious.getSelection() );
wTargetDbname.setEnabled( !wPrevious.getSelection() );
wTablename.setEnabled( !wPrevious.getSelection() );
wlTablename.setEnabled( !wPrevious.getSelection() );
wbTargetDbname.setEnabled( !wPrevious.getSelection() );
wbEdit.setEnabled( !wPrevious.getSelection() );
wincludeSubFolders.setEnabled( !wPrevious.getSelection() );
wlincludeSubFolders.setEnabled( !wPrevious.getSelection() );
wbDelete.setEnabled( !wPrevious.getSelection() );
wbaEntry.setEnabled( !wPrevious.getSelection() );
wbFileFoldername.setEnabled( !wPrevious.getSelection() );
wlWildcard.setEnabled( !wPrevious.getSelection() );
wWildcard.setEnabled( !wPrevious.getSelection() );
wlDelimiter.setEnabled( !wPrevious.getSelection() );
wDelimiter.setEnabled( !wPrevious.getSelection() );
WSourceFileFoldername.setEnabled( !wPrevious.getSelection() );
}
public void dispose() {
WindowProperty winprop = new WindowProperty( shell );
props.setScreen( winprop );
shell.dispose();
}
private void activeSuccessCondition() {
wlNrErrorsLessThan.setEnabled( wSuccessCondition.getSelectionIndex() != 0 );
wNrErrorsLessThan.setEnabled( wSuccessCondition.getSelectionIndex() != 0 );
}
/**
* Copy information from the meta-data input to the dialog fields.
*/
public void getData() {
wName.setText( Const.NVL( jobEntry.getName(), "" ) );
wAddFileToResult.setSelection( jobEntry.isAddResultFilename() );
wincludeSubFolders.setSelection( jobEntry.isIncludeSubFoders() );
wPrevious.setSelection( jobEntry.isArgsFromPrevious() );
if ( jobEntry.source_filefolder != null ) {
for ( int i = 0; i < jobEntry.source_filefolder.length; i++ ) {
TableItem ti = wFields.table.getItem( i );
if ( jobEntry.source_filefolder[i] != null ) {
ti.setText( 1, jobEntry.source_filefolder[i] );
}
if ( jobEntry.source_wildcard[i] != null ) {
ti.setText( 2, jobEntry.source_wildcard[i] );
}
if ( jobEntry.delimiter[i] != null ) {
ti.setText( 3, jobEntry.delimiter[i] );
}
if ( jobEntry.target_Db[i] != null ) {
ti.setText( 4, jobEntry.target_Db[i] );
}
if ( jobEntry.target_table[i] != null ) {
ti.setText( 5, jobEntry.target_table[i] );
}
}
wFields.setRowNums();
wFields.optWidth( true );
}
if ( jobEntry.getLimit() != null ) {
wNrErrorsLessThan.setText( jobEntry.getLimit() );
} else {
wNrErrorsLessThan.setText( "10" );
}
if ( jobEntry.getSuccessCondition() != null ) {
if ( jobEntry.getSuccessCondition().equals( jobEntry.SUCCESS_IF_AT_LEAST ) ) {
wSuccessCondition.select( 1 );
} else if ( jobEntry.getSuccessCondition().equals( jobEntry.SUCCESS_IF_ERRORS_LESS ) ) {
wSuccessCondition.select( 2 );
} else {
wSuccessCondition.select( 0 );
}
} else {
wSuccessCondition.select( 0 );
}
wName.selectAll();
wName.setFocus();
}
private void cancel() {
jobEntry.setChanged( changed );
jobEntry = null;
dispose();
}
private void ok() {
if ( Utils.isEmpty( wName.getText() ) ) {
MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
mb.setText( BaseMessages.getString( PKG, "System.StepJobEntryNameMissing.Title" ) );
mb.setMessage( BaseMessages.getString( PKG, "System.JobEntryNameMissing.Msg" ) );
mb.open();
return;
}
jobEntry.setName( wName.getText() );
jobEntry.setAddResultFilenames( wAddFileToResult.getSelection() );
jobEntry.setIncludeSubFoders( wincludeSubFolders.getSelection() );
jobEntry.setArgsFromPrevious( wPrevious.getSelection() );
int nritems = wFields.nrNonEmpty();
int nr = 0;
for ( int i = 0; i < nritems; i++ ) {
String arg = wFields.getNonEmpty( i ).getText( 1 );
if ( arg != null && arg.length() != 0 ) {
nr++;
}
}
jobEntry.source_filefolder = new String[nr];
jobEntry.source_wildcard = new String[nr];
jobEntry.delimiter = new String[nr];
jobEntry.target_Db = new String[nr];
jobEntry.target_table = new String[nr];
nr = 0;
for ( int i = 0; i < nritems; i++ ) {
String source = wFields.getNonEmpty( i ).getText( 1 );
String wild = wFields.getNonEmpty( i ).getText( 2 );
String delimiter = wFields.getNonEmpty( i ).getText( 3 );
String destdb = wFields.getNonEmpty( i ).getText( 4 );
String desttable = wFields.getNonEmpty( i ).getText( 5 );
if ( source != null && source.length() != 0 ) {
jobEntry.source_filefolder[nr] = source;
jobEntry.source_wildcard[nr] = wild;
jobEntry.delimiter[nr] = delimiter;
jobEntry.target_Db[nr] = destdb;
jobEntry.target_table[nr] = desttable;
nr++;
}
}
jobEntry.setLimit( wNrErrorsLessThan.getText() );
if ( wSuccessCondition.getSelectionIndex() == 1 ) {
jobEntry.setSuccessCondition( jobEntry.SUCCESS_IF_AT_LEAST );
} else if ( wSuccessCondition.getSelectionIndex() == 2 ) {
jobEntry.setSuccessCondition( jobEntry.SUCCESS_IF_ERRORS_LESS );
} else {
jobEntry.setSuccessCondition( jobEntry.SUCCESS_IF_NO_ERRORS );
}
dispose();
}
public boolean evaluates() {
return true;
}
public boolean isUnconditional() {
return false;
}
}