11 Replies Latest reply: Mar 25, 2013 4:39 PM by Jo!
Jo! Level 1 Level 1 (15 points)

Is there a way to export my ics files (export from ical) to a db-format like numbers (spreadsheet) of filemaker?

 

I own a business and the tax-office in the Netherlands wants me to show how many hours I send on my business. I said 'you must be joking, I have something better to do'. But they are serious and haven't entered the 21st century yet apparently!

 

Anyone?


iMac, OS X Mountain Lion (10.8.1), 2.7 GHz intel i5 core 27 inch
  • 1. Re: ics to Numbers or filemaker
    Roger Wilmut1 Level 9 Level 9 (65,535 points)

    You aren't going to find this easy. You can import an ics file into Filemaker Pro simply by dragging it onto the program's icon, but what you get is a single record with a field for each line. Each event is identified by fields containing 'BEGIN:VEVENT' AND 'END:VEVENT' so you would need to convert these to a return and all the other returns to tabs. Even then if there isn't a summary (note) the field is omitted so you wouldn't get the fields in the right places.

     

    I don't know whether there's a program which will convert them - you could Google for that.

  • 2. Re: ics to Numbers or filemaker
    Jo! Level 1 Level 1 (15 points)

    the google-option has been explored of course. That's why I put it here.

    Dare to mention ... maybe there is a windhose version?

  • 3. Re: ics to Numbers or filemaker
    Roger Wilmut1 Level 9 Level 9 (65,535 points)

    Not sure what you can do about this with Google.

  • 4. Re: ics to Numbers or filemaker
    Jo! Level 1 Level 1 (15 points)

    Either you are pulling my leg, in which case I would suggest to go somewhere Els, or you are serious in your answer. Either way, a good idea to reconsider.

  • 5. Re: ics to Numbers or filemaker
    Roger Wilmut1 Level 9 Level 9 (65,535 points)

    Sorry, I misread your answer - I was thinking of Google Calendar... if you can't find a conversion process then I'm afraid there isn't really much you can do. You could try opening the .ics file in Pages and converting the 'End' fields to a return, then all the returns to tabs, then saving as a plain text file which could be opened as a database or spreadsheet: this would then open each entry as a record but you will still have a lot of difficulty getting it to make sense.

  • 6. Re: ics to Numbers or filemaker
    Jo! Level 1 Level 1 (15 points)

    I already had a look at this. ... wont work, too much jibbrish.

    No it needs a converter

  • 7. Re: ics to Numbers or filemaker
    Roger Wilmut1 Level 9 Level 9 (65,535 points)

    The best I could find was these pages:

     

    http://ask.brothersoft.com/how-to-convert-ics-to-excel-169109.html

     

    http://www.ehow.com/how_7245634_import-ical-iwork-numbers.html

     

    The link to Felix Chenier's converter in the second page is broken but Sunbird is stil available - might be worth a look.

  • 8. Re: ics to Numbers or filemaker
    Jo! Level 1 Level 1 (15 points)

    yes I contacted Felix. It was an alpha-project, and he dropped it.

    Sunbird does 'work', but it is crappy software and the output is very messy. Still it is a start

     

    I wonder why this is such a hazard.

    I cannot believe I am the first one to check this out. I need it for my business.

    I hate to believe that I zctually need seperate planning software.

  • 9. Re: ics to Numbers or filemaker
    Jo! Level 1 Level 1 (15 points)

    maybe there is a windoze version somewhere. Parallels still works (though I am not too fond of that)

  • 10. Re: ics to Numbers or filemaker
    jmedema_surefoot Level 1 Level 1 (5 points)

    Actually, this IS completely possible using FileMaker and not very complicated!

     

    After exporting a calendar from iCal and dragging the file onto the FileMaker icon, the events will import as thousands of individual records. From here it simply becomes an exercise in parsing the data from multiple records into individual event records using a FileMaker script

     

    In a nutshell, your script should:

    • Start at the first record
    • Capture desired data from raw ICS data records into variables for temporary storage between the start and end of each event (between BEGIN:VEVENT and END:VEVENT) while deleting records with data that you don't need
    • Once you reach the end of your event, create a new record in a separate table and set the event title, event date, start and end times (which can be used to calculate the total hours), and any other fields you need from the temporary variables.
    • Clear the variables
    • Return to the original table and loop through this same process until you reach (and delete) the last record in the raw ICS import

     

    I exported one of my calendars and, when imported into FileMaker there were over 47,000 records. I ran one parsing routine that took just a minute or two.

     

    To properly pull your data so that you could report to the tax office would take a few hours (2-3?) to program and test so you could get the raw data. To format it for reporting to the tax office would take a bit longer.

     

    Unfortunately, this FileMaker development my business and cannot do this for for free, though I hope to have helped you along at least a bit. Contact me separately if you'd like to discuss this more offline. You contact me via the surefootdata website.

     

    All the best,

     

    Jim

  • 11. Re: ics to Numbers or filemaker
    Jo! Level 1 Level 1 (15 points)

    jmedema_surefoot wrote:

     

    Actually, this IS completely possible using FileMaker and not very complicated!

     

    ...

     

    Unfortunately, this FileMaker development my business

    Hello Jim,

    Thank you for responding.

    Yes, it is 'unfortunate'  (-:

    Anyway, you think it were possible that suc a script wold be available already?

    It does not sound difficult. But I am no longer a FMwizzard (I do not heve the time)

    So trying this is, for the moment not an option.

    I'll send you a message.

     

    Thanks.