Class Declaration:
class CustomerExportXML
{
}
Main Method:
public static void main(Args _args)
{
XmlDocument doc;
XmlElement nodexml;
XmlElement nodeTable;
XmlElement nodeAccountNum;
XmlElement nodeCustGroupId;
XmlElement nodeName;
CustTable custTable;
DirPartyTable dirPartyTable;
DirParty dirParty;
MethodInfo methodInfo;
#define.filename(@'D:\Temp\TestXML.xml')
doc = XmlDocument::newBlank();
nodexml = doc.createElement('xml');
doc.appendChild(nodexml);
while select party, AccountNum, CustGroup from custTable join dirPartyTable
//where custTable.party == DirPartyTable.RecId
{
nodeTable = doc.createElement(tableStr(CustTable));
nodeTable.setAttribute(fieldStr(CustTable, RecId),int642str(custTable.RecId));
nodexml.appendChild(nodeTable);
nodeAccountNum = doc.createElement(fieldStr(CustTable, AccountNum));
nodeAccountNum.appendChild(doc.createTextNode(custTable.AccountNum));
nodeTable.appendChild(nodeAccountNum);
nodeCustGroupId = doc.createElement(fieldStr(CustTable, CustGroup));
nodeCustGroupId.appendChild(doc.createTextNode(custTable.CustGroup));
nodeTable.appendChild(nodeCustGroupId);
Commented Line Starts
//nodeName = doc.createElement(fieldStr(dirPartyTable, Name));
//nodeName.appendChild(doc.createTextNode(custTable.name()));
//nodeTable.appendChild(nodeName);
Commented Line Ends
nodeName = doc.createElement("Name");
nodeName.appendChild(doc.createTextNode(CustTable.name()));
nodeTable.appendChild(nodeName);
}
doc.save(#filename);
info(strFmt("File %1 created.", #filename));
}
class CustomerExportXML
{
}
Main Method:
public static void main(Args _args)
{
XmlDocument doc;
XmlElement nodexml;
XmlElement nodeTable;
XmlElement nodeAccountNum;
XmlElement nodeCustGroupId;
XmlElement nodeName;
CustTable custTable;
DirPartyTable dirPartyTable;
DirParty dirParty;
MethodInfo methodInfo;
#define.filename(@'D:\Temp\TestXML.xml')
doc = XmlDocument::newBlank();
nodexml = doc.createElement('xml');
doc.appendChild(nodexml);
while select party, AccountNum, CustGroup from custTable join dirPartyTable
//where custTable.party == DirPartyTable.RecId
{
nodeTable = doc.createElement(tableStr(CustTable));
nodeTable.setAttribute(fieldStr(CustTable, RecId),int642str(custTable.RecId));
nodexml.appendChild(nodeTable);
nodeAccountNum = doc.createElement(fieldStr(CustTable, AccountNum));
nodeAccountNum.appendChild(doc.createTextNode(custTable.AccountNum));
nodeTable.appendChild(nodeAccountNum);
nodeCustGroupId = doc.createElement(fieldStr(CustTable, CustGroup));
nodeCustGroupId.appendChild(doc.createTextNode(custTable.CustGroup));
nodeTable.appendChild(nodeCustGroupId);
Commented Line Starts
//nodeName = doc.createElement(fieldStr(dirPartyTable, Name));
//nodeName.appendChild(doc.createTextNode(custTable.name()));
//nodeTable.appendChild(nodeName);
Commented Line Ends
nodeName = doc.createElement("Name");
nodeName.appendChild(doc.createTextNode(CustTable.name()));
nodeTable.appendChild(nodeName);
}
doc.save(#filename);
info(strFmt("File %1 created.", #filename));
}