TheSwamp
CAD Forums => CAD General => Dynamic Blocks => Topic started by: ChrisCarlson on May 05, 2014, 08:14:29 AM
-
Is there a "quicker" way to import or enter 72,000 line entries into a lookup table?
Other than this..
(http://i60.tinypic.com/2nspc44.jpg)
-
probably with some code magic
72,000 lines?
What is this block doing?
-
Block is generating part numbers based on length and width.
Widths are increments of 6 units (inches) up to 216 units (18 feet)
Lengths are increments of 6 units (inches) up to 1200 units (100 feet)
Comes out to 7200 possible part numbers per visibility state with 10 states per block.
I don't mind reading if someone has an old tutorial or white paper talking about this
-
Can't you use an array inside the block?
-
That's what I'm doing, the length and width feed the input properties with the lookup property by combining the two values with other nomenclature required for the part number.
-
Sorry, I mean the XY Stretch Box Set (Parameter Sets) where you can set the stretch for X and Y with a minimum, a maximum, and the increment.
Then you don't need to fill a huge list. Just grippoints to stretch or Properties to set the block as you want it.
-
to me it sounds like he's looking for a way to copy a spread sheet into the table.
The combination of the two parametric values (X & Y) needs to match up with a specific part number, correct?
I don't have a solution, i'm just reiterating for clarity...
-
Correct
Basically a block with dimensions 24" x 120" will create a "part number", I'm drawing a blank on the proper term (not an attribute but lookup value maybe?) of MAT2106OEM. This way I can print out a BOM from DataExtraction of all mat sizes required. I tried copying and pasting into AutoCAD from Excel but it attempted to fit all the data into one cell :realmad:
MAT = Nomenclature
2 = Width
10 = Length
6OEM = Nomenclature