+ Reply to Thread
Results 1 to 9 of 9
  1. #1
    Junior Member
    Using
    AutoCAD 2010
    Join Date
    Jul 2010
    Location
    Northants UK
    Posts
    21

    Default Renaming Layouts from a Spreadsheet

    Registered forum members do not see this ad.

    Hi all,

    Is it possible to rename layouts from a spread sheet or table within a drawing?

    I have loads of drawings which require the layouts renaming i to a protocol and renaming individually takes ages while the layout regenerates.

    Your help would be most appreciated

    Stenna

  2. #2
    Forum Deity pBe's Avatar
    Computer Details
    pBe's Computer Details
    Operating System:
    Windows 8.1
    Discipline
    Landscape
    Using
    AutoCAD 2015
    Join Date
    Apr 2010
    Posts
    2,951

    Default

    From an Excel file stenna? in what format does it shows the old_name and new_name for the layouts?

  3. #3
    Junior Member
    Using
    AutoCAD 2010
    Join Date
    Jul 2010
    Location
    Northants UK
    Posts
    21

    Default

    Excel would be good if it's possible.
    I currently have a phasing template which splits each phase of work into a different layout. the client has requested that the date be added to the layout tab for easy recognition. A typical 'can you just' request
    So the renaming would go from P1 to P1 Sat 31 for example
    Shout if you need further information
    Stenna

  4. #4
    Forum Deity pBe's Avatar
    Computer Details
    pBe's Computer Details
    Operating System:
    Windows 8.1
    Discipline
    Landscape
    Using
    AutoCAD 2015
    Join Date
    Apr 2010
    Posts
    2,951

    Default

    Look, i did not say it would be an excel file . I'm asking what is the format of your data [source] for renaming the layout tabs. We here need a basis for the program i.e. "what is" and "what will" as to automate the process.

    How'd you come up with P1 to P1 Sat 31? whats the basis for that and the subsequent numbers thereafter? is there more than one layout tab per drawing? or the numbers varies from one file to another?

    BTW: check the "similar threads" shown at the bottom of this page.

  5. #5
    Forum Deity Organic's Avatar
    Discipline
    Civil
    Using
    AutoCAD not applicable
    Join Date
    Feb 2009
    Posts
    2,338

    Default

    A great program I use all the time is http://www.lee-mac.com/tabsort.html.

  6. #6
    Junior Member
    Using
    AutoCAD 2010
    Join Date
    Jul 2010
    Location
    Northants UK
    Posts
    21

    Default

    Quote Originally Posted by pBe View Post
    How'd you come up with P1 to P1 Sat 31? whats the basis for that and the subsequent numbers thereafter? is there more than one layout tab per drawing? or the numbers varies from one file to another?
    pBe

    The current Layout name is P1 and the sequencing would got along these lines;

    P1, P1A, P2, P2A, P3, P3A and so on up to anything near P15.
    P=Phase #=Phase Number

    The new naming protocol would be (from the spreadsheet/table) it would be something along the lines of but the dates will change on every project P# remains the same

    P1-Sat31, P1A-Sat31, P2-Sun1, P2A-Sun1, P3-Mon2 etc
    P=Phase #=Phase Number - Sat31 = Date Format (or similar)

    Hope that makes things clearer

  7. #7
    Junior Member
    Using
    AutoCAD 2010
    Join Date
    Jul 2010
    Location
    Northants UK
    Posts
    21

    Default

    Organic,
    Many thanks for the post thats fantastic does just what I wanted.....Mr Lee Mac at his finest.
    Page has been bookmarked , lisp installed in start up.
    Thanks again
    Stenna

    PS pBe thanks for your help too

  8. #8
    Forum Deity pBe's Avatar
    Computer Details
    pBe's Computer Details
    Operating System:
    Windows 8.1
    Discipline
    Landscape
    Using
    AutoCAD 2015
    Join Date
    Apr 2010
    Posts
    2,951

    Default

    Quote Originally Posted by stenna View Post
    pBe ...
    The new naming protocol would be (from the spreadsheet/table) it would be something along the lines of but the dates will change on every project P# remains the same
    That is exactly what i'm asking for , where is that spreadsheet/table? or at least give us the format [lines where the data will be retrieved]
    Say P1 what's the basis for Sat31? will that be the current date? And you did not answer the number of layouts?

    P1, P1A, P2, P2A, P3, P3A and so on up to anything near P15. P=Phase #=Phase Numbe
    What does that mean? P1 to P1A for first layout tab? or first of a series of drawings?

    EDIT:
    Quote Originally Posted by stenna View Post
    ...Page has been bookmarked , lisp installed in start up.
    Thanks again
    Stenna

    PS pBe thanks for your help too
    Did not see your reply to Organic .. At least you have a working solution.

    All i did was asked a bunch of questions

    Good for you stenna

  9. #9
    Quantum Mechanic Lee Mac's Avatar
    Computer Details
    Lee Mac's Computer Details
    Operating System:
    Windows 7 Ultimate (32-bit)
    Discipline
    Multi-disciplinary
    Lee Mac's Discipline Details
    Discipline
    Multi-disciplinary
    Details
    Custom Programming / Software Customisation
    Using
    AutoCAD 2013
    Join Date
    Aug 2008
    Location
    London, England
    Posts
    19,322

    Default

    Registered forum members do not see this ad.

    Quote Originally Posted by stenna View Post
    Organic,
    Many thanks for the post thats fantastic does just what I wanted.....Mr Lee Mac at his finest.
    Page has been bookmarked , lisp installed in start up.
    Thanks again
    Stenna
    Many thanks Stenna - I'm glad you like the program!
    Thank you for the recommendation Organic
    Lee Mac ProgrammingTwitterExchange App StoreDropbox (500MB free)

    With Mathematics there is the possibility of perfect rigour, so why settle for less?

Similar Threads

  1. Renaming All Layouts consecutively
    By sephiroth11983 in forum AutoLISP, Visual LISP & DCL
    Replies: 4
    Last Post: 16th Nov 2012, 02:35 am
  2. X-Ref Renaming
    By Spinxy in forum AutoCAD Drawing Management & Output
    Replies: 9
    Last Post: 27th Jul 2011, 12:58 am
  3. X-ref renaming
    By Fanden in forum AutoCAD Drawing Management & Output
    Replies: 2
    Last Post: 19th Feb 2010, 09:40 am
  4. Renaming Layers
    By ALLI in forum AutoCAD Drawing Management & Output
    Replies: 4
    Last Post: 21st Nov 2008, 04:28 am
  5. Renaming Alignments
    By mikman in forum Civil 3D & LDD
    Replies: 2
    Last Post: 9th Jul 2008, 06:46 pm

Tags for this Thread

Bookmarks

Posting Permissions

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