* Dilemma how to Pull data from Outlook ...

[TonyU]

[tt]Hello VBA Gurus...

I have posted this question in the .ASP forum also but have yet to get a response and since it may have to do more with VBA I will also post it here. (I apologize in advance for posting in two different forums)

**********************************************************
Here's the scenario,
We have a scheduling systems created in .asp that is working great we adjusted it a bit a few months ago to pull some of the schedule tasks from out sytem to
insert into OutLook due to some management members like using outlooks capabilities etc...

here's a sample on how we insert data into outlook making them appointments etc...

http://www.l-e.com/tony/1.asp

Now the dilemma:
When the user(s) updates/changes their outlook entries to follow up with the appointment and or whatever, we need to somehow get these updates back
into our datase database...



Can anyone point me in the right direction on this? (Hope I'm making sense)

Thanks in advanced all
**********************************************************

T ® Ñ ¥
To keep a lamp burning we have to keep puting oil in it.

​

 

[venkman]

Hate to sound like a smart ass and not answer your question, but wouldn't an ldap server be a better solution for this? Your online system and exchange/outlook could use it.

Also, it might be helpful to post the code in you asp file. Giving a link to it only allows us to see the output, after it is processed server-side.

-Venkman

 

[TonyU]

[tt] Thanks for your response venkman

You don't sound like a smart ass at all, you're point is valid. I just don't know what you're talking about when you say "wouldn't an ldap server be a better solution for this"
(excuse my ignorance)


**************** Here's the file code *********************
BEGIN:VCALENDAR
PRODID:-//Microsoft Corporation//Outlook 10.0 MIMEDIR//EN
VERSION:1.0
BEGIN:VEVENT
DTSTART:20030311T210000Z
DTEND:20030311T220000Z
LOCATION;ENCODING=QUOTED-PRINTABLE:

http://communities2.microsoft.com/home/c=

hatroom.aspx?siteid=3D34000015
UID:040000008200E00074C5B7101A82E008000000009091C7A9D4D8C2010000000000000000100
0000081B86D3C07876F4F9DAEEA123190A977
DESCRIPTION;ENCODING=QUOTED-PRINTABLE:Join Microsoft experts in an online c=
hat:=0D=0A=0D=0AMicrosoft Systems Management Server 2.0: What Is New in Ser=
vice Pack 5=0D=0A=0D=0AJoin Microsoft experts in an online chat to discuss =
what=92s new in Service Pack 5. Service packs are a compilation of QFEs (fi=
xes) that have been released, and do not typically include new functionalit=
y. However, to improve the functionality of Systems Management Server (SMS)=
2.0, and to provide improved security and interoperability with both Windo=
ws .NET Server 2003 and SMS 2003, Service Pack 5 for SMS 2.0 does include s=
ome functionality changes. You must be aware of these changes to effectivel=
y support your SMS sites. You bring the questions & we will supply the answ=
ers.=0D=0A=0D=0AMarch 11, 2003=0D=0ATime: 1pm Pacific/4pm Eastern/21:00 GMT=
=0D=0A=0D=0AJoin the chat room on the day of the chat:

http://communities2.=

microsoft.com/home/chatroom.aspx?siteid=3D34000015=0D=0A=0D=0AOther IT Pro =
Chats:

http://www.microsoft.com/technet/treeview/default.asp?url=3D/technet=

/itcommunity/chats/Default.asp =0D=0A=0D=0A=0D=0A=0D=0A
SUMMARY;ENCODING=QUOTED-PRINTABLE:Microsoft online chat: Microsoft Systems =
Management Server 2.0: What Is New in Service Pack 5
PRIORITY:3
END:VEVENT
END:VCALENDAR
**************** Here's the file code *********************

T ® Ñ ¥
To keep a lamp burning we have to keep puting oil in it.

​

 

[venkman]

Hi Tony,

I was expecting ASP code... I'm not sure what you posted?

http://www.openldap.org

will provide you with some info on LDAP. LDAP is essentially an address book server (well, that's probably simplifying it a bit, but for our purposes it will do). It's basically a kind of very simple database for storing things that you would normally store in an address book. All email clients I know of (including outlook express and outlook) have the ability to connect to LDAP server to get contact info. It's probably a good long term goal to implement one, but I'm guessing there is a much simpler hack out ther to do what you want to do. I've never actually implemented one, so I'm not much help (I keep meaning to do it for my personal website, but laziness has gotten the better of me).
Anyways, if you had an ldap server, your current scheduling program and outlook could both connect to it for contact management. Thus this would centralize the information to one location that communicates with a universally accepted protocol.

-Venkman

 

[TonyU]

[tt]Thanks venkman, I appreciate your input, and will look into it...

T ® Ñ ¥
To keep a lamp burning we have to keep puting oil in it.

​