Hi,
In import/export section, there is not an option to export the Support Ticket data. Kindly suggest how to export support ticket data from existing system and import into new instance.
Sunil
You have to export both Support Ticket and Communications
Don’t think you can add filters to export specific communications. Maybe you can export from a report.
Thx u @rmehta
But my instance broke because of “bench update” hence unable to import support data. Can you suggest how to resolve it?
nescode@Nescodeerpnext:~/frappe-bench$ bench update
Already up-to-date.
remote: Counting objects: 8, done.
remote: Compressing objects: 100% (8/8), done.
remote: Total 8 (delta 1), reused 0 (delta 0), pack-reused 0
Unpacking objects: 100% (8/8), done.
From https://github.com/frappe/frappe
2325753..19ce1a7 master -> upstream/master
0a661ff..19ce1a7 v4.x.x -> upstream/v4.x.x
* [new tag] v4.14.0 -> v4.14.0
From https://github.com/frappe/frappe
* branch master -> FETCH_HEAD
Updating 2325753..19ce1a7
Fast-forward
frappe/__version__.py | 2 +-
frappe/hooks.py | 2 +-
frappe/public/css/font/noto_sans/noto_sans.css | 24 +++++++++++-----------
frappe/public/js/frappe/misc/number_format.js | 9 +++++---
.../templates/print_formats/standard_macros.html | 2 +-
frappe/website/utils.py | 2 +-
setup.py | 2 +-
7 files changed, 23 insertions(+), 20 deletions(-)
From https://github.com/frappe/shopping-cart
* branch master -> FETCH_HEAD
Already up-to-date.
remote: Counting objects: 42, done.
remote: Compressing objects: 100% (33/33), done.
remote: Total 42 (delta 34), reused 17 (delta 9), pack-reused 0
Unpacking objects: 100% (42/42), done.
From https://github.com/frappe/erpnext
* branch master -> FETCH_HEAD
9490d9d..92b253d master -> upstream/master
Updating 9490d9d..92b253d
Fast-forward
erpnext/__version__.py | 2 +-
.../doctype/sales_invoice/sales_invoice.py | 9 +++--
.../accounts_receivable/accounts_receivable.py | 16 ++++-----
.../received_items_to_be_billed.json | 4 +--
.../doctype/purchase_order/purchase_order.py | 11 ++++++
erpnext/hooks.py | 2 +-
erpnext/patches.txt | 4 ++-
.../delete_gl_entries_for_cancelled_invoices.py | 13 +++++++
erpnext/patches/v4_2/fix_recurring_orders.py | 41 ++++++++++++++++++++++
erpnext/selling/doctype/sales_order/sales_order.py | 11 ++++++
erpnext/selling/sales_common.js | 2 +-
setup.py | 2 +-
12 files changed, 100 insertions(+), 17 deletions(-)
create mode 100644 erpnext/patches/v4_2/delete_gl_entries_for_cancelled_invoices.py
create mode 100644 erpnext/patches/v4_2/fix_recurring_orders.py
database backup taken - ./site1.local/private/backups/20150418_34092648_database.sql.gz - on 2015-04-18 17:12:35.994248
Running latest for site1.local
--------------------------------------------------
Executing erpnext.patches.v4_2.fix_recurring_orders in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v4_2.delete_gl_entries_for_cancelled_invoices in site1.local (1bd3e0294d)
Traceback (most recent call last):
File "/home/nescode/frappe-bench/env/bin/frappe", line 9, in <module>
load_entry_point('frappe==4.13.6', 'console_scripts', 'frappe')()
File "/home/nescode/frappe-bench/apps/frappe/frappe/cli.py", line 39, in main
ret = run(fn, args)
File "/home/nescode/frappe-bench/apps/frappe/frappe/cli.py", line 83, in run
out = globals().get(fn)(**args)
File "/home/nescode/frappe-bench/apps/frappe/frappe/cli.py", line 67, in new_fn
return fn(*args, **new_kwargs)
File "/home/nescode/frappe-bench/apps/frappe/frappe/cli.py", line 431, in latest
frappe.modules.patch_handler.run_all()
File "/home/nescode/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 25, in run_all
if not run_single(patchmodule = patch):
File "/home/nescode/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 50, in run_single
return execute_patch(patchmodule, method, methodargs)
File "/home/nescode/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 66, in execute_patch
frappe.get_attr(patchmodule.split()[0] + ".execute")()
File "/home/nescode/frappe-bench/apps/erpnext/erpnext/patches/v4_2/delete_gl_entries_for_cancelled_invoices.py", line 13, in execute
% (', '.join(['%s']*len(cancelled_invoices))), tuple(cancelled_invoices))
File "/home/nescode/frappe-bench/apps/frappe/frappe/database.py", line 121, in sql
self._cursor.execute(query)
File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/nescode/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 2")
Error: None
Traceback (most recent call last):
File "/usr/local/bin/bench", line 9, in <module>
load_entry_point('bench==0.1', 'console_scripts', 'bench')()
File "/home/nescode/bench-repo/bench/cli.py", line 55, in cli
bench()
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 664, in __call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 644, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 991, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 837, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 464, in invoke
return callback(*args, **kwargs)
File "/home/nescode/bench-repo/bench/cli.py", line 247, in update
patch_sites()
File "/home/nescode/bench-repo/bench/utils.py", line 116, in patch_sites
exec_cmd("{frappe} --latest all".format(frappe=get_frappe(bench=bench)), cwd=os.path.join(bench, 'sites'))
File "/home/nescode/bench-repo/bench/utils.py", line 72, in exec_cmd
subprocess.check_call(cmd, cwd=cwd, shell=True)
File "/usr/lib/python2.7/subprocess.py", line 540, in check_call
raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '/home/nescode/frappe-bench/env/bin/frappe --latest all' returned non-zero exit status 1
Run bench update again
Yes, it works. 
Thx u so much.