public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context) { var frm = new Excel2010ImporterOptionsWindow(_options); if (frm.ShowDialog().ValueOrFalse()) { _options = new Excel2010ImporterOptions { Filename = frm.Filename, Worksheet = frm.Worksheet }; return(true); } return(false); }
public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context) { var filename = PromptForFilename("*.sqlite", "Error databases (*.sqlite)|*.sqlite"); if (!string.IsNullOrEmpty(filename)) { _options = new ErrorDatabaseImporterOptions { Filename = filename }; var frm = new ErrorDatabaseImportOptionsWindow(_options, context); frm.Owner = parentWindow; frm.WindowStartupLocation = WindowStartupLocation.CenterOwner; return(frm.ShowDialog().ValueOrFalse()); } return(false); }
public ErrorDatabaseImportOptionsWindow(ErrorDatabaseImporterOptions options, ImportWizardContext context) { InitializeComponent(); _service = new ImportStagingService(options.Filename); Options = options; Context = context; _mappings = _service.GetMappings(); dataGrid.AutoGenerateColumns = false; foreach (ImportFieldMapping mapping in _mappings) { dataGrid.Columns.Add(CreateColumn(mapping)); } var ds = _service.GetErrorsDataSet(); dataGrid.ItemsSource = ds.Tables[0].DefaultView; dataGrid.IsReadOnly = true; dataGrid.MouseDoubleClick += new MouseButtonEventHandler(dataGrid_MouseDoubleClick); }
public abstract bool GetOptions(Window parentWindow, ImportWizardContext context);
public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context) { var frm = new ExcelImporterOptionsWindow(_options); if (frm.ShowDialog().ValueOrFalse()) { _options = new ExcelImporterOptions { Filename = frm.Filename, Worksheet = frm.Worksheet }; return true; } return false; }
public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context) { var frm = new BVPImportOptionsWindow(PluginManager.Instance.User, _options); frm.Owner = parentWindow; frm.WindowStartupLocation = WindowStartupLocation.CenterOwner; if (frm.ShowDialog().GetValueOrDefault(false)) { _options = new BVPImportOptions { Filename = frm.Filename, RowSource = frm.RowSource }; if (context.FieldMappings == null || context.FieldMappings.Count() == 0) { PreloadMappings(context); } return true; } return false; }
private void PreloadMappings(ImportWizardContext context) { var service = new ImportService(PluginManager.Instance.User); var fields = service.GetImportFields(); var mappings = new List<ImportFieldMapping>(); if (_options != null && _options.RowSource != null) { _options.RowSource.Reset(); var columns = _options.RowSource.ColumnNames; foreach (String colName in columns) { var candidate = fields.Find((field) => { if (!string.IsNullOrEmpty(colName)) { // First try a simple match of the name... if (field.DisplayName.Equals(colName, StringComparison.CurrentCultureIgnoreCase)) { return true; }; // Next convert all underscores to spaces and try that.... var test = colName.Replace("_", " "); if (field.DisplayName.Equals(test, StringComparison.CurrentCultureIgnoreCase)) { return true; } } return false; }); var mapping = new ImportFieldMapping { SourceColumn = colName, TargetColumn = "Material.Other", DefaultValue = null, IsFixed = false }; if (candidate != null) { mapping.TargetColumn = string.Format("{0}.{1}", candidate.Category, candidate.DisplayName); } else { DarwinCoreField dwc; if (Enum.TryParse<DarwinCoreField>(colName, out dwc)) { switch (dwc) { case DarwinCoreField.fieldNotes: case DarwinCoreField.validatorNotes: case DarwinCoreField.transcriberNotes: mapping.TargetColumn = "Material.Notes"; break; case DarwinCoreField.associatedMedia: mapping.TargetColumn = "Material.Multimedia"; break; } } } mappings.Add(mapping); } } context.FieldMappings = mappings; }
public override bool GetOptions(System.Windows.Window parentWindow, ImportWizardContext context) { var filename = PromptForFilename("*.sqlite", "Error databases (*.sqlite)|*.sqlite"); if (!string.IsNullOrEmpty(filename)) { _options = new ErrorDatabaseImporterOptions { Filename = filename }; var frm = new ErrorDatabaseImportOptionsWindow(_options, context); frm.Owner = parentWindow; frm.WindowStartupLocation = WindowStartupLocation.CenterOwner; return frm.ShowDialog().ValueOrFalse(); } return false; }