Solved

Import XML into Outlook 2003/2007

Posted on 2009-05-19
12
1,518 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:mikeg1265
Comment Utility
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
Comment Utility
Please post the XML file.
0
 

Author Comment

by:mikeg1265
Comment Utility
Here it is.  You'll have to change it back to .XML
Events.txt
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 76

Expert Comment

by:David Lee
Comment Utility
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
Comment Utility
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
Comment Utility
Ok.  I'll wait to hear from you.  
0
 

Author Closing Comment

by:mikeg1265
Comment Utility
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
Comment Utility
You're welcome.  No worries.  Answering questions is why I'm here.  Cheers!
0
 

Expert Comment

by:SSI_Admin
Comment Utility
So what was the solution?
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

My experience with Windows 10 over a one year period and suggestions for smooth operation
If you don't know how to downgrade, my instructions below should be helpful.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
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: …

771 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now