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.
Page 1 / 1
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!
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!