Hi @jormantag, I believe File Layout only supports CSV format not .xls file If you want to export PeopleSoft data to .Xls format I would recommend to use BI Publisher report. Thanks, Siva
Hi Siva, using a chart of accounts as an example: If when a row is getting imported and has Account field = 123 AND DepartmentID field = 456 Then update the ProjectID field to 999999 for that row@@PeopleSoftChannel
Thank you for reaching out. Yes this is possible. You can create a separate step for inbound and outbound in your app engine program and include appropriate PeopleCode logic
Excellent for new learners
Thank you Srinivas for taking the time to share your feedback here. I really appreciate it.
Thanks,
Siva
Great. That shows greatness of Peoplesoft even in 2024.
I agree. PeopleSoft is still most flexible ERP software out there in the market.
Thanks,
Siva
wonderful explanation
I am glad to to hear my content was helpful to you 😊
Thanks for your teaching of PeopleSoft!
You're Welcome
Thanks bro.. eagerly waiting for next session
Thank you for letting me know. I am working on it.
Thanks,
Siva
@PeopleSoftChannel thank you for teaching. Excellent Video
Thank you for your encouraging words 😊. It means a lot to me.
Thanks,
Siva
What if the input file contains first 10 rows of data as empty and if the file is corrupted
Greetings Siva, how can this processing be implemented but with an .xlsl file?
Hi @jormantag,
I believe File Layout only supports CSV format not .xls file
If you want to export PeopleSoft data to .Xls format I would recommend to use BI Publisher report.
Thanks,
Siva
Excellent tutorial! Would you be able to demonstrate how and where in the code to modify a field during import?
Could you please elaborate on your question please?
Thanks,
Siva
Hi Siva, using a chart of accounts as an example: If when a row is getting imported and has Account field = 123 AND DepartmentID field = 456 Then update the ProjectID field to 999999 for that row@@PeopleSoftChannel
Can we use inbound and outbound in the same application engine ?
Thank you for reaching out. Yes this is possible. You can create a separate step for inbound and outbound in your app engine program and include appropriate PeopleCode logic