Is there a quick method for generating the tool table
-
- 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
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.
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 (315.19 KiB) Viewed 2134 times
-
- ToolDefaultTable.JPG (144.24 KiB) Viewed 2134 times
- Les Newell
- Site Admin
- Posts: 3675
- Joined: Thu May 11, 2006 8:12 pm
Re: Is there a quick method for generating the tool table
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.
-
- 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
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
- Les Newell
- Site Admin
- Posts: 3675
- Joined: Thu May 11, 2006 8:12 pm
Re: Is there a quick method for generating the tool table
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.
-
- 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
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
I'll just go ahead and finish this macro for now then. It'll be good practice at the least haha
-
- 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
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.
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.
- Les Newell
- Site Admin
- Posts: 3675
- Joined: Thu May 11, 2006 8:12 pm
Re: Is there a quick method for generating the tool table
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.
-
- 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
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 81 times
- Les Newell
- Site Admin
- Posts: 3675
- Joined: Thu May 11, 2006 8:12 pm
Re: Is there a quick method for generating the tool table
Found the problem. Could you send me a UTF-8 version. UTF-8 should work and I can't see anything obviously wrong.
-
- 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
Here is the UTF-8 version
- Attachments
-
- MetalMastersToolTableUTF8.zip
- (3.07 KiB) Downloaded 87 times
Re: Is there a quick method for generating the tool table
This will be a very handy addition!