magento 1.9 – Creating XML RPC method in customer module

I am creating a rpc method in the local customer module. But I am getting invalid path error. After hours of debugging also I am not able to figure out the missing portion. I was able to create in my local sales module but somehow its failing here.

In local/Mycompany/Customer/etc/api.xml :

<config>
<api>
    <resources>
        <customer translate="title" module="mycompany_customer">
            <model>mycompany_customer/customer_api</model>
            <title>Customer API</title>
            <acl>customer</acl>
            <methods>
                <setCustomerWhatsappStatus translate="title" module="customer">
                    <title>Set whatsapp status for customer</title>
                    <acl>customer/setCustomerWhatsappStatus</acl>
                </setCustomerWhatsappStatus> 
            </methods>
            <faults module="mycompany_sales">
                <data_invalid>
                    <code>103</code>
                    <message>Invalid data given. Details in error message.</message>
                </data_invalid>
            </faults>
        </customer>
    </resources>
    <acl>
        <resources>
            <customer translate="title" module="mycompany_customer">
                <title>Customer</title>
                <sort_order>1</sort_order>
                <setCustomerWhatsappStatus translate="title" module="mycompany_customer">
                    <title>Set whatsapp status for customer</title>
                 </setCustomerWhatsappStatus>
            </customer>
        </resources>
    </acl>
</api>

And in my local/Mycompany/Customer/Model/Customer/Api.php :

<?php

class Mycompany_Customer_Model_Customer_Api extends Mage_Customer_Model_Customer_Api
{
    public function setMethod($phone) {
       Mage::log($phone);
    }
}

And I am calling this method with dbaux_customer_customer.setCustomerWhatsappStatus but get Invalid Path error meaning that its not able to reach the method mentioned.

Please let me know if I missed something.

terminology – HTML elements in XML documents

I’ve been reading the HTML specifciation and I am confused with this line:

The nodes representing HTML elements in the DOM must implement, and
expose to scripts, the interfaces listed for them in the relevant
sections of this specification. This includes HTML elements in XML
documents

What HTML elements have to do with xml documents? Somewhat vague description makes things even more complicated:

To ease migration from HTML to XML, UAs conforming to this
specification will place elements in HTML in the
http://www.w3.org/1999/xhtml namespace, at least for the purposes of
the DOM and CSS. The term “HTML elements” refers to any element in
that namespace, even in XML documents.

What kind of migration? Who is UA? What is this http://www.w3.org/1999/xhtml namespace? How can URL be a namespace? And again, what HTML elements have to do with XML document?

python – Creating database and reporting tool out of xml files sourced from FTP

I have few questions regarding a reporting tool that I am trying to create. For better understanding let me describe the scenario first.

I am trying to create an automated reporting tool, which would allow me to bulk query a database of inputs which are sourced from the xml files sitting on an FTP server. I am looking at annual data stored in a zip archive containing multiple xml files with incremental updates issued almost everyday. In the first part of my project, I would like to create an automated download and schedule tool which would fetch the smls from the FTP and update the existent inputs depending on the key (e.g. user ID).

Here are the questions that I am struggling to address:

1) As these are separate files, what would be the best way to compile all this in one single file?
(I wanted to do this via SSIS and SQL, however, since SQL can not accommodate database that is bigger than 10 Gb (the current set of files amounts to 15+Gb), I am looking for the best alternative solution.

2) Is there any solution/software that would be able to create a read-only database straight off the XML files? I.e. without having to convert it in any other format? Also (if there is none) what would be the best alternative to SQL, given its limitations?

Many thanks, keep well!

Conditional Sum using in XML

I am working on a RTF Template which has the below XML inserted in it.

    <?xml version="1.0" encoding="UTF-8"?>

<!--Generated by Oracle BI Publisher -Dataengine, datamodel:_Human_Capital_Management_Recruiting_Job_Offer_Data_Models_JobOfferLetterDM_xdm -->

-<DATA_DS>

<P_INTERNAL_ID/>

<P_OFFERID>300000048185676</P_OFFERID>

<P_OFFERLETTERTEMPLATENAME/>

<P_BIP_UUID/>


-<OFFER_DETAILS>

<OFFER_ID>300000048185676</OFFER_ID>

<JOB_OFFER_TITLE>USI Solution Consultant</JOB_OFFER_TITLE>

<CREATION_DATE>2020-05-22T17:56:36.660+00:00</CREATION_DATE>

<CREATED_BY>akhilesht</CREATED_BY>

<ACCEPTED_ON_BEHALF>N</ACCEPTED_ON_BEHALF>

<ACCEPTED_ON_BEHALF_BY/>

<ACCEPTED_ON_BEHALF_DATE/>

<COMMENTS/>

<PHASE>Offer</PHASE>

<STATE>Accepted</STATE>

<E_SIGNATURE_FULL_NAME>Andew Cota</E_SIGNATURE_FULL_NAME>

<E_SIGNATURE_SIGNEE_IP_ADDRESS>10.52.98.208</E_SIGNATURE_SIGNEE_IP_ADDRESS>

<E_SIGNATURE_SIGNATURE_DATE>2020-05-22T18:04:30.223+00:00</E_SIGNATURE_SIGNATURE_DATE>

<EXPIRATION_DATE/>

<ACCEPTED_DATE>2020-05-22T18:04:30.223+00:00</ACCEPTED_DATE>

<ADDITIONAL_TEXT_1/>

<ADDITIONAL_TEXT_2/>


-<E_SIGNATURE_STATEMENT>

-<![CDATA[<body> 
 <div>
   By signing this Agreement electronically, I agree that  my electronic signature is the legal equivalent of my manual signature.  
 </div> 
 <div> 
  <br /> 
 </div> 
 <div>
   I certify that all information is true and correct to the best of my knowledge. I also agree that no certification authority or other third party verification is necessary to validate my E-Signature and that the lack of such certification or third party verification will not in any way affect the enforceability of my E-Signature.    
 </div> 
</body>]]>
</E_SIGNATURE_STATEMENT>

<OFFER_DESCRIPTION> <![CDATA[ ]]></OFFER_DESCRIPTION>


-<OFFER_DATES>

<OFFER_ID>300000048185676</OFFER_ID>

<MOSTRECENTEXTENDEDDATE>2020-05-22T18:02:44.950+00:00</MOSTRECENTEXTENDEDDATE>

<MOSTRECENTWITHDRAWNDATE/>

</OFFER_DATES>


-<SALARY>

<SALARY_BASIS>INR Monthly Monthly Salary - India</SALARY_BASIS>

<SALARY_RANGE_HIGH/>

<SALARY_RANGE_MID/>

<SALARY_RANGE_LOW/>

<SALARY_AMOUNT>80500</SALARY_AMOUNT>

<COMPA_RATIO/>

<ANNUAL_SALARY>966000</ANNUAL_SALARY>

<ANNUAL_FULLTIME_SALARY>966000</ANNUAL_FULLTIME_SALARY>

<SALARY_RANGE_POSITION/>

<QUARTILE/>

<MULTIPLE_COMPONENTS>Y</MULTIPLE_COMPONENTS>

<OFFER_ID>300000048185676</OFFER_ID>

<GRADE_LADDER/>

<QUINTILE/>

<SALARY_CURRENCY_SYMBOL>₨</SALARY_CURRENCY_SYMBOL>

</SALARY>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Basic Salary</COMPONENT_NAME>

<COMPONENT_AMOUNT>40000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>HRA</COMPONENT_NAME>

<COMPONENT_AMOUNT>20000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Special Adhoc Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Meal Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>1500</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Education Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>NPS Adhoc Pay</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Adhoc Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>500</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Monthly LTA</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Employer PF</COMPONENT_NAME>

<COMPONENT_AMOUNT>5000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Superannuation</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Car Adhoc Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Gratuity</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Insurance Premium</COMPONENT_NAME>

<COMPONENT_AMOUNT>1500</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Housing Loan Subsidy</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPENSATION>

<PLAN_NAME>Guaranteed Bonus</PLAN_NAME>

<OPTION_NAME>Guaranteed Bonus - IN</OPTION_NAME>

<VALUE>50000</VALUE>

<UNITS>INR</UNITS>

<NON_MONETARY_UOM/>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPENS_CURRENCY_SYMBOL>₨</OTHER_COMPENS_CURRENCY_SYMBOL>

<OTHER_COMPENS_FREQUENCY>Once</OTHER_COMPENS_FREQUENCY>

<OTHER_COMPENS_START_DATE>2020-05-23T00:00:00.000+00:00</OTHER_COMPENS_START_DATE>

</OTHER_COMPENSATION>


-<OTHER_COMPENSATION>

<PLAN_NAME>Sign On Bonus</PLAN_NAME>

<OPTION_NAME>Sign On Bonus - India</OPTION_NAME>

<VALUE>10000</VALUE>

<UNITS>INR</UNITS>

<NON_MONETARY_UOM/>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPENS_CURRENCY_SYMBOL>₨</OTHER_COMPENS_CURRENCY_SYMBOL>

<OTHER_COMPENS_FREQUENCY>Once</OTHER_COMPENS_FREQUENCY>

<OTHER_COMPENS_START_DATE>2020-05-23T00:00:00.000+00:00</OTHER_COMPENS_START_DATE>

</OTHER_COMPENSATION>


-<ASSIGNMENT>

<ASSIGNMENT_NAME>Associate Solutions Consultant</ASSIGNMENT_NAME>

<LEGAL_EMPLOYER>Majesco Software and Solutions India Pvt. Limited</LEGAL_EMPLOYER>

<HIRE_DATE>2020-05-23T00:00:00.000+00:00</HIRE_DATE>

<WORKER_TYPE>Employee</WORKER_TYPE>

<BUSINESS_UNIT_NAME>Sales</BUSINESS_UNIT_NAME>

<JOB_NAME>Associate Solutions Consultant</JOB_NAME>

<GRADE>JB-3</GRADE>

<DEPARTMENT>Presales</DEPARTMENT>

<LOCATION_NAME>IN_Mahape Office</LOCATION_NAME>

<PROJECTED_END_DATE/>

<REGULAR_OR_TEMPORARY>Regular</REGULAR_OR_TEMPORARY>

<FULL_OR_PART_TIME>Full time</FULL_OR_PART_TIME>

<WORKING_HOURS>8.75</WORKING_HOURS>

<STANDARD_WORKING_HOURS/>

<FTE/>

<HEAD_COUNT/>

<CONTRACT_NAME/>

<CONTRACT_TYPE/>

<CONTRACT_DURATION/>

<CONTRACT_DURATION_UNIT/>

<CONTRACT_PROJECTED_END_DATE/>

<REPORTING_ESTABLISHMENT/>

<WORKING_AT_HOME/>

<WORKING_AS_A_MANAGER/>

<POSITION/>

<HOURLY_PAID_OR_SALARIED/>

<START_TIME>2020-05-23T00:00:00.000+00:00</START_TIME>

<END_TIME>4712-12-31T00:00:00.000+00:00</END_TIME>

<PROBATION_PERIOD/>

<NOTICE_PERIOD/>

<BARGAINING_UNIT/>

<COLLECTIVE_AGREEMENT/>

<UNION_MEMBER/>

<FORMATTED_SINGLE_LINE_ADDRESS>INDIA</FORMATTED_SINGLE_LINE_ADDRESS>

<FORMATTED_MULTI_LINE_ADDRESS>INDIA</FORMATTED_MULTI_LINE_ADDRESS>

<HR_ACTION>EMPL_OFFER_CREATE</HR_ACTION>

<OFFER_ID>300000048185676</OFFER_ID>

<WORKER_CATEGORY/>

<ASSIGNMENT_CATEGORY>Full-time regular</ASSIGNMENT_CATEGORY>

<ASSIGNMENT_ID>300000048185689</ASSIGNMENT_ID>

<GRADE_STEP/>

<ASSIGNMENT_START_DATE>2020-05-22T00:00:00.000+00:00</ASSIGNMENT_START_DATE>

<ASSIGNMENT_FREQUENCY>Daily</ASSIGNMENT_FREQUENCY>


-<ASSIGNMENT_FLEX_FIELDS>

<ASG_INFORMATION_DATE1/>

<ASG_INFORMATION_DATE2/>

<ASG_INFORMATION_DATE3/>

<ASG_INFORMATION_DATE4/>

<ASG_INFORMATION_DATE5/>

<ASG_INFORMATION_DATE6/>

<ASG_INFORMATION_DATE7/>

<ASG_INFORMATION_DATE8/>

<ASG_INFORMATION_DATE9/>

<ASG_INFORMATION_DATE10/>

<ASG_INFORMATION_DATE11/>

<ASG_INFORMATION_DATE12/>

<ASG_INFORMATION_DATE13/>

<ASG_INFORMATION_DATE14/>

<ASG_INFORMATION_DATE15/>

<ASS_ATTRIBUTE_DATE1/>

<ASS_ATTRIBUTE_DATE2/>

<ASS_ATTRIBUTE_DATE3/>

<ASS_ATTRIBUTE_DATE4/>

<ASS_ATTRIBUTE_DATE5/>

<ASS_ATTRIBUTE_DATE6/>

<ASS_ATTRIBUTE_DATE7/>

<ASS_ATTRIBUTE_DATE8/>

<ASS_ATTRIBUTE_DATE9/>

<ASS_ATTRIBUTE_DATE10/>

<ASS_ATTRIBUTE_DATE11/>

<ASS_ATTRIBUTE_DATE12/>

<ASS_ATTRIBUTE_DATE13/>

<ASS_ATTRIBUTE_DATE14/>

<ASS_ATTRIBUTE_DATE15/>

<ASG_INFORMATION1/>

<ASG_INFORMATION2/>

<ASG_INFORMATION3/>

<ASG_INFORMATION4/>

<ASG_INFORMATION5/>

<ASG_INFORMATION6/>

<ASG_INFORMATION7/>

<ASG_INFORMATION8/>

<ASG_INFORMATION9/>

<ASG_INFORMATION10/>

<ASG_INFORMATION11/>

<ASG_INFORMATION12/>

<ASG_INFORMATION13/>

<ASG_INFORMATION14/>

<ASG_INFORMATION15/>

<ASG_INFORMATION16/>

<ASG_INFORMATION17/>

<ASG_INFORMATION18/>

<ASG_INFORMATION19/>

<ASG_INFORMATION20/>

<ASG_INFORMATION21/>

<ASG_INFORMATION22/>

<ASG_INFORMATION23/>

<ASG_INFORMATION24/>

<ASG_INFORMATION25/>

<ASG_INFORMATION26/>

<ASG_INFORMATION27/>

<ASG_INFORMATION28/>

<ASG_INFORMATION29/>

<ASG_INFORMATION30/>

<ASG_INFORMATION31/>

<ASG_INFORMATION32/>

<ASG_INFORMATION33/>

<ASG_INFORMATION34/>

<ASG_INFORMATION35/>

<ASG_INFORMATION36/>

<ASG_INFORMATION37/>

<ASG_INFORMATION38/>

<ASG_INFORMATION39/>

<ASG_INFORMATION40/>

<ASG_INFORMATION41/>

<ASG_INFORMATION42/>

<ASG_INFORMATION43/>

<ASG_INFORMATION44/>

<ASG_INFORMATION45/>

<ASG_INFORMATION46/>

<ASG_INFORMATION47/>

<ASG_INFORMATION48/>

<ASG_INFORMATION49/>

<ASG_INFORMATION50/>

<ASS_ATTRIBUTE1/>

<ASS_ATTRIBUTE2/>

<ASS_ATTRIBUTE3/>

<ASS_ATTRIBUTE4/>

<ASS_ATTRIBUTE5/>

<ASS_ATTRIBUTE6/>

<ASS_ATTRIBUTE7/>

<ASS_ATTRIBUTE8/>

<ASS_ATTRIBUTE9/>

<ASS_ATTRIBUTE10/>

<ASS_ATTRIBUTE11/>

<ASS_ATTRIBUTE12/>

<ASS_ATTRIBUTE13/>

<ASS_ATTRIBUTE14/>

<ASS_ATTRIBUTE15/>

<ASS_ATTRIBUTE16/>

<ASS_ATTRIBUTE17/>

<ASS_ATTRIBUTE18/>

<ASS_ATTRIBUTE19/>

<ASS_ATTRIBUTE20/>

<ASS_ATTRIBUTE21/>

<ASS_ATTRIBUTE22/>

<ASS_ATTRIBUTE23/>

<ASS_ATTRIBUTE24/>

<ASS_ATTRIBUTE25/>

<ASS_ATTRIBUTE26/>

<ASS_ATTRIBUTE27/>

<ASS_ATTRIBUTE28/>

<ASS_ATTRIBUTE29/>

<ASS_ATTRIBUTE30/>

<ASS_ATTRIBUTE31/>

<ASS_ATTRIBUTE32/>

<ASS_ATTRIBUTE33/>

<ASS_ATTRIBUTE34/>

<ASS_ATTRIBUTE35/>

<ASS_ATTRIBUTE36/>

<ASS_ATTRIBUTE37/>

<ASS_ATTRIBUTE38/>

<ASS_ATTRIBUTE39/>

<ASS_ATTRIBUTE40/>

<ASS_ATTRIBUTE41/>

<ASS_ATTRIBUTE42/>

<ASS_ATTRIBUTE43/>

<ASS_ATTRIBUTE44/>

<ASS_ATTRIBUTE45/>

<ASS_ATTRIBUTE46/>

<ASS_ATTRIBUTE47/>

<ASS_ATTRIBUTE48/>

<ASS_ATTRIBUTE49/>

<ASS_ATTRIBUTE50/>

<ASS_ATTRIBUTE_NUMBER1/>

<ASS_ATTRIBUTE_NUMBER2/>

<ASS_ATTRIBUTE_NUMBER3/>

<ASS_ATTRIBUTE_NUMBER4/>

<ASS_ATTRIBUTE_NUMBER5/>

<ASS_ATTRIBUTE_NUMBER6/>

<ASS_ATTRIBUTE_NUMBER7/>

<ASS_ATTRIBUTE_NUMBER8/>

<ASS_ATTRIBUTE_NUMBER9/>

<ASS_ATTRIBUTE_NUMBER10/>

<ASS_ATTRIBUTE_NUMBER11/>

<ASS_ATTRIBUTE_NUMBER12/>

<ASS_ATTRIBUTE_NUMBER13/>

<ASS_ATTRIBUTE_NUMBER14/>

<ASS_ATTRIBUTE_NUMBER15/>

<ASS_ATTRIBUTE_NUMBER16/>

<ASS_ATTRIBUTE_NUMBER17/>

<ASS_ATTRIBUTE_NUMBER18/>

<ASS_ATTRIBUTE_NUMBER19/>

<ASS_ATTRIBUTE_NUMBER20/>

<ASS_ATTRIBUTE_CATEGORY/>

<ASSIGNMENT_ID>300000048185689</ASSIGNMENT_ID>

</ASSIGNMENT_FLEX_FIELDS>

</ASSIGNMENT>


-<OFFER_RECIPIENT>

<DISPLAY_NAME>Andew Cota</DISPLAY_NAME>

<PERSONAL_EMAIL_ADDRESS>shivamkumar07+12@gmail.com</PERSONAL_EMAIL_ADDRESS>

<WORK_EMAIL_ADDRESS/>

<WORK_PHONE_NUMBER/>

<PERSONAL_PHONE_NUMBER/>

<HOME_ADDRESS/>

<CANDIDATE_TYPE>ORA_EXTERNAL_CANDIDATE</CANDIDATE_TYPE>

<PERSON_NUMBER/>

<OFFER_ID>300000048185676</OFFER_ID>

<RECIPIENT_FULL_NAME>Cota, Andew</RECIPIENT_FULL_NAME>

<RECIPIENT_FIRST_NAME>Andew</RECIPIENT_FIRST_NAME>

<RECIPIENT_LAST_NAME>Cota</RECIPIENT_LAST_NAME>

<RECIPIENT_INITIALS>AC</RECIPIENT_INITIALS>

<RECIPIENT_JOB_TITLE/>

</OFFER_RECIPIENT>


-<TEAM_MEMBER_HIRING_MANAGER>

<OFFER_ID>300000048185676</OFFER_ID>

<HIRING_MANAGER_FIRST_NAME>Amit</HIRING_MANAGER_FIRST_NAME>

<HIRING_MANAGER_LAST_NAME>Doshi</HIRING_MANAGER_LAST_NAME>

<HIRING_MANAGER_FULL_NAME>Amit Doshi</HIRING_MANAGER_FULL_NAME>

<HIRING_MANAGER_JOB_TITLE>Principal Solution Consultant</HIRING_MANAGER_JOB_TITLE>

<HIRING_MANAGER_WORK_EMAIL>test_AMIT.DOSHI@MAJESCO.COM</HIRING_MANAGER_WORK_EMAIL>

<HIRING_MANAGER_WORK_PHONE>1324</HIRING_MANAGER_WORK_PHONE>

<HIRING_MANAGER_INITIALS>AD</HIRING_MANAGER_INITIALS>

</TEAM_MEMBER_HIRING_MANAGER>


-<TEAM_MEMBER_RECRUITER>

<OFFER_ID>300000048185676</OFFER_ID>

<RECRUITER_FIRST_NAME>Akhilesh</RECRUITER_FIRST_NAME>

<RECRUITER_LAST_NAME>Tandel</RECRUITER_LAST_NAME>

<RECRUITER_FULL_NAME>Akhilesh Tandel</RECRUITER_FULL_NAME>

<RECRUITER_JOB_TITLE>VP, Strategy and Solutions</RECRUITER_JOB_TITLE>

<RECRUITER_WORK_EMAIL>test_AKHILESH.TANDEL@MAJESCO.COM</RECRUITER_WORK_EMAIL>

<RECRUITER_WORK_PHONE>1612</RECRUITER_WORK_PHONE>

<RECRUITER_INITIALS>AT</RECRUITER_INITIALS>

</TEAM_MEMBER_RECRUITER>


-<TEAM_MEMBER_COLLABORATORS>

<OFFER_ID>300000048185676</OFFER_ID>

<COLLABORATOR_FIRST_NAME>Amit</COLLABORATOR_FIRST_NAME>

<COLLABORATOR_LAST_NAME>Kumar</COLLABORATOR_LAST_NAME>

<COLLABORATOR_FULL_NAME>Amit Kumar</COLLABORATOR_FULL_NAME>

<COLLABORATOR_JOB_TITLE/>

<COLLABORATOR_WORK_EMAIL>shbahadur@deloitte.com</COLLABORATOR_WORK_EMAIL>

<COLLABORATOR_WORK_PHONE>1355</COLLABORATOR_WORK_PHONE>

<COLLABORATOR_INITIALS>AK</COLLABORATOR_INITIALS>

</TEAM_MEMBER_COLLABORATORS>


-<REQUISITION_DETAILS>

<REQUISITION_TITLE>USI Solution Consultant</REQUISITION_TITLE>

<REQUISITION_NUMBER>171</REQUISITION_NUMBER>

<RECRUITING_TYPE>Professional</RECRUITING_TYPE>

<OTHER_TITLE/>

<OPENINGS>5</OPENINGS>

<NUMBER_HIRED/>

<OFFER_ID>300000048185676</OFFER_ID>

</REQUISITION_DETAILS>


-<OFFER_FLEX_FIELDS>

<ATTRIBUTE_TIMESTAMP1/>

<ATTRIBUTE_TIMESTAMP2/>

<ATTRIBUTE_TIMESTAMP3/>

<ATTRIBUTE_TIMESTAMP4/>

<ATTRIBUTE_TIMESTAMP5/>

<ATTRIBUTE_TIMESTAMP6/>

<ATTRIBUTE_TIMESTAMP7/>

<ATTRIBUTE_TIMESTAMP8/>

<ATTRIBUTE_TIMESTAMP9/>

<ATTRIBUTE_TIMESTAMP10/>

<ATTRIBUTE_DATE1/>

<ATTRIBUTE_DATE2/>

<ATTRIBUTE_DATE3/>

<ATTRIBUTE_DATE4/>

<ATTRIBUTE_DATE5/>

<ATTRIBUTE_DATE6/>

<ATTRIBUTE_DATE7/>

<ATTRIBUTE_DATE8/>

<ATTRIBUTE_DATE9/>

<ATTRIBUTE_DATE10/>

<ATTRIBUTE_NUMBER1/>

<ATTRIBUTE_NUMBER2/>

<ATTRIBUTE_NUMBER3/>

<ATTRIBUTE_NUMBER4/>

<ATTRIBUTE_NUMBER5/>

<ATTRIBUTE_NUMBER6/>

<ATTRIBUTE_NUMBER7/>

<ATTRIBUTE_NUMBER8/>

<ATTRIBUTE_NUMBER9/>

<ATTRIBUTE_NUMBER10/>

<ATTRIBUTE_NUMBER11/>

<ATTRIBUTE_NUMBER12/>

<ATTRIBUTE_NUMBER13/>

<ATTRIBUTE_NUMBER14/>

<ATTRIBUTE_NUMBER15/>

<ATTRIBUTE_NUMBER16/>

<ATTRIBUTE_NUMBER17/>

<ATTRIBUTE_NUMBER18/>

<ATTRIBUTE_NUMBER19/>

<ATTRIBUTE_NUMBER20/>

<ATTRIBUTE_CHAR1>Y</ATTRIBUTE_CHAR1>

<ATTRIBUTE_CHAR2>Office Location</ATTRIBUTE_CHAR2>

<ATTRIBUTE_CHAR3/>

<ATTRIBUTE_CHAR4>2000</ATTRIBUTE_CHAR4>

<ATTRIBUTE_CHAR5/>

<ATTRIBUTE_CHAR6>1000</ATTRIBUTE_CHAR6>

<ATTRIBUTE_CHAR7/>

<ATTRIBUTE_CHAR8/>

<ATTRIBUTE_CHAR9/>

<ATTRIBUTE_CHAR10/>

<ATTRIBUTE_CHAR11/>

<ATTRIBUTE_CHAR12/>

<ATTRIBUTE_CHAR13/>

<ATTRIBUTE_CHAR14/>

<ATTRIBUTE_CHAR15/>

<ATTRIBUTE_CHAR16/>

<ATTRIBUTE_CHAR17/>

<ATTRIBUTE_CHAR18/>

<ATTRIBUTE_CHAR19/>

<ATTRIBUTE_CHAR20/>

<ATTRIBUTE_CHAR21/>

<ATTRIBUTE_CHAR22/>

<ATTRIBUTE_CHAR23/>

<ATTRIBUTE_CHAR24/>

<ATTRIBUTE_CHAR25/>

<ATTRIBUTE_CHAR26/>

<ATTRIBUTE_CHAR27/>

<ATTRIBUTE_CHAR28/>

<ATTRIBUTE_CHAR29/>

<ATTRIBUTE_CHAR30/>

<ATTRIBUTE_CATEGORY/>

<OFFER_ID>300000048185676</OFFER_ID>

<ATTRIBUTE_NUMBER21/>

<ATTRIBUTE_NUMBER22/>

<ATTRIBUTE_NUMBER23/>

<ATTRIBUTE_NUMBER24/>

<ATTRIBUTE_NUMBER25/>

<ATTRIBUTE_NUMBER26/>

<ATTRIBUTE_NUMBER27/>

<ATTRIBUTE_NUMBER28/>

<ATTRIBUTE_NUMBER29/>

<ATTRIBUTE_NUMBER30/>

<ATTRIBUTE_CHAR31/>

<ATTRIBUTE_CHAR32/>

<ATTRIBUTE_CHAR33/>

<ATTRIBUTE_CHAR34/>

<ATTRIBUTE_CHAR35/>

<ATTRIBUTE_CHAR36/>

<ATTRIBUTE_CHAR37/>

<ATTRIBUTE_CHAR38/>

<ATTRIBUTE_CHAR39/>

<ATTRIBUTE_CHAR40/>

<ATTRIBUTE_CHAR41/>

<ATTRIBUTE_CHAR42/>

<ATTRIBUTE_CHAR43/>

<ATTRIBUTE_CHAR44/>

<ATTRIBUTE_CHAR45/>

<ATTRIBUTE_CHAR46/>

<ATTRIBUTE_CHAR47/>

<ATTRIBUTE_CHAR48/>

<ATTRIBUTE_CHAR49/>

<ATTRIBUTE_CHAR50/>

<ATTRIBUTE_CHAR51/>

<ATTRIBUTE_CHAR52/>

<ATTRIBUTE_CHAR53/>

<ATTRIBUTE_CHAR54/>

<ATTRIBUTE_CHAR55/>

<ATTRIBUTE_CHAR56/>

<ATTRIBUTE_CHAR57/>

<ATTRIBUTE_CHAR58/>

<ATTRIBUTE_CHAR59/>

<ATTRIBUTE_CHAR60/>

<ATTRIBUTE_CHAR61/>

<ATTRIBUTE_CHAR62/>

<ATTRIBUTE_CHAR63/>

<ATTRIBUTE_CHAR64/>

<ATTRIBUTE_CHAR65/>

<ATTRIBUTE_CHAR66/>

<ATTRIBUTE_CHAR67/>

<ATTRIBUTE_CHAR68/>

<ATTRIBUTE_CHAR69/>

<ATTRIBUTE_CHAR70/>

<ATTRIBUTE_CHAR71/>

<ATTRIBUTE_CHAR72/>

<ATTRIBUTE_CHAR73/>

<ATTRIBUTE_CHAR74/>

<ATTRIBUTE_CHAR75/>

<ATTRIBUTE_CHAR76/>

<ATTRIBUTE_CHAR77/>

<ATTRIBUTE_CHAR78/>

<ATTRIBUTE_CHAR79/>

<ATTRIBUTE_CHAR80/>

<ATTRIBUTE_CHAR81/>

<ATTRIBUTE_CHAR82/>

<ATTRIBUTE_CHAR83/>

<ATTRIBUTE_CHAR84/>

<ATTRIBUTE_CHAR85/>

<ATTRIBUTE_CHAR86/>

<ATTRIBUTE_CHAR87/>

<ATTRIBUTE_CHAR88/>

<ATTRIBUTE_CHAR89/>

<ATTRIBUTE_CHAR90/>

</OFFER_FLEX_FIELDS>

</OFFER_DETAILS>

</DATA_DS>

Now I want to do addition/SUM of all COMPONENT_AMOUNT where COMPONENT_NAME = ‘Basic Salary & HRA & Special Adhoc Allowance & Meal Allowance & Education Allowance & NPS Adhoc Pay & Adhoc Allowance & Monthly LTA’

Can any anyone please help me to understand how this can be achieved ?

Thanks,
Shivam

Design inputs for XML based java application

I have a java application which basically has to do 1 thing.
Read a large xml, extract information from it, and send the information to another system but in a different xml format.

Earlier we were using jaxb to convert it to a relational database and then use jaxb again to convert it to the desired xml, but given the increasing size of the XMLs, we have to implement a fragmented reading approach using a combination of sax parsing and jaxb so that the memory usage stays within the accepted limits.
But this has slowed down the application considerably. I know there are always tradeoffs, but could anyone please provide any design inputs on the below:

Would it make sense to

  • use something like an XML database instead of the relational one
  • store the xml as is and instead use apache Lucene or Solr to index it and make it searchable

Any other recommendations are welcome. Please let me know if any more information is needed.

magento2 – how to translate options value and xml fields?

I want to translate some words in my project but I can’t see why they didn’t get translated, even if i added them to the folder “i18n” some words was translated but those not

here is some word they can’t get translated :

$fieldsetCustomer = $form->addFieldset(
            'person_info',
            ('legend' => __('Age: '))
        );
 $this->options = (
            ('label' => '-', 'value' => ''),
            ('label' => 'Male', 'value' => 'male'),
            ('label' => 'Female', 'value' => 'Female'),

        );

Can someone tell why they can’t get translated please ?

uicomponent – Admin form not pulling through form values when turning collapsible to tabbed form using ui form xml

I overlooked this comment

The source node's value corresponds to a key in the data array returned by the MagentoFrameworkViewElementUiComponentDataProviderDataProviderInterface::getData method of your UI component.

From https://magento.stackexchange.com/a/219692/70343

Sure enough


    /**
     * Get data
     * @return array
     */
    public function getData()
    {
        if (isset($this->loadedData)) {
            return $this->loadedData;
        }
        $items = $this->collection->getItems();
        foreach ($items as $model) {
            $this->loadedData($model->getId()) = $model->getData();
            $this->loadedData($model->getId())('general') = $model->getData();  // key part
        }
        $data = $this->dataPersistor->get('xigen_announce_group');

        if (!empty($data)) {
            $model = $this->collection->getNewEmptyItem();
            $model->setData($data);
            $this->loadedData($model->getId()) = $model->getData();
            $this->loadedData($model->getId())('general') = $model->getData(); // key part
            $this->dataPersistor->clear('xigen_announce_group');
        }

        return $this->loadedData;
    }

Helped to look at this https://github.com/magento/magento2/blob/2.3/app/code/Magento/Customer/Model/Customer/DataProvider.php#L214-L252

I hope this helps someone. Might save them an hour.

xml – destroys the page layout

I am trying to extend MagentoBundleViewFrontendLayoutcatalog_product_view_type_bundle.xml with my own block class. i created viewlayoutcatalog_product_view_type_bundle.xml With:



    
        
            
        
    

The reference works, I can say for sure, but the page layout is only completely empty, except for the

The whole page looks like this:

The whole page looks like this:

soap – Magento2.3 – XML ​​errors in row 1 in column 7: XML declaration only allowed at the beginning of the document

When loading the SOAP URL of our Magento 2.3.5 store, the following error message is displayed:

This page contains the following errors:

error on line 1 at column 7: XML declaration allowed only at the start of the document
Below is a rendering of the page up to the first error.

How do I find the XML file that is causing this problem? Because this is not shown in the error message.