Hi Reecha, I let this slip through the cracks after returning from London. Have you resolved the issue?
Tim > On Oct 26, 2015, at 3:34 AM, Reecha Bhandari <[email protected]> > wrote: > > Dear All, > > I made the change to the URI and executed the command and as expected the > “ATTEMPTED_INPUT_RECORD_COUNT” came as 5037 (highlighted) but cannot see any > fragmented XML in the database which I checked in the query console. Any > suggestion? > > > 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 -mode local > -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" > > > <image001.png> > > > Thanks, > Reecha > > From: Reecha Bhandari > Sent: Monday, October 26, 2015 10:54 AM > To: '[email protected]' <[email protected]> > Subject: Splitting XML files > > Dear All, > > I am trying to spilt xml file but could see that > “ATTEMPTED_INPUT_RECORD_COUNT:” 0 is exhibited . The sample xml file is as > below . > I am excuting 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 > -aggregate_uri_id id -output_uri_suffix .xml > -aggregate_record_namespace http://marklogic.com/examples > <http://marklogic.com/examples> > > Can someone please suggest as what is wrong in the excution . > > > <?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 > <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 > > <image002.png> > > > Thanks, > Reecha > > > > > > > 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 > [email protected] > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
