Skip to main content

Job to import text file data to Table in MSD axapta

I want to share code to  import text file data to Table in axapta. Here is sample of one field taken in text file.

 #define.ioRead("r")  
   Dialog         dialog = new Dialog('File Upload');  
   Dialogfield       dialogfield;  
   DialogField       dialogFileName;  
   InventTable       inventTable;  
   ItemID         itemID;  
   FileIOPermission    fileIOPermission;  
   CommaTextIo       io;  
   container        inLine;  
   int           lineNum;  
   int           i;  
   ;  
   dialogFileName = dialog.addField(typeid(FilenameSave));  
   dialog.run();  
   if(dialog.closedOk())  
   {  
     fileIOPermission  = new FileIOPermission(dialogFileName.value(), #ioRead);  
     fileIOPermission.assert();  
     io         = new CommaTextIo(dialogFileName.value(), #ioRead);  
     if (io)  
     {  
       ttsbegin;  
       while (io.status() == IO_Status::Ok)  
       {  
         inLine = io.read();  
         if (io.status() != IO_Status::Ok)  
         {  
           break;  
         }  
         itemID = conpeek(inLine,1);  
         if(itemID)  
         {  
           inventTable = inventTable::find(itemID,true);  
           if(inventTable)  
           {  
             inventTable.ItemGroupId = conpeek(InLine,2);  
             inventTable.doUpdate();  
             i++;  
           }  
           else  
           {  
             info(strfmt('Cant find Item %1',itemID));  
           }  
         }  
       }  
       ttscommit;  
     }  
   }  

Popular posts from this blog

strScan and Find a first occurrence of a string in a string using x++

strScan (Find a first occurrence of a string in a string) info("int strScan(str _text1,str _text2,int _position,int _number)"); info("Searches a text string for the occurrence of another string."); info("_text1 - The text string to search."); info("_text2 - The string to find."); info("_position - The position at which the search should start."); info("_number - The number of characters that should be searched."); info(int2str(strScan("ABCDEFGHIJ","DE",1,10)));

Code to get customer Primary Address in Ax 2012

Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole

Get record from table on the basis of field id in Microsoft dynamics axapta x++

How to Get record from table on the basis of field id in dynamics axapta x++. just try following code in job to understand better way. emplTable emplTable; FieldId fieldId; ; fieldId = fieldNum(emplTable, Emplid); select emplTable; info(emplTable.(fieldId)); select emplTable where emplTable.(fieldId) == '1101'; info(emplTable.Name);