This question has been flagged
1 Reply
5084 Views

In version 11 I want to export helpdesk ticket data along with all mail.message data , I've exported all data except some mail message logs, I've exported comment and email type message but  in mail.message database table notification type messages are not visible, How can I export all notification message visible under help desk ticket.

Avatar
Discard
Hi Yenthe,

Thanks for your answer,

I tried your solution but its not exporting all message content, some notification type messages's content is not exported but its visible under helpdesk ticket, so i checked the mail.message table and found some notification content is not stored in table. how it is visible under document (helpdesk ticket in my case), is it stored in any other table.
for reference please see the images in attached.

On Fri, Jan 4, 2019 at 4:53 PM Yenthe Van Ginneken <yenthespam@gmail.com> wrote:

A new answer on Export mail.message data with all messages has been posted. Click here to access the post :

See post


Sent by Odoo S.A. using Odoo.



--
Regards,
--
Vivek kumarSoftware Engineer
Prolitus Technologies Pvt. Ltd.
(Formerly Sakshay Web Technologies Pvt. Ltd.)
A-83, 1st Floor, Sector-2,
Noida 201301
Office: 0120-6841100

Hi Vivek,

I can't get it reproduced on runbot. Do you get the same behaviour when you export them from the messages menu though? Not by exporting from the helpdesk tickets?

Best Answer

Hi Vivek,

The message type is visible (and exportable) right from the mail.message tree view. You can first create a filter to only get messages for the model "helpdesk.ticket":


Then select all items in the treeview for export and be sure to export the fields "Type" and "Subtype". After exporting them you will see all messages related to helpdesk tickets with their type and subtype:


Regards,
Yenthe

Avatar
Discard
Author

Hi Yenthe, I tried this and yes it export all messages, but in some messages (type notification) content(body) is not visible when export. message content is visible under document(helpdesk.tickt in my case) so I checked the entries in mail.message table but content also not stored in database. how it is visible under the document while its not visible in table, is it stored in any other table ?

Author

Here's the table view.

select message_type,subtype_id,body from mail_message where res_id=18809;

message_type | subtype_id | body

--------------+------------+----------------------------------------

comment | 2 | <p>Again just testing logs</p>

comment | 2 | <p>Hello testing logs</p>

notification | 2 |

notification | 17 |

notification | 2 |

comment | 1 | <p>109591 Mark Omo ticket created.</p>

notification | 18 |