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.
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.
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
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.
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
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.
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.
