Encore Forums Knowledgebase  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums  Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

Printable Version

All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC Export/Import >> Format for Time when importing CSV

Page: [1]

Login Message << Older Topic   Newer Topic >>

Format for Time when importing CSV - 1/31/2015 5:45:19 PM    heinelg   Posts: 5 Joined: 3/3/2014 Status: offline Using CC 12 Deluxe. Last year I successfully imported multiple categories of events with date, time, and description. When I tried to import this year's information, all the event times were imported as 12:00 AM instead of the actual event time. What is the proper format for time in the CSV file so CC will import time correctly? Thanks! Post #: 1

RE: Format for Time when importing CSV - 1/31/2015 10:32:34 PM    DEJenc3 Posts: 533 Joined: 6/22/2005 Status: offline I have encountered this same time import issue, without finding a solution. I have always attempted to import data saved via MS Excel in .csv format, whether it was originally exported from Calendar Creator or other sources. I don't know if other software that can store table data would cause the same incompatibility issue. _____________________________ David (in reply to heinelg) Post #: 2

RE: Format for Time when importing CSV - 2/1/2015 5:04:56 AM    heinelg   Posts: 5 Joined: 3/3/2014 Status: offline Update: I've tried half a dozen different formatting options for time but none made a difference. On a whim I checked the Convert special DOS characters box and the times were imported correctly. Larry Further update: well it worked once but the next category didn't import times again even though the CSV formatting and import settings were the same. < Message edited by heinelg -- 2/1/2015 5:17:19 AM > (in reply to DEJenc3) Post #: 3

RE: Format for Time when importing CSV - 2/1/2015 5:48:54 AM    heinelg   Posts: 5 Joined: 3/3/2014 Status: offline Still Further update: Only the Meeting category can be imported with Time I need to play with the formatting in a simple test calendar to see what is accepted. I have too many events in my calendar to spend more time there. Also, only the Meeting category will display time in the calendar. If the Do not use time box is deselected and saved, it is selected again when the properties are viewed again. (in reply to heinelg) Post #: 4

RE: Format for Time when importing CSV - 2/1/2015 6:11:03 AM    DEJenc3 Posts: 533 Joined: 6/22/2005 Status: offline Hi, Larry, Some time ago I tried different ways of importing calendar event data. I started by exporting a range of events from Calendar Creator, using that table as a template for data to import, and then matching the formats exactly. I made sure every cell had some kind of data in it. I still couldn't get the time formats to work. Dates worked, times did not. Databases handle formats in different ways, and sometimes it's difficult or impossible to find a way to make a flawless exchange of data. That seems to be the case with time formats in Calendar Creator, since other fields appear to import without a problem. _____________________________ David (in reply to heinelg) Post #: 5

RE: Format for Time when importing CSV - 2/1/2015 6:28:14 AM    DEJenc3 Posts: 533 Joined: 6/22/2005 Status: offline quote: Only the Meeting category can be imported with Time If you try assigning all events the "Meeting" category, will they all import the time? Even if it works, it may not be practical to change the categories back to their original ones after an import. (If this seems like a possible approach, I'd suggest copying the original categories to a new column that is not imported, and use this as a reference to restore the original categories.) I expect that the "Do not use time" selection has no effect on import and export. The time fields would have to be filled in any case (the 12:00:00 AM default), and the selection field is not a field that's exported, though it would be useful if it and other customizing fields could be exported/imported. _____________________________ David (in reply to DEJenc3) Post #: 6

All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC Export/Import >> Format for Time when importing CSV

Page: [1]

New Messages No New Messages Hot Topic w/ New Messages Hot Topic w/o New Messages Locked w/ New Messages Locked w/o New Messages

Post New Thread  Reply to Message  Post New Poll  Submit Vote  Delete My Own Post  Delete My Own Thread  Rate Posts

Please Note: In order to post a message on the forums, you will need to become an Encore Forum Member. Click on the Register link on the top of this page and follow the instructions to become an Encore Forum Member.

If you are a new member and need help using these forums, please click on the FAQ link at the top of this page.