by Izertis

Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.

Includes a 30 day guarantee
Try it Now

By clicking you consent to share your profile with the developer

#3126 - Mail Merge Report for wysiwyg datatype not wroking

Closed Feature created by sravani.tedla 6 years ago

HI Team,

We are using Mail merge of 2.5.1 version. The document is not able to fetch wysiwyg datatype values.

Please help on that.

Regards, Sravani.Tedla.

  1. sravani.tedla member avatar

    sravani.tedla

    6 years ago

    HI Team,

    Can we get reply on this.

    Regards, Sravani.Tedla

  2. sravani.tedla member avatar

    sravani.tedla

    6 years ago

    Hi Team,

    Can I get a reply on this.

    Awaiting for the reply.

    Regards, Sravani.

  3. dharma member avatar

    Izertis Provider

    6 years ago

    Hi Alexandre,

    Sorry for the delay, we have a lot of work these days.

    We think you mean data from WysiWyg addon (https://www.sugaroutfitters.com/addons/wysiwyg-field-type).

    Sorry, we can not help you about how to generate this data.

    Regards,

    Anabel

    • sravani.tedla member avatar

      sravani.tedla

      6 years ago

      Hi Anabel,

      yes i was pointing about that wysiwyg addon.

      Could you please give an idea so that i can try to change the code from my end.

      Is there any problem for generating data from that datatype.could you please explain for my clarity.

      Awaiting for the reply.

      Regards, Sravani.

  4. sravani.tedla member avatar

    sravani.tedla

    6 years ago

    Hi Anabel,

    Could you please reply on my query.

    Awaiting for the reply.

    Regards, Sravani

  5. sravani.tedla member avatar

    sravani.tedla

    6 years ago

    Action required..

    Awaiting for the reply.

    Regards, Sravani

  6. dharma member avatar

    Izertis Provider

    6 years ago

    Hi,

    Sorry for the delay.

    This type of field, apart from not being a standard type in Sugar, stores the information in html format. It's really hard to convert html text to text prepared for docx (Office) or ods (LibreOffice). Some very basic conversion could be done, but generally it is not possible to support this kind of development at the moment. You can look at a discussion about this conversion using the OpenTBS library (the one used in MMR) in this StackOverflow thread: https://stackoverflow.com/questions/9315531/opentbs-convert-html-tags-to-ms -word-tags

    Creating a calculated MMR variable in the module that is needed, and trying to convert what you can from html to docx would be a possible solution, but at the moment we do not consider its implementation. Regarding that calculated variable, you could also remove all html tags containing the text and extract the text as plain text if the html format was not needed in the generated document.

    Regards,

    Anabel

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "The single biggest downfall of the community edition of SugarCRM or SuiteCRM is the lack of creating a report form a custom module for a single event...." - ian

    Read More Reviews