Without creating the case ,How can we Read the excel/csv attachments from email (email listener) and save the value in Data table?
@GayathriV2026 please check if this discussion helps you. You will have csv results in clipboard, you just need to save that data to clipboard using savable data page.
@Anoop Krishna Thank you. If you have any working code , kindly provide it will be very useful for me
@GayathriV2026 you can try the steps mentioned in the above url. Get the stream and pass the stream to the pxparseexcelfile activity. Please follow the screenshots.
@Anoop Krishna
Getting (Code-Pega-List)pzUnrecognizedFileTemplate CustomerFile message in Tracer.
Kindy Let me know anything wrong, I did exactly same in the link.
What input i need to give in FSFileName
Activity
:Tracer:
BinaryFile
@GayathriV2026 okay, in the attachment page you will be having the attachment name. Try passing that to fsfilename.
@GayathriV2026 great
. Please mark my solution as accepted.
@Gayathri Venkatesan , Could you please let us know how to achieve this ..
@Anoop Krishna Yes i passed the attachment name in the fsfilename, still showing the same error
@GayathriV2026 I think it is looking for file in service export directory. Need to check.
@Anoop Krishna This is achieved by moving the attachment from the mail to service export directory folder by using java code
@GayathriV2026 thanks for accepting , it would be great if you can post the screenshot of the additional step you have implemented with the java code, it will be helpful to others.
@Anoop Krishna
Can you please paste the java code for moving the attachment to service email directory


