Like any other file, the basic logic to opening a file / writing data and then closing file is same even for XML file generation.
How can I learn the ins and outs of Peoplesoft? From what sites can I learn? Update Cancel. Adage in PeopleSoft/IT industry, you actually learn by the practical work. Thus, try to participate in as many project to gain the exposure. Try it for Free! 5 results for 'peoplesoft for dummies' Sort by: Sort. All customers get FREE Shipping on orders over $25 shipped by Amazon. Audible Download Audiobooks.
Of-course, the approach followed to implement these basic stuff will be slightly different. Here we need to make use of xml elements. So thoughtful of time needs to be spent on the design and layout of the XML file.
Approach to design XML file and implement the logic:
Once we are clear with the required information, we should next proceed to implementing the logic.
For instance, let's consider we need to generate XML file which has Address Details of an Employee.
Step 1 would be to first categorize elements. So here we can select Employee as outer element.
Step 2 would be to list out the data elements like here it is Address1,City,State,Country
Peoplesoft For Dummies Free Download For Windows 10
XML will have to look something like below.
Note, intentionally excluded the tag - < in the below example as the below structure auto-converts without tags when viewed online.
?xml version='1.0' encoding='Windows-1252'?>
Employee>
Address>
Address1>'Hitec City'/Address1>
City>'Hyderabad'/City>
State>'TS'/State>
Country>'India'/Country>
/Address>
Employee>
?xml version='1.0' encoding='Windows-1252'?>
Employee>
Address>
Address1>'Hitec City'/Address1>
City>'Hyderabad'/City>
State>'TS'/State>
Country>'India'/Country>
/Address>
Employee>
To implement the above logic in SQR, first you need to initialize xml tags.
Free Peoplesoft Training
let $xmlcntrl_end = '>'
let $xmltext_delim = ''
let $xmlcontent = '
etc..
Below is sample code to write content.
let $xmloutput_line = $xmlcntrl_begin || $xmltag || $xmlcntrl_end ||
$xmlcntrl_begin || $xmltag_end || $xmltag || $xmlcntrl_end
if we decode above statement it would resolve to something like.
<City>'Hyderabad'</City>
Note: if there are nested elements, ensure the tags are properly closed.
Once the data is written, we need to close XML file.
Free Dummies Books Download
Execution:
Peoplesoft For Dummies Oracle
Once the SQR is run , the file will be seen posted in the server path mentioned while opening the file.