Alright. Firing up the #ETL Mapper. It's called "#Mapper", a product by #GXS, now owned by #OpenText. These organisations manage huge UPC catalogs used by thousands of trading partners for selling and buying products.
Did I mention #OpenText has an office on the other side of my town? I've become quite familiar with the #BizLink, #BizMapper, and #BizManager products they bought from #GXS. BizManager has some #usability and #accessibility issues. And its web interface is written in #JSP. I know #java, #webstandards, and JSP from long ago (BizManager's JSP seems that old). Maybe I should offer them my help?
Last week my team learned about a limitation in #XML processing in the #BizMapper application by #OpenText (formerly by #GXS):

If an XMLElement has 2 or more children with the same name, and the source format for that element has its sort order set to unordered, then BizMapper no longer knows which child element to pick.

We wanted the 2nd. BizMapper gave us the 1st.

This is understandable behavior. It's also quite annoying. We reached out to their support and hope for a solution.
Working with #XML documents is a joy. Working with ones that have a #namespace is a royal pain.

The #BizMapper transformation tool for enterprise business communication by #OpenText (formerly by #GXS) can translate XML into #EDI: great for integration with our ERP.

If an XML document has a default ns, the Mapper happily adds it to newly-added fields. Normally that is great.

Until you don't expect it, and wanted no ns.

Then translation will fail.

#businessIntelligence #BI
Anyone else here who uses #BizMapper by #OpenText (formerly by #GXS)?

It's a document transformation tool for enterprise business communication (orders, acknowledgements, etc).

The latest version can read and produce #JSON: nice when we communicate with a partner who also speaks JSON.

It doesn't seem to want to use a JSON Schema as a template for source or target documents. That costs a lot of time.

Any ideas on whether it can do that? And if so, how?

#businessIntelligence #BI