Dynamics AX Developer Forum DataType Compatibility Validation During…

Thread information

State Verified Answer
Date Gopinath M
Date 2017-7-17 11:56 AM
Replies 11 replies
Answers 2 answers
Subscribers 653 subscribers
Views 480 views

DataType Compatibility Validation During Import from CSV

Hi All,

How to validate the data from CSV with the DataTypes..?

Consider the value from the CSV is SO-123456..I want to validate this value with the SalesID(EDT) datatype in AX..

Please tell me the possibilities..

Gopinath M

Gopinath M
validate the data from CSV with the DataTypes..

What does that mean?

Kranthi

Kranthi

In reply to Kranthi:

Hi kranthi,
I want to validate the filed from csv(ex..1947,19475) with the Year(Should contain four numeric values(So 19475 is wrong..))

Gopinath M

In reply to Gopinath M:

You mean the sales id field?

Kranthi

Kranthi

In reply to Kranthi:

Hi,
I want to validate more fileds Like salesId,Year

Gopinath M

In reply to Kranthi:

Hi,
I want to import the Year(2010,2011,2012,etc) values from CSV..If the CSV contains the value like 20111 then I have to show that value in infolog as a warning and the value should not be inserted to table.

Gopinath M

In reply to Gopinath M:

You may have to do it field by field. Example year - it basically falls in between the years of max and minDate (or) the in year related to current fiscal period/year.

Kranthi

Kranthi

In reply to Kranthi:

Hi,
Could you please explain..or Give example

Gopinath M

In reply to Gopinath M:

I have already given you an example for year. Let me know, if you need any specific type.

Kranthi

Kranthi

In reply to Kranthi:

Hi,
Can you tell me how to check the text(from csv) only contains numeric values..?

Gopinath M

In reply to Gopinath M:

Use strkeep funtion.

str s = '12345KK';

if (strKeep(s, '01234567') != s)

Kranthi

Kranthi

In reply to Kranthi:

Hi Kranthi,
Thanks for ur reply..I have used isInteger() method and applied min, max year validations(1900 to 2154)...Its working!..

Gopinath M

Recommended