Jump to content

mmcnab

Members
 View Profile  See their activity

  • Posts

    7

  • Joined

  • Last visited

 Content Type 

Everything posted by mmcnab

  1. mmcnab
    I guess that could work, except that I will have potential ranges of 5,000 to 50,000 customers. That would constitute quite a file!I need to build a container. Any ideas?
  2. mmcnab
  3. mmcnab
    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%>
  4. mmcnab
    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.
  5. mmcnab
    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.
  6. mmcnab

    Saving XML Data

    mmcnab posted a topic in XML

    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.
  7. mmcnab

    ASP to XML

    mmcnab posted a topic in ASP

    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...