File Layout

File layout

Hi,

I have to import data from a csv file which contains the header as a date. And the body contains the details of the transactions.The footer contains the count of the number of rows processed in transaction. I have to load the header in Table 1 and validate whether the date matches with the system date .And the transactions data in a separate table 2 and the footer into the table 3 and have to validate whether the total count of the transactions matches with the footer . Please help me out.

Read XML data into PS record using File Layout/App Engine Peoplecode

Hi,

I am reading an XML file using a file layout

I need to insert the data coming in this file into a PS staging record, the tag structure in the XML file has been mapped to the file layout which uses this staging record. However, I fail to understand how to proceed for fetching the data and inserting using App Engine peoplecode. In case of a CSV file, we split the data and pass it into an array for processing, but I am not really sure on what needs to be done on this case, any inputs on this would be of great help

Thanks,
Dan