Generating files to nest from a CSV

This forum is for general discussion regarding VCarve Pro
Post Reply
gsphalen
Posts: 2
Joined: Thu Feb 19, 2015 8:57 pm
Model of CNC Machine: TBD

Generating files to nest from a CSV

Post by gsphalen »

Hiya,

I'm in the process of purchasing a CNC router to help automate the production of acrylic glass for custom picture framing and am trying to get out in front of the software piece.

Each day, I produce a spreadsheet that has a few hundred entries -- each with a set of dimensions for the rectangle of acrylic that needs to be cut. We currently do this manually: measure, score the acrylic, snap it, repeat. I'd like to take my list of rectangles (currently expressed as simple length/width dimensions in excel), transform them into the necessary vector format, and then have them nested in VCarve Pro to optimize for waste and be cut by the CNC. If anyone has any experience here, suggestions, or even a nod in the right direction, I'd really appreciate it.

thanks much,
-- Gregg

User avatar
Adrian
Vectric Archimage
Posts: 15396
Joined: Thu Nov 23, 2006 2:19 pm
Model of CNC Machine: ShopBot PRS Alpha 96x48
Location: Surrey, UK

Re: Generating files to nest from a CSV

Post by Adrian »

Paul's CSV gadget - http://paulrowntree.weebly.com/gadgets.html - should be able to get the vectors into VCarve so you can nest them from there.

gsphalen
Posts: 2
Joined: Thu Feb 19, 2015 8:57 pm
Model of CNC Machine: TBD

Re: Generating files to nest from a CSV

Post by gsphalen »

Ooh, thanks a lot, Adrian. I'll check it out!

PaulRowntree
Vectric Wizard
Posts: 1687
Joined: Sun Oct 24, 2010 7:28 pm
Model of CNC Machine: homebuilt 4'x2' (Mach3+G540)
Location: Guelph, Ontario
Contact:

Re: Generating files to nest from a CSV

Post by PaulRowntree »

Hi gsphalen
The CSV gadget has also been updated so that you can do a lot of shapes and calculations with single line entries in the CSV file. This includes polygons, circles, special functions, and vectors.
Or, just treat it as a bunch of points, one per line, and the gadget will connect the dots.
Cheers!
Paul Rowntree
WarpDriver, StandingWave, Topo and gadgets available at PaulRowntree.weebly.com

Fernando
Posts: 17
Joined: Thu Mar 05, 2020 11:51 pm
Model of CNC Machine: Router CNC 3,4 and 5 axis

Re: Generating files to nest from a CSV

Post by Fernando »

I downloaded the Gadget but it only works with points?
How do I make it read the width and length of the rectangle in the CSV?
And how do I add circles inside this rectangle?
And another rectangle inside the rectangle?

User avatar
dealguy11
Vectric Wizard
Posts: 2711
Joined: Tue Sep 22, 2009 9:52 pm
Model of CNC Machine: Anderson Selexx 510,24x48 GCnC/WinCNC
Location: Henryville, PA

Re: Generating files to nest from a CSV

Post by dealguy11 »

Attached is an example of a CSV to 2d file using Rowntree's gadget that creates nested rectangles, each in a specific layer that you can color as you like in the Vectric product. To create a circle rather than a rectangle, you would use !Circle,Xcenter,Ycenter,Radius
Attachments
Stecher Kitchen Doors Redo_Geometry.zip
(1.27 KiB) Downloaded 34 times
Steve Godding
Not all who wander (or wonder) are lost

Post Reply