[minor] [patch] update reqd fields in reports
diff --git a/patches/1311/p01_cleanup.py b/patches/1311/p01_cleanup.py
index 3fd798a..ecd7b39 100644
--- a/patches/1311/p01_cleanup.py
+++ b/patches/1311/p01_cleanup.py
@@ -1,6 +1,7 @@
# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
# License: GNU General Public License v3. See license.txt
+from __future__ import unicode_literals
import webnotes
def execute():
diff --git a/patches/1311/p01_make_gl_entries_for_si.py b/patches/1311/p01_make_gl_entries_for_si.py
index 84e0712..5148c63 100644
--- a/patches/1311/p01_make_gl_entries_for_si.py
+++ b/patches/1311/p01_make_gl_entries_for_si.py
@@ -1,6 +1,7 @@
# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
# License: GNU General Public License v3. See license.txt
+from __future__ import unicode_literals
import webnotes
def execute():
diff --git a/patches/1311/p02_index_singles.py b/patches/1311/p02_index_singles.py
index 94fb197..a949680 100644
--- a/patches/1311/p02_index_singles.py
+++ b/patches/1311/p02_index_singles.py
@@ -1,5 +1,6 @@
# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
# License: GNU General Public License v3. See license.txt
+from __future__ import unicode_literals
def execute():
import webnotes
diff --git a/patches/1311/p03_update_reqd_report_fields.py b/patches/1311/p03_update_reqd_report_fields.py
new file mode 100644
index 0000000..a46c557
--- /dev/null
+++ b/patches/1311/p03_update_reqd_report_fields.py
@@ -0,0 +1,17 @@
+# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd.
+# License: GNU General Public License v3. See license.txt
+
+from __future__ import unicode_literals
+
+def execute():
+ import webnotes
+
+ # report_name
+ webnotes.conn.sql("""update `tabReport` set report_name=name where ifnull(report_name, '')=''""")
+
+ # report_type
+ webnotes.conn.sql("""update `tabReport` set report_type='Report Builder'
+ where ifnull(report_type, '')='' and ifnull(json, '')!=''""")
+
+ # is_standard
+ webnotes.conn.sql("""update `tabReport` set is_standard='No' where ifnull(is_standard, '')=''""")
\ No newline at end of file
diff --git a/patches/patch_list.py b/patches/patch_list.py
index 22322f2..3137d28 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -246,4 +246,5 @@
"execute:webnotes.reload_doc('core', 'doctype', 'comment') #2013-11-15",
"patches.1311.p02_index_singles",
"patches.1311.p01_make_gl_entries_for_si",
+ "patches.1311.p03_update_reqd_report_fields",
]
\ No newline at end of file