Solved

Import XML into Outlook 2003/2007

Posted on 2009-05-19
12
1,682 Views
Last Modified: 2012-05-07
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.
0
Comment
Question by:mikeg1265
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
12 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 24439819
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
 

Author Comment

by:mikeg1265
ID: 24440001
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
 
LVL 76

Expert Comment

by:David Lee
ID: 24442397
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Author Comment

by:mikeg1265
ID: 24453078
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
 
LVL 76

Expert Comment

by:David Lee
ID: 24454486
Please post the XML file.
0
 

Author Comment

by:mikeg1265
ID: 24457478
Here it is.  You'll have to change it back to .XML
Events.txt
0
 
LVL 76

Expert Comment

by:David Lee
ID: 24468136
I looked at the file and I can do this.  What do you want to do with the ProgramType, EventUserName, and EventDepartment columns?
0
 

Author Comment

by:mikeg1265
ID: 24471773
I am going to meet with the client Wednesday morning, I'll be in touch, and thanks.
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 24471813
Ok.  I'll wait to hear from you.  
0
 

Author Closing Comment

by:mikeg1265
ID: 31582992
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
 
LVL 76

Expert Comment

by:David Lee
ID: 24487764
You're welcome.  No worries.  Answering questions is why I'm here.  Cheers!
0
 

Expert Comment

by:SSI_Admin
ID: 24551580
So what was the solution?
0

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question