I'm struggling with parsing an XML file into an Access database using xfmap. The XML file is matched on the root level ("Eiendommer", meaning land properties). Each Eiendom contains 1 or more Tax property ("Skatteeiendom"). On each Skatteeiendom there may be 0, 1 or multiple buildings ("Bygg") and this is where the fun begins. To finish the story, in every building there may be 0, 1 or multiple floors ("Etasjer"). I run the XML through 3 consecutive ListExploders in an attempt to retrieve all relevant information from the XML whilst maintaining the relation between floors, buildings and tax properties. This is my first attempt at XML parsing with FME, it may well be that there are better/smarter/more elegant ways to do this.
My problem with this workspace is that I seem to loose track of the attribute values of elements where there is only 1 building. I run the XML through 3 ListExploders so that lists are formed of buildings, and I can route these attributes to a target table in the Access database, but this works only for lists. Which seems logical - a ListExploder only handles lists, naturally. But how can I get a hold of the attribute values for non-listed elements (1 building on 1 property for example) ?
Any help would be greatly appreciated and I will buy you a beer next time you are in town. Promise.
