hello seniors and fellow developers

Discussion in 'Requests' started by alagarasan, Sep 3, 2012.

    
  1. alagarasan

    alagarasan New Member


    i want to know what is the Storage Name for e-Sugam No..
     


  2. admin

    admin Administrator Staff Member


    VATWayBillNo
     


  3. Sudhir Kumar Sahu

    Sudhir Kumar Sahu New Member


    i do not understand your web site
     


  4. admin

    admin Administrator Staff Member


    What do you mean??
     


  5. hitarth

    hitarth Member


    What is Field Name (NOT TITLE FIELD) in Default Invoice Print For -
    Invoice No., Dated, Delivery Note, Mode/Terms of Payment etc. at top right
    Thanks
     


  6. sharad p

    sharad p New Member


    Dear Sir,
    While executing following code it shows error
    Function:'importfromexcel' label 10 : invalid number of steps
    Function:'importfromexcel' label 10 : action execution failed
    Pls. suggest the errors in code

    [#Menu:Gateway of Tally]
    Add : Item: Before: @@Locquit:"Import from Excel" : Call :Importfromexcel

    [Function:Importfromexcel]
    Variable : Totalentries : Number
    00 : Set : Totalentries : $$NumItems:Extallycollection
    10 : Start Progress : Totalentries : "Ledgers creation": "Importing ledgers in" :##SVcurrentcompany
    20 : Walk Collection:Extallycollection
    30 : New Object: Ledger
    40 : Set Value:Name :$_1
    50 : Set Value:parent :$_2
    60 : Set Value:mailingname :$_1
    70 : Set Value:State Name :$_6
    80 : Set Value:Ledger phone :$_7
    90 : Set Value:Ledger fax:$_8
    100 : Set Value:email : $_9
    110 : Insert Collection Object:address
    120 : Set Value:address :$_3+","+$_4
    130 : Set Target : ..
    140 : Insert Collection Object:address
    150 : Set Value:address :$_5
    160 : Set Target: ..
    170 : Create Target
    180 : Show Progress : ##count
    190 : Increment : Count
    200 :End Walk
    210 :End Progress
    220 : Msg Box:"STATUS" :"Ledgers from excel imported successfully"

    [Collection:Extallycollection]
    ODBC:"DRIVER={MICROSOFT EXCEL DRIVER (*.XLS,*.XLSX,*.XLSM,*.XLSB)};DBQ=d:\narendra\LEDGER.XLSX"
    SQL: "SELECT*FROM(LEDGERS$)"
     


  7. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Invalid Steps means Collection Not Gathered


    Step 1
    [Collection:Extallycollection]
    ODBC:"DRIVER={MICROSOFT EXCEL DRIVER (*.XLS,*.XLSX,*.XLSM,*.XLSB)};DBQ=d:\narendra\LEDGER.XLSX"
    SQL: "SELECT*FROM [LEDGERS$]"

    Step 2
    Check Whther The Filename n sheetname are correct , wthether available in the specified path

    Step 3
    Check the Bitness
    whether 32 bit or 64 bi

    Make sure Windows OS , Tally, MS Office are in same bitness
     
    zakirhossain_diu likes this.


  8. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Invalid Steps means Collection Not Gathered


    Step 1
    [Collection:Extallycollection]
    ODBC:"DRIVER={MICROSOFT EXCEL DRIVER (*.XLS,*.XLSX,*.XLSM,*.XLSB)};DBQ=d:\narendra\LEDGER.XLSX"
    SQL: "SELECT * FROM [LEDGERS$]"

    use square Brackets



    Step 2
    Check Whther The Filename n sheetname are correct , wthether available in the specified path

    Step 3
    Check the Bitness
    whether 32 bit or 64 bi

    Make sure Windows OS , Tally, MS Office are in same bitness
     


  9. kdchavan

    kdchavan New Member


    I am looking for help.... Need to have multiple email addresses and contacts for all sundry debtors and creditors along with Contact Name, Number, Designation and email ID. Also All the email Ids should be listed while using mailing option in Tally.

    Can you Please Help SIR?
     


  10. ASHIM1611

    ASHIM1611 New Member


    I ran the above code and I am getting the following two errors:

    1. FUNCTION: 'ImportFromExcel' LABEL: 10 : Invalid number of steps
    2. FUNCTION: 'ImportFromExcel' LABEL: 10 : Action execution failed!

    The function basically tries to read the data from the excel file called Import.xls. I have googled these two errors and I found some suggestions:

    1. The OS + Tally + Microsoft Office should all be either 32 bit or 64 bit.
    2. The excel file name extension should be xls instead of xlsx.
    I have a 64 bit system and I have checked to make sure that both Office and Tally are 64 bit. Also, my file extension is .xls. Any other ideas as to why this might not be working?

    excel tally
     

    Attached Files:



Share This Page