Multiple line party address required while excel to Tally import

Dear Experts,

By using this function, i am able to create ledger but not able to import address in multiple lines. It is coming in a single line. Please guide me in the same query.

[Function: Create New Ledger]
Variable : Counter1 : Number
Variable : IsObjectExists : Logical
Variable:TempLed:String
001 : NEW OBJECT : Ledger
002 : SET VALUE : Name : ##Lednm
003 : Set Value arent :$Ledgrp1
004 :Set Value:LedStateName:$state1
005 :Set Value:COUNTRYNAME:"India"
006 :Insert Collection Object:Address
007 :Set Value:Address:$Add1 + ","+$Add2+","+$Add3
; 008 :Set Value:Address:$Add2;New
; 008A:Set Value:Address:$Add3;New
009 :Set Target:..
010 :Set Value:Ledgerphone:$phone1
011 :Set ValueARTYGSTIN:$GSTNO1
012 :Set Value:GSTRegistrationType:IF $$IsEmpty:$GSTNO1 then "Consumer" else "Regular"
013 : CREATE TARGET
014 : INCREMENT : Counter1
015:Return

 

Experts....Please reply.

 

Watch This Video

 

Thanks a lot...

 

Repeat below as many line as you want:

006 :Insert Collection Object:Address
007 :Set Value:Address:$Add1 + ","+$Add2+","+$Add3
; 008 :Set Value:Address:$Add2;New
; 008A:Set Value:Address:$Add3;New
009 :Set Target:..

 

Thanks all... It is done

 

sir,
bellow code is for excel to tally ledger import
059 : Set Value : Address : If $$IsEmpty:$$FileReadCell:##RCnt:9 Then "" Else $$FileReadCell:##RCnt:9


above code import only ledger address one line

how to import second and third line..............

please tell me,

 

Try this.. may be it will help you

Code:

A01: Insert Collection Object : Address
A02: Set Value : Address:  if $$:IsEmpty:$$FileReadCell:##RCnt:8 Then "" else $$FileReadCell:##RCnt:8
A03: Set Target :   ..

A04: Insert Collection Object : Address
A05: Set Value : Address:  if $$:IsEmpty:$$FileReadCell:##RCnt:9 Then "" else $$FileReadCell:##RCnt:9
A06: Set Target :   ..

A07: Insert Collection Object : Address
A08: Set Value : Address:  if $$:IsEmpty:$$FileReadCell:##RCnt:10 Then "" else $$FileReadCell:##RCnt:10
A09: Set Target :   ..

A10: Insert Collection Object : Address
A11: Set Value : Address:  if $$:IsEmpty:$$FileReadCell:##RCnt:11 Then "" else $$FileReadCell:##RCnt:11
A12: Set Target :   ..

 

Thank You for your reply sir.but it does not works..
Can you please share your mail id . i will send complete code for address column help................

 

Email - rohitjaiswar1995@gmail.com