private void InitImportMapping(List <ImportFieldMapping> mappingList) { // Name ImportFieldMapping fullName = new ImportFieldMapping(Col_Name, true); fullName.Validator = new NotEmptyDataValidator(); mappingList.Add(fullName); ImportFieldMapping desc = new ImportFieldMapping(Col_Description, false); mappingList.Add(desc); ImportFieldMapping price = new ImportFieldMapping(Col_UnitPrice, false); price.Validator = new DecimalDataValidator(); mappingList.Add(price); ImportFieldMapping uom = new ImportFieldMapping(Col_UnitOfMeasure, false); mappingList.Add(uom); ImportFieldMapping packaging = new ImportFieldMapping(Col_Packaging, false); mappingList.Add(packaging); ImportFieldMapping categoryId = new ImportFieldMapping(Col_CategoryId, false); categoryId.Validator = new IntegerDataValidator(); mappingList.Add(categoryId); }
public void RemoveMappingCommandAction(object parameter) { ImportFieldMapping mapping = parameter as ImportFieldMapping; Mappings.Remove(mapping); NotifyPropertyChanged("MappingsConfigured"); }
public CellEditorWindow(ImportFieldMapping mapping, string currentValue) { InitializeComponent(); this.Mapping = mapping; this.CurrentValue = currentValue; this.NewValue = currentValue; this.DataContext = this; Loaded += new RoutedEventHandler(CellEditorWindow_Loaded); }
private void AddFixedField() { InputBox.Show(this.FindParentWindow(), "New fixed column", "Enter the value you wish to fix:", (val) => { var mapping = new ImportFieldMapping { IsFixed = true, DefaultValue = val }; var vm = new ImportFieldMappingViewModel(mapping); _model.Add(vm); lvwMappings.SelectedItem = vm; }); }
private void InitImportMapping(List <ImportFieldMapping> mappingList) { ImportFieldMapping colKey = new ImportFieldMapping(Col_Key, true); colKey.Validator = new NotEmptyDataValidator(); mappingList.Add(colKey); ImportFieldMapping colValue = new ImportFieldMapping(Col_Value, true); colValue.Validator = new NotEmptyDataValidator(); mappingList.Add(colValue); }
public override void OnPageEnter(WizardDirection fromdirection) { var progress = new ProgressWindow(this.FindParentWindow(), "Extracting column information from data source...", true); _fields = _fieldSource(); lvwFields.ItemsSource = _fields; CollectionView myView = (CollectionView)CollectionViewSource.GetDefaultView(lvwFields.ItemsSource); PropertyGroupDescription groupDescription = new PropertyGroupDescription("Category"); myView.GroupDescriptions.Add(groupDescription); var model = new List <ImportFieldMapping>(); JobExecutor.QueueJob(() => { List <String> columns = null; columns = ImportContext.Importer.GetColumnNames(); var existingMappings = ImportContext.FieldMappings; if (existingMappings != null && existingMappings.Count() > 0) { foreach (ImportFieldMapping mapping in existingMappings) { model.Add(mapping); } } else { foreach (string columnName in columns) { var mapping = new ImportFieldMapping { SourceColumn = columnName }; model.Add(mapping); } } _model = new ObservableCollection <ImportFieldMappingViewModel>(model.Select((m) => { return(new ImportFieldMappingViewModel(m)); })); lvwMappings.InvokeIfRequired(() => { lvwMappings.ItemsSource = _model; }); progress.InvokeIfRequired(() => { progress.Dispose(); }); }); }
private void InitImportMapping(List <ImportFieldMapping> mappingList) { // Name ImportFieldMapping name = new ImportFieldMapping(Col_Name, true); name.Validator = new NotEmptyDataValidator(); mappingList.Add(name); ImportFieldMapping address = new ImportFieldMapping(Col_Address, false); mappingList.Add(address); ImportFieldMapping colCity = new ImportFieldMapping(Col_City, false); mappingList.Add(colCity); ImportFieldMapping colCountry = new ImportFieldMapping(Col_Country, false); mappingList.Add(colCountry); ImportFieldMapping colZipCode = new ImportFieldMapping(Col_ZipCode, false); mappingList.Add(colZipCode); ImportFieldMapping colContactPerson = new ImportFieldMapping(Col_ContactPerson, false); mappingList.Add(colContactPerson); ImportFieldMapping contactPhone = new ImportFieldMapping(Col_ContactPhone, false); mappingList.Add(contactPhone); ImportFieldMapping contactFax = new ImportFieldMapping(Col_ContactFax, false); mappingList.Add(contactFax); ImportFieldMapping contactEmail = new ImportFieldMapping(Col_ContactEmail, false); mappingList.Add(contactEmail); ImportFieldMapping website = new ImportFieldMapping(Col_Website, false); mappingList.Add(website); ImportFieldMapping category = new ImportFieldMapping(Col_Category, false); category.Validator = new IntegerDataValidator(); mappingList.Add(category); }
private void CollectMappingInfo() { for (int index = 0; index < MappingList.Count; index++) { RepeaterItem item = rptItems.Items[index]; ImportFieldMapping mapping = MappingList[index]; DropDownList ddl = item.FindControl("ddlColumns") as DropDownList; if (ddl != null) { if (ddl.SelectedValue != null) { mapping.ColumnName = ddl.SelectedValue; } } } }
protected void rptItems_ItemCreated(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e) { DropDownList ddl = e.Item.FindControl("ddlColumns") as DropDownList; if (ddl != null) { ddl.Items.Add(new ListItem(string.Empty, string.Empty)); foreach (ExcelSheetColumn col in CurrentSelectedSheet.Columns) { ddl.Items.Add(new ListItem(col.Name, col.Name)); } ImportFieldMapping mapping = e.Item.DataItem as ImportFieldMapping; if (mapping != null) { ddl.SelectedValue = mapping.ColumnName; } } }
public async void AddMappingCommandAction(Object parameter) { string header = SelectedHeader; StandardFieldAttribute selectedField = SelectedField; IEnumerable <ImportFieldMapping> existing = Mappings.Where(ifm => ifm.Attribute == selectedField); if (existing.Any()) { await App.Controller.MainPageInstance.DisplayAlert("Add Mapping", String.Format("A mapping has already been configured for '{0}'.", selectedField.DisplayName), "OK"); } else { ImportFieldMapping mapping = new ImportFieldMapping(selectedField, header); Mappings.Add(mapping); SelectedHeader = null; SelectedField = null; NotifyPropertyChanged("MappingsConfigured"); } }
public static List <ImportFieldMapping> GetFieldMappings() { List <ImportFieldMapping> mappings = new List <ImportFieldMapping>(); ImportFieldMapping name = new ImportFieldMapping(StandardFieldAttribute.Get(typeof(Credential), "Name"), "Name"); ImportFieldMapping description = new ImportFieldMapping(StandardFieldAttribute.Get(typeof(Credential), "Description"), "Description"); ImportFieldMapping website = new ImportFieldMapping(StandardFieldAttribute.Get(typeof(Credential), "Website"), "Website"); ImportFieldMapping notes = new ImportFieldMapping(StandardFieldAttribute.Get(typeof(Credential), "Notes"), "Notes"); ImportFieldMapping username = new ImportFieldMapping(StandardFieldAttribute.Get(typeof(Credential), "Username"), "Username"); ImportFieldMapping password = new ImportFieldMapping(StandardFieldAttribute.Get(typeof(Credential), "Password"), "Password"); mappings.AddRange(new ImportFieldMapping[] { name, description, website, notes, username, password }); return(mappings); }
private void LoadTemplate() { var dlg = new OpenFileDialog(); dlg.Filter = "Import Template Files (*.bip)|*.bip|All files (*.*)|*.*"; if (dlg.ShowDialog().GetValueOrDefault()) { var inifile = new IniFile(); inifile.Load(dlg.FileName); var filtername = inifile.GetValue("Import", "ImportFilter"); if (string.IsNullOrWhiteSpace(filtername)) { ErrorMessage.Show("Invalid import profile - the name of import filter could not be read!"); return; } var importer = _model.Find((filter) => { return(filter.Name.Equals(filtername, StringComparison.CurrentCultureIgnoreCase)); }); if (importer == null) { ErrorMessage.Show("Invalid import profile - the unrecognized or unloaded import filter: " + filtername); return; } var epStr = inifile.GetValue("Import", "ProfileStr", ""); if (string.IsNullOrWhiteSpace(epStr)) { ErrorMessage.Show("Invalid import profile - No profile string specified."); return; } importer.InitFromProfileString(epStr); ImportContext.Importer = importer; listBox.SelectedItem = importer; var mappings = new List <ImportFieldMapping>(); // Now the mappings... var colCount = inifile.GetInt("Import", "FieldCount"); for (int i = 0; i < colCount; ++i) { String fieldKey = string.Format("Field{0}", i); var mapStr = inifile.GetValue("Mappings", fieldKey); if (!string.IsNullOrWhiteSpace(mapStr)) { var mapEp = EntryPoint.Parse(mapStr); var mapping = new ImportFieldMapping { SourceColumn = mapEp.Name, TargetColumn = mapEp["Mapping"], DefaultValue = mapEp["Default", null], IsFixed = Boolean.Parse(mapEp["IsFixed", "false"]) }; mappings.Add(mapping); var transformStr = inifile.GetValue("Transformations", fieldKey); if (!string.IsNullOrWhiteSpace(transformStr)) { mapping.Transformer = TransformationPipline.BuildFromState(transformStr); } } } ImportContext.FieldMappings = mappings; RaiseRequestNextPage(); } }
private void LoadTemplate() { var dlg = new OpenFileDialog(); dlg.Filter = "Import Template Files (*.bip)|*.bip|All files (*.*)|*.*"; if (dlg.ShowDialog().GetValueOrDefault()) { var inifile = new IniFile(); inifile.Load(dlg.FileName); var filtername = inifile.GetValue("Import", "ImportFilter"); if (string.IsNullOrWhiteSpace(filtername)) { ErrorMessage.Show("Invalid import profile - the name of import filter could not be read!"); return; } var importer = _model.Find((filter) => { return filter.Name.Equals(filtername, StringComparison.CurrentCultureIgnoreCase); }); if (importer == null) { ErrorMessage.Show("Invalid import profile - the unrecognized or unloaded import filter: " + filtername); return; } var epStr = inifile.GetValue("Import", "ProfileStr", ""); if (string.IsNullOrWhiteSpace(epStr)) { ErrorMessage.Show("Invalid import profile - No profile string specified."); return; } importer.InitFromProfileString(epStr); ImportContext.Importer = importer; listBox.SelectedItem = importer; var mappings = new List<ImportFieldMapping>(); // Now the mappings... var colCount = inifile.GetInt("Import", "FieldCount"); for (int i = 0; i < colCount; ++i) { String fieldKey = string.Format("Field{0}", i); var mapStr = inifile.GetValue("Mappings", fieldKey); if (!string.IsNullOrWhiteSpace(mapStr)) { var mapEp = EntryPoint.Parse(mapStr); var mapping = new ImportFieldMapping { SourceColumn = mapEp.Name, TargetColumn = mapEp["Mapping"], DefaultValue = mapEp["Default", null], IsFixed = Boolean.Parse(mapEp["IsFixed", "false"]) }; mappings.Add(mapping); var transformStr = inifile.GetValue("Transformations", fieldKey); if (!string.IsNullOrWhiteSpace(transformStr)) { mapping.Transformer = TransformationPipline.BuildFromState(transformStr); } } } ImportContext.FieldMappings = mappings; RaiseRequestNextPage(); } }
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; }
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; }
private void InitImportMapping(List <ImportFieldMapping> mappingList) { // Full Name ImportFieldMapping fullName = new ImportFieldMapping(Col_FullName, true); fullName.Validator = new NotEmptyDataValidator(); mappingList.Add(fullName); // familyName ImportFieldMapping familyName = new ImportFieldMapping(Col_FamilyName, false); mappingList.Add(familyName); // gender ImportFieldMapping gender = new ImportFieldMapping(Col_Gender, false); char[] regChars = new char[] { 'M', 'F' }; gender.Validator = new CharSetValidator(regChars); mappingList.Add(gender); // phone ImportFieldMapping phone = new ImportFieldMapping(Col_Phone, false); mappingList.Add(phone); // Col_Email ImportFieldMapping email = new ImportFieldMapping(Col_Email, false); mappingList.Add(email); // Col_Fax ImportFieldMapping fax = new ImportFieldMapping(Col_Fax, false); mappingList.Add(fax); // Col_ZipCode ImportFieldMapping zipCode = new ImportFieldMapping(Col_ZipCode, false); mappingList.Add(zipCode); // Col_AddressLine1 ImportFieldMapping addressLine1 = new ImportFieldMapping(Col_AddressLine1, false); mappingList.Add(addressLine1); // Col_AddressLine1 ImportFieldMapping addressLine2 = new ImportFieldMapping(Col_AddressLine2, false); mappingList.Add(addressLine2); // Col_City ImportFieldMapping city = new ImportFieldMapping(Col_City, false); mappingList.Add(city); // Col_Country ImportFieldMapping country = new ImportFieldMapping(Col_Country, false); mappingList.Add(country); // Col_CountryState ImportFieldMapping countryState = new ImportFieldMapping(Col_CountryState, false); mappingList.Add(countryState); }
private DataGridColumn CreateColumn(ImportFieldMapping mapping) { var col = new DataGridTextColumn(); col.Header = mapping.SourceColumn; col.Width = DataGridLength.Auto; col.Binding = new Binding(mapping.SourceColumn); return col; }
public override void OnPageEnter(WizardDirection fromdirection) { var progress = new ProgressWindow(this.FindParentWindow(), "Extracting column information from data source...", true); _fields = _fieldSource(); lvwFields.ItemsSource = _fields; CollectionView myView = (CollectionView)CollectionViewSource.GetDefaultView(lvwFields.ItemsSource); PropertyGroupDescription groupDescription = new PropertyGroupDescription("Category"); myView.GroupDescriptions.Add(groupDescription); var model = new List<ImportFieldMapping>(); JobExecutor.QueueJob(() => { List<String> columns = null; columns = ImportContext.Importer.GetColumnNames(); var existingMappings = ImportContext.FieldMappings; if (existingMappings != null && existingMappings.Count() > 0) { foreach (ImportFieldMapping mapping in existingMappings) { model.Add(mapping); } } else { foreach (string columnName in columns) { var mapping = new ImportFieldMapping { SourceColumn = columnName }; model.Add(mapping); } } _model = new ObservableCollection<ImportFieldMappingViewModel>(model.Select((m) => { return new ImportFieldMappingViewModel(m); })); lvwMappings.InvokeIfRequired(() => { lvwMappings.ItemsSource = _model; }); progress.InvokeIfRequired(() => { progress.Dispose(); }); }); }