Can you collect data from an XmlUrlDataSource and place it into a variable?
-
OK, here is my problem. The company I work for has recently started using SharePoint. The first thing they wanted was a website which allows users to sign up for training courses and the Employee Training Scheduling and Materials Template seemed to be just what we were looking for. The only addition we need is, when an employee signs up to a course, an email being sent to their manager for authorisation. The way the template was built uses a 'Registrations' List as the main data source and this is where I need to store the manager’s name and email address. This is where my problem comes in. The manager’s details are stored on a Domino server and I am trying to use an XmlUrlDataSource to bring the data in. If I link this data source in to the current data source then I can not insert or update the list. Currently I am trying the following code:- <SharePoint:XmlUrlDataSource runat="server" id="XmlUrlDataSource1" selectcommand="http://XXX.XXX.XXX.XXX/employees.nsf/EmployeesAndManagers?ReadViewEntries&StartKey={$UserName}&Count=1" AuthType="None" XPath="/viewentries/viewentry/entrydata[2]/text"></SharePoint:XmlUrlDataSource> <SharePoint:DVListBox runat="server" id="ff3{$Pos}" datasourceid="XmlUrlDataSource1" datatextfield="text()" datavaluefield="text()" Height="20px" selectedvalue="{@Authoriser}" __designer:bind="{ddwrt:DataBind('i',concat('ff3',$Pos),'Text','TextChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Authoriser')}" /> This will display the data I need but will not save to the Registration list. Can anyone see a problem with the code I am using? OR Is there a way I can call the data source, collect the data into an XML variable/Parameter and then submit that variable/parameter to the list using the DataBind? I hope some of that made sense and if not, please feel free to ask questions. Thanks in advance.