Showing posts with label Upload .csv file through job in ax 2012. Show all posts
Showing posts with label Upload .csv file through job in ax 2012. Show all posts

Tuesday, 28 July 2015

Upload .csv file through job in ax 2012

Upload .csv file through job in ax 2012

static void Atul_test(Args _args)
{
    CommaIO                     csvFile;
    container                   readCon, ledgerDimension;
    counter                     icount,inserted;
    Dialog                      dialog;
    DialogField                 dfFileName, dlgJournalNum, JVNumber;
    FileName                    fileName;
    Struct                              struct;
    str 50  jid;
    ;
     inserted =0;
    #File
    dialog      = new Dialog("Pick the file");
   dfFileName  = dialog.addField(extendedTypeStr(FilenameOpen));
    dialog.filenameLookupFilter(["All files", #AllFiles]);      
    if(dialog.run())
    {
            fileName = dfFileName.value();
    }
   
    csvFile  = new CommaIO(fileName, 'r');
   
    if(csvFile)
    {  
        ttsBegin;
        while (csvFile.status() == IO_Status::OK)
        {
          readCon  = csvFile.read();
          if(readCon)
            {

            // write your code, which data you want to upload from csv file.  
               
               
              icount++;
              inserted++;
            }  
        }  
         ttsCommit;
    }
                info(strfmt("%1 records Updated out of %2",inserted,icount));
}


Thank you!

Import General journal from excel in D365 F&O

 Hi Guys, Import General journal from excel in D365 F&O Code:  using System.IO; using OfficeOpenXml; using OfficeOpenXml.ExcelPackage; u...