Over 5 Minutes Creating an XML Export File with People. Soft. Part of MICAs web redesign project is going to involve doing data integration between our CMS Ingeniux, and our HRMS People. Soft.   Recently I have been playing with XML Publisher, and the flat files that it produces seem so perfect for distribution to our CMS. I was a little disappointed that the XML documents that XML Publisher creates are not exposed for use as an integration point between systems. So I began looking for other alternatives. Integration Broker seems to be quite the rage for the moment. After poking around with that, it seemed like a lot of work for what would ultimately be a flat file that is updated periodically when things like course descriptions, or degree plans changed. While this may be useful for more interactive or personalized content, it doesnt really fit the bill for static content. The simplest remember, this is People. Soft way I found to create an XML file similar to the one created by XML Publisher is using File Layouts in Application Designer. The rest of this article is about creating a simple File Layout. Simatic Manager S7 V5 5. There are 4 basic parts to creating a File Layout. Create or Select a Record for your data. I used a view, to avoid having to deal with joins in People. Code. Create a File Layout Definition. Create an Application Engine Program, with a tiny bit of code in it. Stuff all these things into a project so you can maintain your sanity at a later time. After you have selected the record with the data you want to export, create a new File Layout Definition File New Definition File Layout. On the definition tab, right click NEW FILE and select Insert Record. Search for the record you are using for your data, and double click it. The Record Definition, and its columns will show up under NEW FILE now. Save your File Layout Definition. Click the Property Icon, then click the Use tab, and select XML in the File Layout Format drop down. Click OK. Create a new Application Engine Program File New Application Engine Program. Right click Step. 3D Text S on this page. Insert Action.   Click where it says SQL, and select People. Code from the drop down. Double click the new action to edit the People. The CaseWhenExists expression in Oracle is really handy. Heres an example of how to use it in a subselect to return a status. This SQL checks for a match between. Code.   Copy and paste this People. Code into the window Local Record Rec Local File File Local SQL SQL File Get. Filec tempexportsample. Y/ThGfq2Tp3gI/AAAAAAAACd8/iAVVjL3UsaM/s1600/ae_section.jpg' alt='Peoplesoft App Engine Do When Example' title='Peoplesoft App Engine Do When Example' />W, File. PathAbsolute If File. Is. Open Then. If File. Set. File. LayoutFile. Layout. YOURFILELAYOUTDEFINITION Then Rec Create. RecordRecord. YOURRECORDDEFINITION SQL Create. SQLSelectall 1, Rec While SQL. Free Print To Pdf For Mac. Fetch Rec File. Write. Record Rec File. Write. Linelt YOURRECORDDEFINITION End While Else. Error File Layout Not Correct End If Else. Error file not open End If File. Close Save the above Peoplecode and close this window. Insert all these definitions into your project, and make sure you build it, creating any views and tables you may have created for your data. Click the Run Program Icon, and voila you have a XML file which can be used outside of People. Peoplesoft App Engine Do When Example' title='Peoplesoft App Engine Do When Example' />Soft View the File Layout XML Sample. SyQ0V9CLBk/TCnEI-kacNI/AAAAAAAAAEM/U-e4PFNndHQ/s1600/untitleddd.JPG' alt='Peoplesoft App Engine Do When Example' title='Peoplesoft App Engine Do When Example' />How to disable a PeopleSoft Workflow How to disable a particular PeopleSoft Workflow ActivityEvent This solution is applicable for PeopleTools version 8. What is the difference between encapsulation and datahiding. OOPS. Hi, instead of having a do select to retrieve your data, try eliminating that step and only use the peoplecode step to retrieve the data by using rowset to store the. MVA offers Certified Business Analysis Professional CBAP Training, CBAP Certification Training, CBAP Online Training, CBAP Online Course and eLearning Course. CBAP. GSA establishes the maximum CONUS Continental United States Per Diem rates for federal travel customers. Oracle acquired Sun Microsystems in 2010, and since that time Oracles hardware and software engineers have worked sidebyside to build fully integrated systems and.