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

Mass Change of Categories

 
Logged in as: Guest
  Printable Version
All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC General Functionality >> Mass Change of Categories Page: [1]
Login
Message << Older Topic   Newer Topic >>
Mass Change of Categories - 2/28/2014 1:51:01 PM   
bkantor@aol.com

 

Posts: 11
Joined: 2/28/2014
Status: offline
I just imported all of my CC2 files (yes, I said Calendar Creator 2!!!) into Calendar Creator Deluxe v12. After the import, I have 1900 entries in one category and need to change them to a different category. Is there a way to change the category en mass-- i.e., how do I select these 1900 events from the event list and change them all at once to the new category. I see how I can change them one at time, however, this will take a lifetime to do one-at-a-time. Is there a way to do a bulk category reassignment?
Post #: 1
RE: Mass Change of Categories - 2/28/2014 5:05:28 PM   
DEJenc3


Posts: 533
Joined: 6/22/2005
Status: offline
If all your imported events have the same Category, you can change the Category name to one you want to use. From the menu, choose Events, then Categories. Find the category that applies to all the events. Double-click the text portion of the event, and you will see it change to an editable field. Simply change the text to what you would like it to read.

Before you do so, you should copy the name of the Category that attached to all the events (probably "General"?), so you can re-create a Category with that name. "General" is the default assigned to a new event, so you'll want that in your group of Categories.

With any global operation, you'd do well to back up your calendar, or save a copy with a different name, before starting.

_____________________________

David

(in reply to bkantor@aol.com)
Post #: 2
RE: Mass Change of Categories - 3/2/2014 3:58:14 PM   
bkantor@aol.com

 

Posts: 11
Joined: 2/28/2014
Status: offline
David,

I realize I can change the category name, but this is not what I am trying to do. Let me provide more details.

When I imported from CC2, all of my events that imported now have a start and end time that were not there previously in CC2. I don't want the start and end times in my new CC12 calendar either.

With some other calendars that I imported (which had less than 75 entries), I fixed the problem simply by going into the category to which my events were imported (e.g. work events) and selecting the “No time” option (To be very specific, I selected "Events" from the Menu Bar and then "Categories." I then highlighted the “Work Events” category and clicked on the "Event Properties" button. Once in the dialog, I selected the "No Time" check box). Once I did this, I hoped that all my events would no longer have the start/end times on them, but the times were still there. So I then went into the window that shows a list of all 75 of my events and re-selected the SAME category (i.e., work events). By re-selecting the same category the new event properties were applied and the start and end times went away.

This worked well and was tolerable only because I had less than 75 entries. In one of my calendars that I imported though, I have over 1900 events and it would take forever to use the process I described above. Therefore, I was hoping there is some way to remove the time periods off all 1900 entries without having to use the laborious process above.
Any suggestions would be most welcome!

Thanks!

Bruce

(in reply to DEJenc3)
Post #: 3
RE: Mass Change of Categories - 3/2/2014 4:34:21 PM   
DEJenc3


Posts: 533
Joined: 6/22/2005
Status: offline
Bruce,

The only other thing I can think to do would be an export and import. You would export all the events to a CSV file, and import that into Excel or another spreadsheet program, where you can manipulate the text. You could define a new Category, and copy it to all the cells for Category. You would want to be sure that the new Category exists in Calendar Creator when you go to import. The Category in Calendar Creator should have the properties set before hand, I would assume.

There were a few tips I gave on importing in another post, here:
http://forums.encoreusa.com/fb.asp?m=43569

It's usually important that there be no null fields when you are importing, since that's something that can often throw off data exchanges.

You'd have to be aware that this process will strip any formatting you may have done to events. You'll be exchanging basic data only.

You can assume that this will take some trial and error, and may not work for reasons I can't foresee.

If you decide to attempt it, of course, don't use your original calendar, and do everything in temporary calendars.

Let us know if you try it, and if it succeeds, or if it doesn't.

_____________________________

David

(in reply to bkantor@aol.com)
Post #: 4
RE: Mass Change of Categories - 3/2/2014 5:45:41 PM   
bkantor@aol.com

 

Posts: 11
Joined: 2/28/2014
Status: offline
Actually, I figured out a way to get all the time periods to go away! I selected an empty cell, right clicked and selected the properties options. In the "Set Properties of" drop down, I selected the "Cell" option. I then clicked on the Miscellaneous tab and deselected start time and end time. When I did this, the start and end times went away on all 1900 events. Thanks for your suggestions though as I am guessing the import/export option would have worked as well.

Bruce

(in reply to DEJenc3)
Post #: 5
RE: Mass Change of Categories - 3/2/2014 6:46:39 PM   
DEJenc3


Posts: 533
Joined: 6/22/2005
Status: offline
That's good news. I assume that will remove time from events where you may want a time display, but with luck that's not an issue.

If you're going to use the calendar for future events where you'll want some to have the times displayed, and others not, experiment with adding new events, and also modifying categories. If all works well, you should be good for the long term.

_____________________________

David

(in reply to bkantor@aol.com)
Post #: 6
Page:   [1]
All Forums >> [Product Forums] >> [Productivity Software] >> [Calendar Creator] >> CC General Functionality >> Mass Change of Categories 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.031