DDT Database Import converts Decimal(18,6) to Int.

Richard

We'll look into this.  Thanks.

Hi,



any news about that? I have the same issue with decimal(18,4) and decimal(18,5)

This is very important and urgent to me. Planned to roll out to the first customer tomorrow and I cant if that doesnt work.



thanks for your help,





Bastian

Oh, ... that was in the wrong topic.

I actually meant that this happens when I deploy a ddt package not when I import a database

Sorry for the delay on this Bastian, we were all out of the office for labor day this weekend.

I believe we handled the above on an import a while back, but I'll need to reproduce the scenario you are describing on a deployment so we can work through it (if it still manifests.) I know you are in a rush for this so it is high on the priority list. I'll get back to you once I know more.

Thanks,

Dustin

Bastian,

I've been trying to reproduce the issue you are describing but so far everything I've tried has come accross without issue. Creating and outlining a new table in the DDT with two decimal fields (one 18,4 and one 18,5) comes accross just fine after deployment.

Are you on the latest version of the framework? The 1.6.6 beta listed here is actually very stable (it will be released officially as soon as the documentation updates are completed.)

I have found the DDT Import database structure converted all my numeric data types to "int".  It imported decimal types properly but not numeric.  For example, the DDT import for numeric(10,2) shows the data type as "Int" but the detail shows Size: 9, Precision: 10, Scale: 2 as for a numeric data type.  The import was from an SQL 2005 database.

Larry,

Sorry for the delay here.  Our responses are generally much quicker than this but we are not in the office this week.  I will add this to the list and check into it next week.  Thanks for the heads up!

I'm having this problem too. I have SF ver1.6.6.



Also, in the DDT Modify Table Structure screen, why isn't there a Numeric type in the Data Type drop down?



Thanks