Is there a quick method for generating the tool table

Having problems with or questions about SheetCam? Post them here.
Post Reply
David_Lelen01
Posts: 452
Joined: Wed Sep 12, 2018 8:18 pm
Location: South Carolina, USA
Contact:

Is there a quick method for generating the tool table

Post by David_Lelen01 »

I have quickly realized every time i change a custom tool parameter in a post or add a new one, it wipes all custom parameters from the tool table. maybe a glitch, but i just figured that's how it works.

I took a look at the default tool table SheetCAM stores and it does not appear to be in an excel format.

I have an excel file with all my tools and parameters that i created just to keep a backup copy in case.

Is there a way to copy this excel table into the tool table without having to type in each value manually through SheetCAM. This becomes extremely time consuming.
Attachments
Tools.JPG
Tools.JPG (315.19 KiB) Viewed 1812 times
ToolDefaultTable.JPG
ToolDefaultTable.JPG (144.24 KiB) Viewed 1812 times
User avatar
Les Newell
Site Admin
Posts: 3661
Joined: Thu May 11, 2006 8:12 pm

Re: Is there a quick method for generating the tool table

Post by Les Newell »

The next dev version will be able to export and import CSV tool tables which you can load into a spreadsheet. I'm just waiting for Comodo to get back to me about my code signing license so I can create the installer.
David_Lelen01
Posts: 452
Joined: Wed Sep 12, 2018 8:18 pm
Location: South Carolina, USA
Contact:

Re: Is there a quick method for generating the tool table

Post by David_Lelen01 »

Any idea how long that may take? I started writing a VB macro in excel to export it to a text file in the same format. If you expect it to be less than a week before it is able to be released i will just wait. Thanks Les
User avatar
Les Newell
Site Admin
Posts: 3661
Joined: Thu May 11, 2006 8:12 pm

Re: Is there a quick method for generating the tool table

Post by Les Newell »

I have no idea. If it takes more than a week I can upload a temporary installer. Without a certificate Windows will complain when you try to install it.
David_Lelen01
Posts: 452
Joined: Wed Sep 12, 2018 8:18 pm
Location: South Carolina, USA
Contact:

Re: Is there a quick method for generating the tool table

Post by David_Lelen01 »

Oh yes, i've ran into that issue several times. Windows gets very cranky and wont even run the software correctly sometimes even if you do manage to get it installed.

I'll just go ahead and finish this macro for now then. It'll be good practice at the least haha
David_Lelen01
Posts: 452
Joined: Wed Sep 12, 2018 8:18 pm
Location: South Carolina, USA
Contact:

Re: Is there a quick method for generating the tool table

Post by David_Lelen01 »

Les,
What should the format be for the tool table to import? I tried making it exactly like the format of the exported csv, and i tried every CSV output type excel has (comma delimited, UTF-8, MS-Dos, and Macintosh). None successfully work. It imports the tool names and tool numbers but all of the values import as the default sheetcam value.
User avatar
Les Newell
Site Admin
Posts: 3661
Joined: Thu May 11, 2006 8:12 pm

Re: Is there a quick method for generating the tool table

Post by Les Newell »

Could you send me one of your csv files. It should be comma delimited and UTF-8 won't hurt. MSDOS/Mac just refers to the line endings. SheetCam shouldn't care about what version you use there.
David_Lelen01
Posts: 452
Joined: Wed Sep 12, 2018 8:18 pm
Location: South Carolina, USA
Contact:

Re: Is there a quick method for generating the tool table

Post by David_Lelen01 »

It had an error on the UTF-8, but all others did not have an error, they just didnt work.
Attachments
MetalMastersToolTable.zip
(3.06 KiB) Downloaded 66 times
User avatar
Les Newell
Site Admin
Posts: 3661
Joined: Thu May 11, 2006 8:12 pm

Re: Is there a quick method for generating the tool table

Post by Les Newell »

Found the problem. Could you send me a UTF-8 version. UTF-8 should work and I can't see anything obviously wrong.
David_Lelen01
Posts: 452
Joined: Wed Sep 12, 2018 8:18 pm
Location: South Carolina, USA
Contact:

Re: Is there a quick method for generating the tool table

Post by David_Lelen01 »

Here is the UTF-8 version
Attachments
MetalMastersToolTableUTF8.zip
(3.07 KiB) Downloaded 69 times
motoguy
Posts: 121
Joined: Sun May 01, 2016 12:02 am

Re: Is there a quick method for generating the tool table

Post by motoguy »

This will be a very handy addition!
Post Reply