Found way to sort/edit Tool Library with Excel

[drutort]

This is what I have found thus far to sort your stuff:
Step
1. Copy the tool library 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
(do this in note pad not excel, open the csv with notepad)
2. Create blank excel file, will be used to do sorting
3. Paste the text into the excel file 2 times (leave column A blank paste start with B), make sure to separate the areas not to get confused
4. One area you will work with it in its original format that is 1 cell holds all the data, other duplicate area we will convert and extract data for sorting
5. Go to the data tab (assuming you have relatively new excel version) in the data table, move to the 2nd copy of your pasted tool library select all the cells, pretty much the column B as rest is span, then click on "Text to Columns"
Check the Delimited, press next, then select semicolon, "text qualifier" change to none, press next, "column data format" I would leave it as general, then press finish!

6. Now you have a duplicate that has been imported into cells, you can now copy any column you want, and paste it next to your original data in column A, then do proper sort! select column A and B for your sort, and it will sort the "preserved copy" with this new column data that you pulled!

Example is you want to sort your tools by your ID, which is first column, you simply copy that data from the converted duplicated copy, paste it next to your single cell original data, then select both A and B columns and do sort based on the column A!

7. Delete, Column A after done, or remember not to select it. Copy your original single cell data back into your opened csv file that you had open in notepad, save! and bam! Sorted


in my picture, top is the original unedited, untouched SC svc data, you can see this that selected cell has all the data, the bottom copy as you can see has been converted with the above steps, column A has the copy of the first delimited data which is the ID, you see this being pasted right next to the original data on top, I selected only the column A and B 1-13 and did a sort by smallest to largest based on column A, so the original data gets sorted! and everything is preserved!

You can do this with other info, if you like maybe diameter or something else



===== advanced users ====

I tested the code that as converted from semicolon to cells, then I wanted to see what would happen if I saved only what was viewed in the picture as CSV by excel, which is automatically comma delimited. I then opened up the file in notepad, saw the commas and did quick find replace commas with semicolons.

But I noticed that it automatically put extra quotes for the areas that had " in inches, so quick fix for that is this, since you want to remove the quotes, were single quote was it ends with double "", first do find replace "" with !, then find all single " and replace with nothing, now go back and replace ! with a single " BAM fixed this annoying problem.

The good news is I copy pasted that data into the SC CSV, and SC opened it up! no errors and I saw the tool library just fine!


So there you have it, you can quickly edit and create your tool library with few quirts but doable in excel!

BTW after hitting save in SC in the tool Library editor, you can see SC put it into its format all nice and easy to read again! So this proves 100% working

just watch not to leave any extra space or last tool will be duplicated or missing right after the closing footer <END MILLING TOOLS> in this case when dealing with milling


Alternative way to do it, is copy the tool data that you will be working, put it into a blank text file, use find replace, replace all semicolons with commas and save it as a csv file, open with excel bam, you can now edit it in excel, simple when done do the reverse, save the file, then open in notepad and replace all commas with semicolons, then past that tool data back into your SC csv file!

Similar Threads:

• Need Help!- Need help with Correct tool carousel position in tool library
• Problem- Export/Import Tools Library
• Need Help!- Copy/Export Tool/Holder Library
• how to export/import plot style table from Excel
• export ipart detail in excel

[drutort]

if anyone has questions please post, I will try to explain as much as I can, but I found a fix for just about all the early problems/questions I had myself, I think this will be useful for everyone!

[MichaelHenry]

Thanks for uploading this. I'm not quite sure I understand but will try it out and come with questions if it isn't clear.

Mike

[Paul-JB]

X2 Thanks. I will try following your steps as well.

[drutort]

Try the alternate steps with replacing semicolon with comma and opening the file with excel then saving as CSV comma delimited and reverting the stuff to semicolon and placing into ur sc CSV tool library file

Sent from my Nexus 6 using Tapatalk

[mountaindew]

I looked at this a while back and couldn't get it to work reliably. Looks like you have the process refined to make it work "good job". I just could not trust doing so many steps to edit these files and give up. Decided to learn as best I can all the quirks and odd behaviors for creating, using and maintaining tools using the Sprutcam software . And I still get a host of inconsistencies. The data shows correct but when used in a operation some data fields change or whatever. I still have to step thru all the operations and verify all tool data used is consistent and correct. Anyway I will add this to my notebook and look at editing the files like this Thanks for sharing!!

[drutort]

Yup, there are strange things, this is why I start with a clean list generated by sc, and start a few tools, as my guide, now I know how to copy the data of each tool type, making sure nothing is left out, and can work in excel which makes editing, adding deleting stuff a breeze , I have always the blank tool list as a backup, and my own data tools list saved in excel format, this way I can merge the two again if something gets messed up

Sent from my Nexus 6 using Tapatalk

[drutort]

I had a lot of issues, I tried to go and create file with just few tools for few jobs that were related, it would not seem to want to save those tools, I would go add the tool from op, and went from each op doing so... well sometimes it saved others not, so I had to hit the save button and overwrite the file before exiting the operation, all kinds of small quirks that got me to this point to try and figure it out good

Sent from my Nexus 6 using Tapatalk

[drutort]

Sad this forum does not let you edit your posts after x amount of time, I created a much clearer How to, so I posted a new one, I think its much easier, no need to do it in excel just notepad then open in excel

Separated the area into 2 sections, taking data into excel, then taking data out of excel to sc library csv


If admins think I double posted, they can delete this whole thread, but this thread has the original ideas and the long way of importing stuff in excel

[xman2000]

Sad this forum does not let you edit your posts after x amount of time, I created a much clearer How to, so I posted a new one, I think its much easier, no need to do it in excel just notepad then open in excel

Separated the area into 2 sections, taking data into excel, then taking data out of excel to sc library csv


If admins think I double posted, they can delete this whole thread, but this thread has the original ideas and the long way of importing stuff in excel

I am advanced user of Excel, if you can share your Excel vba files of CNC and VB apps i am you like very mutch. Excel is greate software. Thank you.