Mail Merge Reports

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 7 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.

sravani.tedla
7 years ago

HI Team,

Can we get reply on this.

Regards, Sravani.Tedla

reply
sravani.tedla
7 years ago

Hi Team,

Can I get a reply on this.

Awaiting for the reply.

Regards, Sravani.

reply
Izertis Provider
7 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

reply
- sravani.tedla
  7 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.
  
  reply
sravani.tedla
7 years ago

Hi Anabel,

Could you please reply on my query.

Awaiting for the reply.

Regards, Sravani

reply
sravani.tedla
7 years ago

Action required..

Awaiting for the reply.

Regards, Sravani

reply
Izertis Provider
7 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

reply