Question
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?
Accepted Solution
@Gayathri Venkatesan great 👍. Please mark my solution as accepted.
@Gayathri Venkatesan 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
@Gayathri Venkatesanyou can try the steps mentioned in the above url. Get the stream and pass the stream to the pxparseexcelfile activity. Please follow the screenshots.
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
@Gayathri Venkatesan okay, in the attachment page you will be having the attachment name. Try passing that to fsfilename.
@Anoop Krishna Yes i passed the attachment name in the fsfilename, still showing the same error
@Gayathri Venkatesan 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
Accepted Solution
@Gayathri Venkatesan great 👍. Please mark my solution as accepted.
@Gayathri Venkatesan 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.
@Gayathri Venkatesan , Could you please let us know how to achieve this ..