Update geometry attribute from Excel to XML

Hi @chagantisasikir, the first idea that comes to mind when working with XML are the XML transformers. For updating XML have a look at the XMLUpdater

Hope this helps

Actually I am transforming the coordinate system. I took the reader as Shape file, transformed the coordinates for all the features and written in an excel. Now the excel file contains the Key unique field for all the features with their transformed coordinates. For linear features, i have the vertex numbers as well in the excel file. Apart from this i have the data with old coordinates in XML file. I need to update the Geometry attribute in the XML, querying based on its unique field, Name.

For example: I have some 100 records in an XML. Name and Geometry are attributes. Based on its name, i need to query and update its geometry attribute. I will get both the values from excel, query Name in XML and update its geometry attribute. XML will have the Attribute name in the format <NAME>XXX</NAME>, Geometry attribute in format <GEOMETRY>X="123.456" Y="789.456"</GEOMETRY>. Excel will have the Name and Geometry columns with the values given above.

Please suggest better procedure and transformers to be used.

Hi Takashi thank you for the detailed process. Yes my XML looks in a similar, the change in this is:

<?xml version="1.0"?>
<DATASET>
	<FEATURE>
		<NAME>AAA</NAME>
		<GEOMETRY>X="123.456" Y="789.123"</GEOMETRY>
	</FEATURE>
	<FEATURE>
		<NAME>XXX</NAME>    
		<GEOMETRY>X="456.789" Y="123.456"</GEOMETRY>
	</FEATURE>
	<FEATURE>    
		<NAME>ZZZ</NAME>    
		<GEOMETRY>X="789.123" Y="456.789"</GEOMETRY>
	</FEATURE>
</DATASET>

I will try the process explained above and will come back to you.

Thank you.

<?xml version="1.0"?>
<DATASET>
	<FEATURE>
		<NAME>AAA</NAME>
		<GEOMETRY>X="123.456" Y="789.123"</GEOMETRY>
	</FEATURE>
	<FEATURE>
		<NAME>XXX</NAME>    
		<GEOMETRY>X="456.789" Y="123.456"</GEOMETRY>
	</FEATURE>
	<FEATURE>    
		<NAME>ZZZ</NAME>    
		<GEOMETRY>X="789.123" Y="456.789"</GEOMETRY>
	</FEATURE>
</DATASET>

//FEATURE[child::NAME[text()="@Value(NAME)"]]/GEOMETRY 

I have tried the same. But throwing an error "

XMLUpdater(XQueryFactory2): invalid content passed to fn:parse-xml(): loader parsing error: Document is empty".

Can you check that the flow and the queries are correct or not. Please see the attached.flow.jpg

This is the actual xml format:

<?xml version="1.0"?>

As I have mentioned above, the XML document contains the GEOMETRY tag as an attribute. If any issue in the above given XML, can you suggest the way forward.

Yes checked and finally issue solved. Thank you for the great support. Now i am trying for linear features which will have multiple geometry tags inside geometries tag..like

<?xml version="1.0"?>

<GEOMETRIES>

<GEOMETRY>X="1234.789" Y="987.321"</GEOMETRY>

</GEOMETRIES>

1. Create new <GEOMETRIES> element that contains multiple child <GEOMETRY> elements.
2. Replace the original <GEOMETRIES> element in the source XML document with the new <GEOMETRIES> element, using the XMLUpdater transformer (Update Type: Replace, Value Type: XML/XQuery).

Hi Takashi, Yes as guided and with your continuous great support, i have used the XMLTemplater and XMLUpdater to update the geometries in linear features. Everything is done. After all the ready XMLs, i have loaded the data and it looks good. But observed some deviation in the coordinates with respect to the data which is transformed through the ESRI in built Transformation functionality. Please find the deviation in the graphical representation also in the attached testing-fme.jpg. Polygons are the top view of the Buildings, "Circles" on it are the Features transformed using ESRI in built transformation functionality and "Rectangle with a Brown dot in it" are the features(almost of these feaatures are at the edge of the buildings) transformed through FME.

Please can you comment on the reason for deviation and suggest me further.

I am transforming the coordinates from Naparima 1955/UTM zone 20N to UTM-WGS 1984 zone 20N. Please find the attached snapshot reprojector.jpg for the source and target coordinate systems set in Reprojector and suggest further.

Please find the attached snapshot fme-data-inspector.jpg from the FME Data inspector. Please observe the deviation, Black color features transformed through ESRI in built functionality. Blue color features transformed through FME. Please suggest. If required, for further details, we can discuss one to one..

Please need your comments on the above issue. So is it that deviation will be available if we use Reprojector? Is there any way to transform to the coordinates to match the ESRI transformed coordinates?

Thank you for the information. I am unable to find the EsriReprojector. Do i need to install any plugins for that ?

I am getting an error while using ESRIReprojector. Please suggest . The error is "Esri Reprojector: Specified geotransformation `' (forward) may be inappropriate for reprojection from `Naparima55.UTM-20N' (GCS: `GCS_Naparima_1955') to `UTM84-20N' (GCS: `GCS_WGS_1984') using the ESRI reprojection engine"