Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
6 subscribers
Views
2075 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi, I have a problem with generating a word document, using the related sma
lorisgiusepped
over 9 years ago
Hi,
I have a problem with generating a word document, using the related smart service. My problem is this: I have a script task witch with some querys that read data from db and gereate documents from that data. So I fill all cdt, generate xml from the data and than generate the documents. But every tag of the xml, generated for word document, are like <stufftoinsert item1=' '/> and so identifies the ' as keyword. When I found a word with ' in italian I can't generate the document because it recongnize the ' as a limiter (keyword) and the document generation go in error. If I try to put the html ashii decode it goes in error because it dislike the & (remember that the decode of ' is ') and I substitute it with and for this reason. So for these reason I have problem to insert the character ' in the document. Is there another way to insert the character ' in the xml document generation?
OriginalPostID-200840
OriginalPostID-200840
Discussion posts and replies are publicly visible
0
Eduardo Fuentes
Appian Employee
over 9 years ago
What if you use the approach explained at
forum.appian.com/.../Word_Doc_from_Template_Smart_Service.html:
"Substitution values cannot contain HTML formatting tags, such as <i> or <b>, or the characters &, <, and >. If necessary, use the toHtml() function to remove these characters."
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
lorisgiusepped
over 9 years ago
I have just tryed this but it seems doesn't work for the character ' that is my problem because the function tohtml(" ' ") it replys '. So this dont' resolve my problem. Is there another solution?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
What about using
'
instead? This is how you are supposed to escape the tilde in an XML
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
lorisgiusepped
over 9 years ago
I have tryed just now but it gave me an error when found the character &. Like it said the forum I can't use the char & in the xml it is like a vicious circle. I have also tryed to use the function tohtml to convert the term & but it gives to me the reply & that contains the term &. Is a vicious circle.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 9 years ago
Probably I am not visualizing how you're doing this correctly. If you could a attach a simple model with all dependencies to reproduce, that'd help
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel