change cancelled profiles to disabled and show in profile list
diff --git a/patches/november_2012/disable_cancelled_profiles.py b/patches/november_2012/disable_cancelled_profiles.py
new file mode 100644
index 0000000..cc682dc
--- /dev/null
+++ b/patches/november_2012/disable_cancelled_profiles.py
@@ -0,0 +1,8 @@
+import webnotes
+def execute():
+	"""
+		in old system, deleted profiles were set as docstatus=2
+		in new system, its either disabled or deleted.
+	"""
+	webnotes.conn.sql("""update `tabProfile` set docstatus=0, enabled=0
+		where docstatus=2""")
\ No newline at end of file
diff --git a/patches/patch_list.py b/patches/patch_list.py
index 30eca6b..2d17f33 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -671,4 +671,8 @@
 		'patch_module': 'patches.november_2012',
 		'patch_file': 'reset_appraisal_permissions',
 	},
+	{
+		'patch_module': 'patches.november_2012',
+		'patch_file': 'disable_cancelled_profiles',
+	},
 ]