Sending e-mail from D3 through the Linux server

This is a discussion on Sending e-mail from D3 through the Linux server within the Pick Database forums in Other Databases category; Ricky Ginsburg wrote: >Is there a way to have >a Linux server send e-mails from HTML files created in D3? Like this?: removepleaseNebula-RnD.com/products/mail.htm Nah! Impossible! FWIW, the reason I wrote NebulaMail is _exactly_ because of this situation. The Pick developer writes code and it works great for now. Then the user asks for HTML, then for embedded images, then for attachments, then for custom headers... If you don't want to develop and then re-develop, ask me about NebulaMail. Another thing to consider is that not all email clients accept email the same ...

Go Back   Database Forum > Other Databases > Pick Database

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
Reply
  LinkBack Thread Tools Display Modes
  #11  
Old 08-13-2008, 06:28 PM
Default Re: Sending e-mail from D3 through the Linux server [Ad alert]

"Ricky Ginsburg" wrote:
>Is there a way to have
>a Linux server send e-mails from HTML files created in D3?


Like this?:
removepleaseNebula-RnD.com/products/mail.htm

Nah! Impossible!

FWIW, the reason I wrote NebulaMail is _exactly_ because of this
situation. The Pick developer writes code and it works great for now.
Then the user asks for HTML, then for embedded images, then for
attachments, then for custom headers... If you don't want to develop
and then re-develop, ask me about NebulaMail.

Another thing to consider is that not all email clients accept email
the same way. After sending HTML emails many people decide they want
to embed images rather than linking to them. And some email clients
accept both HTML and text in the same package so that the client
software can read it regardless of how it was sent. If the email
isn't properly crafted the recipient gets the format they want but
then it looks like they have an attachment too, which is just the same
email in the other format. And yup, NebulaMail handles all of this
for you.

Now after all of that... As time permits I'm re-writing the
underpinnings of NebulaMail to include all of the features of
NebulaShip:
removepleaseNebula-RnD.com/products/ship.htm

The advantage is that a lot more features become available, including
many features unique to email clients vs sending agents like sendmail.
The difference (not a disadvantage, just different) is that NebulaMail
will now work like everything else from Nebula R&D, with the MV DBMS
sending data to a Windows middle-tier which then does all of the heavy
lifting.

Why make that shift? Well, many of you have or are going through this
now. Having ported products to SCO, Linux, AIX, HPUX, and other
platforms I've learned that hard-coding to a single platform for
immediate convenience does not translate to long-term convenience when
sites start to migrate. With NebulaMail and other offerings, the MV
software and all related BASIC code works exactly the same no matter
which DBMS or OS platform it's all running on.

HTH
T

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com

Reply With Quote
  #12  
Old 08-16-2008, 09:59 PM
Default Re: Sending e-mail from D3 through the Linux server

On Aug 9, 12:26*am, "Ricky Ginsburg" wrote:
:. However, several users at
: various sites are using Mac's for their workstations. > --
: Ricky Ginsburg

Ricky,

Just picking up on this point, I'm curious - are you using some form
of "telnet" client/TE on the Mac's? Assuming that the Mac's are
"recent", and your TE allows you to execute an OS X command, what is
wrong with using the in-built (to OS X) "mail" program --> should be a
fairly minimal change to your code from what I understand ?!!
Reply With Quote
  #13  
Old 08-17-2008, 08:03 AM
Default Re: Sending e-mail from D3 through the Linux server

"Ross Ferris" wrote in message
news:9e9d0c8f-afbf-4073-a51e-41565c139a0a-at-l33g2000pri.googlegroups.com...
On Aug 9, 12:26 am, "Ricky Ginsburg" wrote:
:. However, several users at
: various sites are using Mac's for their workstations. > --
: Ricky Ginsburg

Ricky,

Just picking up on this point, I'm curious - are you using some form
of "telnet" client/TE on the Mac's? Assuming that the Mac's are
"recent", and your TE allows you to execute an OS X command, what is
wrong with using the in-built (to OS X) "mail" program --> should be a
fairly minimal change to your code from what I understand ?!!

Ross - I asked the System Admin if he knew of any Mac programs that we could
run in place of Blat and he didn't have a clue. I'll pass this along to him.
But the real question is - How do you execute a Mac program from D3Linux?


Reply With Quote
  #14  
Old 08-17-2008, 06:00 PM
Default Re: Sending e-mail from D3 through the Linux server

Hi Ross,

From a linux point of view it is very easy to send out an email message,
there are a couple of options depending on what type of msgs want to be sent
out

1) Write out a txt file into a /tmp directory in the Linux Filesystem and
then execute the linux mail command
2) Same as step 1 but you can pipe it through sendmail which would allow you
to control what email address the msg is going to from within Pick

There are other commercial alternatives out there, but the above two would
cater for most situations. There are obviously the exceptions like if you
want to uuencode or send massive attachments then you need to look at a more
robust commercial solution.

Andrew

"Ross Ferris" wrote in message
news:9e9d0c8f-afbf-4073-a51e-41565c139a0a-at-l33g2000pri.googlegroups.com...
On Aug 9, 12:26 am, "Ricky Ginsburg" wrote:
:. However, several users at
: various sites are using Mac's for their workstations. > --
: Ricky Ginsburg

Ricky,

Just picking up on this point, I'm curious - are you using some form
of "telnet" client/TE on the Mac's? Assuming that the Mac's are
"recent", and your TE allows you to execute an OS X command, what is
wrong with using the in-built (to OS X) "mail" program --> should be a
fairly minimal change to your code from what I understand ?!!


Reply With Quote
  #15  
Old 08-17-2008, 07:54 PM
Default Re: Sending e-mail from D3 through the Linux server

Hi
10 years ago I interfaced Postie to Universe - it was exceptionally easy as
it has a straightforward command line interface that one can EXECUTE for
both Windows and Unix. A quick google shows that www.infradig.com is still
very active and $50 is well worth it.
Peter McMurray

"Ricky Ginsburg" wrote in message
news:g7hl2q$74v$1-at-aioe.org...
>I have been using Blat on the client side of all my systems (Windows
>workstations) to handle D3 e-mail processing. However, several users at
>various sites are using Mac's for their workstations. Is there a way to
>have a Linux server send e-mails from HTML files created in D3?
>
> D3Linux 7.4.0 running on RedHat 9.
>
> Thanks.
>
> --
> Ricky Ginsburg
>
> Have you seen Ricky's new website?
> http://www.fawnridge.com/ricky
>



Reply With Quote
  #16  
Old 08-18-2008, 04:09 PM
Default Re: Sending e-mail from D3 through the Linux server

"Ricky Ginsburg" wrote:
>But the real question is - How do you execute a Mac program from D3Linux?


Small, identical client/server components on both sides, written in
Mono (my preference) or Java. Example:

EXECUTE "!msg2remote machost execute thiscmd param1 param2..."


I have a supply of solutions - just waiting for a supply of demand.

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com

Reply With Quote
  #17  
Old 08-18-2008, 07:16 PM
Default Re: Sending e-mail from D3 through the Linux server

The only demands I have are sunny days and a clean beach towel.

--
Ricky Ginsburg

Have you seen Ricky's new website?
http://www.fawnridge.com/ricky
"Tony Gravagno" wrote in
message news:dihja496caelv05qht2s0p49so2ejmf441-at-4ax.com...
> "Ricky Ginsburg" wrote:
>>But the real question is - How do you execute a Mac program from D3Linux?

>
> Small, identical client/server components on both sides, written in
> Mono (my preference) or Java. Example:
>
> EXECUTE "!msg2remote machost execute thiscmd param1 param2..."
>
>
> I have a supply of solutions - just waiting for a supply of demand.
>
> Tony Gravagno
> Nebula Research and Development
> TG@ remove.pleaseNebula-RnD.com
>



Reply With Quote
  #18  
Old 08-18-2008, 07:48 PM
Default Re: Sending e-mail from D3 through the Linux server

On Aug 17, 3:54*pm, "Peter McMurray" wrote:
> Hi
> 10 years ago I interfaced Postie to Universe - it was exceptionally easy as
> it has a straightforward command line interface that one can EXECUTE for
> both Windows and Unix. *A quick google shows thatwww.infradig.comis still
> very active and $50 is well worth it.
> Peter McMurray


This has to be one the most asked questions on cdp. I googled "send
email from pick" in cdp and got 299 results.

Peter is right- Postie is the easiest and simplest way to do this. It
works with smtp servers, pop & imap accounts, handles attachments, and
can send and receive. You can download versions for windows/unix/
linux to try for free, but I hope you'll end up sending Andrew the $50
he deserves. Postie is flexible, cheap, bulletproof, and installed at
every site I administer.

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006
Reply With Quote
  #19  
Old 08-19-2008, 12:08 AM
Default Re: Sending e-mail from D3 through the Linux server

"Ricky Ginsburg" wrote in message
news:g8csbk$pkd$1-at-aioe.org...
> The only demands I have are sunny days and a clean beach towel.
>


And a hurricane-less tropical season each year...

GlenB


Reply With Quote
  #20  
Old 08-19-2008, 10:50 AM
Default Re: Sending e-mail from D3 through the Linux server


Here's how I do it:

#!/usr/bin/perl -w

use strict;
use MIME::Lite;
use Getopt::Std;

#------------------------------
# main
#------------------------------
sub main {
my %opts;

### Get options:
getopts('', \%opts) or die "usage error\n";
my $addr = $ARGV[0] || die "Missing email address.\n";
my $fpath = $ARGV[1] || die "Missing filename to attach.\n";
my $subj = $ARGV[2] || die "Missing Subject.\n";

my $msg = MIME::Lite->new(From => 'mailer-at-plygempw.com',
To => $addr,
Subject => $subj,
Type => "multipart/mixed");
$msg->attach(Type => "text/csv",
Path => $fpath,
Disposition => "attachment");

MIME::Lite->send("smtp","", Timeout=>60);
$msg->send;
}
exit(&main ? 0 : -1);
1;
__END__


This requires MIME::Lite and you can get that via CPAN. To send
other attachment types, just change the "text/csv" to whatever you need.
For example, PDF files would use "application/pdf".

I call this script via rule module in D3. A simple EXECUTE and it's done.

g.

Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 10:06 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.