+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 11 to 17 of 17
  1. #11
    Luminous Being
    Using
    Civil 3D 2016
    Join Date
    Dec 2005
    Location
    GEELONG AUSTRALIA
    Posts
    9,899

    Default

    Registered forum members do not see this ad.

    Copy and paste the code into notepad save as say Lothatch.lsp the data file is just as per example below, then Appload choose Lothatch.lsp

    lotnum,layername
    lotnum,layername
    lotnum,layername

    106,10% built

    It works on your dwg do you know how to create this simple file from excel ?

    I could have done more re finding file but thats what learning is about search for FINDFILE examples
    A man who never made mistakes never made anything

  2. #12
    Forum Newbie
    Using
    AutoCAD 2014
    Join Date
    May 2014
    Posts
    7

    Default

    Hello CAD wizards. Thank you all for you insight and help. I am presently researching and slowly teaching myself LISP. As for the code kindly submitted above by "BIGAL" with help from "lee-mac", im not sure how to implement this. Would this code be for cad itself or for excel, or perhaps both. Perhaps in time I will understand this further, but with time constraints I'm hoping someone may have the time to review what has been suggested and give me some direction as to implementing such a code.


    Look forward to your imput

  3. #13
    Luminous Being
    Using
    Civil 3D 2016
    Join Date
    Dec 2005
    Location
    GEELONG AUSTRALIA
    Posts
    9,899

    Default

    Ok save code to notepad change the 1 line to this (setq fopen (open "c:/users/test.csv" "R")) and save as a lisp file hatchlots.lsp

    Copy this to notepad and save as c:\users\test.csv
    Code:
    106,10% complete
    107,20% complete
    108,30% complete
    109,40% complete
    Then
    appload hatchlots.lsp

    dwg should be different now
    A man who never made mistakes never made anything

  4. #14
    Forum Newbie
    Using
    AutoCAD 2014
    Join Date
    May 2014
    Posts
    7

    Default

    Hello bigal, I created a csv file as instructed with one column lotnum and one column as layer name. I then created a mm.lsp using the code you provided but have been unable to get this to work. after appload I chose the lisp file, then cad ask for file name Am I missing a step or perhaps misunderstand some of your direction?
    I have attached the csv file (created in excel) and the lisp file for your review.

    thanks
    Attached Files
    Last edited by mjm; 2nd Jun 2014 at 04:29 pm.

  5. #15
    Forum Newbie
    Using
    AutoCAD 2014
    Join Date
    Sep 2014
    Posts
    3

    Default

    Has anyone figured this out if it actually works? This is exactly what I am looking for.

  6. #16
    Luminous Being
    Using
    Civil 3D 2016
    Join Date
    Dec 2005
    Location
    GEELONG AUSTRALIA
    Posts
    9,899

    Default

    I wrote it and it works did you try it ?
    A man who never made mistakes never made anything

  7. #17
    Forum Newbie
    Using
    AutoCAD 2014
    Join Date
    Sep 2014
    Posts
    3

    Default

    Registered forum members do not see this ad.

    I followed the steps from your posts above, however I'm having the same issues as mjm. I appload the lisp file, then it says "Unable to recognize command "hatchlots.lsp" Please Try again" It Then asks for a file name, and when i click on that it says bad argument type. Not sure whether I'm missing a step or something? should the tagged lots in the drawing change colors for the specific ones used in the test csv file?

Similar Threads

  1. Data Extraction to Excel turns data into dates.
    By arkitectin in forum AutoCAD Drawing Management & Output
    Replies: 2
    Last Post: 8th May 2014, 05:31 pm
  2. Extracting Data from Excel to CAD or CAD to Excel
    By shivakumar in forum AutoCAD LT
    Replies: 20
    Last Post: 3rd Sep 2013, 07:40 pm
  3. Can't edit attribute when inserting excel data that has 3 lines of data
    By Findermb in forum The CUI, Hatches, Linetypes, Scripts & Macros
    Replies: 2
    Last Post: 12th Jun 2013, 02:34 pm
  4. Replies: 2
    Last Post: 5th Jan 2011, 09:40 pm
  5. Data Link Auto Update
    By guitarguy1685 in forum AutoCAD Drawing Management & Output
    Replies: 0
    Last Post: 17th Aug 2010, 07:57 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