parameterizing/dageg blocks

[Iraz]

Good morning to all, it has been a long time since I follow the forum, it is for me an inexhaustible source of information, but unfortunately I am not yet able to give answers and help to other users. I usually lose some time looking in the old posts solutions to my problems, but this time I can't.

I would like to parameterize blocks in autocad 2010. I press that I was accustomed to the previous work with inventor first and then solid works, excellent software that allowed me a lot of things and, after learning a little to use them, I went to the parameterization of the models I created.
Now I have to address a different speech: I work in the photovoltaic and I have to "name" all my modules installed following the reading of the serial number. My computer colleague asks me if you can tie an excel table to the various fv modules so as to register them after reading the code in the drawing.
I thought about the parameterization, even if maybe it's not correct. Maybe it's more of a "dynamic" of the blocks.
understand that appointing an entire photovoltaic field where it has thousands of modules is time consuming and I would like to automate the thing: Plus I should tie each module to a cell in the excel file.

Is this possible or do I claim the moon?

Thank you, hello to all

 

[PlannerRoad]

but is each module geometrically different than the others? or just change the code?

 

[Iraz]

Just change the code. I usually use blocks to create modules and then replicate them so as to keep properties, make counts, etc.
I even have blocks with multiple modules in some cases (create a "vela" with 15-20 modules) and repeat them.
Now I don't know if I have to create as many blocks as the modules, but it seems really stupid!
I would like to understand if I can insert a text box that goes with a formula type n=n+1 to each next block.

 

[PlannerRoad]

If the module always remains the same, only one block will be enough to copy how many modules are.
to do what you want you have to use attributes. But now I don't know how to automate them with a n=n+1 formula to each copy of a block.
but the data must go from autocad to excel, or from excel to autocad?

 

[Tristan]

Why not use a db access instead?

 

[Tristan]

Just change the code. I usually use blocks to create modules and then replicate them so as to keep properties, make counts, etc.
I even have blocks with multiple modules in some cases (create a "vela" with 15-20 modules) and repeat them.
Now I don't know if I have to create as many blocks as the modules, but it seems really stupid!
I would like to understand if I can insert a text box that goes with a formula type n=n+1 to each next block.

no; but you can do it with some programming in lisp probably

 

[Iraz]

data range from excel (or access, it was to do the example, then you will decide what software to use) in autocad. from the answers it seems to me that you can not do, even planner road recommends the attributes.. I never used them. Now I study them.
I thank you for the help!

 

[lelebianconero]

Hey, if it can help, I got the same problem.
In practice I had a series of drawings within which I had to automatically report the values taken from an excel file.
In the end, through my computer colleague, we did so: I created a model with pluto duck in the positions concerned and I saved the file in dxf.
then opening the dxf through a text editor and making some attempts, we searched for the address to which these known words were found and from there it was easy to write a few lines of code to search in those files the words concerned and replaced them according to our rules.
and I have to say that it works to the great without having to pass from lisp that is very powerful but difficult to understand