Skip to main content
Solved

Question about reading and writing the same XML

oscard
Influencer
Forum|alt.badge.img+21

Good morning.

I have the XML file of an ATOM feed. That XML has to be updated every time the resources provided by that service are updated. Several dates must be changed.

My first approach is read the XML with the XML reader, calculate the current data, modify the XML using the XMLTemplater and wirting the same XML file using the Text File reader (with "Overwrite" set to YES)..

The process reads the C:/ATOM_feed.xml, edits it and writes the file C:/ATOM_feed.xml.

This doesn't work:

"Error opening dataset 'Text File' for writing, ensure that file path and permissions allow for writing".

I guess it makes sense.

So, in order to avoid this, I have used "Creator" to create a feature with an attribute "join" set to "A". I have added the same attribute to the feed from the XML Reader and I have perfomed a Merge using "FeatureMerger" (Requestor = new feature, Supplier = XML). That way I can read and write the same XML file. The merge is the input of the XML Templater.

But I keep looking at my FME project thinking if there is a "prettier" solution. I tend to miss the simple solution, so... Is there a more elegant way to read and write the same XML file?

Thanks for any help provided!

I'm using FME Desktop 2016.

Best answer by takashi

Hi @oscard, if the update can be done with an XQuery expression, you can use the XMLXQueryUpdater transformer to update the XML file directly.

Alternatively, just inserting a FeatureHolder before writing might be effective to avoid the problem.

View original
Did this help you find an answer to your question?

2 replies

david_r
Celebrity
  • david_rCelebrity
  • June 13, 2017

I suspect your solution is pretty optimal, simultaneously reading and writing the same file on disk is asking for trouble, so the OS tries its best to discourage you with a built-in mechanism called file locking.

If you want to learn more about file locking, this is a pretty good starting point: https://en.wikipedia.org/wiki/File_locking

takashi
Influencer
  • takashiInfluencer
  • Best Answer
  • June 13, 2017

Hi @oscard, if the update can be done with an XQuery expression, you can use the XMLXQueryUpdater transformer to update the XML file directly.

Alternatively, just inserting a FeatureHolder before writing might be effective to avoid the problem.

Reply


Helpful Members This Week

Community Stats

31,383
Posts
119,020
Replies
39,012
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.