×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Custom background sheets

Custom background sheets

Custom background sheets

(OP)
Is there a list anywhere of the available variables that you can insert on the background sheets?

example from whats there already:
%{Author}
%{Created/@MM/dd/yy}
FILE NAME: %{File Name}
SHEET %{Sheet number} OF %{Number of Sheets}

actually, I think I just found it under the callout property text.

More importantly though.  how can I link an Excel cell to the background sheet.  I'm trying to insert barcodes into our drawings.

RE: Custom background sheets

Click the Callout command and the Callout Properties dialog box will appear.
In the Callout Properties dialog box, click on the Property Text icon (the icon with a hand and an A). Select Property Text dialog box will appear; you’ll see a list of properties that you’re looking for. Take note on the options available.

With SE16 it’s possible to Expose the variables. If you link an Excel file to a variable and Expose it, you will see the exposed variable in Select Property Text dialog box; depending on the option selected.

I will try to answer if you need further explanation on the options.


HTH

Regards

fwc


RE: Custom background sheets

(OP)
Excellent, I was wondering what the expose did.  still dont see a way to link barcodes from the excel sheet to the drawing, but thank you!

RE: Custom background sheets

Hi

If the barcode is in a single cell in Excel file, copy and paste the cell into the variable in part environment. Expose the linked variable and type Barcode in the Exposed Name cell.

In Draft environment, click the Callout command and type %{Barcode|R1} in Callout Text field of the Callout Properties dialog box then click the OK button. Click anywhere to your preference to place the Callout.

When you create a drawing view of the part; the Barcode number will appear.

You may want to do this.
Once the Drawing View is created; select Index Reference option in Select Property Text dialog box. The Barcode will also appear in the Properties list. The Barcode will not appear if there is no Drawing View of that part in the Draft.

HTH

Regards
fwc

RE: Custom background sheets

(OP)
Just what I needed, Thanks I really appreciate it!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources