--EXEC MIG_INSERT_TOOLKIT_MAPPING_INFO_Sp
CREATE PROCEDURE MIG_INSERT_TOOLKIT_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 = 'TOOLKIT'

	INSERT INTO MIG_PROP_NAMES_MAPPING(AppName, Category, PropName, PropDescription, ControlType, LegacyPropName) 
	VALUES('TOOLKIT', 'GENERAL', 't001', 'Synchronize All Files During "Save"', 'Check Box', 'SYNCCADHEADER_FOR_ALL_MODEL_FILES')
	,('TOOLKIT', 'GENERAL', 't002', 'Show synchronize message during "Save"', 'Check Box', 'SHOW_SYNC_MESSAGE_DURING_SAVE')
	,('TOOLKIT', 'GENERAL', 't003', 'Ignore Items', 'Check Box', 'IGNORE_ITEMS')
	,('TOOLKIT', 'GENERAL', 't004', 'Disable BOM Creation/Modification during "Save"', 'Check Box', 'DISABLE_BOM_MODIFICATION')
	,('TOOLKIT', 'GENERAL', 't005', 'Show Top Down Load report', 'Check Box', 'SHOW_TOP_DOWN_LOAD_REPORT')
	,('TOOLKIT', 'GENERAL', 't006', 'Enable Selective Checkout', 'Check Box', 'ENABLE_SELECTIVE_CHECKOUT')
	,('TOOLKIT', 'GENERAL', 't007', 'Check out all linked items during automatic checkout', 'Check Box', 'AUTOMATIC_CHECKOUT_WITH_ALL_LINKED_ITEMS')
	,('TOOLKIT', 'GENERAL', 't008', 'Local Release Synch', 'Combo Box', 'LOCAL_RELEASE_SYNC')
	,('TOOLKIT', 'GENERAL', 't009', 'Automatically set resolve filename to New', 'Check Box', 'AUTOMATICALLY_SET_RESOLVE_FILENAME_TO_NEW')
	,('TOOLKIT', 'GENERAL', 't010', 'Single file sync (during save)', 'Combo Box', 'LOCAL_SINGLE_FILE_SYNC')
	,('TOOLKIT', 'GENERAL', 't012', 'Disable Set Object Attribute During Save', 'Check Box', 'DISABLE_ATTRIBUTE_GUI')
	,('TOOLKIT', 'GENERAL', 't013', 'Set Document Description to Upper Case', 'Check Box', 'SET_DOC_DESC_TO_UPPER_FILENAME')
	,('TOOLKIT', 'GENERAL', 't014', 'Verify latest revision', 'Check Box', 'VERIFY_LATEST_REVISION')
	,('TOOLKIT', 'GENERAL', 't015', 'Delete links with previous revisions', 'Check Box', 'DELETE_LINKS_WITH_PREVIOUS_REVISIONS')
	,('TOOLKIT', 'GENERAL', 't016', 'Skip Circular Link Loop', 'Check Box', 'SKIP_CIRCULAR_LINK_LOOP')
	,('TOOLKIT', 'GENERAL', 't017', 'Compress open response', 'Check Box', 'ZIP_OPEN_RESPONSE')
	,('TOOLKIT', 'GENERAL', 't018', 'Compress open response objects threshold', 'Text Box', 'ZIP_OPEN_RESPONSE_OBJECTS_THRESHOLD')
	,('TOOLKIT', 'GENERAL', 't052', 'Auto truncate field value based on PLM field length', 'Check Box', 'AUTO_TRUNCATE_STRING_FIELD_VALUE_BASED_ON_PLM_FIELD_LENGTH')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't019', 'Document', 'Text Box', 'DOC')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't020', 'DOT', 'Text Box', 'DOT')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't021', 'XLS', 'Text Box', 'XLS')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't022', 'PPT', 'Text Box', 'PPT')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't023', 'PPS', 'Text Box', 'PPS')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't024', 'POT', 'Text Box', 'POT')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't025', 'MSG', 'Text Box', 'MSG')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't026', 'MPP', 'Text Box', 'MPP')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't027', 'SLDPRT', 'Text Box', 'SLDPRT')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't028', 'SLDASM', 'Text Box', 'SLDASM')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't029', 'SLDDRW', 'Text Box', 'SLDDRW')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't030', 'DWG', 'Text Box', 'DWG')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't031', 'IPT', 'Text Box', 'IPT')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't032', 'IAM', 'Text Box', 'IAM')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't033', 'IDW', 'Text Box', 'IDW')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't034', 'DOCX', 'Text Box', 'DOCX')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't035', 'DOTX', 'Text Box', 'DOTX')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't036', 'XLSX', 'Text Box', 'XLSX')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't037', 'PPTX', 'Text Box', 'PPTX')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't038', 'PPSX', 'Text Box', 'PPSX')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't039', 'POTX', 'Text Box', 'POTX')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't040', 'MSGX', 'Text Box', 'MSGX')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't041', 'MPPX', 'Text Box', 'MPPX')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't042', 'CATProduct', 'Text Box', 'CATProduct')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't043', 'CATPart', 'Text Box', 'CATPart')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't044', 'PAR', 'Text Box', 'PAR')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't045', 'ASM', 'Text Box', 'ASM')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't046', 'DFT', 'Text Box', 'DFT')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't047', 'PSM', 'Text Box', 'PSM')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't048', 'PRT', 'Text Box', 'PRT')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't049', 'XLSM', 'Text Box', 'XLSM')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't050', 'DOCM', 'Text Box', 'DOCM')
	,('TOOLKIT', 'TOOLKIT_EXT_TO_ORIG_APP', 't051', 'STP', 'Text Box', 'STP')
	,('TOOLKIT', 'DOWNLOAD_OPTIONS', 't053', 'Use Wildcard(*)', 'Check Box', 'DOWNLOAD_USE_WILDCARD')
	,('TOOLKIT', 'DOWNLOAD_OPTIONS', 't054', 'Open for Editing', 'Check Box', 'DOWNLOAD_OPEN_FOR_EDITING')
	,('TOOLKIT', 'DOWNLOAD_OPTIONS', 't055', 'Show Thumbnails', 'Check Box', 'DOWNLOAD_SHOW_THUMBNAILS')
	,('TOOLKIT', 'DOWNLOAD_OPTIONS', 't056', 'Ignore Case', 'Check Box', 'DOWNLOAD_IGNORE_CASE')
	,('TOOLKIT', 'GENERAL', 't057', 'Default Tab', 'Combo Box', 'DEFAULT_TAB_FOR_SET_OBJECT_ATTRIBUTES_DIALOG')

END

