Solved

Import XML into Outlook 2003/2007

Posted on 2009-05-19
12
1,616 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
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

685 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