Hi Michael,
Try this link, I just whipped up an STR for you... It is pretty
rough... Many of the fields that are showing can be hidden, users do
not need to see ID numbers and internal machinations.
the link is http://www.brileigh.net/PIC/survey.zip
Regards
Brian
----- Original Message -----
*From:* Michael Iannantuoni <mailto:[EMAIL PROTECTED]>
*To:* DataPerfect Users Discussion Group
<mailto:[email protected]>
*Sent:* Tuesday, November 28, 2006 7:04 AM
*Subject:* Re: [Dataperf] Questionaire/Survey with DataPerfect
Thanks Pat,
After you said that you would approach such a project differently
again, I don't think I'll ask you for your STR file but thanks for
the offer. Your comment about storing each question in it's own
record in a panel subordinate to the main questionnaire control
panel is also useful.
Thanks again,
Michael
Patrick Riley wrote:
Michael, I did one survey project in DataPerfect. It worked out
well in
the end as I was able to do very sophisticated cross tabulations by
various demographic components with ease. My client (an $8 billion
multi-national company) was very impressed.
A word of caution. DataPerfect supports only 255 report variables
which I used to store tabulations. As the survey form progressed,
I ran out of available variables. I got around this by storing two
tabulation results in each variable by multiplying one of the tabs
by 1,000,000 which effectively stored it in the high end of the RV.
When printing the results, I parsed it out of the high end of the
RV by dividing by 1,000,000 and discarding the remainder. To
get the low end tabulation out, I converted the numeric RV to a
string and, extracted the low end, and converted that back to a
number.
If I was doing this again, I'd store each question in it's own
record
in a panel subordinate to the main questionnaire control panel.
This
would eliminate problems with the number of available RVs and allow
you to create much longer surveys.
My questionnaire featured all of your question types plus several
more
(rating something on a scale of 0 to 10, pick up to x choices from a
larger list of choices, or ranking a list of items in your order of
preference). Comments were allowed on many of the questions. The
DataPerfect output program allowed me to print the comments grouped
for review. On cross tabulations, I was able to print just the
comments
that pertained to the associated demographic.
I created the actual survey document as a Web based form and
imported the results into DataPerfect. This worked great as I
didn't
have any input efforts (which would have been substantial with the
large number of comments ... some of them quite lengthy). The Web
based form enabled me to use a combination of input form features
(radio buttons and check boxes) coupled with JavaScript
verifications
to only accept valid input. This forced the input data to be
completely
compliant eliminating any error handling in the DataPerfect
application.
I still have this application in my possession. I did this
project about
7 or 8 years ago so I don't remember much about it but I could send
you the STR file if you'd like. Frankly, if I was doing this
again, I
wouldn't want my old application as it would certainly be
difficult to
understand and modify. I'd, instead, start from scratch using
the two
level approach I described above. If you would like the STR
file, feel
free to call or E-mail.
Hope this helps.
Pat Riley
505-797-9072
At 02:35 AM 11/27/2006, you wrote:
Background:
Our village has recently taken part in a questionnaire/survey
whereby everyone filled in a paper form which is now being
transferred to computer file. The software provided by our local
authority (Council) is not particularly good: you have to go on
line for it to build a "Project List" of surveys done for other
villages before selecting & downloading the one for us - it does
this /every /time you want to transfer data from paper to file.
The "Questionnaire" part then loads but is not very user
friendly, not allowing you to go back to previous questions
without loosing data back to that point . . . . I could go on.
Once data has been transferred to files for the session, it must
be uploaded but the process of building a Project List etc..
occurs again first - all extremely slow & frustrating.
In a moment of frustration/weakness, I did say to the chap
running the project for the village (he did have a good head of
hair before it all started!) that it would be fairly straight
forward to design a database that would do all that is required
so much easier. Luckily for me, I'm too late this time as the
project is well under way but may be repeated in a couple of
years time.
So my question is has anyone designed a DataPerfect database for
questionnaires/surveys? It seems to me that that it should be
fairly straight forward but maybe laborious. There questions
fall into four categories:
Simple Yes/No responses,
Multiple choice options whereby only one of a number of
options must be chosen,
Multiple choice options whereby none, one, some or all of a
number of options must be chosen.
A box allowing comments to be written.
The first and last are easy, I'm not sure of the best way to
achieve the other two.
The other problem is the size of the questionnaire. There are
just under 200 questions which would be too many for a single
panel, although they are divided into sections such as
Transport, Environment etc... I had a thought of using a panel
for each section with a master Table of Contents Panel with
links to all other panels a bit like an table of contents
linking to the relevant pages of a book and maybe links from
each panel to previous & next panels.
This is all thankfully a way off yet but any thoughts or ideas
would be welcomed.
Michael
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------
Hi Michael,
Try this link, I just whipped up an STR for you... It is pretty
rough... Many of the fields that are showing can be hidden, users do
not need to see ID numbers and internal machinations.
the link is http://www.brileigh.net/PIC/survey.zip
----- Original Message -----
*From:* Michael Iannantuoni <mailto:[EMAIL PROTECTED]>
*To:* DataPerfect Users Discussion Group
<mailto:[email protected]>
*Sent:* Tuesday, November 28, 2006 7:04 AM
*Subject:* Re: [Dataperf] Questionaire/Survey with DataPerfect
Thanks Pat,
After you said that you would approach such a project differently
again, I don't think I'll ask you for your STR file but thanks for
the offer. Your comment about storing each question in it's own
record in a panel subordinate to the main questionnaire control
panel is also useful.
Thanks again,
Michael
Patrick Riley wrote:
Michael, I did one survey project in DataPerfect. It worked out
well in
the end as I was able to do very sophisticated cross tabulations by
various demographic components with ease. My client (an $8 billion
multi-national company) was very impressed.
A word of caution. DataPerfect supports only 255 report variables
which I used to store tabulations. As the survey form progressed,
I ran out of available variables. I got around this by storing two
tabulation results in each variable by multiplying one of the tabs
by 1,000,000 which effectively stored it in the high end of the RV.
When printing the results, I parsed it out of the high end of the
RV by dividing by 1,000,000 and discarding the remainder. To
get the low end tabulation out, I converted the numeric RV to a
string and, extracted the low end, and converted that back to a
number.
If I was doing this again, I'd store each question in it's own
record
in a panel subordinate to the main questionnaire control panel.
This
would eliminate problems with the number of available RVs and allow
you to create much longer surveys.
My questionnaire featured all of your question types plus several
more
(rating something on a scale of 0 to 10, pick up to x choices from a
larger list of choices, or ranking a list of items in your order of
preference). Comments were allowed on many of the questions. The
DataPerfect output program allowed me to print the comments grouped
for review. On cross tabulations, I was able to print just the
comments
that pertained to the associated demographic.
I created the actual survey document as a Web based form and
imported the results into DataPerfect. This worked great as I
didn't
have any input efforts (which would have been substantial with the
large number of comments ... some of them quite lengthy). The Web
based form enabled me to use a combination of input form features
(radio buttons and check boxes) coupled with JavaScript
verifications
to only accept valid input. This forced the input data to be
completely
compliant eliminating any error handling in the DataPerfect
application.
I still have this application in my possession. I did this
project about
7 or 8 years ago so I don't remember much about it but I could send
you the STR file if you'd like. Frankly, if I was doing this
again, I
wouldn't want my old application as it would certainly be
difficult to
understand and modify. I'd, instead, start from scratch using
the two
level approach I described above. If you would like the STR
file, feel
free to call or E-mail.
Hope this helps.
Pat Riley
505-797-9072
At 02:35 AM 11/27/2006, you wrote:
Background:
Our village has recently taken part in a questionnaire/survey
whereby everyone filled in a paper form which is now being
transferred to computer file. The software provided by our local
authority (Council) is not particularly good: you have to go on
line for it to build a "Project List" of surveys done for other
villages before selecting & downloading the one for us - it does
this /every /time you want to transfer data from paper to file.
The "Questionnaire" part then loads but is not very user
friendly, not allowing you to go back to previous questions
without loosing data back to that point . . . . I could go on.
Once data has been transferred to files for the session, it must
be uploaded but the process of building a Project List etc..
occurs again first - all extremely slow & frustrating.
In a moment of frustration/weakness, I did say to the chap
running the project for the village (he did have a good head of
hair before it all started!) that it would be fairly straight
forward to design a database that would do all that is required
so much easier. Luckily for me, I'm too late this time as the
project is well under way but may be repeated in a couple of
years time.
So my question is has anyone designed a DataPerfect database for
questionnaires/surveys? It seems to me that that it should be
fairly straight forward but maybe laborious. There questions
fall into four categories:
Simple Yes/No responses,
Multiple choice options whereby only one of a number of
options must be chosen,
Multiple choice options whereby none, one, some or all of a
number of options must be chosen.
A box allowing comments to be written.
The first and last are easy, I'm not sure of the best way to
achieve the other two.
The other problem is the size of the questionnaire. There are
just under 200 questions which would be too many for a single
panel, although they are divided into sections such as
Transport, Environment etc... I had a thought of using a panel
for each section with a master Table of Contents Panel with
links to all other panels a bit like an table of contents
linking to the relevant pages of a book and maybe links from
each panel to previous & next panels.
This is all thankfully a way off yet but any thoughts or ideas
would be welcomed.
Michael
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
