Create XML Files with the PeopleCode XMLDoc Object

Create XML Files using the XMLDoc Object in PeopleCode.
All objects and instructions are available at PeopleToolsTechTips.com
peopletoolstec...
Several tools in PeopleSoft use and XML file as a data source.
Prominent among these is the BI Publisher reporting tool.
We can use PeopleTools to quickly generate the data, enrich and shape it before sending it on to the receiving utility.
This video discusses the XMLDoc method of creating an XML File using PeopleTools and PeopleCode.
The process in brief:
1. Create and load a rowset
2. Enrich the data in that rowset
3. Instantiate the XMLDoc object
4. Load the XMLDoc with the rowset data
5. Extract the XML Using XMLDoc's GenFormattedXmlString() method
6. Write the file
Production Notes:
A PT3 Production
Presenter: Randall Groncki
Camera Kid: Anjelica Groncki
Music: Vlad Gluschenko - Overseas
License: CC BY 3.0: creativecommon...
/ @vladgluschenkomusic

[@PradeepKumar-gq3jd]

How to create multiple excel sheet using sqr i could be able to create multiple sheet for a single workbook using powershell script is it possible to accomplish using sqr

[@PeopleToolsTechTips]

I don't know that answer for SQR. I would move over to BI Pub with the Excel template. It has the multiple sheets for a workbook built in

[@PradeepKumar-gq3jd]

If possible please upload a video on inserting values from XML to a record thanks in advance 👍

[@PeopleToolsTechTips]

So your talking about receiving XML from either a file or an integration and putting that data into a table?

[@PradeepKumar-gq3jd]

@@PeopleToolsTechTips yes recieving xml either a file or integration and putting that into table