Pagegate v4 exported messages

[FTesterman]

I exported messages from PGAdmin trying to debug a report of critical pages not sent. After pulling into a spreadsheet and locating the date, I'm trying to figure out descriptions for each column.

After the Sending email address are two columns with values #TRUE# OR #FALSE# in each. The next column contains Recipient/Message ID related stuff followed by another column containing #TRUE# OR #FALSE# values.

If I can find out the meaning of each of these three columns I can probably determine what happened to the pages.

Thanks,
Fred T.

[Tech Support]

Here is the explanation of the messages table and what fields need to be configured:

user: Enter the recipient name of the person to be contacted.
pin: ""
message: Enter the message to be sent to the recipient.
carrier: ""
date_time_req: Enter the current date/time in this format 5/22/2007 1:47:52 PM
date_time_sent: ""
frm: Enter the Sender's Name here
sent: False
error: False
ascii_file: ""
mail_file: ""
lock: False
scheduled: False
reliapage_index: False
repeat_interval: 0
repeat_stop: Set this to the same value as date_time_req.
station: Set this field to 0.
message_id: ""
retries: 0
last_try: Set this field to 30 seconds prior to the date_time_req field.
transaction: ""
dialer: ""

Note: "" means write a blank string to the field. If you leave the field completely blank, the Jet Engine Database will interpret it as a #NULL# value, which completely throws our program for a loop.

[Tech Support]

I forgot to mention when I made the last post, that's what you would enter if you were entering in a line to the messages table manually but it also explains what each field is and what relative values each field should have.

Note: If a message is sent, the Sent field will be true instead of false. If there was an error while sending the message, Error will be True instead of False.

[FTesterman]

Great! That is exactly what I needed. No way I would enter anything into the database manually :-)