Tuesday, October 1, 2013

Electronic Programming Guides & Google Calendar - Howto


 I thought okay google being a tech firm has solved this file import problem but oh no... for as a simple spelling mistake in a CSV ( comma separated file) used for import/export for various applications can render the import process a " total failure ". Then I tried, " online file conversions " but no solution there. Then  i manually edited the  csv file. ics  is the preferred import/export file format which even google uses. 

In order for a successful import, some changes need to be done to the csv file, specifically the addition of following row of text - 

Subject   Start Date  Start Time  End Date  End Time  All Day Event  Description  Location  Private

One need only be concerned with 1st 3 columns, for this to work properly.


 Fashion TV October 2013 schedule 


sorting of 3 data fields to 1st 3 columns

successful import to google calendar 

for this to be a complete success, create a blank google calendar which is separate from calendar you use daily if something goes wrong, you dont have to edit  " one calendar entry at a time " to undo the import process. 

sadly, FTV EPG is a monthly publication, therefore, one needs to tinker with native FTV EPG released  in a csv format.

No comments:

Post a Comment