As you have seen the Exporting Complete Table Record into CSV in the last post. Same way here i have written Code for Importing CSV into Table
static void Import_CSV(Args _args) { common TableBuffer; DictTable dictTable = new DictTable(tableNum(TableName)); // Define Table Name str TableName = dictTable.name(); DictField dictField; int i; CommaIo file; container line; str path = 'C:\\Users\\saadullah\\Documents\\'+TableName+'.csv'; // Directory Path #define.filename(path) #File file = new CommaIo(#filename, #io_read); if (!file || file.status() != IO_Status::Ok) { throw error("File cannot be opened."); } TableBuffer = dictTable.makeRecord(); while (file.status() == IO_Status::Ok) { line = file.read(); // Selecting File values line by line as assigning to Container if (line != conNull()) { // Looping the Table Field // we have Defined - 15 from the Counting of Fields // we do not Require 15 System Field such as RecId, RecVersion, Created By, Created Datetime, Modified By, etc... for( i =1; i <= dictTable.fieldCnt() -15; i++) { // Selecting the Fields dictField = new DictField(dictTable.id(), dictTable.fieldCnt2Id(i)); // Assigning the Container values to the Selected Table Field TableBuffer.(dictField.id()) = conpeek(line, i); } // Inserting Record TableBuffer.doInsert(); } } }