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
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Make use of createrowset and try writing the rowset data once its fetched..
Thanks,
Vamsi
Thanks,
Vamsi Krishna
Even I have no idea about this. I am confused coz when I am trying to load the data with XML file, it is not loading. The tag structure in the XML file has been mapped to the file layout, still I am unable to do.
Can you plz chk the properties of file layout...
Raj
I have multiple tags my xml suchas below:
Unknown
xxx
FIRST ID
9999
Mailing
XXXXXX
XXXXX
IL
XXXXX-XXXX
US
Unknown
YYYY-MM-DD HH:MM:SS
Batch
xxx
Other Information
MMDDYYHHMMSS
Mailing
XXXXXX
XXXXX
IL
XXXXX-XXXX
XX
FIRST ID
9999
SECOND ID
0000000888
I am trying to import the data from the above xml into psoft table. How should the xml file layout look like?Also the filelayout that i created does not populate.
Any help is greatly appreciated.
seems your XML input file might not well-formatted. Please validate XMl file throu xml formatter before processing in PS. Post formatting copy the xml, save .mll file. Put this file in PS server. Run the process. Hope all your rows from input file loaded successfully into staging table.
seems your XML input file might not well-formatted. Please validate XMl file throu xml formatter before processing in PS. Post formatting copy the xml, save .mll file. Put this file in PS server. Run the process. Hope all your rows from input file loaded successfully into staging table.
Sanga