Hi, I'd like some help with importing my excel file via tdl to tally. This was based on the post : http://tdlexperts.com/index.php?threads/import-payment_vch-excel-to-tally.251/#post-564 however i cant seem to get it to work. The start progress just starts and dissappears, when I check on the ledger vouchers, the entries aren't there. Code: [#Menu : Gateway of Tally] Item : Import : CALL : Import payment [Function : Import payment] 001 : Call : Import Of Payment Voucher [Function : Import Of Payment Voucher] Variable : Counter : Number 00 : SET : Counter : 0 01 : START PROGRESS : ($$NumItems:PaymentInfo) : "Vouchers Importing " : @@CmpMailName : "Payment Vouchers Importing ..." 02 : WALK COLLECTION : Payment Info 03 : SET : SVViewName : $$SysName:AcctgVchView 04 : NEW OBJECT : Voucher 05 : SET VALUE : Date : $$Date:@@EVchDatePost 06 : SET VALUE : VoucherTypeName : $$VchTypePayment 07 : INSERTCOLLECTION OBJECT : AllLedgerEntries 08 : SET TARGET : LedgerEntries 09 : SET VALUE : LedgerName : $DSDLedgerNameDr 10 : SET VALUE : Amount : $DSDAmountdr 20 : SET VALUE : Is Deemed Positive: "Yes" 30 : SET TARGET : .. 40 : INSERTCOLLECTION OBJECT : ALlLedgerEntries 50 : SET TARGET : LedgerEntries 60 : SET VALUE : LedgerName : $DSDLedgerNameCr 70 : SET VALUE : Amount : $DSDAmountcr 80 : SET VALUE : Is Deemed Positive: "No" 90 : SET TARGET : .. 100 : SET VALUE : PersistedView : ##SVViewName 110 : SET VALUE : NARRATION :$DSDNarration 120 : CALL : Save Target Payment 130 : INCREMENT : Counter 140 : SHOW PROGRESS : ##Counter 150 : END WALK 160 : END PROGRESS 170 : RETURN [Function: Save Target Payment] 04 : Save Target [Collection: Payment Info] ODBC : "Driver={Microsoft Excel Driver (*.xls)};Dbq=" + @@MaterODBCExcelPath+"" SQL : "Select * from ["+@@MaterODBCExcelSheet+"$]" SQLObject : Payment Info Obj [Object : Payment Info Obj] DSDDATE: $_1 DSDLedgerNameDr : $_2 DSDLedgerNameCr : $_3 DSDAmountdr : $_4 DSDAmountcr : $_5 DSDNarration :$_6 [System : Formula] EVchNoPost : $_1 EVchDatePost : $$Date:@@EVchDateStrPost EVchDateStrPost : ($$StringPart:$_1:8:2) + "-" + + ($$StringPart:$_1:5:2) + "-" + + ($$StringPart:$_1:0:4) [System : Formula] Mater ODBC Excel Path : "C:\Program Files\Tally.ERP9\ImportVouchers.xls" ;; The Excel Sheet Path Mater ODBC Excel Sheet : "PaymentVCH" ;; Sheet name in That Excel File ;;End-of-File
Dear Admin, Please mark this one as 'SOLVED'. It has already been solved on my side by dce2150404336 Thanks,
