How can we Read the excel/csv attachments from email (email listener) and save the value in Data table?

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.

https://support.pega.com/discussion/reading-excel-sheet-attached-email-using-email-listener-and-copy-data-clipboard

@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 :+1:. 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