Tool library .json file manipulation

Tool library .json file manipulation

CuttingEdgeManufacturing
Collaborator Collaborator
1,925 Views
7 Replies
Message 1 of 8

Tool library .json file manipulation

CuttingEdgeManufacturing
Collaborator
Collaborator

Hello all, I am working on software that keeps track of tooling inventory, culling most of the data from the readily available json file that f360 uses. i add in about 6-8 properties to the json file for my needs, and then put the file back where i got it.

 

however for some reason when i import my test library back to f360 it highlights the majority of tools in the library as if something is wrong with them. it still lets me go in and edit the tools but i can't find any issues with the tools. below is screenshot as well as sample of the json file. can anyone see what is wrong with this?

 

Screenshot_56.png

 

{
  "data": [
    {
      "OrderQty": 0,
      "product-link": "6010",
      "Cost": 5.0,
      "Employee": "",
      "Location": "",
      "onHandQty": 0,
      "stockQty": 0,
      "orderQty": 0,
      "ReturnTool": false,
      "type": "thread mill",
      "vendor": "Gorilla Mill",
      "product-id": "GMDTTM58-11UN4FL",
      "description": "5/8-11\"",
      "BMC": "carbide",
      "GRADE": "Mill Generic",
      "geometry": {
        "CSP": false,
        "DC": 0.433,
        "HAND": true,
        "LB": 2.0,
        "LCF": 0.5,
        "NOF": 4,
        "NT": 1,
        "OAL": 5.0,
        "SFDM": 0.625,
        "TP": 0.0909091,
        "shoulder-length": 1.969,
        "thread-profile-angle": 60,
        "SIG": 0,
        "RE": 0.0,
        "TA": 0,
        "tip-diameter": 0.0,
        "tip-length": 0.0
      },
      "guid": "0112c196-8a79-421d-8dda-d4aa964aa6d7",
      "holder": {
        "description": "Maritool CAT40-ER32-2.35",
        "guid": "e800051b-e2d6-4699-a2b6-dad6466a0a0c",
        "last_modified": "1485790626152",
        "product-id": "CAT40-ER32-2.35",
        "product-link": "",
        "segments": [
          {
            "height": 0.148,
            "lower-diameter": 1.5,
            "upper-diameter": 1.97
          },
          {
            "height": 0.836,
            "lower-diameter": 1.97,
            "upper-diameter": 1.97
          },
          {
            "height": 0.176,
            "lower-diameter": 1.57,
            "upper-diameter": 1.57
          },
          {
            "height": 0.09,
            "lower-diameter": 1.57,
            "upper-diameter": 1.75
          },
          {
            "height": 0.425,
            "lower-diameter": 1.75,
            "upper-diameter": 1.75
          },
          {
            "height": 0.05,
            "lower-diameter": 1.75,
            "upper-diameter": 1.85
          },
          {
            "height": 0.03,
            "lower-diameter": 2.442,
            "upper-diameter": 2.502
          },
          {
            "height": 0.145,
            "lower-diameter": 2.502,
            "upper-diameter": 2.502
          },
          {
            "height": 0.079,
            "lower-diameter": 2.502,
            "upper-diameter": 2.215
          },
          {
            "height": 0.118,
            "lower-diameter": 2.215,
            "upper-diameter": 2.215
          },
          {
            "height": 0.079,
            "lower-diameter": 2.215,
            "upper-diameter": 2.502
          },
          {
            "height": 0.143,
            "lower-diameter": 2.502,
            "upper-diameter": 2.502
          },
          {
            "height": 0.03,
            "lower-diameter": 2.502,
            "upper-diameter": 2.442
          },
          {
            "height": 0.125,
            "lower-diameter": 1.75,
            "upper-diameter": 1.75
          }
        ],
        "type": "holder",
        "unit": "inches",
        "vendor": "Maritool"
      },
      "post-process": {
        "break-control": false,
        "comment": "",
        "diameter-offset": 17,
        "length-offset": 17,
        "live": true,
        "manual-tool-change": false,
        "number": 17,
        "turret": 0
      },
      "start-values": {
        "presets": [
          {
            "description": "",
            "f_n": 0.012242786571039,
            "f_z": 0.0031,
            "guid": "eac33213-4083-35b8-afe3-17bd42a249f0",
            "n": 4410.xxx-xxxxxxxx,
            "n_ramp": 44110.0,
            "name": "1018",
            "tool-coolant": "flood",
            "use-stepdown": false,
            "use-stepover": false,
            "v_c": 499.99999999999937,
            "v_f": 54.6934307900093,
            "v_f_leadIn": 54.0,
            "v_f_leadOut": 54.0,
            "v_f_plunge": 54.0,
            "v_f_ramp": 54.0,
            "v_f_retract": 0.0,
            "stepdown": 0.0,
            "stepover": 0.0
          },
          {
            "description": "",
            "f_n": 0.010769117817118,
            "f_z": 0.0028,
            "guid": "f35f5601-68a9-477b-b4b0-2ffeedb3bef1",
            "n": 1764.3042190325598,
            "n_ramp": 1764.0,
            "name": "4140",
            "tool-coolant": "flood",
            "use-stepdown": false,
            "use-stepover": false,
            "v_c": 200.0,
            "v_f": 19.7602072531647,
            "v_f_leadIn": 19.0,
            "v_f_leadOut": 19.0,
            "v_f_plunge": 19.0,
            "v_f_ramp": 19.0,
            "v_f_retract": 0.0,
            "stepdown": 0.0,
            "stepover": 0.0
          },
          {
            "description": "",
            "f_n": 0.012091641057817,
            "f_z": 0.0031,
            "guid": "b118ce46-da35-4ed6-9806-b98e05ffe077",
            "n": 2646.xxx-xxxxxxxx,
            "n_ramp": 2646.0,
            "name": "Tool Steel",
            "tool-coolant": "flood",
            "use-stepdown": false,
            "use-stepover": false,
            "v_c": 300.0,
            "v_f": 32.8160584740056,
            "v_f_leadIn": 32.0,
            "v_f_leadOut": 32.0,
            "v_f_plunge": 32.0,
            "v_f_ramp": 32.0,
            "v_f_retract": 0.0,
            "stepdown": 0.0,
            "stepover": 0.0
          },
          {
            "description": "",
            "f_n": 0.01118476797848,
            "f_z": 0.0028,
            "guid": "0e1767f5-b0ef-422f-b49d-6cb8c3eb06ed",
            "n": 3308.0704106860494,
            "n_ramp": 3308.0,
            "name": "Stainless Steel",
            "tool-coolant": "flood",
            "use-stepdown": false,
            "use-stepover": false,
            "v_c": 375.0,
            "v_f": 37.0503885996837,
            "v_f_leadIn": 37.0,
            "v_f_leadOut": 37.0,
            "v_f_plunge": 37.0,
            "v_f_ramp": 37.0,
            "v_f_retract": 0.0,
            "stepdown": 0.0,
            "stepover": 0.0
          }
        ]
      },
      "unit": "inches"
    }
],
"version": 0
}
0 Likes
1,926 Views
7 Replies
Replies (7)
Message 2 of 8

boopathi.sivakumar
Autodesk
Autodesk

From the given sample it didn't give me any warnings, Could you send me over the .json file i can take a look into it

 


Boopathi Sivakumar
Senior Technology Consultant

0 Likes
Message 3 of 8

CuttingEdgeManufacturing
Collaborator
Collaborator

couldn't find a way to attach file in PM so here is the json file.

0 Likes
Message 4 of 8

I can able to see couple of issues with the .json 

the grade should not be null it must be one of

  • "Mill Generic"
  • "generic"

And if you don't have any holders it should not also be null, It has to be removed from the data object.

I have added the modified file for your reference

 


Boopathi Sivakumar
Senior Technology Consultant

0 Likes
Message 5 of 8

CuttingEdgeManufacturing
Collaborator
Collaborator
ah, thought i fixed that issue. thanks for that. I didn't look through it too hard thinking i had those issues fixed!
0 Likes
Message 6 of 8

looks like my preset speeds and feeds for endmills it doesn't like that i set stepdown and stepover to false, but also set the values for them to 0.0" so if stepdown is false ignore the value for this as well?
0 Likes
Message 7 of 8

It seems like a bug to me.. If "use-stepdown" and "use-stepover" is false then it shouldn't look for the stepdown and stepover value.. will report to the team. 


Boopathi Sivakumar
Senior Technology Consultant

0 Likes
Message 8 of 8

CuttingEdgeManufacturing
Collaborator
Collaborator

fixed it on my end. but yea seems like a bug. thanks for the help!

0 Likes