search

bcolpaert / Colso.Xrm.AttributeEditor

XrmToolbox plugin to create, modify and delete entity attributes via an Excel template.
MIT License
8 stars 12 forks source link

Upload template throws error #30

Open bl0wfish opened 7 months ago

bl0wfish commented 7 months ago

Error description: I cannot upload templates, even if they have not been changed. It crashes with an overflow exception, as can be seen in the following screenshot:

image

After uploading the template, 2 attributes are shown in the window, but the others are missing, so I assume the error happens on the third line of the template.

This attribute's “Max Value” property is 10000000000. The “Max Value” is a default configuration and was not changed by us. The error seems to happen, because this exceeds the upper boundaries of the Int32 data type. It should rather be an Int64.

Template File: uom_attributeeditor.xlsx

Specific error System.OverflowException: Der Wert für einen Int32 war zu groß oder zu klein. bei System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) bei Colso.Xrm.AttributeEditor.AppCode.TemplateHelper.ConvertToRawValue(ColumnAttribute column, String stringvalue) bei Colso.Xrm.AttributeEditor.AppCode.AttributeMetadataRow.FromListViewItem(ListViewItem item) bei Colso.Xrm.AttributeEditor.AttributeEditor.<>c__DisplayClass39_0.b__0(Object sender, DoWorkEventArgs e) bei System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) bei System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

Steps to reproduce:

  1. Pick a table, I used “Unit” as it has relatively few Fields and I never modified it.
  2. Download template.
  3. Select template file.
  4. Upload the template that has just been saved.

Environment Attribute Editor-Version: 1.2023.9.2 XrmToolBox-Version: 1.2023.12.68 Dataverse-Version: 9.2.23121.00190 OS: Windows 11 Pro 64 bit