Convert whole field to decimal field

(0) Share

Report

Posted on by CrmUser101

180

Hello,

I want to convert whole field to decimal field.
I have whole number field on form numofMonth.

I want to create new decimal field numofMonth2

is this right approach?

How can I migrate data from numofMonth field to numofMonth2 field?

is there better approach to implement this solution?

Thanks,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

a33ik 3,306 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

I would recommend using SSIS with KingswaySoft adapters to migrate the data.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Shafdev ,

Are you wanting to keep both values or only the Decimal value moving forward? Is this just a one time migration?

If one time migration, the easiest approach I would look at is the following:

Add new column as decimal to the table

Create a view that shows both fields

Export the data to Excel

Utilize Excel to set the value of the new field based on the value of the current field (I would usually follow this approach:

Add a column to right of exported data (temporary) and set the value to the cell with the exported whole number (i.e. if A2 then set value of this new column as =A2)

Change column format in Excel on this temporary column to have two decimal places

Copy column values and "Paste Values" into your new Dataverse column you have in the output and this should put in the decimal values

Remove the temporary column

Import the data which will update each row and populate the new field

Drop the original field from the table after removing from all forms / views etc.

Was this reply helpful? Yes No
LaurenWithers 82 on at

Like (0)

Report
Copy link

Link copied!
You could also write a plugin for migrating the data from the whole number field to the new decimal field; using the RetrieveMultiple method to retrieve all the records from the entity that contains the numofMonth field, loop through the records, and update the value of the numofMonth2 field for each.

For example:
var query = new QueryExpression("entity_name"); query.ColumnSet = new ColumnSet("numofMonth", "numofMonth2"); var records = service.RetrieveMultiple(query).Entities; foreach (var record in records) { decimal numofMonth = ((int)record.GetAttributeValue<AliasedValue>("numofMonth")).Value / 100m; record["numofMonth2"] = numofMonth; service.Update(record); }

If this helped please give it a thumbs up, if it solved the issue please give it a thumbs up and accept it as the solution.
🙂

Was this reply helpful? Yes No