« Read-only and Automatic Transaction Modes | Main | The Revit 2013 MEP API and External Services »

May 07, 2012

Comments

Hi Jeremy,

it would be nice if we could also access the background color in schedule cells.
Think of displaying values in different ways, depending on different conditions.
We can perform the colorizing via GUI, so why not via API ?

Thanks,
Rudolf

Dear Rudolf,

Thank you, that is an absolutely brilliant idea!

Please submit an ADN DevHelp Online request for this and I will file a wish list item for you.

Cheers, Jeremy.

HI Jeremy.

The schedule API rocks and I have used it extensively in our new product Project Browser for creating what we call queries - .
http://revitfb.blogspot.co.nz/2012/05/project-browser-for-revit-2013-now.html

Please though allow us to access the element ID’s that are contained within the schedule, or at least allow us to schedule the elements ID values. At the moment I have to export the schedule to a txt file compare the family types and names and then back in Revit match the corresponding objects. That is pretty inefficient.

Good start though ;)

Cheers

Phillip

Dear Phillip,

Thank you very much for your appreciation, and I am very glad to hear that you are already making good use of this functionality.

Your project browser sounds like a powerful tool. Sorry that you have jump through such silly hoops to access the data you require.

My suggestion to Rudolf applies to your case as well: please submit an ADN DevHelp Online request for this and I will file a wish list item for access to the element ids for you.

Cheers, Jeremy.

I will do Jeremy.

The Revit 2013 API is a huge advancement. I can't wait to see what you guys have in store for next year.

Dear Phillip,

Yes, absolutely, on both counts. Unbelievably impressive factory deliverables, and can't wait to see what comes next.

Looking forward to seeing your case as well, thank you for that.

Cheers, Jeremy.

Hi Jeremy,

I am excited to work with schedule export but I noticed there is no easy way to reference the elements through ID or GUID when schedules are exported to a text file. Do you know if it's possible to import the exported schedule data back into Revit?

Dear Jemish,

Glad you are excited, so am I.

Yes it is, as you can see from Phillip's description below of how he achieves this very task.

It is a workaround, though, and rather kludgy. I know of no other way, though. Please file a wish list item for a future enhancement.

Cheers, Jeremy.

Hi Jeremy,
you responded through email that with some detailed testing there might be the possibility to access the revision schedule that is placed in a titleblock. I'm hoping some loyal readers could test it out (I'm by no means a programmer).

Thanks,

Chris

Could this be used to read Revision Schedules on a sheet? I see them in the Revit database as a ViewSchedule but your addin didn't access them directly. If we could access these dependent schedules, we could read the Revisions on Sheet.

Hi Jeremy,

Very usefull your blog if you ask me ;)

Using the ScheduleDefinition.GetSchedulableFields it is possible to iterate through the available (shared) parameters and add or insert (addfield or insertfield) them to the created schedule.


However I wish to add a calculated value / calculated field to the schedule. This field does not show up in GetSchedulableFields because this field has to be added 'on the fly'. In the API there is a schedulefieldtype.formula member which suggest it may be possible to add a calculated field. Do you know how to add a calculated field because I am running out of ideas. Or is this not possible (yet)?


Thanks,
Raymond

Dear Raymond,

Thank you for your appreciation. I am glad you find it useful.

Yes, sorry, currently not possible. Revit 2013 provided a first stab at a schedule API, to be fledged out in future, e.g. to access individual values.

Cheers, Jeremy.

Hi Jeremy,

Do you know if it will be possible to iterate/modify data directly in schedule in Revit 2014 API? It would be far more elegant solution to write directly into schedule.

Thanks,

Maja

Dear Maja,

Yes, sure, it is. Take a look at the fourth bullet item here:

http://thebuildingcoder.typepad.com/blog/2013/03/revit-2014-api-and-room-plan-view-boundary-polygon-loops.html

Look at the presentation, recording and sample code provided there.

Look at the overview of the 'ViewSchedule changes' in the What's New in the Revit 2014 overview:

http://thebuildingcoder.typepad.com/blog/2013/04/whats-new-in-the-revit-2014-api.html

Look at the new ScheduleAutomaticFormatter, ScheduleCreation and ScheduleToHTML SDK samples.

Cheers, Jeremy.

Hi Jeremy!

Is it possible to populate a Schedule Key from excel, without assigning the parameters to any instance?

I would like to create a shedule key to have drop down lists, following a work a quantities map from excel. Only then i would assign the keys to the elements i choose an that way i would have an optimizes process to create and update the maps for each project.

Also i tried to install you Scheduledata sample, but i´m not getting it right. It would be nice to have it functioning to understand a little bit better the programming language needed to work around the schedules data.

I have the plug-in installed but when i run it i get the following message:

"Revit encountered a Autodesk.Revit.Exceptions.ArgumentException: Contains invalid characters
Parameter name:mane at Autodesk.Revit.DB.ViewSchedule.Export(String folder, String name, ViewScheduleExportOptions options) .... "


Any idea of what the problem is?

Dear Rui,

I am not a user so I have no idea what a schedule key is.

Ask me about extensible storage instead :-)

http://thebuildingcoder.typepad.com/blog/2013/03/cloud-mobile-extensible-storage-data-use-in-schedules.html#4

From Revit 2014 onwards, you can populate schedule data directly:

http://thebuildingcoder.typepad.com/blog/2013/04/whats-new-in-the-revit-2014-api.html > ViewSchedule changes.

I have no idea what might be causing your error.

I suggest working through the Revit API getting started material and learning to use the Visual Studio debugger to see for yourself what is going on:

http://thebuildingcoder.typepad.com/blog/about-the-author.html#2

Good luck!

Cheers, Jeremy.

Thanks Jeremy!

I Really have to take some of my spare time to look through that getting started info and understand more clearly the whole process.

If i run into any problems taking these steps i will bug you again ;)

Once again thank you for your support and your contribute to the Revit community!

Cheers, Rui Gavina

Dear Rui,

My pleasure entirely.

Best of luck to you!

Cheers, Jeremy.

Hi Jeremy!
I try to make out Revit API as well as English language.
So, I have some questions.
Is it possible to create parameters within API? For example, I wish to get level as a parameter and to make it as a column.

Regards, Alexander.

Dear Alexander,

Yes, sure. E.g.,

http://lmgtfy.com/?q=building+coder+create+shared+parameter

Cheers, Jeremy.

Dear Jeremy,
We can access into table data of Schedule to get text in cell. So can we get elementIDs on row of Schedule?

Thanks.

I found a way to access the scheduled items, using the schedule filters, it is useful for me

Dear Manuel,

Cool. Congratulations. Thank you for letting us know.

Cheers, Jeremy.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Your Information

(Name and email address are required. Email address will not be displayed with the comment.)

Jeremy Tammik

AboutTopicsIndexSource