Question
MUFG
IN
Last activity: 10 Feb 2024 5:37 EST
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?
-
Reply
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
Updated: 10 Feb 2024 4:28 EST
Bits in Glass
IN
@GayathriV2026 great 👍. Please mark my solution as accepted.
Bits in Glass
IN
@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.
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
@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.
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
@GayathriV2026 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
@GayathriV2026 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
@GayathriV2026 great 👍. Please mark my solution as accepted.
Bits in Glass
IN
@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.