-- EXEC MIG_INSERT_CREO_MAPPING_INFO_Sp
CREATE PROCEDURE MIG_INSERT_CREO_MAPPING_INFO_Sp
AS
BEGIN
	
	DELETE FROM MIG_PROP_NAMES_MAPPING WHERE AppName = 'PROE'

	INSERT INTO MIG_PROP_NAMES_MAPPING(AppName, Category, PropName, PropDescription, ControlType, LegacyPropName) 
	VALUES
	 ('PROE', 'LOCATIONS', 'p062', 'Edit Location', 'Text And Browse Button', 'EDIT_LOCATION')
	,('PROE', 'LOCATIONS', 'p063', 'View Location', 'Text And Browse Button', 'VIEW_LOCATION')
	,('PROE', 'INITAL_SAVE_OPTION', 'p054', 'Create Documents Only', 'Check Box', 'CREATE_DOCUMENTS_ONLY')
	,('PROE', 'INITAL_SAVE_OPTION', 'p055', 'Must assign an Item', 'Check Box', 'MUST_ASSIGN_AN_ITEM')
	,('PROE', 'INITAL_SAVE_OPTION', 'p056', 'Set Object Attribute During Save', 'Check Box', 'SET_ATTRIBUTES_MANUALLY')
	,('PROE', 'INITAL_SAVE_OPTION', 'p057', 'Specify Manual ID for Items', 'Check Box', 'ITEM_MANUAL_ID')
	,('PROE', 'INITAL_SAVE_OPTION', 'p058', 'Specify Manual ID for Documents', 'Check Box', 'DOCUMENT_MANUAL_ID')
	,('PROE', 'INITAL_SAVE_OPTION', 'p059', 'Generate Object-IDs based on Item-ID', 'Check Box', 'GENERATE_OBJECT_IDS_BASED_ON_ITEM_ID')
	,('PROE', 'GENERAL', 'p027', 'Allow Link to Released Items', 'Check Box', 'ALLOW_LINK_TO_RELEASED_ITEMS')
	,('PROE', 'GENERAL', 'p028', 'File Name Uniqueness', 'Combo Box', 'UNIQUE_FILE_NAMES')
	,('PROE', 'GENERAL', 'p029', 'Disable actions on view files', 'Check Box', 'DISABLE_ACTIONS_ON_VIEW_FILES')
	,('PROE', 'GENERAL', 'p030', 'Save Additional Drawings', 'Check Box', 'SAVE_ADDITIONAL_DRAWING')
	,('PROE', 'GENERAL', 'p031', 'Download Additional Drawings', 'Check Box', 'DOWNLOAD_ADDITIONAL_DRAWING')
	,('PROE', 'GENERAL', 'p032', 'Show message on successful open', 'Check Box', 'SHOW_MESSAGE_ON_SUCCESSFUL_OPEN')
	,('PROE', 'GENERAL', 'p033', 'Query Search Default', 'Combo Box', 'QUERY_SEARCH_DEFAULT')
	,('PROE', 'GENERAL', 'p034', 'Warn user when the same item is linked to parent and child components', 'Check Box', 'SHOW_BOM_ERROR_PARENT_AND_CHILD_WITH_SAME_ITEM')
	,('PROE', 'GENERAL', 'p035', 'Take Ownership during Edit File in Integration', 'Check Box', 'TAKE_OWNERSHIP_DURING_EDIT_FILE_IN_INTEGRATION')
	,('PROE', 'GENERAL', 'p036', 'Skip Mapping for RELEASED files during Download', 'Check Box', 'SKIP_MAPPING_FOR_RELEASED_FILES')
	,('PROE', 'GENERAL', 'p037', 'Set as PHANTOM Item', 'Check Box', 'ENABLE_PHANTOM_ITEM')
	,('PROE', 'GENERAL', 'p038', 'Skip Meta Data comparision during Download', 'Check Box', 'SKIP_META_DATA_COMPARISON_DURING_DOWNLOAD')
	,('PROE', 'GENERAL', 'p039', 'Warn for missing CheckIn specific modified mapping XML file', 'Check Box', 'WARN_FOR_MISSING_CHECKIN_SPECIFIC_MODIFIED_MAPPING_XML_FILE')
	,('PROE', 'GENERAL', 'p040', 'Set CAD Instance Name as Item-ID', 'Check Box', 'SET_CAD_INSTANCE_NAME_AS_ITEM_ID')
	,('PROE', 'GENERAL', 'p041', 'Generate Items for all configurations', 'Check Box', 'GENERATE_ITEM_FOR_ALL_CONFIGURATIONS')
	,('PROE', 'GENERAL', 'p042', 'Save External References', 'Check Box', 'SAVE_EXTERNAL_REFERENCE_FILES')
	,('PROE', 'GENERAL', 'p043', 'Allow reload of already opened files', 'Check Box', 'ALLOW_RELOAD_OF_ALREADY_OPENED_FILES')
	,('PROE', 'GENERAL', 'p044', 'Refresh files from PLM on local open', 'Check Box', 'REFRESH_FILES_FROM_PLM_ON_LOCAL_OPEN')
	,('PROE', 'GENERAL', 'p045', 'Create separate BOM lines for component files linked to same item', 'Check Box', 'CREATE_SEPERATE_BOM_LINES_FOR_COMPONENT_FILES_LINKED_TO_SAME_ITEM')
	,('PROE', 'GENERAL', 'p046', 'Action to be taken when MC_ERROR has non zero value', 'Combo Box', 'ACTION_TO_TAKE_WHEN_MC_ERRORS_IS_NON_ZERO')
	,('PROE', 'GENERAL', 'p047', 'Update items with "ERP Item Default Data" automatically', 'Check Box', 'SET_ERP_DEFAULT_ITEM_DATA_AUTOMATICALLY')
	,('PROE', 'GENERAL', 'p048', 'Retain Item-Drawing Links', 'Check Box', 'PLM_RETAIN_ITEM_DRAWING_LINKS')
	,('PROE', 'GENERAL', 'p049', 'Show drawings of non-Editable components', 'Check Box', 'ADD_NON_EDITABLE_COMPONENT_DRAWINGS')
	,('PROE', 'GENERAL', 'p050', 'Look for additional drawings in the storage files', 'Check Box', 'LOOK_FOR_ADDITIONAL_DRAWINGS_IN_STORAGE')
	,('PROE', 'GENERAL', 'p051', 'Force Link to Item', 'Check Box', 'FORCE_LINK_TO_ITEM')
	,('PROE', 'GENERAL', 'p052', 'Do not save OBSOLETE objects', 'Check Box', 'DISALLOW_OBSOLETE')
	,('PROE', 'GENERAL', 'p053', 'Create BOM using Master representation', 'Check Box', 'CREATE_BOM_USING_MASTER_REP')
	,('PROE', 'LINK_TO_ITEM_DIALOG', 'p060', 'Create Item Checkbox Default', 'Check Box', 'LTI_DLG_CREATE_ITEM')
	,('PROE', 'LINK_TO_ITEM_DIALOG', 'p061', 'Link to Document Checkbox Default', 'Check Box', 'LTI_DLG_LINK_ITEM_TO_DOC')
	,('PROE', 'SAVE_NEUTRAL_FILES', 'p070', 'Generate Neutral Files', 'Check Box', 'GENERATE_NEUTRAL_FILES')
	,('PROE', 'SAVE_NEUTRAL_FILES', 'p071', 'Show Neutral files during Save', 'Check Box', 'SHOW_GENERATE_NEUTRAL_FILES_DURING_SAVE')
	,('PROE', 'SAVE_NEUTRAL_FILES', 'p072', 'Generate Neutral Files during', 'Combo Box', 'NEUTRAL_FILES_GENERATION')
	,('PROE', 'SAVE_NEUTRAL_FILES', 'p073', 'Generate 3D PDFs for Model files', 'Check Box', 'GENERATE_3D_PDFS_FOR_MODELS')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p096', 'None', 'Check Box', 'NEUTRAL_FILES_PARTS_NONE')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p097', 'BMP', 'Check Box', 'NEUTRAL_FILES_PARTS_BMP')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p098', 'TIFF', 'Check Box', 'NEUTRAL_FILES_PARTS_TIFF')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p099', 'IGES', 'Check Box', 'NEUTRAL_FILES_PARTS_IGES')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p100', 'JPEG', 'Check Box', 'NEUTRAL_FILES_PARTS_JPEG')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p101', 'VRML', 'Check Box', 'NEUTRAL_FILES_PARTS_VRML')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p102', 'STEP', 'Check Box', 'NEUTRAL_FILES_PARTS_STEP')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p103', 'PDF', 'Check Box', 'NEUTRAL_FILES_PARTS_PDF')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p104', 'PVS', 'Check Box', 'NEUTRAL_FILES_PARTS_PVS')
	,('PROE', 'SAVE_NEUTRAL_FILES_PARTS', 'p105', 'PVZ', 'Check Box', 'NEUTRAL_FILES_PARTS_PVZ')
	,('PROE', 'SAVE_NEUTRAL_FILES_IPARTS', 'p095', 'Generate For All Instances', 'Check Box', 'NEUTRAL_FILES_FOR_ALL_INSTANCES')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p074', 'None', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_NONE')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p075', 'BMP', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_BMP')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p076', 'TIFF', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_TIFF')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p077', 'IGES', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_IGES')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p078', 'JPEG', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_JPEG')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p079', 'VRML', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_VRML')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p080', 'STEP', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_STEP')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p081', 'PDF', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_PDF')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p082', 'PVS', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_PVS')
	,('PROE', 'SAVE_NEUTRAL_FILES_ASSEMBLY', 'p083', 'PVZ', 'Check Box', 'NEUTRAL_FILES_ASSEMBLY_PVZ')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p084', 'None', 'Check Box', 'NEUTRAL_FILES_DRAWING_NONE')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p085', 'CGM', 'Check Box', 'NEUTRAL_FILES_DRAWING_CGM')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p086', 'DXF', 'Check Box', 'NEUTRAL_FILES_DRAWING_DXF')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p087', 'DWG', 'Check Box', 'NEUTRAL_FILES_DRAWING_DWG')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p088', 'PDF', 'Check Box', 'NEUTRAL_FILES_DRAWING_PDF')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p089', 'Drawing contains OLE Object', 'Check Box', 'DRAWING_CONTAINS_OLEOBJECTS')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p090', 'Font for PDF generation', 'Combo Box', 'FONT_FOR_PDF_GENERATION')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p091', 'Layers Export Settings', 'Combo Box', 'EXPORT_LAYERS_PDF_GENERATION')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p092', 'PVS', 'Check Box', 'NEUTRAL_FILES_DRAWING_PVS')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p093', 'PVZ', 'Check Box', 'NEUTRAL_FILES_DRAWING_PVZ')
	,('PROE', 'SAVE_NEUTRAL_FILES_DRAWING', 'p094', 'Add Searchable Text', 'Check Box', 'PDF_SEARCHABLE_TEXT')
	,('PROE', 'AFTER_SAVE', 'p001', 'Check In Cleanup', 'Combo Box', 'CHECK_IN_CLEANUP')
	,('PROE', 'AFTER_SAVE', 'p002', 'Save and Unlock Cleanup', 'Combo Box', 'SAVE_AND_UNLOCK_CLEANUP')
	,('PROE', 'AFTER_SAVE', 'p003', 'Show message on successful save', 'Check Box', 'SHOW_MESSAGE_ON_SUCCESSFUL_SAVE')
	,('PROE', 'ATTACHED_TO_WKFL', 'p004', 'Attached to Business Process', 'Combo Box', 'ATTACHED_TO_BP')
	,('PROE', 'ATTACHED_TO_WKFL', 'p005', 'Attach related Models/Drawings', 'Check Box', 'ATTACH_RELATED_MODELS_DRAWINGS')
	,('PROE', 'ATTACHED_TO_WKFL', 'p006', 'Attach all related objects', 'Check Box', 'DISPATCH_ATTACH_ALL_RELATED_OBJECTS')
	,('PROE', 'ATTACHED_TO_WKFL', 'p007', 'Allow edit Workflow', 'Check Box', 'ALLOW_EDIT_WORKFLOW')
	,('PROE', 'ATTACHED_TO_WKFL', 'p008', 'Action for objects locked by Business Process', 'Combo Box', 'ACTION_FOR_OBJECTS_LOCKED_BY_BP')
	,('PROE', 'ATTACHED_TO_WKFL', 'p009', 'Attach Draft Objects Only', 'Check Box', 'WKFL_ATTACH_UNDEFINED_OBJECTS')
	,('PROE', 'ATTACHED_TO_WKFL', 'p010', 'Attach All Items', 'Check Box', 'WKFL_ATTACH_ALL_ITEMS')
	,('PROE', 'TEMPLATE_FOR_TDL', 'p109', 'Part template', 'Browse For File', 'PART_TEMPLATE')
	,('PROE', 'TEMPLATE_FOR_TDL', 'p110', 'Assembly template', 'Browse For File', 'ASSEMBLY_TEMPLATE')
	,('PROE', 'TROUBLESHOOTING', 'p118', 'Generate Log files', 'Check Box', 'GENERATE_LOG_FILES')
	,('PROE', 'CONFIRMATION_MESSAGES', 'p017', 'Enable Download Multiple Revisions', 'Check Box', 'ENABLE_DOWNLOAD_MULTIPLE_REVISIONS')
	,('PROE', 'CONFIRMATION_MESSAGES', 'p018', 'Enable Save Older Revisions', 'Check Box', 'ENABLE_SAVE_OLDER_REVISIONS')
	,('PROE', 'CONFIRMATION_MESSAGES', 'p019', 'Disable unused rows during Download', 'Check Box', 'DISABLE_UNUSED_ROWS_DURING_EFI')
	,('PROE', 'CONFIRMATION_MESSAGES', 'p020', 'Warn when different File Version is selected during download', 'Check Box', 'WARN_REVISION_SWITCH_IN_DOWNLOAD_DIALOG')
	,('PROE', 'CONFIRMATION_MESSAGES', 'p021', 'Warn when replacing Draft File during Save', 'Check Box', 'WARN_REPLACE_PLM_UNDEFINED_FILE_DURING_SAVE')
	,('PROE', 'BALLOON_MAPPING', 'p011', 'Transfer Ballooning Information', 'Check Box', 'MAP_BALOONNING_INFORMATION')
	,('PROE', 'BALLOON_MAPPING', 'p012', 'Field in Part List table', 'Text Box', 'PART_LIST_TABLE_FIELD')
	,('PROE', 'BALLOON_MAPPING', 'p013', 'Component parameter for Balloon Mapping', 'Text Box', 'BALLOON_FIELD_ON_PROE_FILE')
	,('PROE', 'BALLOON_MAPPING', 'p014', 'Warn for duplicate Balloon IDs', 'Check Box', 'WARN_FOR_DUPLICATE_BALOON_IDS')
	,('PROE', 'BALLOON_MAPPING', 'p015', 'Warn for incorrect Ballooning', 'Check Box', 'WARN_FOR_INCORRECT_BALLOONING')
	,('PROE', 'BALLOON_MAPPING', 'p016', 'Warn for incomplete Ballooning', 'Check Box', 'WARN_FOR_INCOMPLETE_BALLOONING')
	,('PROE', 'THUMBNAILS', 'p111', 'Generate thumbnails during Save to PLM', 'Check Box', 'GENERATE_THUMBNAILS_DURING_SAVE_TO_PLM')
	,('PROE', 'THUMBNAILS', 'p112', 'Generate thumbnails for part file types', 'Check Box', 'GENERATE_THUMBNAILS_FOR_PARTS')
	,('PROE', 'THUMBNAILS', 'p113', 'Generate thumbnails for assembly file types', 'Check Box', 'GENERATE_THUMBNAILS_FOR_ASSEMBLIES')
	,('PROE', 'THUMBNAILS', 'p114', 'Generate thumbnails for drawing file types', 'Check Box', 'GENERATE_THUMBNAILS_FOR_DRAWINGS')
	,('PROE', 'THUMBNAILS', 'p115', 'Generate thumbnails for CAD file structure', 'Combo Box', 'THUMBNAIL_GENERATION_FOR_SUBSTRUCTURE')
	,('PROE', 'THUMBNAILS', 'p116', 'Format for thumbnails generation', 'Combo Box', 'THUMBNAIL_TYPE_FOR_GENERATION')
	,('PROE', 'THUMBNAILS', 'p117', 'Thumbnails Size', 'Text Box', 'THUMBNAILS_SIZE')
	,('PROE', 'SAVE_DOWNLOAD_BACKUP_FILES', 'p068', 'Save and Download backup files', 'Check Box', 'SAVE_AND_DOWNLOAD_BACKUP_FILES')
	,('PROE', 'SAVE_DOWNLOAD_BACKUP_FILES', 'p069', 'Number of last backup file versions to download', 'Text Box', 'NUMBER_OF_BACKUP_VERSOINS_TO_DOWNLOAD')
	,('PROE', 'SET_ITEM_ID_INITIAL_SAVE', 'p106', 'Set Item-ID based on', 'Combo Box', 'INITAL_SETTING_OF_ITEM_ID_TO_MATCH_FILENAME')
	,('PROE', 'SET_ITEM_ID_INITIAL_SAVE', 'p107', 'Action to take if Item-ID exists in PLM database', 'Combo Box', 'ACTION_TO_TAKE_IF_ITEMID_EXISTS_IN_PLM')
	,('PROE', 'SET_ITEM_ID_INITIAL_SAVE', 'p108', 'Action to take when same Item-ID is generated for multiple files', 'Combo Box', 'DUPLICATE_ITEM_IDS_ACTION')
	,('PROE', 'SAVE_CHANGES_TO_PLM', 'p066', 'Save only modified files', 'Check Box', 'SAVE_MODIFIED_FILES_ONLY')
	,('PROE', 'SAVE_CHANGES_TO_PLM', 'p067', 'Do not traverse child files under non-modified files', 'Check Box', 'DO_NOT_TRAVERSE_CHILDS_OF_NONMODIFIED_FILES')
	,('PROE', 'COPY_PRODUCT_STRUCTURE', 'p022', 'Rename Family Table Instances', 'Check Box', 'RENAME_FAMILY_TABLE_INSTANCES')
	,('PROE', 'DEFAULT_MAPPING_TEMPLATE', 'p023', 'Assign Default Mapping Template Only for the new files', 'Check Box', 'ASSIGN_DEFAULT_MAPPING_TEMPLATES_ONLY_FOR_THE_NEW_FILES')
	,('PROE', 'DEFAULT_MAPPING_TEMPLATE', 'p024', 'Default mapping template for part files', 'Combo Box', 'DEFAULT_MAPPING_TEMPLATE_PART_FILES')
	,('PROE', 'DEFAULT_MAPPING_TEMPLATE', 'p025', 'Default mapping template for Assembly files', 'Combo Box', 'DEFAULT_MAPPING_TEMPLATE_ASSEMBLY_FILES')
	,('PROE', 'DEFAULT_MAPPING_TEMPLATE', 'p026', 'Default mapping template for Drawing files', 'Combo Box', 'DEFAULT_MAPPING_TEMPLATE_DRAWING_FILES')
	,('PROE', 'PERFORMANCE', 'p064', 'Read external references of active features only', 'Check Box', 'READ_ACTIVE_FEAT_REFERENCES')
	,('PROE', 'PERFORMANCE', 'p065', 'Read external references of components in current structure only', 'Check Box', 'READ_ACTIVE_STRUCTURE_FILE_REFERENCES')

END

