anafranil online
IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> How to edit SC Tool Library in Excel, Useful for sorting adding, editing etc with the power of excel
Val
post Jun 9 2016, 06:55 PM
Post #1


Advanced Member
***

Group: Members
Posts: 50
Joined: 8-October 11
From: USA
Member No.: 3,307



This tutorial assumes you have an understanding in how to open and edit text files on your computer along with knowing your way around in Microsoft Excel, please do not ask questions regarding these steps, unless there needs to be a clarification to the steps in this tutorial.

Always backup your files, the SC tool library .csv and your edited files so you can always go back and redo things. The example below will deal with the mill tool section only, but should apply to other areas once you identify the “data” by data I mean the section were the tool definition is and not the header or footers that define other things for SC and are not formatted the same with the semicolon as the delimiter.

Getting SprutCAM tool Library CSV file to excel
1. Copy the tool library (data) section that you want to work with, mostly going to be the mill, lathe etc section, only the data stuff, none of the header/footer stuff (starting from ID=INTEGER; and end right before <END MILLING TOOLS> )
(do this in notepad not excel, open the SprutCAM tool Library csv file with notepad)
2. Create a blank text file in notepad
3. Paste the data from step 1 into blank text file
4. Go to edit in notepad, press “replace” type in semicolon to find, replace with comma
5. Save text file, then rename changing the extension from .txt to .csv
6. open this file with excel, it might give you some warnings, ignore those by pressing ok or yes.

Now you will see all the data in columns, rows, cells etc…
You can now sort, edit do what you want, but stay to the format, if you do not follow the proper format you could corrupt your tool library file. (good idea to always have backup)
Best way to not mess up the formatting, is to have created few mill tool types, like drill, mill, engraver, tap etc… so you have a reference point and you can copy that whole row, and then make the changes needed for your tool, this way you should be almost 100% not to mess up.

At this point I would save this .csv into native excel format, as you will export/save as .csv when you are finished with your editing

Getting your Excel file into SprutCAM tool Library CSV file
Now that you have done your edits, and have a excel format file, you want to get the data back to SC tool library format.

1. Go to File save as in excel, and save the tool data as comma delimited .csv Keep your original excel file too.
2. Now right click on this .csv file made, and open with notepad
3. Once opened with notepad we will now do a few find and replace commands
4. Go to edit and click on Replace in the find what type , as in comma and in replace with ; semicolon
After this step it is almost done, one issue remains if you have any quotes as in representing inches with a single “ excel CSV format will put that whole cell in quotes, and thus adding double quotes
5. to get rid of double quotes we will go to edit tab Replace in the find what we type “” 2 quotes replace it with say ! then go to edit replace and find the single quote “ and replace it with nothing just leave the replace with area blank, it will remove the single quote.
6. now we want that double quote which we turned into ! to be a single “ we do one last Replace find what type ! and type “ single quote in the replace with
7. take this data copy all, and go to your SC tool library CSV file, back in the same section, and paste it in the proper area save the file. see pictures for help
8. Go to SC and load the new tool library CSV, make sure things are good, hit save SC, if all is good SC will format that tool data back with all those spaces and easy to read, this confirms that all has worked.

Now you can do these steps as need, when you want to make changes; always keep your original files just in case, the excel file and original SC tool library backed up (copies)
Attached File(s)
Attached File  SC_format_tool_library_in_Excel_4.jpg ( 133.48K ) Number of downloads: 6
Attached File  SC_format_tool_library_in_Excel_3.jpg ( 175.8K ) Number of downloads: 4
Attached File  SC_format_tool_library_in_Excel_2.jpg ( 75.7K ) Number of downloads: 4
Attached File  SC_format_tool_library_in_Excel_5.jpg ( 43.57K ) Number of downloads: 4
 
Go to the top of the page
 
+Quote Post
Sprut_UK
post Jun 16 2016, 09:32 AM
Post #2


Advanced Member
***

Group: Administrators
Posts: 1,076
Joined: 12-December 07
From: United Kingdom
Member No.: 4



Hi Val,

Thank you for taking the time to produce this information and for posting it here cool.gif

Dave


--------------------
"Never interrupt your opponent when he is making a mistake..." - Napoleon Bonaparte
www.sprut.co.uk
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



Lo-Fi Version Time is now: 29th March 2017 - 09:15 AM