Dear All, I am trying to spilt xml file, could see that "ATTEMPTED_INPUT_RECORD_COUNT:" 60211 is exhibited but we are not able to see any data in the database when we see through Query console. The sample xml file is as below . I am executing below command in command prompt to spilt xml and insert in database at port 8047 :
D:\mlcp-1.3-3-bin\mlcp-1.3-3\bin\call mlcp.bat import -host localhost -port 8047 -username admin -password admin -input_file_path D:\MiFID_POC_data\Sub_5_file_7.xml -input_file_type aggregates -aggregate_record_element Tx -output_uri_suffix .xml -aggregate_record_namespace "urn:iso:std:iso:20022:tech:xsd:DRAFT3auth.016.001.01" Here nested Tx element are occurring but we want to upload the first Tx element through mlcp fully as it is having full transaction information.Can someone please suggest how to achieve this through mlcp even nested Tx elemnts are there. <?xml version="1.0" encoding="UTF-8"?><!--Test data for MiFID II / MAR project.--><Document xmlns="urn:iso:std:iso:20022:tech:xsd:DRAFT3auth.016.001.01" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:iso:std:iso:20022:tech:xsd:DRAFT3auth.016.001.01 DRAFT3auth.016.001.01.xsd"><MIFIRTxRpt ><RptHdr><RptgPty><Agt>CFK3E8QWERTYUIOPLK12</Agt><Prsn><Id>KEFJFPEOPLE</Id><SchmeNm><Prtry>GHBEJPEOPLE</Prtry></SchmeNm><Issr>JISSUERS</Issr></Prsn></RptgPty><MIFIDInvstmtPty>true</MIFIDInvstmtPty><SubmitgPty><Agt>HCA3E8QWERTYUIOPLK12</Agt><Prsn><Id>CAJKJPEOPLE</Id><SchmeNm><Prtry>HDDBHPEOPLE</Prtry></SchmeNm><Issr>EISSUERS</Issr></Prsn></SubmitgPty></RptHdr><TxRpt> <Tx><ActnTp>NEWT</ActnTp><TxId>CGGHGBBCJCCJGGEGHBIBAACBBEFJAHDG823FBDEBG</TxId><RptgPty><Agt>EAA3E8QWERTYUIOPLK12</Agt><Prsn><Id>HAEAFPEOPLE</Id><SchmeNm><Prtry>CAEAGPEOPLE</Prtry></SchmeNm><Issr>FISSUERS</Issr></Prsn></RptgPty><MIFIDInvstmtPty>true</MIFIDInvstmtPty><SubmitgPty><Agt>DIA3E8QWERTYUIOPLK12</Agt><Prsn><Id>JKICAPEOPLE</Id><SchmeNm><Prtry>BAAJDPEOPLE</Prtry></SchmeNm><Issr>CISSUERS</Issr></Prsn></SubmitgPty><Buyr><OrgOrPrsn><Org><LEI>Z1MMP4OXN8FN36QI2W16</LEI></Org></OrgOrPrsn><CtryOfBrnch>UK</CtryOfBrnch></Buyr><BuyrDcsnMkr><Prsn><FrstNm>DCDFIRSTNAME</FrstNm><Nm>CBCSURNAME</Nm><BirthDt>1970-08-04</BirthDt><Id><Id>DCDCBCFIRSTNAMELASTNAMEIDSCHEME</Id><SchmeNm><Cd>EUID</Cd></SchmeNm><Issr>K Test issuer</Issr></Id></Prsn></BuyrDcsnMkr><Sellr><OrgOrPrsn><Prsn><FrstNm>AKHFIRSTNAME</FrstNm><Nm>JAISURNAME</Nm><BirthDt>1970-08-04</BirthDt><Id><Id>AKHJAIFIRSTNAMELASTNAMEIDSCHEME</Id><SchmeNm><Cd>EUID</Cd></SchmeNm><Issr>C Test issuer</Issr></Id></Prsn></OrgOrPrsn><CtryOfBrnch>UK</CtryOfBrnch></Sellr><SellrDcsnMkr><Prsn><FrstNm>AJHFIRSTNAME</FrstNm><Nm>GFDSURNAME</Nm><BirthDt>1970-08-04</BirthDt><Id><Id>AJHGFDFIRSTNAMELASTNAMEIDSCHEME</Id><SchmeNm><Cd>EUID</Cd></SchmeNm><Issr>I Test issuer</Issr></Id></Prsn></SellrDcsnMkr><OrdrTrnsmssnInd>true</OrdrTrnsmssnInd><Tx><TradDt><DtTm>2015-05-18T08:14:36.832</DtTm></TradDt><TradgCpcty>MTCH</TradgCpcty><Qty><Unit>859582</Unit></Qty><Pric><MntryVal Ccy="XPF">836131</MntryVal></Pric><PricMltplr>1000</PricMltplr><TradVn><Othr>XOFF</Othr></TradVn></Tx><FinInstrmId><Id><ISIN>IT0012199904</ISIN></Id><DlvryTp>CASH</DlvryTp></FinInstrmId><InvstmtDcsnPty><Id><Prsn><Id>KKADPEOPLE</Id></Prsn></Id></InvstmtDcsnPty><ExctgPty><Id><Prsn><Id>GKGBPEOPLE</Id></Prsn></Id></ExctgPty><AddtlAttrbts/></Tx> <Tx><ActnTp>NEWT</ActnTp><TxId>FKHDFADHAJDBGCFJHKECFBACKIEKBHCB824AKICJG</TxId><RptgPty><Agt>IJJ3E8QWERTYUIOPLK12</Agt><Prsn><Id>IGJCFPEOPLE</Id><SchmeNm><Prtry>DJJHBPEOPLE</Prtry></SchmeNm><Issr>BISSUERS</Issr></Prsn></RptgPty><MIFIDInvstmtPty>true</MIFIDInvstmtPty><SubmitgPty><Agt>HBB3E8QWERTYUIOPLK12</Agt><Prsn><Id>DDEAGPEOPLE</Id><SchmeNm><Prtry>KHFIEPEOPLE</Prtry></SchmeNm><Issr>GISSUERS</Issr></Prsn></SubmitgPty><Buyr><OrgOrPrsn><Org><MIC>NORX</MIC></Org></OrgOrPrsn><CtryOfBrnch>UK</CtryOfBrnch></Buyr><BuyrDcsnMkr><Prsn><FrstNm>GKFFIRSTNAME</FrstNm><Nm>IFISURNAME</Nm><BirthDt>1970-08-04</BirthDt><Id><Id>GKFIFIFIRSTNAMELASTNAMEIDSCHEME</Id><SchmeNm><Cd>EUID</Cd></SchmeNm><Issr>I Test issuer</Issr></Id></Prsn></BuyrDcsnMkr><Sellr><OrgOrPrsn><Prsn><FrstNm>HIJFIRSTNAME</FrstNm><Nm>GEHSURNAME</Nm><BirthDt>1970-08-04</BirthDt><Id><Id>HIJGEHFIRSTNAMELASTNAMEIDSCHEME</Id><SchmeNm><Cd>EUID</Cd></SchmeNm><Issr>H Test issuer</Issr></Id></Prsn></OrgOrPrsn><CtryOfBrnch>UK</CtryOfBrnch></Sellr><SellrDcsnMkr><Prsn><FrstNm>EKBFIRSTNAME</FrstNm><Nm>BADSURNAME</Nm><BirthDt>1970-08-04</BirthDt><Id><Id>EKBBADFIRSTNAMELASTNAMEIDSCHEME</Id><SchmeNm><Cd>EUID</Cd></SchmeNm><Issr>E Test issuer</Issr></Id></Prsn></SellrDcsnMkr><OrdrTrnsmssnInd>false</OrdrTrnsmssnInd><Tx><TradDt><DtTm>2015-05-16T08:42:31.213</DtTm></TradDt><TradgCpcty>MTCH</TradgCpcty><Qty><Unit>772043</Unit></Qty><Pric><MntryVal Ccy="JMD">394152</MntryVal></Pric><PricMltplr>590</PricMltplr><TradVn><Othr>XOFF</Othr></TradVn></Tx><FinInstrmId><Id><ISIN>DE000CR8WLS2</ISIN></Id><DlvryTp>CASH</DlvryTp></FinInstrmId><InvstmtDcsnPty><Id><Prsn><Id>HCCDPEOPLE</Id></Prsn></Id></InvstmtDcsnPty><ExctgPty><Id><Prsn><Id>DCEDPEOPLE</Id></Prsn></Id></ExctgPty><AddtlAttrbts/></Tx> <Tx><ActnTp>NEWT</ActnTp><TxId>CHEJCFKEFICGHIKGJHEIHDBBHEBJHDFK824BBKADK</TxId><RptgPty><Agt>CCJ3E8QWERTYUIOPLK12</Agt><Prsn><Id>GAKEGPEOPLE</Id><SchmeNm><Prtry>BFGAFPEOPLE</Prtry></SchmeNm><Issr>EISSUERS</Issr></Prsn></RptgPty><MIFIDInvstmtPty>true</MIFIDInvstmtPty><SubmitgPty><Agt>KJI3E8QWERTYUIOPLK12</Agt><Prsn><Id>HHJDAPEOPLE</Id><SchmeNm><Prtry>HABHAPEOPLE</Prtry></SchmeNm><Issr>IISSUERS</Issr></Prsn></SubmitgPty><Buyr><OrgOrPrsn><Org><LEI>ZX8OABUX9TYQCBNLUZ20</LEI></Org></OrgOrPrsn><CtryOfBrnch>UK</CtryOfBrnch></Buyr><BuyrDcsnMkr><Prsn><FrstNm>KBJFIRSTNAME</FrstNm><Nm>IFCSURNAME</Nm><BirthDt>1970-08-04</BirthDt><Id><Id>KBJIFCFIRSTNAMELASTNAMEIDSCHEME</Id><SchmeNm><Cd>EUID</Cd></SchmeNm><Issr>G Test issuer</Issr></Id></Prsn></BuyrDcsnMkr><Sellr><OrgOrPrsn><Org><MIC>XBAR</MIC></Org></OrgOrPrsn><CtryOfBrnch>UK</CtryOfBrnch></Sellr><SellrDcsnMkr><Prsn><FrstNm>HDBFIRSTNAME</FrstNm><Nm>IEBSURNAME</Nm><BirthDt>1970-08-04</BirthDt><Id><Id>HDBIEBFIRSTNAMELASTNAMEIDSCHEME</Id><SchmeNm><Cd>EUID</Cd></SchmeNm><Issr>E Test issuer</Issr></Id></Prsn></SellrDcsnMkr><OrdrTrnsmssnInd>true</OrdrTrnsmssnInd><Tx><TradDt><DtTm>2015-05-08T03:26:15.260</DtTm></TradDt><TradgCpcty>MTCH</TradgCpcty><Qty><MntryAmt Ccy="EUR">287338</MntryAmt></Qty><Pric><Pctg>0.5224</Pctg></Pric><PricMltplr>200</PricMltplr><TradVn><MIC>WETP</MIC></TradVn></Tx><FinInstrmId><Id><ISIN>DE000CR8TGA6</ISIN></Id><DlvryTp>CASH</DlvryTp></FinInstrmId><InvstmtDcsnPty><Id><Prsn><Id>ICJHPEOPLE</Id></Prsn></Id></InvstmtDcsnPty><ExctgPty><Id><Prsn><Id>AFGEPEOPLE</Id></Prsn></Id></ExctgPty><AddtlAttrbts/></Tx Thanks & Regards Vaibhaw Purwar DISCLAIMER The information transmitted, including any attachments, is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you receive this email by mistake, please advise the sender and delete it immediately. Email transmission cannot be guaranteed to be secure, or error free as information could be intercepted, corrupted, lost or destroyed as a result of the transmission process. Views or opinions presented in this email are solely those of the author and do not necessarily represent those of the Company. Through this e-mail, no employee or agent is authorized to conclude/commit any new or incidental terms, which are not part of the original contract with the client or vendor, other than by way of duly executed and signed amendment contract between the parties in accordance with the agreed protocol of the contract. Please be aware that the Company monitors e-mail communications through our networks for regulatory compliance purposes. NIIT Technologies Limited and its related entities consider the privacy of its clients to be of utmost importance and works to protect it. The Privacy Policy of the Company can be accessed from our website www.niit-tech.com.
_______________________________________________ General mailing list General@developer.marklogic.com Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general