Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to access Networked Emails
Message
From
28/01/2003 18:56:34
Michael Ouellette
Australian Technical Services (VIC) Pty
Australia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00743385
Message ID:
00746485
Views:
18
Sorry about the delayed response, I've been away.

Yes, that's the million dollar question eh? I would add an additional field
to the customer table with the customer email address
OR
Inform each client of their ID/account number and force them to give it to you in their email order each time. As a double check I'd make them give you their company name
EX:

Subject: Company: XYZ Company, ID: 12345

You can parse the subject line and split it into Company and ID. If both can be found in one record you have a match; otherwise you could reject the
email & print out a errors list automatically.

I suppose if it's always the same person ordering then the lookup could simply be their email address.

Personally, I'm a believer in making the customer shoulder as much of the responsibility as possible.

My system always has an email address, their name & business address.
I use a combination to determine if they are an existing customer or new.
The client set up the business rules.
I dump the whole message into a memo field and parse it for the info we require.

I hope this helps and is on time...
Previous
Reply
Map
View

Click here to load this message in the networking platform