Re: Import and Insert data from email

"Simon Gare" <simon@xxxxxxxxxxxxx> wrote in message
news:#Snt4EobIHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
Ok here are the answers

I will assume plain text, could we read either plain or HTML from
different
clients?
No attachments
No cut and paste
Once in db journey is passed to mobile device for driver journey details
Consistent formula can be guaranteed

"formula" or "format"? How is it guaranteed?

Web form not an option
Yes the online form validates the address using Royal Mail paf file then
calculates the distance using MapPoint

What is a "Royal Mail paf file"?

The example you gave are not valid address:
Collection address = 20, HA1 3RT
Destination address = 333, W10 6RA
Thus, MapPoint couldn't map them.

All this because of 1 client who insists in sending email instead of
filling
our form.

What volume are you talking about? One email a day, a week?
Why not just enter their email data into your online form rather
than go to the effort to develop a custom solution which requires
testing, documentation, as well as maintenance?

Also can you clarify "Also, I asked for you to send me an email not post
it."

I was asking you to forward me one or two of the actual emails that you
would receive so I could identify additional questions or approaches.

Regards
Simon


"McKirahan" <News@xxxxxxxxxxxxx> wrote in message
news:uPqdnZqEyIdQzi7anZ2dnUVZ_qOknZ2d@xxxxxxxxxxxxxx
"Simon Gare" <simon@xxxxxxxxxxxxx> wrote in message
news:O6I3hznbIHA.5348@xxxxxxxxxxxxxxxxxxxxxxx
Well this is the question, but if we had a strict policy inplace and
description as to what format to lay it out in could we read from the
email
body line by line in an asp page where we could validate the address
and
insert into db?

The format I sent you before is a real email.

Please quote what you are replying to so others can follow the
conversation.

Validate what address -- Email, Collection, and /or Destination?


You still haven't answered each of my questions. Here they are again:

Q. Are the messages in plain text or HTML?
A. I presume "plain text"

Q. Would there be any attachments? If so, what type?
A. I presume "no attachements".

Q. What would the client effort be; would they be willing
to cut-and-paste a "Reply To" copy of the email into
a textarea?

Q. Once in the database how would they be used?

Q. Can a consistent format always be guaranteed?

Q. Would you send me an example of a real email?

Q. Could an Web form be used to generate the email?

Q. How would you handle missing data?

Q. Does the "online booking interface" insert records into a db?

Also, I asked for you to send me an email not post it.
Why, becuase they're different!


It would be a lot more helpful if:
a) you wouldn't top post (as I mentioned before)
b) you would insert your answers after my questions.



.

Relevant Pages

  • Re: Usenet image display
    ... Then, as others have posted, the problem is that you are set to read all messages in plain text, and the inline display cannot be shown since it uses richedit.dll to display the information in the preview pane. ... >I can not view attachments using O.E. 6 in newsgroups any longer. ... > I only want to view incomming messages in text, I never want to view> HTML ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: TNEF encoding
    ... HTML or Plain Text ... >> messages are being encoded in a Windows format called ... >> can not read the attachments. ...
    (microsoft.public.outlook.general)
  • Re: MSCONFIG Query
    ... A 1KB plain text message shows up as at least 2KB if in HTML. ... The OP's original post shows as 6KB in the size column in Outlook Express. ...
    (microsoft.public.windowsxp.general)
  • Printing attachments from HTML emails
    ... When printing from outlook messages, ... plain text then you can select the option to print ... attachments, unfortunately if the message is HTML then you ...
    (microsoft.public.outlook)
  • Re: Is Plain Text email 100% safe?
    ... There can be no virus in the body of a plain text email, but the attachments might still be infected, if they're in some format other than plain text. ... They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. ...
    (microsoft.public.security.virus)