Jump to content

mmcnab

Members
 View Profile  See their activity

  • Posts

    7

  • Joined

  • Last visited

 Content Type 

Posts posted by mmcnab

    Saving Form Data

    in XSLT/XSL-FO

    Posted

    I think you need to change the way you are organizing the data in the XML file. Your current root node is "newdata" and you are storing the answers to the questions in "field" elements. What you are lacking here is a way to differentiate one user's data from another user's data.Either change your XML so that it is something like:
    <questionnaire><newdata id="cust1">  <field /></newdata><newdata id="cust2">  <field /></newdata></questionnaire>

    or:

    <newdata><userdata id="cust1">  <field /></userdata><userdata id="cust2">  <field /></userdata></newdata>

    Now, I don't know much about using server.CreateObject to create an XML file so I can't provide any code, but it sounds like you're going to have to read the contents of the XML file before you convert the inputs from the form into XML. Then you'll need to append the XML that is generated from the inputs to what is already loaded in your XML object. Once that is done, you can write the data to back to the file. Otherwise, you'll continue to overwrite the previous user's data.

    Saving Form Data

    in XSLT/XSL-FO

    Posted

    I am using server.CreateObject to create the xml file. Here is the ASP script I am using to collect the data and output to XML:<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title></head><body><%'--------------------------------------------------------------------'The "ConvertFormtoXML" Function accepts to parameters.'strXMLFilePath - The physical path where the XML file will be saved.'strFileName - The name of the XML file that will be saved.'--------------------------------------------------------------------Function ConvertFormtoXML(strXMLFilePath, strFileName) 'Declare local variables. Dim objDom Dim objRoot Dim objField Dim objFieldValue Dim objattID Dim objattTabOrder Dim objPI Dim x 'Instantiate the Microsoft XMLDOM. Set objDom = server.CreateObject("Microsoft.XMLDOM") objDom.preserveWhiteSpace = True 'Create your root element and append it to the XML document. Set objRoot = objDom.createElement("newdata") objDom.appendChild objRoot 'Iterate through the Form Collection of the Request Object. For x = x+1 To Request.Form.Count 'Check to see if "btn" is in the name of the form element. If it is, 'then it is a button and we do not want to add it to the XML 'document". If instr(1,Request.Form.Key(x),"btn") = 0 Then 'Create an element, "field". Set objField = objDom.createElement("field") 'Create an attribute, "id". Set objattID = objDom.createAttribute("id") 'Set the value of the id attribute equal the the name of the current 'form field. objattID.Text = Request.Form.Key(x) 'The setAttributeNode method will append the id attribute to the 'field element. objField.setAttributeNode objattID 'Create another attribute, "taborder". This just orders the 'elements. Set objattTabOrder = objDom.createAttribute("taborder") 'Set the value of the taborder attribute. objattTabOrder.Text = x 'Append the taborder attribute to the field element. objField.setAttributeNode objattTabOrder 'Create a new element, "field_value". Set objFieldValue = objDom.createElement("field_value") 'Set the value of the field_value element equal to the value of the 'current field in the Form Collection. objFieldValue.Text = Request.Form(x) 'Append the field element as a child of the root element. objRoot.appendChild objField 'Append the field_value element as a child of the field elemnt. objField.appendChild objFieldValue End If Next 'Create the xml processing instruction. Set objPI = objDom.createProcessingInstruction("xml", "version='1.0'") 'Append the processing instruction to the XML document. objDom.insertBefore objPI, objDom.childNodes(0) 'Save the XML document. objDom.save strXMLFilePath & "\" & strFileName 'Release all of your object references. End Function'Do not break on an error.On Error Resume Next'Call the ConvertFormtoXML function, passing in the physical path to'save the file to and the name that you wish to use for the file.ConvertFormtoXML "c:/inetpub/wwwroot/casino/mohegan","newdata.XML"'Test to see if an error occurred, if so, let the user know.'Otherwise, tell the user that the operation was successful.If err.number <> 0 then Response.write("Errors occurred while saving your form submission.")Else Response.write("Thank you for participating in our survey! Please use your 'BACK' button to return to your home page.")End If%>

    Saving Form Data

    in XSLT/XSL-FO

    Posted

    Thank you for your response, but I was looking for something more specific. I do not need a hit counter. I need to retrieve quastionairre answers. I need help in creating a 'container' for the xml files.

    Saving Form Data

    in XSLT/XSL-FO

    Posted

    I'm new to XML. I have a questionairre, the results of which, I can process through .ASP and display in an XML document like the following:<?xml version="1.0" ?> - <newdata>- <field id="T1" taborder="1"><field_value>mon, tue, wed</field_value> </field>- <field id="RadioGroup1" taborder="2"><field_value>bus</field_value> </field>- <field id="RadioGroup2" taborder="3"><field_value>spouse</field_value> </field>- <field id="RadioGroup3" taborder="4"><field_value>some</field_value> </field>- <field id="textfield" taborder="5"><field_value>arniemonday</field_value> </field>- <field id="submit" taborder="6"><field_value>Submit</field_value> </field>- <field id="name" taborder="7"><field_value>Arnold Palmer</field_value> </field></newdata>How do I stop the data from refreshing every time a new user submits their data? In other words I want the data to keep "stacking" until I am ready to import all of the responses into Excel. I've been to more forums and read more tutorials than you can imagine and just cannot get it! Thanks for your help.

    Saving XML Data

    in XML

    Posted

    I'm new to XML. I have a questionairre, the results of which, I can process through .ASP and display in an XML document link the following:<?xml version="1.0" ?> - <newdata>- <field id="T1" taborder="1"> <field_value>mon, tue, wed</field_value> </field>- <field id="RadioGroup1" taborder="2"> <field_value>bus</field_value> </field>- <field id="RadioGroup2" taborder="3"> <field_value>spouse</field_value> </field>- <field id="RadioGroup3" taborder="4"> <field_value>some</field_value> </field>- <field id="textfield" taborder="5"> <field_value>arniemonday</field_value> </field>- <field id="submit" taborder="6"> <field_value>Submit</field_value> </field>- <field id="name" taborder="7"> <field_value>Arnold Palmer</field_value> </field> </newdata>How do I stop the data from refreshing every time a new user submits their data? In other words I want the data to keep "stacking" until I am ready to import all of the responses into Excel. I've been to more forums and read more tutorials than you can imagine and just cannot get it! Thanks for your help.

    ASP to XML

    in ASP

    Posted

    I have a form with checkboxes, radio buttions and a text box. A user sumbits the form that is processed by this .asp form:<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Untitled Document</title></head><body><%'--------------------------------------------------------------------'The "ConvertFormtoXML" Function accepts to parameters.'strXMLFilePath - The physical path where the XML file will be saved.'strFileName - The name of the XML file that will be saved.'--------------------------------------------------------------------Function ConvertFormtoXML(strXMLFilePath, strFileName) 'Declare local variables. Dim objDom Dim objRoot Dim objField Dim objFieldValue Dim objattID Dim objattTabOrder Dim objPI Dim x 'Instantiate the Microsoft XMLDOM. Set objDom = server.CreateObject("Microsoft.XMLDOM") objDom.preserveWhiteSpace = True 'Create your root element and append it to the XML document. Set objRoot = objDom.createElement("RESPONSE") objDom.appendChild objRoot 'Iterate through the Form Collection of the Request Object. For x = 1 To Request.Form.Count 'Check to see if "btn" is in the name of the form element. If it is, 'then it is a button and we do not want to add it to the XML 'document". If instr(1,Request.Form.Key(x),"btn") = 0 Then 'Create an element, "field". Set objField = objDom.createElement("field") 'Create an attribute, "id". Set objattID = objDom.createAttribute("id") 'Set the value of the id attribute equal the the name of the current 'form field. objattID.Text = Request.Form.Key(x) 'The setAttributeNode method will append the id attribute to the 'field element. objField.setAttributeNode objattID 'Create another attribute, "taborder". This just orders the 'elements. Set objattTabOrder = objDom.createAttribute("taborder") 'Set the value of the taborder attribute. objattTabOrder.Text = x 'Append the taborder attribute to the field element. objField.setAttributeNode objattTabOrder 'Create a new element, "field_value". Set objFieldValue = objDom.createElement("field_value") 'Set the value of the field_value element equal to the value of the 'current field in the Form Collection. objFieldValue.Text = Request.Form(x) 'Append the field element as a child of the root element. objRoot.appendChild objField 'Append the field_value element as a child of the field elemnt. objField.appendChild objFieldValue End If Next 'Create the xml processing instruction. Set objPI = objDom.createProcessingInstruction("xml", "version='1.0'") 'Append the processing instruction to the XML document. objDom.insertBefore objPI, objDom.childNodes(0) 'Save the XML document. objDom.save strXMLFilePath & "\" & strFileName 'Release all of your object references. End Function'Do not break on an error.On Error Resume Next'Call the ConvertFormtoXML function, passing in the physical path to'save the file to and the name that you wish to use for the file.ConvertFormtoXML "c:/inetpub/wwwroot/casino/mohegan","RESPONSE.xml"'Test to see if an error occurred, if so, let the user know.'Otherwise, tell the user that the operation was successful.If err.number <> 0 then Response.write("Errors occurred while saving your form submission.")Else Response.write("Thank you for participating in our survey! Please use your 'BACK' button to return to your home page.")End If%></body></html>My problem is that every time a user submits a new form, the XML is overwritten. How do I 'store' or 'persist' the XML so that the inputs from multiple users will be available? I just need to save it into a .txt file or similar. I do not want to post back to SQL server. I'm relatively new to this and have been picking up pieces of code here and there. All was well until now! Thank you!

×
×
  • Create New...