How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Claws224 Your Own Question

Claws224
Claws224, IEEE Datacommunication Engineer
Category: Mac
Satisfied Customers: 5182
Experience:  IEEE, Microsoft
5195814
Type Your Mac Question Here...
Claws224 is online now
A new question is answered every 9 seconds

Can anyone tell me how to export iCal events from iCal in a

Customer Question

Can anyone tell me how to export iCal events from iCal in a format that can be manipulated (i.e. plain text, comma delimited, Numbers, etc.)? I just need start date, end date, and subject.

Up till now, I've been using Bento. But, I upgraded to Snow Leopard and now my iCal events are on Exchange and now Bento can't read them.

I've tried the Get Specified iCal items feature in Automator, but when I run it, it just runs forever.

I've tried Export option in iCal, but when I run that, I get the spinning multi colored wheel forever.

I've tried backing up iCal but then I get a file that can't be opened by any other application.

I'm totally out of ideas and would really appreciate any help on how to do this and/or why Automator and iCal crash when doing the tasks described above.
Submitted: 5 years ago.
Category: Mac
Expert:  Claws224 replied 5 years ago.

Hi,

 

There is a small free application that might do what you are wanting to acchieve called Address book to CSV and you can get it from here http://www.antoniolore.net/ab2csv.php

 

This should allow you to take what you have in iCal and transfer it to a CSV that youc an then import to a multitude of applications from Enourage to bento or Excel

 

Let us know if you need more info


Thanks

Eric

Customer: replied 5 years ago.
Hi,

This is not working for me.

First, it seems to be focused on Address Book entries. As stated in my question, I need to export iCal Events. I don't need to export Address Book entries.

Second, it says to "select a group" but it won't allow me to choose a group, no options are given.

Third, when I do it, I get a CSV that has no data in it.

Mitch
Expert:  Claws224 replied 5 years ago.

Ok,

 

What program are you wishing to move the iCal files to?

 

Thanks

Customer: replied 5 years ago.
I would like to pull all iCal events for a given month and work with them in Numbers (the iWorks equivalent to Excel). Each field of the event should translate into a column in Numbers (i.e. start date/end date/subject).

I used to just pull the events into Bento then copy/paste into Numbers but now Bento won't read events that are in Exchange.
Expert:  Claws224 replied 5 years ago.

Ok,

 

In that case manually doing what you want to do will be very difficult without having Entourage or something in between, However you amy wish to consider an app like TimeLog http://www.mediaatelier.com/TimeLog4/ for about $40.00 it sould do exactly what you are wanting as well as giving you trackable time logging.

 

Take a look and let me know what you think

 

Thanks

Eric

Customer: replied 5 years ago.
That is a crazy program and I can't figure it out.

The query feature does not work, it does not pull up the right dates. There is no subject field. The export feature excludes start and end time, which are the most important fields after subject.

I have just written this to them:

Hi,

I have just installed timelog and I am trying to figure out how to use it.

I want to import iCal Events from my Calendar then sort them and ideally export them to Numbers.

I can't understand the data it's showing me. The data contains fields such as Client and Project but those fields do not exist in an iCal Event.

I do need to see the Subject line, since that's how I code iCal Events against projects. But, the field "Subject" for an Event does not appear anywhere.

So, can you tell me, how can I see the Subject line for an iCal event? And, how does TimeLog come up with the value to put into the Project field for a given iCal event?

Mitch
Expert:  Claws224 replied 5 years ago.

Ok Mitch,

 

The developer is located in Switserland and it is currently 1am there so I would assume you will hear back first thing in the morning from them, If they cannot or do not answer you let me know.

 

Thanks

Customer: replied 5 years ago.
Hi,

As noted in my response, this solution doesn't work. I've documented the problems that I have had in using that software to perform the tasks that I've requested. I've emailed them for help but got no response.

Mitch
Expert:  Claws224 replied 5 years ago.

Ok,

 

The only method to do what you want that I know of is to use the Time Log application, Howeer I will opt out and see if another expert may have another idea.

 

Thanks

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
< Last | Next >
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
 
 
 

Meet The Experts:

 
 
 
  • Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
< Last | Next >
  • http://ww2.justanswer.com/uploads/macthelife/2009-10-20_1899_mikesebaharsquare64.jpg Mike's Avatar

    Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
  • http://ww2.justanswer.com/uploads/AS/ashiknasameen/2012-5-15_141836_final2.64x64.jpg Ashik's Avatar

    Ashik

    Mac Helper

    Satisfied Customers:

    5282
    7+ Years of Experience in troubleshooting Macs, iPhone, iPad, iPod etc
  • http://ww2.justanswer.com/uploads/DP/dpean/2012-6-6_172828_avatorme1.64x64.JPG Daniel's Avatar

    Daniel

    Mac Genius

    Satisfied Customers:

    4670
    Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.
  • http://ww2.justanswer.com/uploads/VI/vinodvmenon2005/1.64x64.jpg Vinod Menon's Avatar

    Vinod Menon

    Support Specialist

    Satisfied Customers:

    2068
    worked as a Tech support Associate for Apple products
  • http://ww2.justanswer.com/uploads/BE/beboo/2011-1-14_201648_n5063313142021801763.64x64.jpg Brandon M.'s Avatar

    Brandon M.

    Mac Support Specialist

    Satisfied Customers:

    1501
    10+ Years Mac Support as contractor and currently an IT Manager for law firm
  • http://ww2.justanswer.com/uploads/MA/MacDruid/IMG_0232.64x64.JPG John T. F.'s Avatar

    John T. F.

    Mac Druid

    Satisfied Customers:

    1408
    20+ years in the computer/Mac industry
  • http://ww2.justanswer.com/uploads/MA/MacHelpdesk/1d2d506.64x64.jpg David's Avatar

    David

    Mac Support Specialist

    Satisfied Customers:

    1236
    BSc, H.Dip, Apple Certified
 
 
 

Related Mac Questions

Chat Now With A Mac Support Specialist
Claws224
Claws224
CIO
965 Satisfied Customers
IEEE, Microsoft