Author Topic: write-line, wrong-line  (Read 7449 times)

0 Members and 1 Guest are viewing this topic.

daron

  • Guest
write-line, wrong-line
« Reply #15 on: September 24, 2004, 11:42:29 AM »
Isn't Autocad already full of reactors: i.e. most double click properties? I know I'm not the first to think about mtatts, but it is something I might have more of a need for now than ever. We are restructuring our spec book, which gets rewritten for each job. The designer that is developing the new spec book wants to take it out of excel, which it's currently in (she's cool), and put it in autocad. Attributes won't work because the info is too dynamic, so she's considering mtext. Our project managers are in the habit of copying what's in the excel spec book and creating a shiplist with it. If they don't have the excel version, they have to type out the entire thing. I know how frustrating that can be, so I wanted to make a program that would export the specs itno excel for the PM's.

If you want to covert it to activex, I wouldn't mind, but I've noticed that if objects don't get released, my computer at work slows down to a snails pace. It's probably best to stay away from ActiveX at least on my end.

MP

  • Seagull
  • Posts: 17750
  • Have thousands of dwgs to process? Contact me.
write-line, wrong-line
« Reply #16 on: September 24, 2004, 12:30:20 PM »
Quote from: Daron
Isn't Autocad already full of reactors?

Yup, that's my point :)

Quote from: Daron
I know I'm not the first to think about mtatts, but it is something I might have more of a need for now than ever. We are restructuring our spec book, which gets rewritten for each job. The designer that is developing the new spec book wants to take it out of excel, which it's currently in (she's cool), and put it in autocad. Attributes won't work because the info is too dynamic, so she's considering mtext. Our project managers are in the habit of copying what's in the excel spec book and creating a shiplist with it. If they don't have the excel version, they have to type out the entire thing. I know how frustrating that can be, so I wanted to make a program that would export the specs itno excel for the PM's.

As much fun as it is designing and coding systems like this have you considered any pre-canned third party apps, like
    http://www.dotsoft.com/word2cad.htm,
    http://www.dotsoft.com/autocell.htm,
    http://www.dotsoft.com/xl2cad.htm
    [/list:u]?
    Quote from: Daron
    If you want to covert it to activex, I wouldn't mind, but I've noticed that if objects don't get released, my computer at work slows down to a snails pace. It's probably best to stay away from ActiveX at least on my end.

    That kind of slowdown is typical of the improper release of objects created with vlax-create-object. I see no need for the use of said function, unless you're going ObjectDBX. But having said that, any ObjectDBX code would be ancillary [external] to my little function -- as I see it you'd just pass the document object to my function, it would scan for the intelligence and then be done with it. The caller would be responsible for creating, passing and releasing the document object. How's that for side stepping responsibility? :)
    Engineering Technologist • CAD Automation Practitioner
    Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
    cadanalyst@gmail.comhttp://cadanalyst.slack.comhttp://linkedin.com/in/cadanalyst

    MP

    • Seagull
    • Posts: 17750
    • Have thousands of dwgs to process? Contact me.
    write-line, wrong-line
    « Reply #17 on: September 24, 2004, 02:04:42 PM »
    Converted program to activex variant, please see this.
    Engineering Technologist • CAD Automation Practitioner
    Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
    cadanalyst@gmail.comhttp://cadanalyst.slack.comhttp://linkedin.com/in/cadanalyst

    daron

    • Guest
    write-line, wrong-line
    « Reply #18 on: September 25, 2004, 03:46:25 PM »
    Thanks MP.

    MP

    • Seagull
    • Posts: 17750
    • Have thousands of dwgs to process? Contact me.
    write-line, wrong-line
    « Reply #19 on: September 25, 2004, 04:23:35 PM »
    You're welcome Daron. :)
    Engineering Technologist • CAD Automation Practitioner
    Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
    cadanalyst@gmail.comhttp://cadanalyst.slack.comhttp://linkedin.com/in/cadanalyst

    sinc

    • Guest
    write-line, wrong-line
    « Reply #20 on: September 27, 2004, 09:17:14 PM »
    Quote from: MP

    For example, if there were 3 attribute values for a single block instance like:
    "Some data"
    "Some more data"
    "And yet, more data"

    It would be exported to the CSV file as
    Some data,Some more data,And yet[Cedilla] more data

    Ah, OK.  But still, whatever reads your pseudo-csv file needs to replace cedillas with commas.

    Anything that can parse a CSV file will be able to read your file if you instead export it as:
    Code: [Select]
    Some data,Some more data,"And yet, more data"
    If you want to include data that includes double-quotes, you need to enclose the entire field in double-quotes, and then put two quotes back-to-back where you want a single double quote to appear.  For example, the following includes two data items,
    'Storm Drain' and '36" RCP':
    Code: [Select]
    Storm Drain,"36"" RCP"
    This is the definition of the CSV format.  Anything that can parse a CSV file can parse data formatted in this manner without any issues.