Select employee name from employee list using xml request

Discussion in 'Tally Integration' started by skulal75, Apr 6, 2021.

    
  1. skulal75

    skulal75 New Member


    using xml request i want to pass or select employee name from the list
     

    Attached Files:



  2. teja varma

    teja varma Active Member


    I tried this, but no luck
    Try asking tally solutions.
     


  3. Sai Vineeth

    Sai Vineeth Active Member


    Use this XML to get List of Employee Names, loop though list to select one
    Code:
    <ENVELOPE>
        <HEADER>
            <VERSION>1</VERSION>
            <TALLYREQUEST>Export</TALLYREQUEST>
            <TYPE>Data</TYPE>
            <ID>List of Employees</ID>
        </HEADER>
        <BODY>
            <DESC>
                <STATICVARIABLES>
                    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                </STATICVARIABLES>
                <TDL>
                    <TDLMESSAGE>
                        <REPORT NAME="List of Employees" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
                            <FORMS>List of Employees</FORMS>
                        </REPORT>
                        <FORM NAME="List of Employees" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
                            <TOPPARTS>List of Employees</TOPPARTS>
                            <XMLTAG>"List of Employeess"</XMLTAG>
                        </FORM>
                        <PART NAME="List of Employees" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
                            <TOPLINES>List of Employees</TOPLINES>
                            <REPEAT>List of Employees : Collection of Employee</REPEAT>
                            <SCROLLED>Vertical</SCROLLED>
                        </PART>
                        <LINE NAME="List of Employees" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
                            <LEFTFIELDS>Name</LEFTFIELDS>
                        </LINE>
                        <FIELD NAME="Name" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
                            <SET>$Name</SET>
                            <XMLTAG>"EMPLOYEE"</XMLTAG>
                        </FIELD>
                        <COLLECTION NAME="Collection of Employee" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
                            <TYPE>COSTCENTER</TYPE>
                            <TYPE>COSTCENTER</TYPE>
                            <FILTERS>IsEmployeeGroup</FILTERS>
                            <FILTERS>payroll</FILTERS>
                        </COLLECTION>
                        <SYSTEM TYPE="Formulae" NAME="IsEmployeeGroup"> Not $ISEMPLOYEEGROUP</SYSTEM>
                        <SYSTEM TYPE="Formulae" NAME="payroll">$FORPAYROLL</SYSTEM>
                    </TDLMESSAGE>
                </TDL>
            </DESC>
        </BODY>
    </ENVELOPE>
     


Share This Page