Exporting support ticket data

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. :smile:
Thx u so much.