-- EXEC MIG_INSERT_MSOFFICE_MAPPING_INFO_Sp
CREATE PROCEDURE MIG_INSERT_MSOFFICE_MAPPING_INFO_Sp
AS
BEGIN

	DELETE FROM MIG_PROP_NAMES_MAPPING WHERE AppName = 'MSOFFICE'

	INSERT INTO MIG_PROP_NAMES_MAPPING(AppName, Category, PropName, PropDescription, ControlType, LegacyPropName) VALUES
	 ('MSOFFICE', 'LOCATIONS', 'o001', 'Edit Location', 'Text And Browse Button', 'EDIT_LOCATION')
	,('MSOFFICE', 'LOCATIONS', 'o002', 'View Location', 'Text And Browse Button', 'VIEW_LOCATION')
	,('MSOFFICE', 'INITAL_SAVE_OPTION', 'o003', 'Specify Manual ID for Documents', 'Check Box', 'DOCUMENT_MANUAL_ID')
	,('MSOFFICE', 'INITAL_SAVE_OPTION', 'o006', 'Set Object Attribute During Save', 'Check Box', 'SET_ATTRIBUTES_MANUALLY')
	,('MSOFFICE', 'INITAL_SAVE_OPTION', 'o009', 'Concatenate Item-ID/File-ID', 'Check Box', 'APPLY_PI_NAMING_CONVENTION')
	,('MSOFFICE', 'GENERAL', 'o004', 'File Name Uniqueness', 'Combo Box', 'UNIQUE_FILE_NAMES')
	,('MSOFFICE', 'GENERAL', 'o005', 'Query Search Default', 'Combo Box', 'QUERY_SEARCH_DEFAULT')
	,('MSOFFICE', 'GENERAL', 'o021', 'Fill ToCAD Mapping values only in blank fields', 'Check Box', 'APPLY_TOCAD_MAPPING_ON_EMPTY_PROPS')
	,('MSOFFICE', 'GENERAL', 'o024', 'Synchronize PDF generation', 'Check Box', 'SETUPTODATE_WAIT_FOR_PDF')
	,('MSOFFICE', 'GENERAL', 'o027', 'Do not calculate the formulas during download', 'Check Box', 'DISABLE_WORKBOOK_CALCULATION_DOWNLOAD')
	,('MSOFFICE', 'AFTER_SAVE', 'o007', 'Show message on successful save', 'Check Box', 'SHOW_MESSAGE_ON_SUCCESSFUL_SAVE')
	,('MSOFFICE', 'AFTER_SAVE', 'o014', 'Check In Cleanup', 'Combo Box', 'CHECK_IN_CLEANUP')
	,('MSOFFICE', 'AFTER_SAVE', 'o015', 'Save and Unlock Cleanup', 'Combo Box', 'SAVE_AND_UNLOCK_CLEANUP')
	,('MSOFFICE', 'TROUBLESHOOTING', 'o008', 'Generate Log files', 'Check Box', 'GENERATE_LOG_FILES')
	,('MSOFFICE', 'ATTACHED_TO_WKFL', 'o010', 'Attached to Business Process', 'Combo Box', 'ATTACHED_TO_BP')
	,('MSOFFICE', 'ATTACHED_TO_WKFL', 'o011', 'Attach all related objects', 'Check Box', 'DISPATCH_ATTACH_ALL_RELATED_OBJECTS')
	,('MSOFFICE', 'ATTACHED_TO_WKFL', 'o012', 'Attach Draft Objects Only', 'Check Box', 'WKFL_ATTACH_UNDEFINED_OBJECTS')
	,('MSOFFICE', 'ATTACHED_TO_WKFL', 'o013', 'Allow edit Workflow', 'Check Box', 'ALLOW_EDIT_WORKFLOW')
	,('MSOFFICE', 'LINK_TO_EXISTING_ITEM_FOLDER', 'o016', 'Enable Automatic Link to Item and/or Folder', 'Check Box', 'ENABLE_LINK_TO_EXISTING_ITEM_FOLDER')
	,('MSOFFICE', 'LINK_TO_EXISTING_ITEM_FOLDER', 'o017', 'Item ID property name', 'Text Box', 'ITEM_ID_ATTR_ON_FILE')
	,('MSOFFICE', 'LINK_TO_EXISTING_ITEM_FOLDER', 'o018', 'Folder ID property name', 'Text Box', 'FOLDER_ID_ATTR_ON_FILE')
	,('MSOFFICE', 'LINK_TO_EXISTING_ITEM_FOLDER', 'o019', 'Alternate Folder ID Property', 'Text Box', 'FOLDERALT_ID_ATTR_ON_FILE')
	,('MSOFFICE', 'OUTLOOK', 'o026', 'Append Received Time on the Outlook Message to the filename', 'Check Box', 'APPEND_RECEIVED_TIME_TO_FILENAME')
	,('MSOFFICE', 'THUMBNAILS', 'o020', 'Thumbnails Size', 'Text Box', 'THUMBNAILS_SIZE')
	,('MSOFFICE', 'DEFAULT_MAPPING_TEMPLATE', 'o022', 'Assign Default Mapping Template Only for the new files', 'Check Box', 'ASSIGN_DEFAULT_MAPPING_TEMPLATES_ONLY_FOR_THE_NEW_FILES')
	,('MSOFFICE', 'DEFAULT_MAPPING_TEMPLATE', 'o023', 'Default Mapping Template for Outlook Files', 'Combo Box', 'DEFAULT_MAPPING_TEMPLATE_OUTLOOK')
	,('MSOFFICE', 'SAVE_NEUTRAL_FILES', 'o028', 'Generate Neutral Files', 'Check Box', 'GENERATE_NEUTRAL_FILES')
	,('MSOFFICE', 'SAVE_NEUTRAL_FILES', 'o029', 'Show Neutral files during Save', 'Check Box', 'SHOW_GENERATE_NEUTRAL_FILES_DURING_SAVE')
	,('MSOFFICE', 'SAVE_NEUTRAL_FILES_EXCEL', 'o030', 'None', 'Check Box', 'NEUTRAL_FILES_EXCEL_NONE')
	,('MSOFFICE', 'SAVE_NEUTRAL_FILES_EXCEL', 'o031', 'PDF', 'Check Box', 'NEUTRAL_FILES_EXCEL_PDF')
	,('MSOFFICE', 'SAVE_NEUTRAL_FILES_WORD', 'o032', 'None', 'Check Box', 'NEUTRAL_FILES_WORD_NONE')
	,('MSOFFICE', 'SAVE_NEUTRAL_FILES_WORD', 'o033', 'PDF', 'Check Box', 'NEUTRAL_FILES_WORD_PDF')
	,('MSOFFICE', 'SAVE_NEUTRAL_FILES_POWERPOINT', 'o034', 'None', 'Check Box', 'NEUTRAL_FILES_POWERPOINT_NONE')
	,('MSOFFICE', 'SAVE_NEUTRAL_FILES_POWERPOINT', 'o035', 'PDF', 'Check Box', 'NEUTRAL_FILES_POWERPOINT_PDF')

END

