Create Item from Script

I made this a while ago to save me some time of having to interact with the GUI. Works well enough, and will get updates to become a scoped app or script include... It's a start.

Toss it in a fix script and adjust the bottom to your details while in the correct scope/update set. Then you have to figure out containers.

function createCatalog(name) { /* * Expecting a string (name) */ var catalogExists = new GlideRecord('sc_catalog'); catalogExists.addQuery('title', name); catalogExists.query(); if (catalogExists.next()) { return catalogExists.sys_id; } else { var sc_catalog = new GlideRecord('sc_catalog'); sc_catalog.initialize(); sc_catalog.description = ''; //sc_catalog.sys_name = name; sc_catalog.title = name; sc_catalog.active = true; return sc_catalog.insert(); }}function createCategory(name, catalogId) { /* * Expecting a string (name) * Expecting a string (catalogId) */ var categoryExists = new GlideRecord('sc_catalog'); categoryExists.addQuery('title', name); categoryExists.query(); if (categoryExists.next()) { return categoryExists.sys_id; } else { var sc_category = new GlideRecord('sc_category'); sc_category.initialize(); sc_category.sc_catalog = catalogId; sc_category.sys_name = name; sc_category.title = name; return sc_category.insert(); }}function createItem(itemObj, categoryId, catalogId) { /* * Expecting an object (itemObj) * name * short_description * . * Expecting a string (categoryId) * Expecting a string (catalogId) */ var itemExists = new GlideRecord('sc_cat_item'); itemExists.addQuery('name', itemObj.name); itemExists.addQuery('category', categoryId); itemExists.addQuery('sc_catalogs', catalogId); itemExists.query(); if (itemExists.next()) { return itemExists.sys_id; } else { var sc_cat_item = new GlideRecord('sc_cat_item'); sc_cat_item.initialize(); sc_cat_item.category = categoryId; sc_cat_item.sc_catalogs = catalogId; sc_cat_item.name = itemObj.name; sc_cat_item.short_description = itemObj.short_description; sc_cat_item.description = itemObj.short_description; return sc_cat_item.insert(); }}function createVariables(varArr, itemId) { /* * Expecting an array of object containing; * name (String) * question_text (String) * order (Number) * value (String) * type (Number) * * 1 = Yes/No * * 2 = MultiLine Text * * 3 = Multiple Choice (required "choices" = array {"name","value","order"}) * * 4 = Numeric Scale (optional "numericScaleMin", "numericScaleMax") * * 5 = Select Box (required "choices" = array {"name","value","order"}) * * 6 = Single Line Text * * 7 = Checkbox * * 8 = Reference (requires "table", "qual") * * 9 = Date * * 10 = Date/Time * * 11 = Label * * 12 = Break * * 13 = UNLISTED * * 14 = Macro * * 15 = UI Page * * 17 = Macro with Label * * 18 = Lookup Select Box (requires "table", "qual") * * 19 = Container Start * * 20 = Container End * * 21 = List Collector * * 22 = Lookup Multiple Choice * below are the additional required sometimes things * table (string) * choices (array) of {name, value, order} * qual (string) */ if (typeof varArr.name === "string") { varArr = [varArr]; } varArr.map(function(varObj){ var variableSysid; var variableExists = new GlideRecord('item_option_new'); variableExists.addQuery('name', varObj.name); variableExists.addQuery('cat_item', itemId); if (variableExists.next()) { //return variableExists.sys_id; variableSysid = variableExists.sys_id; } else { var variable = new GlideRecord('item_option_new'); variable.initialize(); variable.cat_item = itemId; variable.name = varObj.name.split(' ').join('_'); if (typeof varObj.question_text === 'undefined') { //varObj.question_text = varObj.name.replace(/_/g, ' '); var arrayOfQs = varObj.name.split(' '); varObj.question_text = ''; arrayOfQs.map(function(question){ varObj.question_text += question.charAt(0).toUpperCase(); varObj.question_text += question.substr(1, question.length); varObj.question_text += ' '; }); } variable.question_text = varObj.question_text; variable.sys_name = varObj.question_text; if (typeof varObj.order === 'undefined') { var sc_item_option = new GlideRecord('item_option_new'); sc_item_option.addQuery('cat_item', itemId); sc_item_option.orderByDesc('order'); sc_item_option.setLimit(1); sc_item_option.query(); if (sc_item_option.next()) { varObj.order = parseInt(sc_item_option.order) + 100; } else { varObj.order = 100; } } variable.order = varObj.order; variable.type = varObj.type; variable.cat_item = itemId; if (typeof varObj.value === 'undefined') { varObj.value = ''; } variable.default_value = varObj.value; variable.default_html_value = varObj.value; variable.reference = varObj.table; variable.lookup_table = varObj.table; variable.list_table = varObj.table; variable.reference_qual = varObj.qual; variable.reference_qual_condition = varObj.qual; variableSysid = variable.insert(); //return variable.insert(); } gs.print(typeof varObj.choices); gs.print(typeof varObj.choices !== 'undefined'); if (typeof varObj.choices !== 'undefined') { gs.print('choices len: ' + varObj.choices.length); varObj.choices.map(function(option){ var choice = new GlideRecord('question_choice'); choice.initialize(); choice.question = variableSysid; choice.text = option.text; choice.value = option.value; choice.order = option.order; choice.insert(); }); } });}function createUIPolicy(itemId) { var policy = new GlideRecord('catalog_ui_policy'); policy.short_description = 'Initial UI Policy'; policy.applies_to = 'item'; policy.catalog_item = itemId; var policyId = policy.insert(); var sc_item_option = new GlideRecord('item_option_new'); sc_item_option.addQuery('cat_item', itemId); sc_item_option.orderByDesc('order'); sc_item_option.query(); while (sc_item_option.next()) { var policyAction = new GlideRecord('catalog_ui_policy_action'); policyAction.catalog_item = itemId; policyAction.ui_policy = policyId; policyAction.catalog_variable = 'IO:' + sc_item_option.sys_id; policyAction.insert(); }}var catalog = createCatalog('Custom Catalog');var category = createCategory('Categories are Silly', catalog);var item = createItem({ name: 'Burger Request', short_description: 'Request a burger'}, category, catalog);var variables = [ { name: 'How delicious should it be?', type: 5, choices : [{ name:'Disgusting', value:'disgusting', order:'100' },{ name:'Tolerable', value:'tolerable', order:'200' },{ name:'Average', value:'average', order:'300' },{ name:'Good', value:'good', order:'400' }{ name:'Great', value:'great', order:'500' },] },{ name: 'Special Instructions', type: 6 } ];createVariables(variables, item);createUIPolicy(item);