Inventor General Discussion

Reply
Contributor
aaron.seifert
Posts: 23
Registered: ‎08-04-2009
Message 1 of 9 (493 Views)
Accepted Solution

Decals in Excel

493 Views, 8 Replies
08-07-2012 01:40 PM

I have all my pipe decals in excel per ANSI standards (see attached).  Do I realy have to create 64 separate files for each decal?

*Expert Elite*
blair
Posts: 3,954
Registered: ‎11-13-2006
Message 2 of 9 (479 Views)

Re: Decals in Excel

08-07-2012 01:52 PM in reply to: aaron.seifert

In a short form "Yes" if you only want one line and the required direction. Perhaps a iLogic guru might be able to or possibly a factory part with a lookup table for process and direction.

 

How would they do it in real life, A decal for each process and a direction arrow that can be flipped, or Process and LH decal and Process and RH decal?

Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.

IV2015 up1 PDSU / Sim Mech 2015 /
Win7-64
EVGA X79 - Classified, iCore7 3930k 32Gb Quad-Channel
950Gb (2 x 500Gb Sata III SSD RAID0 Adaptec 6805E Controller)
Nvidia GTX-690 Classified - 335.23
SpacePilot Pro 3.17.7, 6.17., 4.11
*Expert Elite*
Curtis_Waguespack
Posts: 2,815
Registered: ‎03-08-2006
Message 3 of 9 (478 Views)

Re: Decals in Excel

08-07-2012 02:02 PM in reply to: aaron.seifert

Hi aaron.seifert,

 

Are you wanting to use a screen capture of the excel file as a decal, or are you wanting to read in the text and emboss it into an extrude feature? Can you post the Excel file?

 

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com

 

 

 

 



  solution.png  Did you find this reply helpful ? If so please use the Accept as Solution or  Kudos button below.





Valued Contributor
dane_m_steyne
Posts: 92
Registered: ‎10-01-2011
Message 4 of 9 (399 Views)

Re: Decals in Excel

08-17-2012 04:30 AM in reply to: Curtis_Waguespack

Hi Curtis,

 

I am looking to do the same.How could i do the "screen capture" and then use as a decal.Also can the decal be added to either the part or to a part in an assembly?

 

I made an example IV2013 pipe in which the long number in the excel 2010 sheet will run verticle on the pipe and also a square shaped number for placing in the middle of the pipe.The numbers are on a white background with a black border.How would i apply the numbers from the spreadsheet onto the parts as a DecaL

I have attached the IV2013 part and the Excel 2010 spreadsheet

 

Much appreciated

 

Dane

*Expert Elite*
Curtis_Waguespack
Posts: 2,815
Registered: ‎03-08-2006
Message 5 of 9 (336 Views)

Re: Decals in Excel

08-26-2012 09:26 PM in reply to: aaron.seifert

Hi dane_m_steyne,

 

Here is a data set (2013 files) with an iLogic configured label. You can use the form to set the label text and the bend diameter (diameter of the pipe it will wrap to). To place it in an assembly, use the Place iLogic Component tool to place the file named LB-7832.ipt. This will generate a new file depending upon the selections you make.

 

You can look at the LB-7832.ipt file to see how it was created. If it's not clear just ask and I'll explain what is going on in the part.

 

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com



  solution.png  Did you find this reply helpful ? If so please use the Accept as Solution or  Kudos button below.





*Expert Elite*
Curtis_Waguespack
Posts: 2,815
Registered: ‎03-08-2006
Message 6 of 9 (301 Views)

Re: Decals in Excel

08-27-2012 07:56 AM in reply to: Curtis_Waguespack

attached file



  solution.png  Did you find this reply helpful ? If so please use the Accept as Solution or  Kudos button below.





Valued Contributor
dane_m_steyne
Posts: 92
Registered: ‎10-01-2011
Message 7 of 9 (279 Views)

Re: Decals in Excel

08-28-2012 07:01 AM in reply to: aaron.seifert

Hi Curtis

 

That is exactly what i wanted.Thank you

 

I tried in the assembly and it is excellent.

 

I do have a further question please.

 

1. I am new to iLogic.Is it possible in the iLogic code to change the reference numbers from ABC-0001 / ABC-0100 to say BSC-001 / BSC--100 as an example ?

 

2. Where can i view the code.You have set this up brilliantly

 

3. Also can the diameter in the code be changed to other values ?

 

Are you a programmer or did you learn the iLogic feature by teaching yourself.I see you have a book out Inventor 2013....do you teach iLogic in this book?

 

Again thank you.Appreciated

 

Dane

*Expert Elite*
Curtis_Waguespack
Posts: 2,815
Registered: ‎03-08-2006
Message 8 of 9 (268 Views)

Re: Decals in Excel

08-28-2012 08:31 AM in reply to: dane_m_steyne

Hi dane_m_steyne,

 

1. I am new to iLogic.Is it possible in the iLogic code to change the reference numbers from ABC-0001 / ABC-0100 to say BSC-001 / BSC--100 as an example ?

You can change these as needed by going to the Manage tab > Parameters button and right-clicking on the  label text parameter and choosing Edit Multi Value List

 

2. Where can i view the code.

In this particular file there really isn't any programming code, all of the magic is handled by the iLogic tools, specifically the Forms tools. To access these tools you can go to the Manage tab > iLogic panel > Edit iLogic Tree button, and then you'll see a forms tab. Right click on the form and choose Edit Form (or something like that, I can't look at it just now).

 

3. Also can the diameter in the code be changed to other values?

You can change the diameters as needed by going to the Manage tab > Parameters button and right-clicking on the parameter and choosing Edit Multi Value List, just as you did the label text parameter.

 

4. Are you a programmer or did you learn the iLogic feature by teaching yourself.I see you have a book out Inventor 2013....do you teach iLogic in this book?

Indeed I'm self taught, and I think a real programmer would tell you that I'm a bit of a hack, and not a programmer :smileywink:. I do cover the iLogic tools in the Mastering 2013 book, devoting the last chapter to iLogic. It covers the basics and goes maybe just a step or two deeper.

 

Another good resource to start off with iLogic are the Autodesk provided tutorials:

These tutorials are probably as good as any other way to become familiar with the basics of iLogic. Once you've done them you'll find the other resources (books, blog posts, etc.) easier to understand.

 

My suggestion is to start off simple working through the first two  tutorials and then take some time to try to automate simple tasks with your own part files that you already know how to do in Inventor. For instance, change a part size, change a part color, set a part number, change a description, etc. Then go back and do the 3rd tutorial that deals with assemblies.

 

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com

 



  solution.png  Did you find this reply helpful ? If so please use the Accept as Solution or  Kudos button below.





Valued Contributor
dane_m_steyne
Posts: 92
Registered: ‎10-01-2011
Message 9 of 9 (247 Views)

Re: Decals in Excel

08-28-2012 03:12 PM in reply to: aaron.seifert

Hi Curtis

 

Thank you for all the help.I will use your tips

 

Best Regards

 

Dane

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor

Twitter

Facebook

Blogs

Pinterest

Youtube