Just In Found way to sort/edit Tool Library with Excel


Results 1 to 10 of 10

Thread: Found way to sort/edit Tool Library with Excel

  1. #1
    Registered
    Join Date
    Feb 2008
    Location
    usa
    Posts
    124
    Downloads
    0
    Uploads
    0

    Lightbulb Found way to sort/edit Tool Library with Excel

    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:
    Attached Thumbnails Attached Thumbnails Found way to sort/edit Tool Library with Excel-sc-format-tool-library-excel-jpg   Found way to sort/edit Tool Library with Excel-sc-format-tool-library-excel-2-jpg  
    Last edited by drutort; 06-08-2016 at 07:10 PM.


  2. #2
    Registered
    Join Date
    Feb 2008
    Location
    usa
    Posts
    124
    Downloads
    0
    Uploads
    0

    Default Re: Has anyone figured how to export tool library with ; in excel?

    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!

    Last edited by drutort; 06-08-2016 at 07:11 PM.


  3. #3
    Gold Member
    Join Date
    Jun 2006
    Location
    USA
    Posts
    2928
    Downloads
    0
    Uploads
    0

    Default Re: Found way to sort/edit Tool Library with Excel

    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



  4. #4
    Registered
    Join Date
    Mar 2015
    Posts
    142
    Downloads
    0
    Uploads
    0

    Default Re: Found way to sort/edit Tool Library with Excel

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



  5. #5
    Registered
    Join Date
    Feb 2008
    Location
    usa
    Posts
    124
    Downloads
    0
    Uploads
    0

    Default Re: Found way to sort/edit Tool Library with Excel

    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



  6. #6
    Gold Member mountaindew's Avatar
    Join Date
    Nov 2007
    Location
    earth
    Posts
    1647
    Downloads
    0
    Uploads
    0

    Default Re: Found way to sort/edit Tool Library with Excel

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



  7. #7
    Registered
    Join Date
    Feb 2008
    Location
    usa
    Posts
    124
    Downloads
    0
    Uploads
    0

    Default Re: Found way to sort/edit Tool Library with Excel

    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



  8. #8
    Registered
    Join Date
    Feb 2008
    Location
    usa
    Posts
    124
    Downloads
    0
    Uploads
    0

    Default Re: Found way to sort/edit Tool Library with Excel

    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



  9. #9
    Registered
    Join Date
    Feb 2008
    Location
    usa
    Posts
    124
    Downloads
    0
    Uploads
    0

    Default Re: Found way to sort/edit Tool Library with Excel

    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



  10. #10
    Registered
    Join Date
    Mar 2018
    Location
    Brazil
    Posts
    11
    Downloads
    0
    Uploads
    0

    Default Re: Found way to sort/edit Tool Library with Excel

    Quote Originally Posted by drutort View Post
    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.



Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


About CNCzone.com

    We are the largest and most active discussion forum for manufacturing industry. The site is 100% free to join and use, so join today!

Follow us on


Our Brands

Found way to sort/edit Tool Library with Excel

Found way to sort/edit Tool Library with Excel