topic Re: Automatic numbering in schedules in Project data & BIM

Automatic numbering in schedules

HelenE — Wed, 20 Nov 2024 14:19:18 GMT

Hello!

I have a question I wanted to ask all of you regarding automatic numbering in schedules. I have created a door schedule based on the type of door it is (ie wooden interior door). Let's say that I have 20 such doors in that project. I would like the first column to have the numbers in ascending order, listing these doors. Right now I'm forced to manually enter this information in each cell which is tedious when there are a lot of windows or doors. Is this automatic numbering possible? I've tried to indicate what I mean in the attached image.

Re: Automatic numbering in schedules

Gerry Leonor — Tue, 04 Oct 2022 07:52:51 GMT

made a MS Teams Wiki post for our office.

Apologies, but i've had to resort to screenshots to get the info, as they currently do not allow a PDF print from MS Teams > Wiki.

I'm sure other people have a cleaner way to do it, but this is how i've been doing it.

"in other related news"...now that you've got the doors/windows auto-numbered, time for you to single-click tag them:

Re: Automatic numbering in schedules

HelenE — Tue, 04 Oct 2022 10:21:30 GMT

Thank you so very much for your prompt reply! I will try it and let you know!

Re: Automatic numbering in schedules

Daniel Pataki — Wed, 05 Oct 2022 10:51:17 GMT

Hello, I would recommend the Import/Export Property Data Interoperability Function.

Import/Export Property Data via Spreadsheet (Graphisoft.com)

Prepare an empty column in AC, export your list, create the numbers quickly in Excel and import back.

Of course you still need to redo this steps, if you have a new door. But still way faster than one by one...

Re: Automatic numbering in schedules

HelenE — Thu, 06 Oct 2022 07:27:06 GMT

Hi Daniel, thank you so much for replying. I tried following the steps in the link you shared but when I went to import the schedule back into Archicad it said "Nothing to import. No property values are selected or none are valid for import." Do you why this is? Thank you so much.

Re: Automatic numbering in schedules

Daniel Pataki — Thu, 06 Oct 2022 08:06:33 GMT

There is already a thread about this: Re: Importing Excel File, nothing to import? - Graphisoft Community

According to them:

Solution 1, if you turn off the headline... weird, but try...

Solution 2, "make sure the first value of each column has a value when importing."

Other guesses:

Maybe you tried to overwrite a custom field or the element-id. This method only works with properties you created in property manager and also properly assigned to the relevant classification of the doors. But this shouldnt block the whole list...

Re: Automatic numbering in schedules

HelenE — Thu, 06 Oct 2022 08:33:26 GMT

Hi again! I tried following all the steps you showed me (thank you again!) but once I've added the temporary id to the label I created, I don't know what to do next. How do import these numbers into my door and window schedule?

Re: Automatic numbering in schedules

HelenE — Thu, 06 Oct 2022 08:42:56 GMT

Ah thank you once again!!

Re: Automatic numbering in schedules

Gerry Leonor — Thu, 06 Oct 2022 12:50:53 GMT

when you say you've added the temporary ID, you sound like you went as far as step 2. you still need to do the steps that involve the Element ID Manager.

it's basically this:

https://youtu.be/5KHkh6vcuZA?t=112

i've linked the video to start just before the 2-minute mark, just to skip the prelude. it's the same point i'm trying to make.

select the door/window elements you want to number in a certain sequence
change them in the Element ID manager

now for you to add it in your door/window schedule, you'll need to make sure that you have added the Element ID in the Fields in the Schedule Settings Dialogue Box.

Re: Automatic numbering in schedules

HelenE — Thu, 06 Oct 2022 14:57:06 GMT

Thank you Gerry!!!

Re: Automatic numbering in schedules

brainclosely — Wed, 01 Feb 2023 16:56:59 GMT

Thank you for your response. I figured it out.

coreball

Re: Automatic numbering in schedules

LoisCook — Tue, 19 Nov 2024 10:30:10 GMT

Assign a shared parameter to doors if one is not already in use.

getaway shootout

Re: Automatic numbering in schedules

Ricardo Lopez — Wed, 20 Nov 2024 13:49:49 GMT

Hi @HelenE

There is also an option to automatically create an ID based on criteria. Maybe that could work for you as well. Check the link below:

>>> ID Manager <<<

Regards.