Hello,
I try to load an excel with about 1 mio lines into dataverse - the setting is in Dataverse to german number formats. The excel is set to german formats too. when i load the excel into dataverse it shows me the right format on the sreen e.g. 14,17 in words 14 euro and 17 cent. when the excel is loaded it allways crashes in the fields with decimal values (value outside the range). the loaded records show then the value of the field 1 417,00 - when i do this with 10 testrecords it loads 8 out of 10 - but there is no difference in this 2 records.
here is the error message
a/v9.1/crd44_aartikeltests{ "crd44_anlage": "2009-12-09T00:00:00+00:00", "crd44_artikel": "1000", "crd44_bestand": 0, "crd44_bestsperre": false, "crd44_bezeich": "SCREW MACH PAN", "crd44_einheit": 1, "crd44_ekp": "1,1499999999999999", "crd44_ersatz": "VINTAGEPARTS", "crd44_liefer1": "HD", "crd44_mwst": 0, "crd44_nummer": 6, "crd44_reser": 0, "crd44_update": "2025-02-05T00:00:00+00:00", "crd44_vkp": "3,33", "crd44_wgr": "HDHDP" }
{"message":"A validation error occurred for crd44_aartikeltest.crd44_ekp. The value 1.15E+16 of type System.Double is outside the valid range(0 to 1000000000).","cdsErrorCode":"0x80044330","HelpLink":"
http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80044330&client=pla...","InnerErrorMessage":"A validation error occurred for crd44_aartikeltest.crd44_ekp. The value 1.15E+16 of type System.Double is outside the valid range(0 to 1000000000).","cdsRequestId":"aff689d3-c7f2-4124-9eda-dd8a43965784","cdsRequestUtcTime":"3/29/2025 11:06:03 AM"}
your kind help would be very nide
regds, Manfred
