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]
    IsODBCTable : Yes

    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