Donate Now Goal amount for this year: 3000 USD, Received: 1207 USD (40%)

Results 1 to 8 of 8
Like Tree6Likes
  • 3 Post By josephpeel
  • 1 Post By amoursol
  • 1 Post By cellophane
  • 1 Post By josephpeel

Thread: Sheet Renumbering

  1. #1
    Moderator cellophane's Avatar
    Join Date
    August 9, 2011
    Location
    Louisville, KY
    Posts
    6,104
    Current Local Time
    12:52 AM

    Sheet Renumbering

    Dumb question on renumbering sheets: Usually when I need to renumber sheets it is because I have to add a sheet which throws off my sequencing. I can export sheets and renumber in excel with no problems but I hit an issue when I bring things back into Revit since the sheet numbers technically already exist. Is there a way around this that I'm just missing other than swapping letters around - i.e. A101 to B101 to A102?

  2. #2
    Forum Co-Founder Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    10,036
    Current Local Time
    11:52 PM
    Depends how you are doing the renumbering from excel: you have to use a tool that let's you specify the processing order, and can work from the top down. I don't recall if yoy can do that with Spreadsheet a link or not. But I imagine you can if you resort the lists a certain way?

  3. #3
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,396
    Current Local Time
    06:52 AM
    You could do it with excel if you add an extra step. First import/change all your sheet numbers to something else (Like add a letter to the end of the existing numbers, still unique), then import the actual numbers you want.

    Personally I made a simple 'Find and replace' tool in dynamo for both sheet and view names. Extremely useful when you want to adjust part of the name for all sheets.
    amoursol, cellophane and cganiere like this.

  4. #4
    Senior Member amoursol's Avatar
    Join Date
    November 21, 2012
    Location
    London, United Kingdom
    Posts
    612
    Current Local Time
    05:52 AM
    Joseph's right, you simply need to add into your script an interim step that renames them to something arbitrary first.

    Exiting Names -> Arbitrary (So no conflict) -> New names (Utilising some existing names).

    You can use the Clockwork node Passthrough to make sure that your Dynamo sequencing executes in the correct order.
    cellophane likes this.

  5. #5
    Moderator cellophane's Avatar
    Join Date
    August 9, 2011
    Location
    Louisville, KY
    Posts
    6,104
    Current Local Time
    12:52 AM
    Thanks!

    Quote Originally Posted by josephpeel View Post
    Personally I made a simple 'Find and replace' tool in dynamo for both sheet and view names. Extremely useful when you want to adjust part of the name for all sheets.
    Is that something you can share? I'm good with just a screenshot - helps me figure things out on my end if I actually have to build it

    Quote Originally Posted by amoursol View Post
    You can use the Clockwork node Passthrough to make sure that your Dynamo sequencing executes in the correct order.
    I'll take a look at it and see what I can muddle together.
    amoursol likes this.

  6. #6
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,396
    Current Local Time
    06:52 AM


    Something like this
    Attached Thumbnails Attached Thumbnails Sheet Renumbering-findreplace.jpg  
    cganiere likes this.

  7. #7
    Moderator cellophane's Avatar
    Join Date
    August 9, 2011
    Location
    Louisville, KY
    Posts
    6,104
    Current Local Time
    12:52 AM
    Cool! One quick question: Is the Change View Name node a boolean that you renamed?

  8. #8
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,396
    Current Local Time
    06:52 AM
    yep. I just gave then names to show what they do.
    Probably better to rename them "Boolean - do stuff" to avoid confusion.

Similar Threads

  1. Room Renumbering Effect on MEP
    By Juniper01 in forum MEP - General
    Replies: 5
    Last Post: April 1st, 2016, 08:55 PM
  2. Renumbering views on sheets
    By Juniper01 in forum Architecture and General Revit Questions
    Replies: 0
    Last Post: October 22nd, 2015, 03:09 PM
  3. Revisions and renumbering (2014)
    By Jrobker in forum MEP - General
    Replies: 22
    Last Post: March 31st, 2015, 05:57 PM
  4. Renumbering Objects with the same mark - macro?
    By cellophane in forum Third party Add-Ins, API and R&D
    Replies: 5
    Last Post: January 27th, 2013, 06:53 PM
  5. Replies: 0
    Last Post: June 25th, 2012, 06:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •