Encore Forums 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

Format for Time when importing CSV

 
Logged in as: Guest
  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
Page:   [1]
All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC Export/Import >> Format for Time when importing CSV Page: [1]
Jump to:





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.

Forum Software © ASPPlayground.NET Advanced Edition 2.4

0.016