Question
MUFG
IN
Last activity: 25 Oct 2024 7:07 EDT
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
Updated: 10 Feb 2024 4:28 EST
Bits in Glass
IN
@Gayathri Venkatesan great 👍. Please mark my solution as accepted.
Bits in Glass
IN
@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.
MUFG
IN
@Anoop Krishna Thank you. If you have any working code , kindly provide it will be very useful for me
Bits in Glass
IN
@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.
MUFG
IN
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
Bits in Glass
IN
@Gayathri Venkatesan okay, in the attachment page you will be having the attachment name. Try passing that to fsfilename.
MUFG
IN
@Anoop Krishna Yes i passed the attachment name in the fsfilename, still showing the same error
Bits in Glass
IN
@Gayathri Venkatesan I think it is looking for file in service export directory. Need to check.
MUFG
IN
@Anoop Krishna This is achieved by moving the attachment from the mail to service export directory folder by using java code
Accepted Solution
Updated: 10 Feb 2024 4:28 EST
Bits in Glass
IN
@Gayathri Venkatesan great 👍. Please mark my solution as accepted.
Bits in Glass
IN
@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.
World Bank Group
IN
@Gayathri Venkatesan , Could you please let us know how to achieve this ..