Message 1 of 8
Tool library .json file manipulation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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?
{
"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
}