OpenXML / PASW Data Collection - Project 1
My presentation at SPSS Directions in Las Vegas (9th – 13th Nov) will require me to provide several working examples of OpenXML / PASW Data Collection integration. I am currently looking for three different examples with increasing levels of complexity. Two will probably be around the survey metadata document and Word while the third will be around a reporting script that is exporting to PowerPoint.
So in order to not overwhelm the project and suffer from the inevitable procrastination I have decided to start with a topic that is often requested by clients.
Is it possible to create a printable copy of the responses to a survey so that it can be sent either to the respondent or a stake-holder?
Scenario:
A Rail company wishes to provide an online complaints form that allows travellers to submit details of complaints regarding late trains or poor service while on trains. The information would then be escalated to the relevant account manager with the complainant receiving a copy of the details of the complaint for their own records.
The Survey:
This will consist of two pages of questions. The first will obtain general details of the complainant while the second will obtain details of the complaint. Once both pages have been captured the complainant will be asked to confirm submission and then will be e-Mailed a PDF copy of the complaint. Their e-Mail address is a mandatory field in the first page.
The Steps:
The following steps will be required to complete the project:
· Construct Survey Metadata
· Construct Survey Routing to ask questions
· Watch Microsoft Videos on Custom Parts
· Build Routing to construct an XML document of the responses provided
· Construct a Word document defining the layout of the complaint record form
· Pass the XML across to the document as a Custom Part
· Insert Placeholders into the document to ensure the information appears in the right locations in the document
· Create a dll that receives the XML from PASW Data Collection, inserts it into the custom part within the document template, generates a PDF from the resulting document and sends it to the complainant
These steps have been defined before I have had chance to watch the videos on the implementation of custom parts. I am documenting my intentions at this point so that I can show what has to change once I better understand the way custom parts work.
