<< Click to Display Table of Contents >> Navigation: Developers' Guide > Using Data Interface > FAQs > Sample > Importing/Exporting User-Defined Table Data |
Navigation: Developers' Guide > Using Data Interface > FAQs > Sample >
Importing/Exporting User-Defined Table Data
This sample add-on shows how to set "userDefinedTable.AllowImportExport" flag to "True" for importing and exporting user-defined table data in iVend Retail.
<<< UserDefinedTable userDefinedTable = UserDefinedTableSubSystem.Instance.Load(TableName); if (userDefinedTable == null) { userDefinedTable = UserDefinedTableSubSystem.Instance.Create(); userDefinedTable.TableName = TableName; userDefinedTable.Description = TableDescription; userDefinedTable.IsHistoryTracked = true; userDefinedTable.AllowImportExport = true; string fieldName = "U_" + FieldName;
UserDefinedField m_Field = userDefinedTable.Fields.FirstOrDefault(d => d.FieldName.ToUpper() == fieldName.ToUpper()); if (m_Field == null) { UserDefinedField userDefinedField = userDefinedTable.CreateField(); userDefinedField.FieldName = FieldName; userDefinedField.Description = FieldDescription; userDefinedField.DataType = dataType; userDefinedField.DataLength = dataLength; userDefinedField.IsSearchable = isSearchable; userDefinedField.IsMandatory = IsMandatory; userDefinedField.DisplayOnly = DisplayOnly; userDefinedField.ShowInResults = ShowInResults; userDefinedField.RegularExpression = RegularExpression; userDefinedTable.AddField(userDefinedField); CXS.Retail.BusinessLogic.UDFHelperClass.CommitUserDefinedFields(userDefinedTable); } } |