Msdax12.blogspot.com Website Review

Though there are many ways to upload data into MS Dynamics Ax, one of the way is by making job in MS Dynamics Ax, though it is a traditional Let us as*ume that the data to be uploaded is available in CSV format. Also as*ume that the data to be uploaded is a list of city In this case data to be uploaded are: 1.       CountryRegionId in Column number 2 2.       Description in Column number 4 3.       Name in Column number 7 4.       StateId in Column number 9 To write a job in MS Dynamics Ax, go to the AOT by pressing CTRL+D.     LogisticsAddresssCity   logisticsAddresssCity;     LogisticsAddresssCity   uploadLogisticsAddresssCity;     CommaIO                     csvFile;     CONTAINER                   readCon;     counter                     icount, inserted;     Dialog                      dialog;     DialogField                 dfFileName;     FileName                    fileName;     #File          filename =  dfFileName.value();       }          csvFile  =  NEW CommaIO(filename,'r');         readCon  = csvFile.read();         TTSBEGIN;             readCon  = csvFile.read();             name = CONPEEK(readCon, 7);             IF(readCon)                 {                     SELECT LogisticsAddresssCity WHERE logisticsAddresssCity.Name == name;                     IF(!LogisticsAddresssCity)                     {                         info(STRFMT(%1 %2, CONPEEK(readCon, 4), CONPEEK(readCon, 7)));                         uploadLogisticsAddresssCity.clear();                         uploadLogisticsAddresssCity.CountryRegionId = CONPEEK(readCon, 2);