Send CSV ouput by email to user and then delete the CSV

[susmitha]

Hi List,

My client has requested the following functionality

1. Send 'CSV' output by EMAIL to the user and then delete the CSV.
After searching list i found information about sending CSV to user but didn't find any information on deleting the CSV file.
Any help would be appreciated

Release : 9.1

 

[peterbruce]

susmitha,

If you can send the file, then you have acces to it. Below are 3 business functions that can be used to delete the file.

Function Name:; OpSysFileOperations
Souce Module: B0500180
Description: Operating System File Operations Delete, Rename, File Exists

Function Name:; ExecuteExternalProgram
Souce Module: B34A1030
Description: Execute External Program

Function Name:; DeleteOrCopyFlatFile
Souce Module: B4700230
Description: Delete Or Copy Flat File

 

[Gabe]

Hello,

I just noticed you were talking about csv attachments sent using JDE? Would you tell me how do you do that? I'm trying to send csv attachments using BF B0500725 and it really sends but the attachments contains "printer code" and not a real attachemnt! It works fine when a PDF is sent?
Best regards,
Gabe.

 

[veni vidi vici]

Hi PeterBruce,

I'm doing a UBE that send email to the AN8 you pass him like lot's of person on the List.

Everything is good until a user asked me to send them CSV.

I believe your B34A1030 is the solution, but i don't know how to format the command line (i have no knowledge of the deep JDE process).

In P986110B the View CSV button call a run executable starting with : /servlet/com.jdedwards.jas.ube?

Would you know if i can use the same process?

thank you