Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Import XML into Outlook 2003/2007

Posted on 2009-05-19
12
Medium Priority
?
1,756 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
Industry Leaders: 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 2000 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

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!

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
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: …
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…

660 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