User Tools
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:devel:corebosupdater [2020/04/07 19:26] gmoshi [massCreateFields] |
en:devel:corebosupdater [2020/06/08 02:32] (current) joebordes [massCreateFields] |
||
|---|---|---|---|
| Line 251: | Line 251: | ||
| "table": "industry", | "table": "industry", | ||
| "module": "Accounts" | "module": "Accounts" | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
| + | <code javascript> | ||
| + | { | ||
| + | "name": "del values building", | ||
| + | "description": "delete all the current values in the building picklist of Products", | ||
| + | "operation": "deleteAllPicklistValues", | ||
| + | "setting": { | ||
| + | "table": "building", | ||
| + | "module": "Products" | ||
| } | } | ||
| } | } | ||
| Line 268: | Line 279: | ||
| "module": "Accounts", | "module": "Accounts", | ||
| "values": ["Telecommunications", "Banking"] | "values": ["Telecommunications", "Banking"] | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
| + | <code javascript> | ||
| + | { | ||
| + | "name": "del values prodtype", | ||
| + | "description": "delete some values from the prodtype picklist of Products", | ||
| + | "operation": "deletePicklistValues", | ||
| + | "setting": { | ||
| + | "table": "prodtype", | ||
| + | "module": "Products", | ||
| + | "values": ["Sell", "Rent Holiday"] | ||
| } | } | ||
| } | } | ||
| Line 283: | Line 306: | ||
| "fields": ["fieldname1", "fieldname2", "fieldname3"], | "fields": ["fieldname1", "fieldname2", "fieldname3"], | ||
| "module": "Accounts" | "module": "Accounts" | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
| + | <code javascript> | ||
| + | |||
| + | { | ||
| + | "operation": "setQuickCreateFields", | ||
| + | "setting": { | ||
| + | "fields": ["floor", "internet", "building"], | ||
| + | "module": "Products" | ||
| } | } | ||
| } | } | ||
| Line 289: | Line 322: | ||
| ===== massCreateFields ===== | ===== massCreateFields ===== | ||
| - | Given an array of field definitions this method will create or activate the fields. The layout is an array of Module Name, Block Name and Field Definition. | + | Given an array of field definitions, this method will create or activate the fields. The layout is an array of Module Name, Block Name, and Field Definition. |
| <code javascript> | <code javascript> | ||
| Line 298: | Line 331: | ||
| "module":{ | "module":{ | ||
| "block name or ID":{ | "block name or ID":{ | ||
| - | "fields": [ | + | "fieldname1": { |
| - | { | + | "columntype": "decimal(10,3)", |
| - | "fieldname1": { | + | "typeofdata": "NN~O", |
| - | "columntype": "decimal(10,3)", | + | "uitype": "1", |
| - | "typeofdata": "NN~O", | + | "displaytype": "3", |
| - | "uitype": "1", | + | "label": "", // optional, if empty fieldname will be used |
| - | "displaytype": "3", | + | "massedit": 0 | 1 // optional, if empty 0 will be set |
| - | "label": "", // optional, if empty fieldname will be used | + | "mods": [module names], // used if uitype 10 |
| - | "massedit": 0 | 1 // optional, if empty 0 will be set | + | "vals": [picklist values], // used if uitype 15, 16 or 33 |
| - | "mods": [module names], // used if uitype 10 | + | }, |
| - | "vals": [picklist values], // used if uitype 15, 16 or 33 | + | "fieldname2": { |
| - | } | + | "columntype": "decimal(10,3)", |
| + | "typeofdata": "NN~O", | ||
| + | "uitype": "1", | ||
| + | "displaytype": "3", | ||
| + | "label": "", // optional, if empty fieldname will be used | ||
| + | "massedit": 0 | 1 // optional, if empty 0 will be set | ||
| + | "mods": [module names], // used if uitype 10 | ||
| + | "vals": [picklist values], // used if uitype 15, 16 or 33 | ||
| } | } | ||
| - | ] | ||
| } | } | ||
| } | } | ||
| Line 317: | Line 356: | ||
| } | } | ||
| </code> | </code> | ||
| + | <code javascript> | ||
| + | { | ||
| + | "operation": "massCreateFields", | ||
| + | "setting": | ||
| + | { | ||
| + | "Vendors": { | ||
| + | "Custom Information": { | ||
| + | "cal": { | ||
| + | "columntype": "int(11)", | ||
| + | "typeofdata": "V~O", | ||
| + | "uitype": "10", | ||
| + | "displaytype": "1", | ||
| + | "label": "Sabi", | ||
| + | "massedit": "1", | ||
| + | "mods":"Products" | ||
| + | }, | ||
| + | "volume": { | ||
| + | "columntype": "varchar(100)", | ||
| + | "typeofdata": "V~O", | ||
| + | "uitype": "1", | ||
| + | "displaytype": "1", | ||
| + | "label": "Volume", | ||
| + | "massedit": "1" | ||
| + | } | ||
| + | } | ||
| + | } | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
| + | |||
| + | <code javascript> | ||
| + | { | ||
| + | "operation": "massCreateFields", | ||
| + | "setting": | ||
| + | { | ||
| + | "Vendors": { | ||
| + | "Custom Information": { | ||
| + | "palm": { | ||
| + | "columntype": "int(11)", | ||
| + | "typeofdata": "V~O", | ||
| + | "uitype": "10", | ||
| + | "displaytype": "1", | ||
| + | "label": "Palm", | ||
| + | "massedit": "1", | ||
| + | "mods":"Products" | ||
| + | }, | ||
| + | "pressures": { | ||
| + | "columntype": "varchar(100)", | ||
| + | "typeofdata": "V~O", | ||
| + | "uitype": "1", | ||
| + | "displaytype": "1", | ||
| + | "label": "Pressures", | ||
| + | "massedit": "1" | ||
| + | } | ||
| + | } | ||
| + | }, | ||
| + | "Products": { | ||
| + | "Custom Information": { | ||
| + | "uniqueapplicationfieldname": { | ||
| + | "columntype": "int(11)", | ||
| + | "typeofdata": "V~O", | ||
| + | "uitype": "15", | ||
| + | "displaytype": "1", | ||
| + | "label": "Values", | ||
| + | "massedit": "1", | ||
| + | "vals":["Accounts","Bank","VICOBA"] | ||
| + | }, | ||
| + | "volume": { | ||
| + | "columntype": "varchar(100)", | ||
| + | "typeofdata": "V~O", | ||
| + | "uitype": "1", | ||
| + | "displaytype": "1", | ||
| + | "label": "Volume", | ||
| + | "massedit": "1" | ||
| + | } | ||
| + | } | ||
| + | } | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
| + | |||
| ===== massHideFields ===== | ===== massHideFields ===== | ||
| Line 327: | Line 447: | ||
| "setting": { | "setting": { | ||
| "fields": ["fieldname1", "fieldname2", "fieldname3"], | "fields": ["fieldname1", "fieldname2", "fieldname3"], | ||
| + | "module": "Accounts" | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
| + | <code javascript> | ||
| + | { | ||
| + | "operation": "massHideFields", | ||
| + | "setting": { | ||
| + | "fields": ["bill_street", "ship_street", "ownership"], | ||
| "module": "Accounts" | "module": "Accounts" | ||
| } | } | ||
| Line 341: | Line 470: | ||
| "setting": { | "setting": { | ||
| "fields": ["fieldname1", "fieldname2", "fieldname3"], | "fields": ["fieldname1", "fieldname2", "fieldname3"], | ||
| + | "module": "Accounts" | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
| + | |||
| + | <code javascript> | ||
| + | { | ||
| + | "operation": "massDeleteFields", | ||
| + | "setting": { | ||
| + | "fields": ["website", "email1", "bill_city"], | ||
| "module": "Accounts" | "module": "Accounts" | ||
| } | } | ||
| Line 360: | Line 499: | ||
| } | } | ||
| </code> | </code> | ||
| + | <code javascript> | ||
| + | { | ||
| + | "operation": "massMoveFieldsToBlock", | ||
| + | "setting": { | ||
| + | "fields": ["city", "street"], | ||
| + | "module": "Vendors", | ||
| + | "block": "LBL_VENDOR_INFORMATION" | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
| ===== orderFieldsInBlocks ===== | ===== orderFieldsInBlocks ===== | ||
| Line 387: | Line 535: | ||
| { | { | ||
| "operation": "orderFieldsInBlocks", | "operation": "orderFieldsInBlocks", | ||
| - | "setting": | + | "setting": |
| { | { | ||
| "Vendors":{ | "Vendors":{ | ||
| - | "Custom Information": | + | "LBL_VENDOR_INFORMATION": |
| - | { | + | ["vendorname", "vendor_no","glacct"] |
| - | ["city", "street"] | + | } |
| - | } | + | } |
| - | } | + | } |
| - | } | + | </code> |
| + | |||
| + | <code javascript> | ||
| + | { | ||
| + | "operation": "orderFieldsInBlocks", | ||
| + | "setting": | ||
| + | { | ||
| + | "Vendors":{ | ||
| + | "LBL_VENDOR_INFORMATION": | ||
| + | ["vendor_no", "vendorname","glacct"] | ||
| + | |||
| + | }, | ||
| + | "Products":{ | ||
| + | "LBL_PRODUCT_INFORMATION": | ||
| + | ["product_no", "productname","expiry_date"] | ||
| + | } | ||
| + | } | ||
| } | } | ||
| </code> | </code> | ||
| Line 410: | Line 574: | ||
| "module": "Accounts", | "module": "Accounts", | ||
| "field": "industry", | "field": "industry", | ||
| + | "multiple": false | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
| + | <code javascript> | ||
| + | { | ||
| + | "operation": "convertTextFieldToPicklist", | ||
| + | "setting": { | ||
| + | "module": "Invoice", | ||
| + | "field": "salescommission", | ||
| "multiple": false | "multiple": false | ||
| } | } | ||
| Line 428: | Line 602: | ||
| "hoverfield": "fieldname that triggers the tooltip", | "hoverfield": "fieldname that triggers the tooltip", | ||
| "fields2show": ["fieldname1", "fieldname2", "fieldname3"] | "fields2show": ["fieldname1", "fieldname2", "fieldname3"] | ||
| + | } | ||
| + | ] | ||
| + | } | ||
| + | </code> | ||
| + | <code javascript> | ||
| + | { | ||
| + | "operation": "setTooltip", | ||
| + | "setting": [ | ||
| + | { | ||
| + | "module": "Vendors", | ||
| + | "hoverfield": "vendorname", | ||
| + | "fields2show": ["state", "street"] | ||
| } | } | ||
| ] | ] | ||
| Line 447: | Line 633: | ||
| } | } | ||
| </code> | </code> | ||
| + | <code javascript> | ||
| + | { | ||
| + | "name": "del invoice module from menu", | ||
| + | "description": "delete all invoice module entries in the menu", | ||
| + | "operation": "removeAllMenuEntries", | ||
| + | "setting": { | ||
| + | "module": "Invoice" | ||
| + | } | ||
| + | } | ||
| + | </code> | ||
