Follow @dporton

Importing CVT & SEQ files into Surveycraft.

With Dimensions it is possible to convert Dimensions data into a surveycraft format. To do this you need some DLLS installed on your machine and an mrs script. Once run , the script products a CVT ( metadata ) and SEQ ( data ) file. To Get these into surveycraft you need to do the following.

Read more

How do I loop the complex questions

You have been working on looping through your MDD for a while now and your code is almost complete, you have a few things left on your list to resolve, one of them is “How do i loop the complex questions”. This article explains how to do this and hopefully shows you some very useful concepts that can be re-used.

Read more

How can I get the text for a category

You have been working on looping through your MDD for a while now and your

 is almost complete, you have a few things left on your list to resolve, one of them is "Response.value returns a category number rather than the text, how , how can I get the response text". This article explains how to resolve this and hopefully shows you some very useful concepts that can be re-used.

Read more

Avoid Incrementing Quotas When Reviewing Interviews

Reviewing an interview causes the interview to be re-executed.  This can cause quotas to be incremented if the interview and sample management scripts do not take this into account.  The DDL example interviewing and sample management scripts for quota show how to avoid extra quota increments and should be used as a base.

Read more

Show all Excel constants

It is often very useful to have a list of all the constants that are used in Excel 2003. One way to get a list is to search the web, but you can produce such a list yourself. All you have to make sure is that you have the following DLL installed TlbInf32.dll. If you don’t have it, search the web and you will find. Once installed create a new mrs file and add the following code

Read more

Finding the value of EXCEL constants

When you write scripts that utilise Microsoft Excel objects you will definitely come across the need to understand some of the numeric values that are stored as Excel Constants. There are several ways you can find out these values and this article provides you with two ways to do that. Before we get started we need to have some excel code.

Read more

Corporate look and feel

In this section we will show you how quickly you can adopt a Corporate look and feel. Lets take the example where we have just got a job and the client has asked that we develop a online survey with their corporate look and feel. The company that we are working with is called Your Health and is a company that investigates customers day to day habits. The website looks like this.

Read more

Map Questions

Sometimes you will need your respondents to click on images to select areas such as what state do you live in. In this example we are going to take an image of Australia and turn it into a click-able image that we can use in our survey. We will also show you how you can store the information selected in your survey. The image we are going to use is the following.

Read more

%d bloggers like this: