Item Alias Update in already entered Item Master " Please help me"

Discussion in 'Tally Developer' started by MIttal Sharma, Jan 8, 2016.

    
?

Item Alias code Update in Excuting Item master

  1. Code Update

    2 vote(s)
    100.0%
  2. Item Master

    2 vote(s)
    100.0%
Multiple votes are allowed.
  1. MIttal Sharma

    MIttal Sharma New Member


    ;;Dear All ,
    ;
    ;;Please help me for Update item Master alias tdls file .

    ;;Code Given below


    [Collection: ExceltemMasterAliasCollection]
    ODBC : "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=D:\Import Template\ST Alias.xlsx"
    SQL : "Select * from [Sheet1$]"

    [Function: STAliasImport]
    Variable : TotalEntries : String
    Variable : Count : Number
    00 : Set : TotalEntries : $$NumItems:ExceltemMasterAliasCollection
    10 : Start Progress: ##TotalEntries : "Update Stock Item Alias" : "Importing Stock Item Alias" : ##SVCurrentCompany
    20 : Walk Collection : ExceltemMasterAliasCollection
    30 : Alter Object : STOCKITEM
    40 : Set Value : Name : $_1
    50 : Save Target : ..
    60 : Insert Collection Object: Name
    70 : SET VALUE : Name : $_2
    80 : SET VALUE : LANGUAGEID : "1033"
    90 : Create Target : ..
    330 : SAVE TARGET
    340 : Show Progress : ##Count
    350 : Increment : Count
    360 : End Walk
    370 : End Progress
    380 : Msg Box : "Status" : "Item Master Alias Imported Successfully"

    [#Menu: Gateway of Tally]

    Add : Item : Before : @@locQuit : "Import Stock Item Alias" : Call : STAliasImport
     

    Attached Files:



  2. admin

    admin Administrator Staff Member


    try using

    modify object concept
     


  3. MIttal Sharma

    MIttal Sharma New Member


    Dear ,

    Mne bhut try k h but nhe ho pa rha h so Please help me
     


  4. Ria

    Ria Member


    insert collection object : language name
    set value : name : ##aliasname
    set target : ..
     


Share This Page