I have Sharepoint Foundation 2010, and one of my sites has a library which contains videos. What I want to do is have an XML file written to a directory on a remote machine, whenever the users update the list by adding or removing items. There is a desired output format that I need the XML file to match - the file is actually a playlist for a HTML5 video gallery. The XML file needs to contain the filename of the video file, and a title that the user can set in Sharepoint when they add the video to the list.
Is this possible? I have seen various web-posts saying that code can be written to achieve this, but in Sharepoint and Sharepoint Designer, I can't seem to find anywhere to add code. It's possible the administrator of the site has locked down this functionality, or maybe it's a restriction of Sharepoint Foundation which prevents me writing code functions to do this?
Edit - Further Info:
It seems that I need only write a text file to a remote directory to achieve what I need. Even so, it doesn't seem straightforward to use Sharepoint Designer 2010 to create a workflow which writes the library columns to a text file, whenever the library is added to.