MobilityDubai    Community Forums  Hop To Forum Categories  Pocket PC General Discussion    Calander - bulk entry
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Contributing Editor
Picture of Saravana Kumar Paulraj
Yahoo IM
Posted
Is there any way to 'bulk' enter the calender entry into the PPC...

I would like to keep trace of cricket fixtures etc, which I have in excel, and want all of them to come to my calender... any idea??

I can re-format them, if it needs to be stored in particular format (csv/tsv or any other)
 
Posts: 2342 | Location: Dubai, UAE | Registered:: Fri January 07 2005Reply With QuoteEdit or Delete MessageReport This Post
Contributing Editor
Picture of SteveJ
Yahoo IM
Posted Hide Post
SKP
quote:
Is there any way to 'bulk' enter the calender entry into the PPC...

I'll have a look in to this I seem to recall a macro writen in Excel to import data to outlook.
rgds
Steve


Rgds
Steve
 
Posts: 2454 | Location: UAE | Registered:: Mon September 19 2005Reply With QuoteEdit or Delete MessageReport This Post
Contributing Editor
Picture of SteveJ
Yahoo IM
Posted Hide Post
Skp

If you export a sample of your calander entries to an excel file you will get a series of 22 columns.

Subject/StartDate/StartTime/EndDate/EndTime/Alldayevent/
Reminderonoff/ReminderDate/ReminderTime/MeetingOrganizer
/RequiredAttendees/OptionalAttendees/MeetingResources/
BillingInformation/Categories/Description/Location/Mileage
/Priority/Private/Sensitivity/Showtimeas

From these columns it should be obvious what to populate them with Smile using your own example many fields wont be required and the format should similary be replicated

You should then be able to re-import to outlook then synch Smile

rgds
Steve


Rgds
Steve
 
Posts: 2454 | Location: UAE | Registered:: Mon September 19 2005Reply With QuoteEdit or Delete MessageReport This Post
Contributing Editor
Picture of Saravana Kumar Paulraj
Yahoo IM
Posted Hide Post
quote:
Originally posted by SteveJ:
From these columns it should be obvious what to populate them with Smile using your own example many fields wont be required and the format should similary be replicated

You should then be able to re-import to outlook then synch


Thanks for the reply!!!

Guess what... thats the FIRST thing I tried and an IMPORT. It didnt work. I have Office 2002 at home, and didnt work.

I will try the similar approach tomorrow at office PC - 2003 version. lets see...
 
Posts: 2342 | Location: Dubai, UAE | Registered:: Fri January 07 2005Reply With QuoteEdit or Delete MessageReport This Post
Contributing Editor
Picture of SteveJ
Yahoo IM
Posted Hide Post
SKP
quote:
I will try the similar approach tomorrow at office PC - 2003 version. lets see...

Opps I have 2003 will try one myself also try export excel as csv and import
rgds
Steve


Rgds
Steve
 
Posts: 2454 | Location: UAE | Registered:: Mon September 19 2005Reply With QuoteEdit or Delete MessageReport This Post
Contributing Editor
Picture of Saravana Kumar Paulraj
Yahoo IM
Posted Hide Post
yes.. i created my entries and savwed them in CSV ofrmat only...

I checked with other online help... I guess I should save the file in iCalendar format orsomething else.... all tomorrow Wink
 
Posts: 2342 | Location: Dubai, UAE | Registered:: Fri January 07 2005Reply With QuoteEdit or Delete MessageReport This Post
Contributing Editor
Picture of SteveJ
Yahoo IM
Posted Hide Post
SKP
No problem in 2003 edited excel file then re-imported excel file Smile

rgds
Steve


Rgds
Steve
 
Posts: 2454 | Location: UAE | Registered:: Mon September 19 2005Reply With QuoteEdit or Delete MessageReport This Post
Contributing Editor
Picture of Saravana Kumar Paulraj
Yahoo IM
Posted Hide Post
2003... worked like charm... I didnt take the actual file... will do it tom..

Thanks Smile
 
Posts: 2342 | Location: Dubai, UAE | Registered:: Fri January 07 2005Reply With QuoteEdit or Delete MessageReport This Post
Contributing Editor
Picture of SteveJ
Yahoo IM
Posted Hide Post
Skp
quote:
2003... worked like charm... I didnt take the actual file... will do it tom.. Thanks Smile

No props M8 must of been the easyest one yet for us Big Grin not sure on repeatability setting though
rgds
Steve


Rgds
Steve
 
Posts: 2454 | Location: UAE | Registered:: Mon September 19 2005Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

    MobilityDubai    Community Forums  Hop To Forum Categories  Pocket PC General Discussion    Calander - bulk entry

Copyright © MobilityDubai 2003 - 2008