[Doc Merge] - Library of Errors

Hi Ross. Sorry to hear you're having trouble using Doc Merge! We will work on making the Doc Merge errors more meaningful and providing more documentation to help you troubleshoot. Thanks for the tip!

In the meantime, here is some technical meaning behind the errors you encountered (which you may or may not care about) and some suggestions for troubleshooting:

• Malformed table: This is a parser error and means that the parser was unable to create readable xml tags. We suggest manually recreating the table and making sure the collection tags (e.g., {#calls} ... {/calls}) are in the proper cells. Start with a simple table and then build up complexity.
• {insert field name} is not defined: This is a metadata error and it might mean that your metadata is out of date or that the tag is incorrect. Please recheck the field name that you are using is correct.
• Unexpected identifier: This might mean that the field name is wrong. Please check your syntax.

Right now conditionals in Doc Merge only work with Microsoft Word. We are looking into expanding this capability to Excel in the future. 

You may find the help article on Sample Doc Merge Templates to be helpful to see how an example Excel template is set up, for example.

Let us know if we can provide any more help!

Thanks for this Lydia. Very helpful. I do have one further query, if you don't mind answering? It is regarding looping over product bundles when producing a quote doc. I want to filter by the name of the bundle but cannot seem to get it to work. Am i being dumb?? the below works but shows me all of the bundles

-----

{#product_bundles}

{if product_bundle_items.name==”Additional Items”}

{name}

{/product_bundles}

 -----

I have not tested myself, but I believe it is enough to enter "{if name==”Additional Items”}" as you are already looping through all product_bundles.  And then you need an ending if statement {endif}

Hope this helps

Annoyingly im getting this with just {ifname=="Additional Items"} (and the endif of course) 

Error: Invalid or unexpected token

another unhelpful error message

Annoyingly im getting this with just {ifname=="Additional Items"} (and the endif of course) 

Error: Invalid or unexpected token

another unhelpful error message

hi Ross Page

have you tried to use single quotes instead of double?

There is some confusion when to use one style or the other, even on the official

knowledgebase here they give examples using both:
https://support.sugarcrm.com/Knowledge_Base/Doc_Merge/Filtering_with_Conditionals/ 

Not sure if Sugar product development team can remove this confusion?

Unfortunately doesn't work either way. wondering if name is just to much of a variable to use as a filter.

You said:
"Annoyingly im getting this with just {ifname=="Additional Items"} (and the endif of course) "

is the space missing just in your post or also in your template?
{if name=="Additional Items"}

instead of

{ifname=="Additional Items"}