--EXEC MIG_INSERT_PLM_PREFS_MAPPING_INFO_Sp
CREATE PROCEDURE MIG_INSERT_PLM_PREFS_MAPPING_INFO_Sp
AS
BEGIN

	--=CONCAT("INSERT INTO MIG_PROP_NAMES_MAPPING(AppName, Category, PropName, PropDescription, ControlType, LegacyPropName) VALUES('TOOLKIT', '", A2, "', '", B2, "', '", C2, "', '", D2, "', '", E2, "')")
	DELETE FROM MIG_PROP_NAMES_MAPPING WHERE AppName = 'WEBPLM'

	INSERT INTO MIG_PROP_NAMES_MAPPING(AppName, Category, PropName, PropDescription, ControlType, LegacyPropName) VALUES
	 ('WEBPLM', 'REVISION_CONTROL', 'w001', 'Selective Check-Out Levels', 'Text Box', 'SELECTIVE_CHECK_OUT_LEVELS')
	,('WEBPLM', 'WORKFLOW_TAG', 'w002', 'Default Attach to Business Process', 'Combo Box', 'DEFAULT_ATTACH_TO_BP')
	,('WEBPLM', 'GENERAL', 'w003', 'Default Project', 'Text Box', 'DEFAULT_PROJECT')
	,('WEBPLM', 'GENERAL', 'w007', 'PLM Email Address From', 'Text Box', 'PLM_EMAIL_ADDRESS_FROM')
	,('WEBPLM', 'IMPORT_AND_EXPORT', 'w008', 'Skip Meta Data in Export', 'Check Box', 'SKIP_METADATA_IN_EXPORT')
	,('WEBPLM', 'WORKFLOW_TAG', 'w009', 'Allow Check-In and Check-Out Steps with No Valid Objects Attached', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w010', 'Workflow handle only Locked Object', 'Check Box', 'WF_RESTRICT_LOCKING_BP_ONLY_VCTL')
	,('WEBPLM', 'GENERAL', 'w011', 'Copy classification during duplicate object', 'Check Box', 'COPY_CLASSIFICATION_DURING_DUPLICATE')
	,('WEBPLM', 'REVISION_CONTROL', 'w012', 'Allow Check-Out Latest Created Only', 'Check Box', 'ALLOW_CHECKOUT_LATEST_CREATED_ONLY')
	,('WEBPLM', 'GENERAL', 'w013', 'Allow linking to released Item', 'Check Box', 'ALLOW_LINK_RELEASED_ITEM')
	,('WEBPLM', 'GENERAL', 'w014', 'Allow linking to released Document', 'Check Box', 'ALLOW_LINK_RELEASED_DOC')
	,('WEBPLM', 'FILES', 'w016', 'Enable file security based on synchronization rules', 'Check Box', 'FILE_SECURITY_BASED_ON_SYNCHRONIZATION')
	,('WEBPLM', 'GENERAL', 'w017', 'Change Project Owner removes access to original Project', 'Check Box', 'REMOVE_ORIG_PROJECT_AUTH')
	,('WEBPLM', 'GENERAL', 'w018', 'Show Drag and Drop Confirmation Dialog', 'Check Box', 'SHOW_DRAG_DROP_CONFIRMATION_DIALOG')
	,('WEBPLM', 'WORKFLOW_TAG', 'w019', 'Allow locked objects in new BP', 'Check Box', 'ALLOW_LOCKED_OBJS_IN_NEW_BP')
	,('WEBPLM', 'GENERAL', 'w020', 'Manual Revision must comply with Mask', 'Check Box', 'FORCE_REVISION_MASK_COMPLIANCE')
	,('WEBPLM', 'GENERAL', 'w021', 'Add leading Zeroes in Find No.', 'Check Box', 'ADD_LEADING_ZEROS_FIND_NO')
	,('WEBPLM', 'REVISION_CONTROL', 'w022', 'Check-Out action (for Documents) Remove links to non-effective Items', 'Check Box', 'UNLINK_NON_EFFECTIVE_LINKED_ITEM')
	,('WEBPLM', 'FILES', 'w023', 'On-demand file multi-vault synchronization', 'Check Box', 'FILE_MULTI_SITE_SYNCHRONIZATION_ON_DEMAND')
	,('WEBPLM', 'GENERAL', 'w024', 'Consider User Default Project during Duplicate of Object', 'Check Box', 'CONSIDER_DEFAULT_PROJECT_DURING_DUPLICATE')
	,('WEBPLM', 'GENERAL', 'w025', 'Reference Designators range indicator', 'Text And Browse Button', 'REF_DESIGNATORS_RANGE_INDICATOR')
	,('WEBPLM', 'GENERAL', 'w026', 'Use Reference Designators', 'Check Box', 'REF_DESIGNATORS_IN_USE')
	,('WEBPLM', 'FILES', 'w027', 'Ignore Neutral Files during Edit/View of Files', 'Check Box', 'IGNORE_NF_DURING_EDIT_OR_VIEW_OF_CADFILES')
	,('WEBPLM', 'FILES', 'w028', 'GUI File', 'Text Box', 'GUI_FILE')
	,('WEBPLM', 'FILES', 'w029', 'File Name Uniqueness', 'Combo Box', 'UNIQUE_FILE_NAMES')
	,('WEBPLM', 'FILES', 'w030', 'Thumbnails Size', 'Text And Browse Button', 'THUMBNAILS_SIZE')
	,('WEBPLM', 'FILES', 'w031', 'Synchronize files via Main Vault only', 'Check Box', 'SYNCHRONIZE_FILES_VIA_MAIN_SITE')
	,('WEBPLM', 'FILES', 'w032', 'Download File Location', 'Text And Browse Button', 'WEBPLM_FILE_DOWNLOAD_LOCATION')
	,('WEBPLM', 'REVISION_CONTROL', 'w033', 'Check-In/Out sync all up to date sites', 'Check Box', 'FILE_CHECKINOUT_SYNC_ALL_UPTODATE_SITES')
	,('WEBPLM', 'FILES', 'w034', 'Default File Viewer Zoom Value', 'Check Box', 'DEFAULT_FILE_VIEWER_ZOOM_VALUE')
	,('WEBPLM', 'PERFORMANCE', 'w035', 'Refresh Task List after approval', 'Check Box', 'REFRESH_TASK_LIST_AFTER_APPROVAL')
	,('WEBPLM', 'PROJECTS', 'w036', 'Allow cross-project authorization for logical links', 'Check Box', 'ALLOW_LINK_ACROSS_PROJECTS')
	,('WEBPLM', 'PROJECTS', 'w037', 'Allow cross-project authorization for hierarchical links', 'Check Box', 'ALLOW_PS_LINK_ACROSS_PROJECTS')
	,('WEBPLM', 'REVISION_CONTROL', 'w038', 'Cross Project Authorization for Check-In/Check-Out Operations', 'Check Box', 'ALLOW_CROSS_PROJECT_OBJECTS')
	,('WEBPLM', 'QUERY', 'w039', 'Reminder to Save Query', 'Check Box', 'ASK_TO_SAVE_QUERY')
	,('WEBPLM', 'QUERY', 'w040', 'Default Revision Option', 'Combo Box', 'DEFAULT_REVISION_OPTION')
	,('WEBPLM', 'ERP_OBJECTS', 'w041', 'ERP Version', 'Combo Box', 'ERP_VERSION')
	,('WEBPLM', 'ERP_OBJECTS', 'w042', 'ERP Company', 'Text Box', 'ERP_COMPANY')
	,('WEBPLM', 'ERP_OBJECTS', 'w043', 'ERP Connection using ION', 'Check Box', 'ERP_CONNECTION_USING_ION')
	,('WEBPLM', 'ERP_OBJECTS', 'w044', 'Force Sending WBS/WP to Element', 'Check Box', 'FORCE_ELEMENT_FOR_WBS_WP')
	,('WEBPLM', 'SEND_TO_PRODUCTION', 'w045', 'Tree Levels', 'Text And Browse Button', 'TREE_LEVELS')
	,('WEBPLM', 'SEND_TO_PRODUCTION', 'w047', 'Send BOM Designed for Purchase', 'Check Box', 'SEND_BOM_DESIGNED_FOR_PURCHASE')
	,('WEBPLM', 'SEND_TO_WBS_WP', 'w048', 'Send Items to ERP', 'Check Box', 'CHK_SEND_TO_PRODUCTION')
	,('WEBPLM', 'SEND_TO_WBS_WP', 'w050', 'Send BOM Designed for Purchase', 'Check Box', 'SEND_BOM_DESIGNED_FOR_PURCHASE_TO_WBS_WP')
	,('WEBPLM', 'WORKAREAS', 'w051', 'Number of Levels in Structure Pane', 'Text Box', 'NUMBER_OF_LEVELS_IN_STRUCTURE')
	,('WEBPLM', 'WORKFLOW_TAG', 'w052', 'Restrict use of Dispatch according to Workflow Template Association', 'Check Box', 'USE_WF_TEMPLATE_ASSOCIATION')
	,('WEBPLM', 'WORKFLOW_TAG', 'w053', 'Strict Workflow Association Rules', 'Check Box', 'STRICT_WORKFLOW_ASSOCIATION_RULES')
	,('WEBPLM', 'WORKFLOW_TAG', 'w054', 'Repeat Email Reminder for Task until it is done', 'Check Box', 'REPEAT_TASK_REMINDER')
	,('WEBPLM', 'WORKFLOW_TAG', 'w055', 'Repeat Email Reminder for Task - Time Unit', 'Combo Box', 'REPEAT_TASK_REMINDER_UNIT')
	,('WEBPLM', 'WORKFLOW_TAG', 'w056', 'Repeat Email Reminder for Task - Frequency', 'Text Box', 'REPEAT_TASK_REMINDER_FREQ')
	,('WEBPLM', 'WORKFLOW_TAG', 'w057', 'Notify Originator when Business Process is complete', 'Check Box', 'ORIGINATOR_GET_EMAIL_BP_COMPLETE')
	,('WEBPLM', 'WORKFLOW_TAG', 'w058', 'Notify Originator when Business Process is suspended', 'Check Box', 'ORIGINATOR_GET_EMAIL_BP_SUSPENDED')
	,('WEBPLM', 'WORKFLOW_TAG', 'w059', 'Notify Originator when Business Process is cancelled', 'Check Box', 'ORIGINATOR_GET_EMAIL_BP_CANCELLED')
	,('WEBPLM', 'WORKFLOW_TAG', 'w060', 'Notify Originator when Business Process is resumed', 'Check Box', 'ORIGINATOR_GET_EMAIL_BP_RESUMED')
	,('WEBPLM', 'WORKFLOW_TAG', 'w061', 'Notify Originator when Business Process is rejected', 'Check Box', 'ORIGINATOR_GET_EMAIL_BP_REJECTED')
	,('WEBPLM', 'USE_LOCAL_TOOLKIT', 'w063', 'File Transfer with Locally Installed Toolkit', 'Check Box', 'TRANSFER_FILES_USING_LOCAL_TOOLKIT')
	,('WEBPLM', 'USE_LOCAL_TOOLKIT', 'w064', 'Edit File location', 'Text And Browse Button', 'WEBPLM_EDIT_LOCATION')
	,('WEBPLM', 'USE_LOCAL_TOOLKIT', 'w065', 'View File Location', 'Text And Browse Button', 'WEBPLM_VIEW_LOCATION')
	,('WEBPLM', 'USE_LOCAL_TOOLKIT', 'w066', 'Do Not Create extra Folder for View File', 'Check Box', 'DO_NOT_CREATE_EXTRA_FOLDER_FOR_VIEW_FILE')
	,('WEBPLM', 'PARTNER_NET', 'w067', 'Receive email when publication is approved or rejected', 'Check Box', 'MAIL_APPROVE_REJECT')
	,('WEBPLM', 'PARTNER_NET', 'w068', 'Receive email when new publication is assigned', 'Check Box', 'MAIL_NEW_PUBLICATION')
	,('WEBPLM', 'PARTNER_NET', 'w069', 'Receive email when new note is added', 'Check Box', 'MAIL_NEW_NOTE')
	,('WEBPLM', 'PARTNER_NET', 'w070', 'Receive email when new publication is posted in the project', 'Check Box', 'MAIL_NEW_PUBL_IN_PROJECT')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w071', 'Mode', 'Combo Box', 'CONSIST_MODE')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w072', 'Fix', 'Combo Box', 'CONSIST_FIX')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w073', 'Shared Project', 'Text Box', 'POOL_PROJ')
	,('WEBPLM', 'REVISION_CONTROL', 'w074', 'Enable read write lock for Check-In/Check-Out', 'Check Box', 'ENABLE_CHECK_IN_OUT_RW_LOCK')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w075', 'Require Additional Confirmation', 'Check Box', 'TASK_APPROVE_DOUBLE')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w076', 'Force addition of Reason', 'Check Box', 'WF_MANDATORY_COMMENTS')
	,('WEBPLM', 'BUSINESS_PARTNER', 'w077', 'Maintain Customer Part Number', 'Check Box', 'CUSTOMER_PART_NO')
	,('WEBPLM', 'BUSINESS_PARTNER', 'w078', 'Maintain Supplier Part Number', 'Check Box', 'SUPPLIER_PART_NO')
	,('WEBPLM', 'GENERAL', 'w079', 'All Projects Mode', 'Check Box', 'ALL_PROJECTS')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w080', 'Authorize Items to All Projects', 'Check Box', 'ITEM PROJ_SHARE')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w081', 'Authorize Documents to All Projects', 'Check Box', 'DOC PROJ_SHARE')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w082', 'Authorize Folders to All Projects', 'Check Box', 'FOLDER PROJ_SHARE')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w083', 'Ignore Missing numbers during Mask generation', 'Check Box', '')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w084', 'Email address to be used by PLM', 'Text Box', 'MAIL_FROM_ADDR')
	,('WEBPLM', 'CLASSIFICATION_PARAMETERS', 'w085', 'Author must Classify Items', 'Check Box', 'AUTHOR_MUST_CLASSIFY_ITEM')
	,('WEBPLM', 'CLASSIFICATION_PARAMETERS', 'w086', 'Author must Classify Documents', 'Check Box', 'AUTHOR_MUST_CLASSIFY_DOC')
	,('WEBPLM', 'CLASSIFICATION_PARAMETERS', 'w087', 'Author must Classify Materials', 'Check Box', 'AUTHOR_MUST_CLASSIFY_MATERIAL')
	,('WEBPLM', 'IMPORT_AND_EXPORT', 'w088', 'PLM Export Path', 'Text Box', '')
	,('WEBPLM', 'IMPORT_AND_EXPORT', 'w089', 'PLM Import Path', 'Text Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w090', 'Action on multiple revisions selected', 'Combo Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w091', 'Log Staging Times', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w092', 'Select option to recreate links during Undo Check-Out', 'Combo Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w093', 'Disable automatic Check-In of child documents', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w094', 'Delete Ineffective Links (On Check-In)', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w095', 'Display report on Revision Control Operations', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w096', 'Re-create links using look-up table (On Undo Check-In)', 'Check Box', '')
	,('WEBPLM', 'CLASSIFICATION_PARAMETERS', 'w097', 'Classification In Use', 'Check Box', 'CLASSIFICATION_IN_USE')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w098', 'Check Out Major', 'Check Box', 'CHECK_OUT_MAJOR')
	,('WEBPLM', 'REVISION_CONTROL', 'w099', 'Manage Files using Base Versioning', 'Check Box', '')
	,('WEBPLM', 'DEFAULT_TEMPLATES', 'w100', 'Items', 'Text And Browse Button', '')
	,('WEBPLM', 'DEFAULT_TEMPLATES', 'w101', 'BOM', 'Text And Browse Button', '')
	,('WEBPLM', 'DEFAULT_TEMPLATES', 'w102', 'Documents', 'Text And Browse Button', '')
	,('WEBPLM', 'DEFAULT_TEMPLATES', 'w103', 'Folders', 'Text And Browse Button', '')
	,('WEBPLM', 'DEFAULT_TEMPLATES', 'w104', 'Files', 'Text And Browse Button', '')
	,('WEBPLM', 'DEFAULT_TEMPLATES', 'w105', 'Business Process', 'Text And Browse Button', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w106', 'Skip DAL authorization checks', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w107', 'Skip Circular Loop detection check', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w108', 'Manage thumbnails using Base Versioning', 'Check Box', '')
	,('WEBPLM', 'CLASSIFICATION_PARAMETERS', 'w109', 'Display Boolean attributes as list-box in Classification Dialog', 'Check Box', '')
	,('WEBPLM', 'FILES', 'w112', 'Show Navigation Session', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w113', 'Traverse using table (instead of JSON)', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w114', 'During Undo Check-Out, delegate files deletion to background job', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w115', 'Derived version action on re-upload of base version', 'Combo Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w117', 'Mark documents for text search indexing on Check-In', 'Combo Box', '')
	,('WEBPLM', 'SYSTEM_PARAMETERS', 'w118', 'Generate Mask using BMS', 'Check Box', '')
	,('WEBPLM', 'REVISION_CONTROL', 'w121', 'Action on derived version on thumbnails re-upload of base versions', 'Combo Box', '')
	,('WEBPLM', 'ERP_OBJECTS', 'w122', 'Impact Analysis Configuration', 'Text And Browse Button', '')
	,('WEBPLM', 'ERP_OBJECTS', 'w123', 'ERP Site', 'Text Box', '')

END

