topic Re: Schedule category in Revit API Forum

Schedule category

will.wydock — Tue, 08 Aug 2017 00:01:06 GMT

I am currently working on a routine that i would be able to add additional columns to an existing schedule. However, would like to limit the routine to only be able to work on mechanical equipment. I have tried using Viewschedule.Category.Name to try to narrow that down but i don't seem to be getting anywhere with it. Is it possible to retrieve the category information from the schedule?

public void addtoschedule()
		{
			Document doc = this.Document;
			ViewSchedule mvs = doc.ActiveView as ViewSchedule;
			Category mcat = null;
			using (Transaction t = new Transaction(doc, "create Schedule")) 
			{
				t.Start();
				{

					if(mvs.Category.Name.ToLower()=="mechanical equipment")
				{
					ScheduleDefinition msd = mvs.Definition;
					ScheduleField mnamefield = msd.AddField(new SchedulableField(ScheduleFieldType.Instance, new ElementId(BuiltInParameter.ALL_MODEL_MARK)));
				}
				else
				{
					TaskDialog.Show("Warning","The active schedule is not for mechanical equipment.");
					                
				}
							
				t.Commit();
				}
			}

Re: Schedule category

matthew_taylor — Tue, 08 Aug 2017 11:16:41 GMT

Hi @will.wydock,

Well, if the category has any elements, you just get the category of the first element in the viewschedule. Using a new FilteredelementCollector(doc, viewshed.Id).

If the schedule doesn't have any elements, then viewschedule.Definition.CategoryId is supposed to get the elementId of the category. It showed up as Null in RevitLookup though, so you may want to check it.

Re: Schedule category

will.wydock — Tue, 08 Aug 2017 13:23:00 GMT

That was very helpful. I was able to use viewschedule.Definition.CategoryId and compare it with doc.Settings.Categories to get the desired results

Document doc = this.Document;
			ViewSchedule mvs = doc.ActiveView as ViewSchedule;
			
			Category mcat = null;
			
			using (Transaction t = new Transaction(doc, "create Schedule")) 
			{
				t.Start();
				{
					foreach (Category c in doc.Settings.Categories) 
					{
						if (c.Name.ToLower() == "mechanical equipment") 
						{
							mcat = c;
						}
					}
					//is the schedule for Mechanical equipment?					
					if(mvs.Definition.CategoryId==mcat.Id)
					{
						//Schedule Definition
						ScheduleDefinition msd = mvs.Definition;
						//Add parameters to schedule
						ScheduleField mnamefield = msd.AddField(new SchedulableField(ScheduleFieldType.Instance, new ElementId(BuiltInParameter.ALL_MODEL_MARK)));
						
					}

Re: Schedule category

matthew_taylor — Tue, 08 Aug 2017 13:35:04 GMT

Or simply:

Public Shared Function GetBuiltinCategory(ByVal categoryId As DB.ElementId) _
     As DB.BuiltInCategory  
  Return DirectCast( _
     [Enum].Parse(GetType(DB.BuiltInCategory), categoryId.IntegerValue), _
     DB.BuiltInCategory)
End Function