Import XML into Outlook 2003/2007

Hello,

I have a customer who wants to import XML files that were converted from a different Calendar file into an Outlook shared calendar on an Exchange Server. Is that even possible? Any help in the right direction would be appreciated.
mikeg1265Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
David LeeConnect With a Mentor Commented:
Ok.  I'll wait to hear from you.  
0
 
David LeeCommented:
Hi, mikeq1265.

When you say "import" I assume you mean import them into the calendar as appointments.  If so, then it is possible, but only indirectly.  Outlook does not have the ability to import XML files directly.  You'd have to check into the possibility of converting the XML files into one of the formats that Outlook can handle.  If you're successful, then you could import the data once it's been converted.  Another alternative is to use scripting.  VBA and VBScript can both read XML and both can create appointments in Outlook.  
0
 
mikeg1265Author Commented:
Thanks, I can open the XML in Excel and everything look good. However, if I try to save the XLS file as a CSV and import it in Outlook there is nothing in the calendar. It's blank. I'll look into the VBS idea, I don't really have any experience with VB programming but I'll see what I can do.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
David LeeCommented:
When you do the import of the CSV file are you signed into the shared account?  If not, then the appointments are being added to your calendar.  

I might be able to help with the VB idea.  I'd need a sample of the XML file to work from.
0
 
mikeg1265Author Commented:
I try to import CSV file on the local machine into Outlook on the local machine with User Rights set to Everyone Full Control. I get a blank calendar. If you would like a sample I can send you the XML or the CSV files. Whatever your preference.

Regards,

Mike G.
0
 
David LeeCommented:
Please post the XML file.
0
 
mikeg1265Author Commented:
Here it is.  You'll have to change it back to .XML
Events.txt
0
 
David LeeCommented:
I looked at the file and I can do this.  What do you want to do with the ProgramType, EventUserName, and EventDepartment columns?
0
 
mikeg1265Author Commented:
I am going to meet with the client Wednesday morning, I'll be in touch, and thanks.
0
 
mikeg1265Author Commented:
I spoke to the supervisor responsible for making the decision to either convert or scrub. She has decided to scrub and use Outlook exclusively so no conversion is neccessary now. Thank you very much for looking into this. Sorry I wasted your time and I appreciate the input.
0
 
David LeeCommented:
You're welcome.  No worries.  Answering questions is why I'm here.  Cheers!
0
 
SSI_AdminCommented:
So what was the solution?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.