Uploading cvs or xlsx format calendar meetings

Question

Level 1

21 points

Uploading cvs or xlsx format calendar meetings

I know there is a way to expheort a calendar in Outlook in CVS or XLXS format. The issue I am having is importing the file (Calendar) into iCloud's Calendar. It works as a hit and miss and I usually get this message: An error occurred while importing or exporting and the import/export was terminate. MAPI error 0X80040107 was reported. I need to be able to upload Calendar because I don't have the availability to synchronize my Calendar at work. I have done it and it work but I always get this message. The solution is to delete the iCloud calendar, wait about 1 hour to refreash and upload it again. Any help or anything I can use to ease up my madness? I really wish Apple had a way to upload a file directly to their iCloud page using a web import.

iPhone 5, iOS 6.0.1

Posted on Dec 14, 2012 6:37 PM

Reply

Answer 1

diesel vdub

Level 7

22,178 points

Dec 15, 2012 5:42 AM in response to esteban2800

Install iCloud Control Panel on the computer.

The control panel will act as the intermediary syncing the Outlook calendar to the iCloud calendar.

Reply

Answer 2

esteban2800 Author

Level 1

21 points

Dec 15, 2012 7:51 AM in response to diesel vdub

I have it already but nothing uploads and I can't even see my Outlook calendar on iTunes to sync it up. Perhaps this is an issue with Windows 8. I am going to try it on Windows 7 and have one calendar as a default calendar.

Reply

Answer 3

esteban2800 Author

Level 1

21 points

Dec 15, 2012 9:01 AM in response to esteban2800

Nope it does work even if I sync up with iCloud control panel. Not sure why, I even added it on iTunes and actually selected my local calendar with the manual sync. Then I created a bogus meeting on my local calendar, ran the iTunes sync, and waited over 10 minutes to see if my iCloud Calendar was updated. Nothing.

Reply

Answer 4

esteban2800 Author

Level 1

21 points

Dec 18, 2012 7:28 PM in response to esteban2800

The issue is with Windows 8. It works fine with Windows 7.

Reply

Answer 5

esteban2800 Author

Level 1

21 points

Dec 18, 2012 8:56 PM in response to diesel vdub

Below are step by steps to upload an Outlook calendar to iCloud:

1. Using Outlook 2010, click File, select Import
2. Select EXPORT to a file
3. Select Microsoft Excel 97-2003 or Comma Seperated Values (Windows)
4. Select the Calendar to export from (this is the source calendar)
5. Save the exported file as: Calendar.csv
6. Export "Appointments" from folder: Calendar
7. Export and create individual occurrences’ of appointments or tasks that occur between: range_date and range_date
8. The utility will export your file
9. Go back to File, Import, and NOW you will IMPORT the same file but now the DESTINATION will be iCloud
10. Select Import from another program or file
11. Select Microsoft Excel 97-2003 or Comma Separated Values (Windows)
12. Browse to the import file and select it
13. Now, you can only use "Allow duplicates to be created" because the other two selections (Replace duplicates with items imported and Do not import duplicates items) will give you an error. In fact, "do not import duplicate items does not do anything.
14. Click Next and now Select the iCloud Calendar
15. Click Next and your calendar will be uploaded to iCloud. This will create duplicates and you will need to delete your calendar constantly.

-------

Note: What I was proposing is to have an import utility directly into iCloud.com calendar's settings.

Reply

Answer 6

esteban2800 Author

Level 1

21 points

Sep 20, 2013 9:00 PM in response to esteban2800

Or switch to Google, they have master the art of uploading calendars!

Reply