Hello am new to FME I in the process of Automating the import of invoices and G/L transactions. Our CitySuite by Harris. Is the anyone who is or who has been involved with the integration of these. My biggest hurdle at the moment is the format of dollar amounts in XML. I have tried using the xquery formula but then the XML Templater fails. Any assistance would be appreciated.
Solved
FME - CitySuite
+4- Contributor
Best answer by donalmateer
Hi
Upon further investigation - you should be able to use the XQuerty function fn:format-number to format the dollar amounts.
A non XQuery method would be to use a StringFormatter with .2f to format the dollar amount before the XMLTemplater.
Hope this helps!
+5- Safer
Hi
Thank you posting on the community. A good starting point would be to look the following tutorial series on the FME Support Center.
Tutorial: Getting Started with XML
XML (Extensible Markup Language)
This might help with the issue at hand. In the meantime I will look into your current hurdle and try find a solution.
Thanks!
1 person upvoted this
+5- Safer
- Best Answer
Hi
Upon further investigation - you should be able to use the XQuerty function fn:format-number to format the dollar amounts.
A non XQuery method would be to use a StringFormatter with .2f to format the dollar amount before the XMLTemplater.
Hope this helps!
1 person upvoted this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.