New Release – Bulk Data Updater 1.2022.4

This release has only a few new additions.
But I really love these new features!

Read from the Bulk Data Updater Release Notes: JonasR.app/BDU/Releases

Calculate [almost] all types

The Calculate feature was quite nice but very limited as you could only use it for the target of text-type columns.

This is now improved!

Example: calculate to set lookup columns.

See the docs for BDU and Calculate.

Column types

Bulk Data Updater can update these types:

Text / String / Memo
Boolean / Yes or No
Whole Number / Int / BigInt
Decimal / Double
Money
DateTime
Picklist / OptionSet / Choice
Custom / Lookup / Uniqueid

Still missing: Owner, State, Status, PartyList, CalanderRules, EntityName, ManageProperty, Virtual, Choices

Issues

Calculations are now possible for almost all types of columns! #148
Closed issues with problems and ideas – thank you all! 😘
- #10 8 by @rwilson504
- #116 by @sbetzin
- #138 by @stonekw
- #108 by @rwilson504
- #157 by @MscrmTools

Bypass Custom Business Logic

🤓 This is great – and a bit scary… 😱

With one small checkbox, you can disable all custom plugins and other logic for all Updated, Assign, SetState, or Delete requests.

You have to know what it does, as skipping executing business logic can get unwanted consequences and you can miss things your solution needs.

Note: It is not only disabling “your own” logic but all others that are not from the “core” functionality.

You really should read this doc from Microsoft. You don’t have to read the code in there, but make sure you understand what it does.

💪 You get a lot of power, please be gentle… 🙏

Remember: Make sure that you know what you are doing!

Issues

Bypass Custom Business Logic feature added #79
This is a great feature is a “recently” available from Microsoft.
Make sure you read this info from the Microsoft Docs to know what you really do…!
Thanks for the support by @LinnZawWin and @MarkMpn! 🙏

Handle min version 9.2 is available for the Bypass Custom Business Logic feature. Fixed #159
For any on-prem, the first release (1.2022.4.1) – everything breaks the tool. The second release fixes it!

Lookup to Assign

You may have many users and teams… well, I don’t, my small demo environments are all small…

If users want to update Assign it may be a mess if you have a gazillion users.

So instead of two combo boxes (one for user, one for team), it is now changed to one lookup. I am actually using “my library” and it is very easy to implement the tool control, and it is a lot easier to use the lookup dialog for the users.

Using general control to lookup user or team.

Issue

Use Lookup instead of ComboBox for User/Team. #65
The Assign feature is now using the lookup dialog (from Rappen.XTB.Helper library) to easier find the right user or team.
Thank you @KazimGok and @leeh795 for this idea! 🤓