需要帮助在 XML 文件中插入子节点 [英] Need Help to Insert Child Node in XML FILE
问题描述
需要 PowerShell 中的帮助以更正 XML 文件.我想在这里插入的节点不是第一个孩子的 XML 文件.当前文件的结构 - 这是当前文件,我需要这方面的帮助
Need help in PowerShell to correct the XML file. The Node I want to insert here is not the first child of the XML file. Structure of Current File - This is the current file and I need help on this
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<Shipment xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" >
<ShipmentNumber>0012546776</ShipmentNumber>
<Container>Selleys/Yates</Container>
<Extnl_id/>
<AddressForwardingAgent>
<PartnerNumber>0000400260</PartnerNumber>
<LanguageKey>EN</LanguageKey>
<Name>TEST</Name>
<HouseandStreet>TEST1</HouseandStreet>
</AddressForwardingAgent>
<AddressSender>
<TransportPlanningPoint>4001</TransportPlanningPoint>
<LanguageKey>EN</LanguageKey>
<Name>TEST2</Name>
<HouseandStreet>TEST2</HouseandStreet>
</AddressSender>
<Consignment>
<ConsignmentNumber>0001</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>X</DangerousGoodsIndicator>
<GrossWeight>2005.268</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>3.856</TotalVolume>
<VolumeUOM>M3</VolumeUOM>
</ConsignmentHeader>
<ConsignmentNumber>0002</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>X</DangerousGoodsIndicator>
<GrossWeight>21.12</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>0.044</TotalVolume>
<VolumeUOM>M3</VolumeUOM>
</ConsignmentHeader>
<ConsignmentNumber>0003</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>Y</DangerousGoodsIndicator>
<GrossWeight>12.45</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>0.056</TotalVolume>
<VolumeUOM>P3</VolumeUOM>
</ConsignmentHeader>
</Consignment>
预期输出 - 我希望使用 PowerShell 在 XML 中实现这种结构.
Expected Output - This kind of structure I want in XML by using PowerShell.
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<Shipment xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" >
<ShipmentNumber>0012546776</ShipmentNumber>
<Container>Selleys/Yates</Container>
<Extnl_id/>
<AddressForwardingAgent>
<PartnerNumber>0000400260</PartnerNumber>
<LanguageKey>EN</LanguageKey>
<Name>TEST</Name>
<HouseandStreet>TEST1</HouseandStreet>
</AddressForwardingAgent>
<AddressSender>
<TransportPlanningPoint>4001</TransportPlanningPoint>
<LanguageKey>EN</LanguageKey>
<Name>TEST2</Name>
<HouseandStreet>TEST2</HouseandStreet>
</AddressSender>
<Consignment>
<ConsigmentLine> ## Need to insert this tag here
<ConsignmentNumber>0001</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>X</DangerousGoodsIndicator>
<GrossWeight>2005.268</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>3.856</TotalVolume>
<VolumeUOM>M3</VolumeUOM>
</ConsignmentHeader>
</ConsigmentLine>
<ConsigmentLine> ## Need to insert this tag here
<ConsignmentNumber>0002</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>X</DangerousGoodsIndicator>
<GrossWeight>21.12</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>0.044</TotalVolume>
<VolumeUOM>M3</VolumeUOM>
</ConsignmentHeader>
</ConsigmentLine>
<ConsigmentLine> ## Need to insert this tag here
<ConsignmentNumber>0003</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>Y</DangerousGoodsIndicator>
<GrossWeight>12.45</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>0.056</TotalVolume>
<VolumeUOM>P3</VolumeUOM>
</ConsignmentHeader>
</ConsigmentLine>
</Consignment>
推荐答案
您需要先捕获 'ConsignmentNumber' 和 'ConsignmentHeader' 节点,从 xml 中删除 'Consignment' 节点并重建它.
You need to capture the 'ConsignmentNumber' and 'ConsignmentHeader' nodes first, remove the 'Consignment' node from the xml and rebuild that.
对于演示,我使用的是 Here-String,但您可能需要使用 [xml]$xml = Get-Content -Path 'D:\MyCurrentXml.xml'<从文件中读取它/代码>
For demo, I'm using a Here-String, but you'd probably need to read it from file using [xml]$xml = Get-Content -Path 'D:\MyCurrentXml.xml'
[xml]$xml = @"
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<Shipment xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" >
<ShipmentNumber>0012546776</ShipmentNumber>
<Container>Selleys/Yates</Container>
<Extnl_id/>
<AddressForwardingAgent>
<PartnerNumber>0000400260</PartnerNumber>
<LanguageKey>EN</LanguageKey>
<Name>TEST</Name>
<HouseandStreet>TEST1</HouseandStreet>
</AddressForwardingAgent>
<AddressSender>
<TransportPlanningPoint>4001</TransportPlanningPoint>
<LanguageKey>EN</LanguageKey>
<Name>TEST2</Name>
<HouseandStreet>TEST2</HouseandStreet>
</AddressSender>
<Consignment>
<ConsignmentNumber>0001</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>X</DangerousGoodsIndicator>
<GrossWeight>2005.268</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>3.856</TotalVolume>
<VolumeUOM>M3</VolumeUOM>
</ConsignmentHeader>
<ConsignmentNumber>0002</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>X</DangerousGoodsIndicator>
<GrossWeight>21.12</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>0.044</TotalVolume>
<VolumeUOM>M3</VolumeUOM>
</ConsignmentHeader>
<ConsignmentNumber>0003</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>Y</DangerousGoodsIndicator>
<GrossWeight>12.45</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>0.056</TotalVolume>
<VolumeUOM>P3</VolumeUOM>
</ConsignmentHeader>
</Consignment>
</Shipment>
"@
要以您想要的方式重建它,这应该可行:
To rebuild this the way you want, this should work:
# capture two arrays of nodes for 'ConsignmentNumber' and 'ConsignmentHeader'
$numbers = $xml.Shipment.Consignment.ChildNodes | Where-Object { $_.LocalName -eq 'ConsignmentNumber' }
$headers = $xml.Shipment.Consignment.ChildNodes | Where-Object { $_.LocalName -eq 'ConsignmentHeader' }
# remove the entire 'Consignment' node from the xml
$xml.Shipment.RemoveChild($xml.Shipment.Consignment)
# and create a new 'Consignment' node
$newConsignment = $xml.CreateElement('Consignment')
# loop through the arrays, create a new 'ConsigmentLine' node and add the captured nodes to it
for ($i = 0; $i -lt $numbers.Count; $i++) {
$lineNode = $xml.CreateElement('ConsigmentLine')
$lineNode.AppendChild($numbers[$i])
$lineNode.AppendChild($headers[$i])
# append this to the newly created 'Consignment' node
$newConsignment.AppendChild($lineNode)
}
# finally, append the new 'Consignment' node to the 'Shipment' node
$xml.Shipment.AppendChild($newConsignment)
# and save the xml
$xml.Save('D:\MyCorrectedXml.xml')
结果:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Shipment xmlns:xsi="http://www.w3.org/2001/xmlschema-instance">
<ShipmentNumber>0012546776</ShipmentNumber>
<Container>Selleys/Yates</Container>
<Extnl_id />
<AddressForwardingAgent>
<PartnerNumber>0000400260</PartnerNumber>
<LanguageKey>EN</LanguageKey>
<Name>TEST</Name>
<HouseandStreet>TEST1</HouseandStreet>
</AddressForwardingAgent>
<AddressSender>
<TransportPlanningPoint>4001</TransportPlanningPoint>
<LanguageKey>EN</LanguageKey>
<Name>TEST2</Name>
<HouseandStreet>TEST2</HouseandStreet>
</AddressSender>
<Consignment>
<ConsigmentLine>
<ConsignmentNumber>0001</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>X</DangerousGoodsIndicator>
<GrossWeight>2005.268</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>3.856</TotalVolume>
<VolumeUOM>M3</VolumeUOM>
</ConsignmentHeader>
</ConsigmentLine>
<ConsigmentLine>
<ConsignmentNumber>0002</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>X</DangerousGoodsIndicator>
<GrossWeight>21.12</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>0.044</TotalVolume>
<VolumeUOM>M3</VolumeUOM>
</ConsignmentHeader>
</ConsigmentLine>
<ConsigmentLine>
<ConsignmentNumber>0003</ConsignmentNumber>
<ConsignmentHeader>
<DangerousGoodsIndicator>Y</DangerousGoodsIndicator>
<GrossWeight>12.45</GrossWeight>
<WeightUOM>KG</WeightUOM>
<TotalVolume>0.056</TotalVolume>
<VolumeUOM>P3</VolumeUOM>
</ConsignmentHeader>
</ConsigmentLine>
</Consignment>
</Shipment>
P.S.您的示例 xml 缺少最后的结束 </Shipment>
标记
这篇关于需要帮助在 XML 文件中插入子节点的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!