Hello All,
I have a XML generated and wanted to write the data in the xml format. But when I generate the document,
To explain my xml is in the below format
<Doc>
{data
<exp>
<exp1>
{data}
}
</Doc>
I have the attached the xml out and the template I'm using to generate the document. Can anyone guide where I have gone wrong since the data is written for each row .
I need to show only the data how it is generated in the XML file.
<ram> <ramId>549</ramId> <ami>2323231001</ami> <so></so> <shippingReferenceNumber>2323231001</shippingReferenceNumber> <loggedInUser>User</loggedInUser> <now>03/18/2022 09:18 PM</now> <sendingplant>West</sendingplant> <receivingplant>Services</receivingplant> <currentYear>2022</currentYear> <overpackUsed>Nil</overpackUsed> <exposureCheck>☐</exposureCheck> <totalNumberofPackages>Total 2 Packages</totalNumberofPackages> <totalWeightofPackages>Total 19.05108 kgs</totalWeightofPackages> <shippingDOT>✓</shippingDOT> <shippingIATA>☐</shippingIATA> <shippingICAO>☐</shippingICAO> <shippingIMDG>☐</shippingIMDG> <exceptedPkgDetails> <ID>106</ID> <RAM_ID>549</RAM_ID> <exceptedActivity> <id>159</id> <ram_Id>549</ram_Id> <expt_ID>106</expt_ID> <sourceInfo>10774843</sourceInfo> <nominalActivity>100.0000 (mCi)</nominalActivity> <equipmentNumber>10774843</equipmentNumber> <srNumber>AM9778</srNumber> <isotopValue>Am241Be</isotopValue> <superiorNumber>212345</superiorNumber> </exceptedActivity> <exceptedActivity> <id>160</id> <ram_Id>549</ram_Id> <expt_ID>106</expt_ID> <sourceInfo>10774846</sourceInfo> <nominalActivity>100.0000 (mCi)</nominalActivity> <equipmentNumber>10774846</equipmentNumber> <srNumber>AM9778</srNumber> <isotopValue>Am241Be</isotopValue> <superiorNumber>212345</superiorNumber> </exceptedActivity> <exposureValue>.005 (mSv/hr) </exposureValue> <exposureUnit></exposureUnit> <weight>9.525538 kgs</weight> <length>53.34</length> <width>53.34</width> <height>53.34</height> <security></security> <securityTape></securityTape> <securitySealNum>456789</securitySealNum> <ramUNNumber>UN2910</ramUNNumber> <properShippingName>Radioactive Material, Excepted Package, Limited Quantity of Material</properShippingName> <classValue>7, 9</classValue> <radiationLevel>Excepted Pkg.</radiationLevel> <erg>161</erg> <competentAuthorityCert>N/A</competentAuthorityCert> <materialDescription>RAM_Am241Be_100_ mCi_LWD_CTN_VERIFIER</materialDescription> <dimension>53.34 x 53.34 x 53.34 cms</dimension> <packageCount>1</packageCount> <activityci>0.0962 (Ci)</activityci> <calculatedGBq>3.55767 (GBq)</calculatedGBq> <packageType>Excepted Package</packageType> <showOverPack></showOverPack> </exceptedPkgDetails> <exceptedPkgDetails> <ID>105</ID> <RAM_ID>549</RAM_ID> <exceptedActivity> <id>156</id> <ram_Id>549</ram_Id> <expt_ID>105</expt_ID> <sourceInfo>10774848</sourceInfo> <nominalActivity>100.0000 (mCi)</nominalActivity> <equipmentNumber>10774848</equipmentNumber> <srNumber>AM9778</srNumber> <isotopValue>Am241Be</isotopValue> <superiorNumber>212345</superiorNumber> </exceptedActivity> <exceptedActivity> <id>157</id> <ram_Id>549</ram_Id> <expt_ID>105</expt_ID> <sourceInfo>10774842</sourceInfo> <nominalActivity>100.0000 (mCi)</nominalActivity> <equipmentNumber>10774842</equipmentNumber> <srNumber>AM9778</srNumber> <isotopValue>Am241Be</isotopValue> <superiorNumber>212345</superiorNumber> </exceptedActivity> <exceptedActivity> <id>158</id> <ram_Id>549</ram_Id> <expt_ID>105</expt_ID> <sourceInfo>10774844</sourceInfo> <nominalActivity>100.0000 (mCi)</nominalActivity> <equipmentNumber>10774844</equipmentNumber> <srNumber>AM9778</srNumber> <isotopValue>Am241Be</isotopValue> <superiorNumber>212345</superiorNumber> </exceptedActivity> <exposureValue>0.5 (mRem/hr) </exposureValue> <exposureUnit></exposureUnit> <weight>9.525538 kgs</weight> <length>53.34</length> <width>53.34</width> <height>53.34</height> <security></security> <securityTape></securityTape> <securitySealNum>123456</securitySealNum> <ramUNNumber>UN2910</ramUNNumber> <properShippingName>Material</properShippingName> <classValue>7, 9</classValue> <radiationLevel>Excepted Pkg.</radiationLevel> <erg>161</erg> <competentAuthorityCert>N/A</competentAuthorityCert> <materialDescription>VERIFIER</materialDescription> <dimension>53.34 x 53.34 x 53.34 cms</dimension> <packageCount>2</packageCount> <activityci>0.0962 (Ci)</activityci> <calculatedGBq>3.55767 (GBq)</calculatedGBq> <packageType>Excepted Package</packageType> <showOverPack></showOverPack> </exceptedPkgDetails> </ram>
0728.Template.docx
2323231001 (1).docx
Thanks
Discussion posts and replies are publicly visible
Any suggest how to get the data populated as per the XML.
Thanks in advance
I have got the format working, hence closing the thread.