Export UDF fields in excel using Tally ODBC

Discussion in 'Requests' started by Alph, Apr 19, 2021.

    
  1. Alph

    Alph New Member


    Hello TDL Experts !

    I am new to TDL, so please bare with me in case I ask a naive question or if this is already answered earlier.
    Basically I created a simple TDL file to add a new field to ledger and stock item but when I export this data to excel using tally odbc connection the UDF fields are not exported.

    Can you please let me know if there is a way to export it? Or in which table I can find the UDF data information?
     


  2. teja varma

    teja varma Active Member


    You have to expose the collection to ODBC, so you can access that collection.
    Inside that collection, you need to compute UDF you added.

    ;;;;;;;;;;;;;;;;;; Example;;;;;;;;;;;;
    [Collection : AllItems]
    Type:StockItem
    IsODBCTable : Yes
    Compute:Identifier:$UDF


    ;;;
    So in excel, you can access like this ;;;;;;;;
    Select $Identifier from AllItems
     


  3. Alph

    Alph New Member


    Thank you Teja, it worked for me...
     


Share This Page