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

Need To Know Expected Fields To Import CSV File

 
Logged in as: Guest
  Printable Version
All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC Export/Import >> Need To Know Expected Fields To Import CSV File Page: [1]
Login
Message << Older Topic   Newer Topic >>
Need To Know Expected Fields To Import CSV File - 11/21/2016 11:55:40 AM   
Brian O

 

Posts: 4
Joined: 11/21/2016
Status: offline
I need to know the expected fields so I can import a CSV file into CC 10.

In the good old days, I used a DOS version of CC, and it was a wonderful product. I created files of events, some recurring - some one-time, for things like Birthdays and Anniversaries, Payments Due, Hockey Games, etc. It worked great and I could select which files to include in a particular (month) calendar that I would then print.

Sadly, when an upgrade Windoze version of CC came out, it had some serious bugs (what you saw was NOT what you got printed), so I stopped using the product.

I thought I would try CC again, hoping that the bugs from 10-15 years ago have been corrected.

So, now I want to import a CSV file that I will be creating from data I have in a Word document table. I know how to turn that into a CSV format and file, but I don't know the fields that CC is expecting to read (start date, time, font size, etc.).
Is this information available somewhere?

Thanks.
Post #: 1
RE: Need To Know Expected Fields To Import CSV File - 11/21/2016 12:05:43 PM   
JasonC

 

Posts: 1657
Joined: 12/14/2005
From: Hayward, CA
Status: offline
Calendar Creator 12.1 may have unsolvable bugs due to the fact that Windows 10 is not a supported operating system. This program is so old that we offer email support only.

The new version can import CSV files from these older programs, see the data it can read on this screenshot:




Attachment (1)

_____________________________

Jason Carver
Encore Sales Department and Customer Service
www.encore.com
For Tech Support, visit http://support.encore.com

(in reply to Brian O)
Post #: 2
RE: Need To Know Expected Fields To Import CSV File - 11/21/2016 2:04:50 PM   
ellengard


Posts: 3241
Joined: 10/2/2006
Status: offline
quote:

ORIGINAL: Brian O
I need to know the expected fields so I can import a CSV file into CC 10.

Open your CC 10 program. Look at any of the pre-made event lists or even a blank one. You'll see all the fields.

Are you getting CC 10 to work on Win 10?!

_____________________________

my desktop publishing tips
Print Shop guest blogger(2014-20)

(in reply to Brian O)
Post #: 3
RE: Need To Know Expected Fields To Import CSV File - 11/21/2016 3:05:58 PM   
DEJenc3


Posts: 493
Joined: 6/22/2005
Status: offline
quote:

I need to know the expected fields so I can import a CSV file into CC 10.


The advice in this post (and thread) may still apply:
http://forums.encoreusa.com/fb.asp?m=49841

_____________________________

David

(in reply to Brian O)
Post #: 4
RE: Need To Know Expected Fields To Import CSV File - 11/21/2016 3:17:54 PM   
Brian O

 

Posts: 4
Joined: 11/21/2016
Status: offline
Thanks for your reply.

I am attempting to run CC 10 on a Xindoze XP (SP3) system.
So far no problems, except that I don't know how the program expects the fields in the CSV file to be defined (hence my original question).

I don't think I understand your suggestion.
The *.bcc files that are provided as part of the CC 10 installation are in a format to be read by CC, and are not CSV files. I can't read them (coherently) in a text editor such as Notepad / Wordpad.

I will try to load one of the files in CC and then export it, and hopefully that will provide some insight as to what fields the program expects when it imports a CSV file.

(in reply to ellengard)
Post #: 5
RE: Need To Know Expected Fields To Import CSV File - 11/21/2016 3:23:02 PM   
DEJenc3


Posts: 493
Joined: 6/22/2005
Status: offline
quote:

I will try to load one of the files in CC and then export it, and hopefully that will provide some insight as to what fields the program expects when it imports a CSV file.


Yes, this is what I'm advising. Export events to a .csv and open them in a spreadsheet. It will give you the field names, and you can also study the formats. Date and time fields can be particularly tricky, and you may have to expect a lot of trial and error. It's safest to work with copies only while testing.

_____________________________

David

(in reply to Brian O)
Post #: 6
RE: Need To Know Expected Fields To Import CSV File - 11/21/2016 3:28:33 PM   
Brian O

 

Posts: 4
Joined: 11/21/2016
Status: offline
Thanks for the reply.

The referenced thread had useful information, but still no specifics as to expected fields.

It is also disturbing that CC seems to have trouble importing times correctly.
One of my intended applications is to import several CSV files (or one merged file) with lists of NHL games on TV, with date, time, and text information with teams and network information.
If times are not imported correctly, that kills that application, although it sounds like if I treat these events as "meetings" that the time will import correctly.

(in reply to DEJenc3)
Post #: 7
RE: Need To Know Expected Fields To Import CSV File - 11/21/2016 3:35:24 PM   
Brian O

 

Posts: 4
Joined: 11/21/2016
Status: offline
Thanks for the second reply.

I plan to work first with a one-or two-record test file to get the formats correct. Then I can do macro edits in my real data file to make it conform.
I use Word to do macro edits on tabular data, switching back and forth between table and text, and using the Replace all feature. I also have a text editor that allows me to write macros so whatever the required format is, I am confident that I can easily convert my data.

(in reply to DEJenc3)
Post #: 8
RE: Need To Know Expected Fields To Import CSV File - 11/21/2016 3:49:59 PM   
DEJenc3


Posts: 493
Joined: 6/22/2005
Status: offline
Yes, once you find a successful import of some records, you'll have the key to format and import the rest in most cases, though a small sampling won't guarantee that all records will be correctly imported.

Problems with importing data of all kinds, especially formatted fields like date and time, are not confined to Calendar Creator, but are tricky with many databases and spreadsheets. Retaining initial 0s in number fields (like Zip codes) and empty (null) fields are common examples.

_____________________________

David

(in reply to Brian O)
Post #: 9
RE: Need To Know Expected Fields To Import CSV File - 1/8/2017 9:46:52 PM   
CalendarNut

 

Posts: 4
Joined: 1/8/2017
Status: offline
Will the development team create an update file every year for holidays, phase of the moon, presidents actual birthday, etc?

(in reply to JasonC)
Post #: 10
Page:   [1]
All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC Export/Import >> Need To Know Expected Fields To Import CSV File 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

1.422