DataType Compatibility Validation During Import from CSV

Online Gopinath M 9 months ago

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..

0 Offline Kranthi 9 months ago

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

What does that mean?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Online Gopinath M 9 months ago 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..))
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Offline Kranthi 9 months ago in reply to Gopinath M

You mean the sales id field?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Online Gopinath M 9 months ago in reply to Kranthi

Hi,
I want to validate more fileds Like salesId,Year
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Online Gopinath M 9 months ago 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.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
+1 Offline Kranthi 9 months ago 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.
Cancel
Up 0 Down

Reply

Reject Answer

Cancel
0 Online Gopinath M 9 months ago in reply to Kranthi

Hi,
Could you please explain..or Give example
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Offline Kranthi 9 months ago in reply to Gopinath M

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

Reply

Verify Answer

Cancel
0 Online Gopinath M 9 months ago in reply to Kranthi

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

Reply

Verify Answer

Cancel
0 Offline Kranthi 9 months ago in reply to Gopinath M

Use strkeep funtion.

str s = '12345KK';

if (strKeep(s, '01234567') != s)
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
+1 Online Gopinath M 9 months ago 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!..
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Recommended

DataType Compatibility Validation During Import from CSV

Microsoft Dynamics 365 User Groups

Microsoft Dynamics User Groups