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',
+ },
]