Exporting project calendars

M

molligdj

Is there a way to export a project in ical format.

I want to be able to import project schedule into a google calendar.
 
S

Steve

Don't think that Project will do iCal format. You could try saving your
Project as a CSV file and importing that into Google. You might need to
modify it in Excel before it will import correctly. See the Google online
help forums for CSV file import problems.

HTH
 
S

Steve

I ran some tests on this and found that I could create a map in Project to
line up the columns with Google Calendar. I used the following as a test:

Project Field Google Field Data Type
Name Subject Text
Start Start Date Text
Finish End Date Text

This almost works. For some reason the date fields in Project are not
recognized as Date types, so are saved as text. When you look at them in
Excel, they appear as Sun 7/19/09. Google will not read these, and you can't
simply reformat them in Excel. Retyping them in the correct format (which is
completely pointless) will fix the problem, and they will import
successfully into Google Calendar.

I'll keep playing with this and will let you know if I find a solution. I
suspect that this will need to be customized in VBA or something.
 
R

Rob Schneider

Jan said:
Hi,

Don't know bout Google but wouldn't change the date format in Project solve
this?
Click to expand...

Or use a custom field formatted how Google wants it?
 
M

MS Office Guru

How do you restore the opening page on Project to what it originally was when
it was brand new?
 
S

Steve

Tools -> Options -> View Tab -> Date Format does the trick. It seems really
obvious now ;-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Auto populate value from one task to another in MS PROJECT 0
Team Calendar 0
Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Can activities be imported with their relationships? 0
Base calendar interaction with a resource calendar 0
Display weeks from a Milestone 0
Can we use outlook calendar as an universal place post work schedules for all the users? 0

Top