Follow @dporton

How do I check my connection to my mrInterview SQL database

You have your mrInterview system setup, but you are unsure if the SQL database is accessible to you. The first thing to do would be to talk to your IT guys and see what they have to say, if they say you should be able to connect then the quickest way for you to double check is to try and make the SQL connection. Ask them to provide you with the SQL login details ( name of server, user login and password ) and once you have this, you are ready to go.

Read moreHow do I check my connection to my mrInterview SQL database

Report at end

At some stage you may be asked to produce a report at the end of the survey to allow the user to print off or just view their answers to the questions they selected. Now there are many ways this can be achieved but in this example we will show you a simple way of doing this. And once you have this structure it could be taken further. What we will do is to create a survey, collect an email address and then send the respondent an email with their survey responses in html format in the email, after viewing them on the screen. We will not cover the send email bit in this example, but you can see how to do this in another article on this website.

Read moreReport at end

2×4 Translate

The Story

“When I had to implement my first project with support for multiple languages, we all underestimated the need for professional translation management. I had to manage a project with 16 different languages and more than 1200 single labels. Instead of planned 2 hrs. management time per language, I finally needed more than twice as long.”

Read more2×4 Translate

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 moreImporting CVT & SEQ files into Surveycraft.

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 moreHow do I loop the complex questions

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 moreHow can I get the text for a category

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 moreAvoid Incrementing Quotas When Reviewing Interviews

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 moreShow all Excel constants

%d bloggers like this: