Subject: PINE folder conversion to dbase?

From: [email-masked] (USAWORLD)
Date: 13 Jul 1995 11:07:26 -0400

I use PINE on a UNIX system (world.std.com). I would like to 
download a selected PINE mail folder (e.g. to-reply-later) to 
my DOS pc and then convert the folder to a dbase file. 

Presently I must use Delrina's "Internet Messenger" to direct 
dial (rather than telnet) world.std.com, then "Internet 
Messenger" downloads the messages to my pc and stores them in 
dbase III compatible files. Hence the conversion of mail 
folders to dbase files is technically possible. 

How can I convert a PINE mail folder to a dbase file without 
using "Internet Messenger" ?

Thanks in advance for your help. James Reese

---

From: [email-masked] (Kurt)
Date: Tue, 18 Jul 1995 13:56:32 GMT

>Thanks in advance for your help. James Reese

You can write a small program in dBASE to import the data from the
folders, and store that data into the dBASE file.  You would need to
find out exactly what structure is used in the dBASE file(s) you are
wanting to add records.

Kurt Risser

---

From: [email-masked] (USAWORLD)
Date: 18 Jul 1995 14:59:47 -0400

>Kurt Risser

I had previously used Foxpro to do that with mail log files on a VM/CMS
machine running RICE mail. The program was straightforward since RICE has
a marker line with the number of lines in each message.

Upon moving to a UNIX system, saving messages to a file using the simple
Unix "mail"  left no reasonable marker line to do the same. However, since
my message above, I discovered that Pine does not strip a marker line
between messages saved to a folder. The marker line doesn't have the total
number of lines of the message, so I'll start from there. 

If someone has already written a dbase prg for this, I'd appreciate it.
Presently, I use Foxpro and Access. 

Regards, James Reese

---

From: [email-masked] (USAWORLD)
Date: 19 Jul 1995 08:53:52 -0400

Here's the dbase file structure of Delrina's Internet Messenger (IM). IM
logs onto my UNIX account, reads the INBOX and PINE's read-messages
folder, and downloads them to dbase files. However, IM can only direct
dial the UNIX machine, and does not work with my PPP connection. What I
wind up doing is going online via PPP Telnet to the Unix, invoke PINE,
then once a day direct dial using IM to download the PINE folders to dbase
files. 

Since I can write only elementary dbase code, it's beyond me to write a
program which can duplicate what IM does. What would be nice is to have a
prg which could convert the PINE folders after they have been downloaded
to a pc.

Suggestions? James Reese

IM Dbase File Structure :
Field  Field Name  Type       Width
    1  ARRIVEDATE  Date           8
    2  ARRIVETIME  Character      6
    3  FROM        Character     70
    4  TO          Character     70
    5  OLD_TO      Character     30
    6  STATUS      Character      2
    7  DOCNUM      Character     14
    8  SUBJECT     Character     70
    9  DATA        Character      8
   10  NOTEBODY    Memo          10
   11  NEW         Character      1
   12  TYPE        Character      3
   13  FILE        Character     12
   14  CC          Character     70
   15  BCC         Character     70
   16  EDITOR      Character     12
   17  PRIORITY    Character      1
   18  PASSWORD    Character      8
   19  INSCRIPT    Character      8
   20  OUTSCRIPT   Character      8
   21  HOSTFILE    Character     17