Community
Fusion Design, Validate & Document
Stuck on a workflow? Have a tricky question about a Fusion (formerly Fusion 360) feature? Share your project, tips and tricks, ask questions, and get advice from the community.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Importing CSV file or similar to populate an array of plaques

4 REPLIES 4
Reply
Message 1 of 5
Anonymous
673 Views, 4 Replies

Importing CSV file or similar to populate an array of plaques

I've tried to find a way to import text into fusion 360.  Specifically, I'd like to take text from an Excel file, csv file or something similar and populate the surface of 16 plagues arrayed for CNC engraving.  Each plague has unique text which would come from the file (Excel, CSV, etc).  This process would be repeated dozens of times hence the desire to find a way to auto populate the text into Fusion 360.

 

Does anyone have any insight into how this might be accomplished?

 

Shane  

4 REPLIES 4
Message 2 of 5
innovatenate
in reply to: Anonymous

 

 

You would probably need to dive into the API and write a custom script that would import your coordinates and text from an excel file. 

 

Importing data from a CSV file:

https://help.autodesk.com/view/fusion360/ENU/?guid=GUID-1c19f064-fdf0-11e4-a863-f8b156d7cd97

 

Create Sketch Text:

https://knowledge.autodesk.com/search-result/caas/CloudHelp/cloudhelp/ENU/Fusion-360-API/files/Sketc...

 

If programming isn't your thing, you may consider discussing your customization needs with an Autodesk Reseller. I hope this helps!

 

Thanks,

 

 




Nathan Chandler
Principal Specialist
Message 3 of 5
I_Forge_KC
in reply to: innovatenate

Or someone from the Services Marketplace!


K. Cornett
Generative Design Consultant / Trainer

Message 4 of 5
Alan.r.beswick
in reply to: Anonymous

Apologies for not replying sooner.

 

I'd like to take text from an Excel file, csv file or something similar and populate the surface of 16 plagues arrayed for CNC engraving.

 

Too hard, so do it backwards

I'd like to take text and populate the surface WITH 16 plagues arrayed for CNC engraving.

 

In the description below, there is a little programming to be done. I will give printf examples, as printf is available in many C like languages. Python and even FORTRAN have equivalents. I will use the unix utility awk.

 

Prepare the text, say triple spaced. I used 100 random names from https://www.name-generator.org.uk/quick/

awk '{printf "%s\n\n\n", $0}' randomnames.txt

 

Create a Fusion 360 text box, wide enough to take the name without folding it. The formatted text will flow out of the bottom of the text box in a controlled manner

 

Create the plaque over the first line of names, then make a rectangular array to create the multiple tags

Hint: parameterise the text height

 

That will give ONE column of plaques, any font, centre justified. To get multiple columns, prepare the text using a monospaced font like courier.

awk '{printf "%-30s", $0} NR%3 == 0 {print ""}' randomnames.txt

mini:scratch atnt$ 
Lowri Stuart                  Kareena Ryan                  Kalem Hewitt                  
Hallam Redfern                Rita Zamora                   Kayne Eastwood                
Ayaana Simmons                Massimo Coates                Gage Hunt                     
...
Jazmin Stanley Brody Spencer Abdul Muir Tayyib Dunn Konnor Mcdermott Dante Leal Weronika Wagner Jemima Atherton Valerie Tran

Use a two dimensional array of plaques and job done.

With a slightly more complex printf statement, you can get centre justified text on the 2D array of plaques.

 

Export and dxf and laser it.

 

Hopefully, there is a sample attached.

Message 5 of 5

Oops, correct file attached

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report