bcolpaert / colso.xrm.attributeeditor Goto Github PK

Hello!

I am currently trying to import fields to a small test entity in a dev enviroment via Attribute Editor. The problem is, that my Org is in German and it looks like that is the reason I get the Error "The language code 1033 is not a valid language for this organization."

Did I miss some configuration?

Greetings from Germany and thanks for the effort.

Michael,

Working in a D365 V9 environment. It appears that global option sets are not recognized in the template export. I have several attributes on my opportunity record that are tied to global option sets, however, in the export template, they show up under the simple option set with the same picklist values but no reference or tie-in to the global set.

I am using this to create fields in another instance and my concern is that the global set will be lost and/or not tied to the attribute that gets created. Is it as simple as just manually creating the global set in the new environment and adding the Display Name (as indicated in the export template) of the global set to the spreadsheet template and clearing out the simple option set field that populates upon export?

Thanks!

Grant J

Hi,

I already see some topic about this plugin not working in a different language than English (1033).
It is possible to add a language code table/option to pick while using the plugin?

Maybe it is then useful for more languages than English.

If not possible, it is possible to write a quick summary about which code needs to be adjusted to work? I tried to replace the 1033 for my own language code everywhere in the project and re-build it. Then i replaced the .dll in the XRmtoolbox plugin folder but that does not work. Did i forget anything?

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:

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

Hi, thank you for creating this tool, but I am having an issue trying to use it.

I select my entity, and click "Download template", but when I open the file in Excel 2013, I get an error:

• We found a problem with some content in 'asdfasdf.xlsx'. Do you want us to try to recover as much as we can?

I answer Yes, and the Excel spreadsheet opens with one sheet containing a row for each field.

When I try to "Upload template", I get this error:

• Entity sheet is not found in the template

Here is the error log when opening the original downloaded template:

error518760_01.xml

Thank you,
Dave

Urgent! help please! Hello, First of all, thank you very much for all the useful XRM tools.

I am using the "Attribute Editor" to update the option set (picklist) values of several variables in different entities of my CRM instance. Following the procedure to update those values (https://msollenberger.com/2018/01/22/quickly-updating-multiple-entity-attributes/) , I do not get to modify any of the picklist option values. I am using the XRM with the last version 1.2018.1.20.

• What can I do to resolve this problem?

Thank you very much in advance for your help!
Claudia C

Hello,

I just updated to 2018.3 and I can't update fields anymore as it is throwing an error when I hit save & publish. All I'm doing is updating the display name. Thanks. :

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Colso.Xrm.AttributeEditor.AppCode.AttributeTypes.PicklistAttribute.b__8_1(String[] x)
at System.Linq.Enumerable.WhereSelectArrayIterator2.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at Colso.Xrm.AttributeEditor.AppCode.AttributeTypes.PicklistAttribute.AddAdditionalMetadata(PicklistAttributeMetadata attribute)
at Colso.Xrm.AttributeEditor.AppCode.AttributeTypes.AttributeMetadataBase1.GetAttributeMetadata() at Colso.Xrm.AttributeEditor.AppCode.AttributeTypes.AttributeMetadataBase1.UpdateAttribute(IOrganizationService service)
at Colso.Xrm.AttributeEditor.AttributeEditor.<>c__DisplayClass40_0.b__2(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

First, Great tool!

I'm currently running it towards an onPrem 2013 deployment. I can download, upload the file and save the file. Problem is that the tool does not include currency/money base fields. Hence changing the name on a money field will not have any change on its corresponding name field.

I see two potential solutions both equally good for my case

• Export base fields as rows in the excel and let me update them in same way as before
• Update the base fieldname with same name as local currency field but append "(Base)" to the end as default.

I think that the first option is better to give the user the freedom to have other naming convention.

Second part
Is it possible to add a "Save & Publish" button which does same as current Save button but also publish the selected entity?

Would you consider including the description of the attribute to allow change. Or would you take contributions to the code adding the description field.

Hello,

I downloaded an entity template and updated the description field in the template. When I upload the template it does show that there are updates to the description field, but once I save it and publish it the updates to the description is not done. Changes to the display name work correctly but not the description. Thanks.

Getting "input string is not in correct format". It probably has something to do with syntax of a lookup field type in the Excel spreadsheet. A guide on how to use this tool would be helpful.

Thanks a lot for developing this plugging

I am wondering whether there is any way to apply updates to a specific solution. It looks like that this plug-in works with default solution only.

Hi bcolpaert,

can you give me a short Manual how to use the AttributeEditor?

how to create new Attributes
f.e. if optionset, where to type in the os-values and if global or not
what are the possible chageable cols of the donwloaded Entity template
how to delete Attributes?
or whatelse is possible with the tool.

thx, Gr. PeB

If I download attributes from an entity and then upload the same to a new entity, I found that:
length of text strings is not preserved
min and max values of numeric strings is not preserved
date type fields are not preserved (date,date&time,date only)
calculated fields are not created correctly.

Hi
just found your very helpful attribute Editor. Thank you for that.

Now I tried to create 10 (!!) different named attributes with a lookup onto my entity salutation.

Unfortunately this failed as I think the Relationship Name is not set so that it always creates a different name. It only takes Source entity name and lookup entity name but should also add attribute name at the end.

Is it possible to add this?

Kind regards

Beat

Hi - I am only receiving this error with the AttributeEditor tool installed:

Could not load file or assembly 'DocumentFormat.OpenXml, Version=2.5.5631.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

I completely removed the toolbox and all plugins, reinstalled to version 1.2021.9.52

I used this to update approximately 100 display names in my environment. Upon doing so, it reset the following attributes on each field:

Currency Fields:

• Changed the max value from 1,000,000,000 to 100
• Changed the precision from 2 to Pricing Decimal Precision
• Changed the IME Mode from auto to disabled

Decimal Fields:

• Changed the max value from 1,000,000,000 to 100
• Changed the precision from 2 to 1

Memo Fields:

• Changed the max length from 2000 to 500

Picklist Fields:

• If there was a default value selected, it changed it to null

This of course caused many issues in my environment and had to be manually fixed, costing many hours.

Thank you.

It's a great tool that save me (or anyone) a lot of time.

One thing is unclear to me: how do you define/choose the numbers for new option values? I assume you can't just randomly pick a serie of numbers since I assume Dynamics had some sort of system to prevent duplicates.

Hello,
I receive an error when uploading a file. I have attached the error and the file I am trying to upload.
Thanks,
Tim
attribute editor error 061219.txt
edn_property_attributeeditor3a.xlsx

It's not possible to define the min and max values for numeric and currency fields in the template.

Hi

I'm getting an error trying to create a new option set field in Dynamics 365 Version 1612 (9.0.2438). The template was created from a Dynamics CRM 2013 system.

It has correctly identified the fields that need to be updated & created and successfully created a lookup field.

When it gets to the option set field, it gives the error

"Option set display name description is null or empty for objectid: 00000000-0000-0000-0000-000000000000. objectcolumn: DisplayName and language: 1033".

This is a non-global option set with 9 values.

Kind regards
Andy

After downloading the tool from the Tool Library, it failed with the following error.

Could not load file or assembly 'DocumentFormat.OpenXml, Version=2.5.5631.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

I had to copy the required assembly file from my old machine to run the tool. Here is the link to download the required .dll file in case if anyone else experiences the same issue.

https://1drv.ms/u/s!Ai-uZ1F-rHmWhc9c1bS2ri0aLMJrRA?e=sAk2nQ

I would like to be able to set the relationship name on a lookup data type.