CAD Forum - Database of tips, tricks and utilities for AutoCAD, Inventor and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 5446
Arkance Systems CZ
FB TW YT LN Blog
RSS channel - CAD tips RSS tips
RSS discussions

Discussion Discussion forum

 

HelpCAD discussion

 
CAD Forum - Homepage CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.

Please abide by the rules of this forum.

How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic ClosedRoom Numbers/Blocks/labels
 Post Reply Post Reply Page  <123>
Author
  Topic Search Topic Search  Topic Options Topic Options
Lokislady85 View Drop Down
Newbie
Newbie


Joined: 14.Oct.2014
Location: United States
Using: AutoCAD2014 LT, Inventor2012, 3DS MAX, FASTCAD7.5X
Status: Offline
Points: 17 		Direct Link To This Post Posted: 20.May.2015 at 16:37
I can't find the express tools in LT... CAD keeps telling me that the data upload should go to a table...
Back to Top
Lokislady85 View Drop Down
Newbie
Newbie


Joined: 14.Oct.2014
Location: United States
Using: AutoCAD2014 LT, Inventor2012, 3DS MAX, FASTCAD7.5X
Status: Offline
Points: 17 		Direct Link To This Post Posted: 19.May.2015 at 20:36
Here's an example of what we're trying to do...uploads/506613/Copy_of_Patch_panel_label_example_2.pdf
excel won't upload so pdf instead
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175 		Direct Link To This Post Posted: 19.May.2015 at 20:04
Maybe you can use Express Tools to accomplish the task?

In AutoCAD go to...

Express Tools > Blocks > Export Attribute Information > Specify Output File Name > Select Blocks.

Open the resultant text file in Excel, edit your attributes and "save as" a text file.  You can choose to overwrite the exported text file or create a new one.

Back in AutoCAD go to...

Express Tools > Blocks > Import Attribute Information > Select Saved Text File.

I tested the method using a simple block with one attribute (a room number) and it worked.

This method was originally suggested at CADTutor by someone calling themselves Newby Bern.
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175 		Direct Link To This Post Posted: 19.May.2015 at 18:42
Every time you expand upon a question I ask I can think of six more questions.  Maybe I should stop.

Post a sample drawing.  Perhaps that will clear up my confusion.
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>
Back to Top
Lokislady85 View Drop Down
Newbie
Newbie


Joined: 14.Oct.2014
Location: United States
Using: AutoCAD2014 LT, Inventor2012, 3DS MAX, FASTCAD7.5X
Status: Offline
Points: 17 		Direct Link To This Post Posted: 19.May.2015 at 18:29
Sigh, no we need numbers that update from excel with exact placement since the lables are perferated and standard sizing in a table ends up with at least one row (or more) of labels with perferations through the text. We also only want the text, no borders since these are small labels that need to be legible. We've been trying with blocks to get the placement but we still need this to update from excel...which is where a table would be nice (and we know how to remove the borders) and it links to excel but... the excel sheet is all single line, and the labels are double line (room number and slot #) which is not arranging well on the sheet...
So, yeah, how do you link a block attribute to multiple spots on an excel sheet?
As in excel=  line 1
          line 2
to...
AutoCAD Block=  attribute 1
               attribute 2  
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175 		Direct Link To This Post Posted: 19.May.2015 at 18:02
I thought all you were concerned about were the numbers?  Are you also trying to draw the lines that surround the numbers too?
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>
Back to Top
Lokislady85 View Drop Down
Newbie
Newbie


Joined: 14.Oct.2014
Location: United States
Using: AutoCAD2014 LT, Inventor2012, 3DS MAX, FASTCAD7.5X
Status: Offline
Points: 17 		Direct Link To This Post Posted: 19.May.2015 at 17:05
Less on how do I make a block with attributes and more how do I make an attribute from an excel spreadsheet...such as

xxxx           xxx


xxxx            xxx
                  xxx    


xxxx             xxx
                   xxx

right? and then link the xxx blocks to individual cells on the same spread sheet...
The spread sheet I have but double lines in excel are a pain as well as irregular spacing so...CAD?
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175 		Direct Link To This Post Posted: 19.May.2015 at 16:59
So how would you a) set up your attributed block and 2) set up the spreadsheet?
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>
Back to Top
Lokislady85 View Drop Down
Newbie
Newbie


Joined: 14.Oct.2014
Location: United States
Using: AutoCAD2014 LT, Inventor2012, 3DS MAX, FASTCAD7.5X
Status: Offline
Points: 17 		Direct Link To This Post Posted: 19.May.2015 at 16:51
Yes, because I really don't want the lines that come with a table...
Back to Top
John Connor View Drop Down
Senior Member
Senior Member


Joined: 01.Feb.2011
Location: United States
Using: AutoCAD 2018
Status: Offline
Points: 7175 		Direct Link To This Post Posted: 19.May.2015 at 16:20
The room number blocks are linked to a spreadsheet and you want to do the same thing?
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>
Back to Top

Related CAD tips:


 Post Reply Post Reply Page  <123>
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0,496 seconds.
CF
CAD Forum - tips, tricks, utilities, discussion for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, 3ds Max, Fusion 360 and other Autodesk software (support by Arkance Systems)
Arkance Systems CZ (CAD Studio) - Autodesk Platinum Partner & Training Center & Services Partner
CONTACT:
webmaster.cz@arkance-systems.com
tel. +420 910 970 111
  Copyright ©2024 | Advertise with us | Online privacy
FB TW YT LN Blog
TOPlist