RE: extracted data to be sent t external email addresses

JDE User11

Active Member
RE: extracted data to be sent t external email addresses

You can easily create .csv files from a section in a UBE by selecting the
section and then going to the section menu to database output. In the box
that pops up select which type of file, name the file and then click next
and follow the wizard.
 
RE: extracted data to be sent t external email addresses

I'm interested in this topic too.
Hello list!

I try to send an email with the pdf attached, but the problem is to know the
file name. Is possible to kwnow the pdf file name geberated in a UBE before
this is show in the screen?

Anyone has try to?

Thank you!

Gilbert
OneWorld B7332 SP 11.3
Windows NT, AS400
 
RE: extracted data to be sent t external email addresses

Are you trying to send the email from UBE iteself. If
yes, how do you do that?
 
I too will be working on this matter soon.
But didn't try much I had a problem -If we try to send some pdf through external mailing system of jdedwards we don't have an attachment option .

Are you dealing with this in different way.


XE SP13
NT
ORACLE
 
RE: extracted data to be sent t external email addresses

The naming convention for a UBE is report name_version_UBE_Report ID_PDF.
In theory, you could use table I/O to pull back the version name from the
F983051, and I am sure that you could get the report ID in the same manner.
Therefore, being able to get the report pdf file name. Then use that
information to define which pdf to get.

Cheers
 
FWIW:

Another way is to create your email-message in code (in your UBE) and send that to your SMTP-server via C-code or custom-DLL (e.g. visual basic).
You can create e.g. HTML-code in this way too.

I don't think you can get the name of the PDF-file in the manner you described because there is also a kind of Process-ID in the name of the file. See the other messages in this forum about this problem.

Walter
 
Try taking a look at BSFN B0500190.

I've used this to send text only messages from a UBE. Haven't tried attachments yet.

Regards,

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 
Just tried sending attachments with B0500190. It works.

One gotcha though. Despite what function documentation says all arguments are required - even if all you pass is a "0" or blank.

The tough part still seems to be coming up with a routine that returns the name and location of the generated .pdf file, AND that works on either workstation or server.

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 
Larry,
Would you be so kind as to copy your returned value (running on workstation and on server too) here onto the Forum/List?

I am very curious to it and it is shorter way for me (us?) to know exactly the results instead of making my own experiments.
Attached ER lines, including explored BSFN call could be also very useful for me (us?).

Am I too lazy on Friday evening? ;-) (local time 19:25)

Thanks in advance (or TIA?),

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Zoltan,

sounds like you don't believe me <grin>.

Anyway attached is a word document with screen shots and code sample.
I've tested emailing attachments from both client and server - both work fine. We still have the problem of programmatically obtaining the .pdf file name and location though :(

Regards,


Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 

Attachments

  • 3-11142-EMailTest2.doc
    74.5 KB · Views: 114
Larry,
I am really very sorry and I am honestly ashamed of myself.
I missunderstood something in your previous reply and I have thought that you have resolved with success how to retrieve the name and location of the generated .pdf file. I was originaly curious to that.
Please Larry, excuse me. You know - my English (and my old hands <blush>).

At last but not least please, belive me that I believed you (as usually ;-)

Zoltán
P.S.: What is your opinion to ZIP the attachment before to put it onto the Forum. Maybe Eric will be greatful to us for to do so, sparing the storage on the server(s?) of the Forum.

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Zoltan please, I was only kidding also. I did not take you to really be doubting my word!

I to want someone to solve the puzzle of getting name/location of the .pdf files. We have the ability to email them if we just knew where they are!

Yes, I forgot to zip the attachment. Sorry :)

Best Regards,

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 
If you run your report on local form, you will find it in the path
where you have OW, for example C:\B7\DEMO\Printqueue, then you can
arrange icons by Date, the first one is the report you have already
run, the nomenclature is ReportName_VersionName_Number, this is the
file you can send by mail.

I hope it helps you.
Jazi

----- Mensaje Original -----
De: gezquerra <[email protected]>
Fecha: Jueves, Mayo 17, 2001 5:49 am
Asunto: RE: extracted data to be sent t external email addresses


--------------------------------------» » »
Consigue tu e-mail gratis en http://www.terra.com/mail/
Get your free e-mail account at http://www.terra.com/webmail/

Para el Dia de la Madre, ven a - http://www.terra.com/compras/
 
Jazi,

the thread is how to programmatically locate the the file name/path from within the generating UBE, not how to manually do it.

Thanks anyway though.

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 
RE: extracted data to be sent t external email addresses

Hello list!

Thanks for your help. Finally I can to extract data to send (in my case) by
email the purchase orders to suppliers.

If there are anyone interested:

1.- An UBE that calls a second UBE for each Purchase Order. (In my case)
2.- Second UBE with Page Header Section, Header Section and Detail Section.
3.- In each section I use Database Output to insert lines in a Fixed
Delimited File (convert the fields to strings before to insert in the text
file!)
4.- In the Header Section use the BSFN B0500190 to send the email with the
text file attached.
5.- Finally delete the text file (In my case I use the BSFN "Execute
External Program").

On this way, the 1st UBE call the 2nd for each purchase order, the 2nd UBE
create, populate, send and delete the text file.

I hope it should be useful.

Gilbert
OneWorld B7332 SP 11.3
AS400 /Win NT 4
 
Back
Top