Solved

Import XML into Outlook 2003/2007

Posted on 2009-05-19
12
1,575 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
Find out what you should include to make the best professional email signature for your organization.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

772 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