Avatar of rackpeople
rackpeople
 asked on

Is it possible to update exchange calendar, from csv file ?

We need to create calendar appointments, several times a day, data can be formatted as desired, csv, excel, txt, xml. But how do we get them into an outlook calendar, could be public folder, or could be specific user, makes no difference.
'We have looked into the export/ import feature in outlook, and i solves the basic funktion, but is manual !!
Exchange

Avatar of undefined
Last Comment
rackpeople

8/22/2022 - Mon
crokeefe28

crokeefe28

sorry...i misread your requirement
Brum07

How about importing via a vbscript as here;

http://www.outlookcode.com/codedetail.aspx?id=1436

set the VBscript to grab the csv from a shared location that everyone has access to and set a scheduled task to import when required.

Regards
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
crokeefe28

After doing a little reasearch, this can be done, but it depends on how crafty you are with WEBDAV or VB.NET.  What version of Exchange are you running?
rackpeople

ASKER
exh 2007 .. and NOT very crafty with webdav... ca do a small bit of vn though :)
rackpeople

ASKER
vb that is
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
rackpeople

ASKER
but it looks doable, do you know if i can add more fields to the code, ex. category end date etc. ?
ASKER CERTIFIED SOLUTION
crokeefe28

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
rackpeople

ASKER
only pointed in the right direction