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
+10- 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!
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+8- 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!
+8- 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!