Rounding of decimals by SmartConnect
Can someone please change the title to “Rounding of decimals by SmartConnect”?
Anatoli, by default SmartConnect doesn’t round anything unless you tell it. If you duplicate the map and export to a CSV file is the data rounded? The other thing to try for troubleshooting would be to create a SQL Trace using SQL profiler and see the actual statements being executed.
Hi Lorren, thank you for your reply.
I’ve done quite a few tests now and it seems it’s SmartConnect that does the rounding. I’ve created a brand new map to do the same insert and I DIDN’T TELL it to round values.
A test export to CSV DOESN’T round but insert into a table does.
I’m having difficulties getting the SQL Profiler to work right now – as I don’t have SQL Server Installation Center any more.
The version of SmartConnect I use is 18.104.22.168
I can provide more detail. This forum doesn’t support screenshots, though.
Anatoli, if you change the destination to CSV, does SmartConnect round the amount? I have been using the product since 20.13 and i have not seen SmartConnect round anything without it being told to do so through a calculation. I am not familiar if 20.12 did that or not.
If you want to send your resulting CSV that is exported, you can send it to me at email@example.com and i’ll take a look at it.
If you would like to submit an answer or comment, please sign in to the eOne portal.