Emaiiling from MvBase3

[Susan McCree]

I support a company that uses a Pick system (written in the 1980s and significantly modified since then) to run all their office functions.  They are currently on MvBase3 and do not want to upgrade to a different version of Pick.  They would like to be able to email invoices, purchase orders, etc. from their system.  

I'd like to hear from people who have done this before for MvBase3.  The company is considering hiring a contractor to set up this capability.

Susan McCree

susan...@outlook.com

[Jim Idle]

Write a record into a directory

Write a program in say Java or go that waits on changes in the directory using standard change notification

Use standard modem interfaces to send the email

Don’t try to write an email interface in MvBase. 

If mvbase can execute programs external to itself in Windows or Linux, just pipe the data to it. 

Jim

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
---
You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/mvdbms/2e7f1fc8-d524-4faa-bb4e-148348dad831n%40googlegroups.com.

[Jim Idle]

Modern not modem

[Steven Martin Trimble]

When I supported mvBASE, I handled outbound email by writing a .bat record to DOS based on the requirements of a really neat command line app called 'blat'. It is an email relay application. Once the .bat record is written, mvBASE would execute the .bat file and you are in business.

here is an example of the one line .bat file:

d:\blat\blat.exe d:\blat\MVBASE_FILESAVE1.TXT -u ste...@whosit.net -pw the$pswd -t "cd...@whosit.net" -s "File-Save IBM220 WinZip FTP 02-03-2014 submitted at 00:21:04" -f "ste...@whosit.net  " -i "CDMI <ste...@whosit.net  >" -o "IBM220 CDMI mvBASE Server" -noh2 -server smtp.att.yahoo.com > d:\blat\ERR17.TXT

The above command writes its results to the d:\blat\ERR17.TXT file, so you can READ that record and find out its results.

For Invoices, etc, I write the Invoice using an html template (including company logo), replace the contents with dynamic data, write the .html file, then use the app wkhtmltopdf, and attach the .pdf output using an email template, which uses blat.

Since those days, I only have 1 client still running Windows. All other clients use Linux.

My favorite flavor is Linux/openQM. just my 2 cents :)

CDMI

Steven Trimble

(501) 772-3450 cell/text

cdm...@gmail.com

--

[Bill H]

I do email simply by having the MV program substitute content into a text template. I initially create a 'Q' pointer to "C:\inetpub\mailroot\Pickup", e.g. (EMAILFILE). Then every email I write to the (EMAILFILE) and Windows sends it out immediately.  The Windows SMTP server (pre Windows Server 2022) is configured to only send out email from certain IP addresses, which usually forwards to your corporate outgoing email server.  So, the only thing I had to do in MV was write a single subroutine that read the email template, substituted the tags with the content, then write to the EMAILFILE.

[IZZI ZMAN]

If the application runs on Linux/Unix a very easy to use tool is "mpack". It might be core on Linux or easily available to be downloaded. Notice: you also need to have email running on the LInux box, sendmail or Postfix, etc...

It's also easy to include in any program and/or a Paragraph that can prompt for the variables. You can access via a SH command.

Example Syntax:

mpack --s "subject line of email" FILENAME.TXT email_...@xxxx.com

Regards,
Izzi

[Will Johnson]

Yes when I supported MvBase, the above methods, were exactly how we did it.

We first started by the write it to a directory, and then another process picks it up and sends it

We then went to the write it out and *launch* it method, which is at least more instant

[vasc...@gmail.com]

I wrote a couple years ago a program using VB and Visual Studio that sends emails via a SMTP Server, then executed inside Pick D3.

This worked several years with all the features that are available in a normal client email software like Outlook. Attachments (any kind), Bcc, High Importance and so on.

I can have a look and find it on request and available to help developing specific other tools.

 

Something that I have also developed was a reverse engineering for Pick d3 Data Basic Source Code using Windows and for Mentor ADDS machines (long ago).

I never though that some company working with Pick D3 could lose all the source code as in result of tape streamers damaged. It was around 3000 source code in a management app.

All 100% readable by programmers.

 

VSAIT Consultant

Mobile with WhatsApp: +44 7577870873

Email: vasc...@gmail.com

To view this discussion visit https://groups.google.com/d/msgid/mvdbms/e18ea1cc-4a9d-4a65-9aad-754425b168a4n%40googlegroups.com.