Please Guide on XMl File

Discussion in 'Tally Developer' started by auruem, Apr 2, 2023.

    
  1. auruem

    auruem Member


    Hi @Amit Kamdar Sjr

    Please guide me….

    am trying to write a tdl related to pincode in detors and creditors ledger

    in india there are about 20 Thousand pin codes

    Is it possible or there is any limit of lines or size of of xml file

    am not expert in any programming language
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    First of all, am really surprised you need a TDL for Pincodes ... logically the concept is not that helpful.....

    Second, there is no limit, but bigger the LIVE database (i.e. data from which it is being picked up) slower your code will work..

    Third, there is already exiting code for CITIES in Ledger Master in this forum.... find it and use it ... instead of city you can call up your pincode database.
     


  3. auruem

    auruem Member


    @Amit Kamdar Sir , Thanks for Quick Reply….

    i know its not that useful…

    But , am useing it for learning only…
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Okay ... Code exists for Cities ---- replicate the same and replace cities with pincode databse.
     


  5. Sai Vineeth

    Sai Vineeth Active Member



  6. auruem

    auruem Member



  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    V Good... congrats....
     


  8. auruem

    auruem Member


    @Amit Kamdar Sir Please Guide…

    what to write in Description to go to last line of the Form every time i open it to create new line

    Every time i have to press ctrl + End after opening form
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Write a Function to execute your report and Key-Press ............
     


  10. auruem

    auruem Member


    i created this code for eduecation purpose

    i have 2 issue in following code

    1. deletes all the fields if wrongly delets first field
    2. like to go last row when opens form

    Code:
    ;    Create CITY Master
    
    ;    [#Menu        : GateWay Of Tally]
    ;        Add        : Key Item    : CREATE CITY MASTER    : Y : Alter    : AuCreateCity
    
        [#Menu        : GateWay Of Tally]
            Add        : Key Item    : CREATE CITY MASTER    : Y  : Call    : AuCityFunc 1
    
        [Function    : AuCityFunc 1 ]
            10        : Alter        : AuCreateCity
            11        : Trigger Key     : Enter
    ;        20        : Call        : AuCityFunc 2
           
        [Function    : AuCityFunc 2]
            10        : Trigger Key    : "Ctrl + End"
            20        : Trigger Key    : "BackSpace"
            30        : Trigger Key    : "BackSpace"
            40        : Trigger Key    : "BackSpace"
    
        [Report        : AuCreateCity]
            Object    : Company
            Form    : AuruemCityForm
            Title    : $$LocaleString:"City Master Creation"
            ON        : LOAD    : Call : AuCityFunc 2
    
        [Form        : AuruemCityForm]
            Part    : AuCityCreationPart
            Width    : 80% Page
            Height    : 80% Page
            Verical Align    : Top
    
        [Part        : AuCityCreationPart]
            Line    : AuCityCreationTitleLine , AuCityMasterLine
            Repeat    : AuCityMasterLine    : AuCityMstUDF
            Scroll    : Both
            Break    : $$Isempty:#AuNewCity
    
        [Line        : AuCityCreationTitleLine]
            Field    : Short Prompt, Name Field, Simple Field, Medium Prompt, Medium Prompt2
            Border    : Thick Bottom
            Local    : Field    : Short Prompt        : Info        : $$Localestring:"Sr.No."
            Local    : Field    : Name Field        : Info        : $$Localestring:"CITY"
            Local    : Field    : Simple Field        : Info        : $$Localestring:"TALUKA"
            Local    : Field    : Medium Prompt        : Set As    : $$Localestring:"DISTRICT"
            Local    : Field    : Medium Prompt2    : Set As    : $$Localestring:"PINCODE"
            Local    : Field    : Default            : Align        : Left
            Local    : Field    : Default            : Style        : Normal Bold
    
        [Line        : AuCityMasterLine]
            Fields    : AuCitySrNo, AuNewCity, AuNewTaluka, AuNewDist, AuNewPinCode
            Local    : Field        : Default        : Align    : Left
            Local    : Field        : AuCitySrNo    : Align    : Center
            Local    : Field        : AuNewCity        : Align    : Left
            Local    : Field        : AuNewCity        : Width    : 25
    ;        Local    : Field        : AuNewCity        : Color    : Orange
    
        [Field        : AuCitySrNo]
            Set As    : $$Line
            Skip    : Yes
    ;        Color    : Au Deep Pink
            Width    : 10
    
        [Field            : AuNewCity]
            Use            : Name Field
            Storage        : AuNewCityUDF
            Style       : Large Bold
            Unique      : Yes
    
        [Field                : AuNewTaluka]
            Use                : Name Field
            Set as            : $$Value
            Storage            : AuNewTalukaUDF
            Width            : 20
            Skip Forward    : ($$Isempty:#AuNewCity)
            Color            : Red
    ;        Validate        : NOT ($$IsEmpty:$$Value)
            Notify            : AuTalukaEmpty:($$Isempty:$$Value) And Not ($$Isempty:#AuNewCity)
            Align            : Left
        [Field                : AuNewDist]
            Use                : Name Field
            Storage            : AuNewDistUDF
            Set as            : $$Value
            Width            : 20
            Skip Forward    : ($$Isempty:#AuNewCity)
            Color            : Blue
    ;        Validate        : NOT $$IsEmpty:$$Value
            Notify            : AuDistEmpty:($$Isempty:$$Value) And Not ($$Isempty:#AuNewCity)
    
    
        [Field                : AuNewPinCode]
            Use                : Name Field
            Storage            : AuNewPinUDF
            Set as            : $$Value
            Width            : 20
            Skip Forward    : ($$Isempty:#AuNewCity)
            Color            : Blue
    ;        Validate        : NOT $$IsEmpty:$$Value
            Notify            : AuPinE    mpty:($$Isempty:$$Value) And Not ($$Isempty:#AuNewCity)
                   
    
        [System                : UDF]
            AuCityMstUDF    : AggreGate    : 25000
            AuNewCityUDF    : String    : 25001
            AuNewTalukaUDF    : String    : 25002
            AuNewDistUDF    : String    : 25003
            AuNewPinUDF        : String    : 25004   
    
        [System                    : Formulas]
            AuTalukaEmpty        : "Taluka Is Empty !"+$$Newline+"Are You Sure?"
            AuDistEmpty            : "District is Empty!"+$$Newline+"Are You Sure?"
            AuPinEmpty            : "PinCode is Empty!"+$$Newline+"Are You Sure?"
    
    ;;    EoF City Master
     


Share This Page