Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Paramaterized Patterns using Excel Data

matt.culik
Contributor

Paramaterized Patterns using Excel Data

matt.culik
Contributor
Contributor

I'm trying to laser cut a foam socket organizer. I need a 2D DXF file for my laser cutter software. I have a bunch of sockets and a digital caliper that sends measurements to Excel at the click of a button. 

 

What I'd like to do is create a parameterized sketch block that includes a circle where the socket will sit and the socket label. Ideally, I'd be able to measure each socket, send the actual diameter to Excel, and add a standardized clearance amount and a label. Then, I'd assign the relevant column headers to my parameterized sketch block and Fusion 360 would spit out a sketch block for each socket. Then, I'd lay the blocks out, save the sketch as a DXF and go to town on the laser cutter.

 

Does anyone know if this can be done in Fusion 360? If not, is there any software you're aware of that can?

 

Thanks!

 

 

0 Likes
Reply
485 Views
7 Replies
Replies (7)

BrianEkins
Mentor
Mentor

Fusion doesn't have anything like a sketch block, but what you want to do would be simple enough to create directly in a sketch since it will just be placing circles and text. There are plenty of small samples in the API help that show how to create a sketch and draw a circle and text.

 

The Fusion API doesn't have anything to read from an Excel file, but Python does. There is some built-in capability to read from a CSV file, which will be the easiest.

---------------------------------------------------------------
Brian Ekins
Inventor and Fusion 360 API Expert
Website/Blog: https://EkinsSolutions.com
1 Like

matt.culik
Contributor
Contributor

@BrianEkins - Just confirming what I think you're saying...

 

Use Python to "pull" the data from CSV and then turn that data into a sketch by pushing it into Fusion using their API?

 

If I'm correct, that sounds interesting. I've never done any programming like that before, but it's been on my list of things to try/learn. 

 

Aside from creating the "sketch blocks," does the API have any functionality to automatically distribute/align them?

 

Thanks!

0 Likes

BrianEkins
Mentor
Mentor

You understand what I'm suggesting. There's nothing in Fusion, or the API, to help in organizing the shapes. You'll need to do that yourself in your code. When you create the geometry, you'll be defining the coordinates of the geometry and can calculate where it needs to be positioned.

---------------------------------------------------------------
Brian Ekins
Inventor and Fusion 360 API Expert
Website/Blog: https://EkinsSolutions.com
2 Likes

Jorge_Jaramillo
Collaborator
Collaborator

If this will be a script development just to make a single design, best option is to do it with the application or with another app that allow you to export the DXF file; it could be a big effort which is not worth.

But if your intention is to learn how to develop scripts, it is a good option.

Take into account that almost the same steps you make in the designer, need to be replicated in the script development, like for example, create sketch, draw circumference, add constraints, and so on.

 

1 Like

matt.culik
Contributor
Contributor

@Jorge_Jaramillo@BrianEkins - I do want to learn how to develop scripts, but also need to be realistic with my time. If you guys know of a program that would allow me to create sketch blocks from Excel/CSV/whatever tabulated data and export as a 2D DXF, that would be awesome.

 

Thanks!

0 Likes

Jorge_Jaramillo
Collaborator
Collaborator
Hi, the online API documentation comes with use case examples, which were very useful when I started learning the API. I'd suggest to start from there.
Then you can learn specific python modules to extent the functionality of your developments.
0 Likes

BrianEkins
Mentor
Mentor

I suspect what you want is unique enough that it's unlikely you'll find something existing that does exactly what you want. I know it's a lot to grasp when you first start, but having a project is the best way to learn it.

---------------------------------------------------------------
Brian Ekins
Inventor and Fusion 360 API Expert
Website/Blog: https://EkinsSolutions.com
0 Likes