Importing/Exporting User-Defined Table Data

<< 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 >

hm_btn_navigate_prevhm_btn_navigate_tophm_btn_navigate_next

Importing/Exporting User-Defined Table Data

 

Show/Hide Hidden Text

This sample add-on shows how to set "userDefinedTable.AllowImportExport" flag to "True" for importing and exporting user-defined table data in iVend Retail.

Click here to collapse/expand the view.

Sample for Importing/Exporting User-Defined Table data.

<<< 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);

                    }

                }