Learn ODBC : Finding a record
Monday, February 1st, 2010 | No Comments
In this second article about ODBC we will begin to explore the ADODB.Recordset object. We will take what we have learnt previously and use it to write a function that will connect to a database table using the ADODB.Connection object and find a specific record, once found we will return its id. › Continue reading
Learn ODBC : Getting Connected
Thursday, January 28th, 2010 | No Comments
In this set of articles we will learn how to write code that will allow you to connect to tables within a database. We will show you how to connect to Data collection tables as well as normal SQL tables and show you the four things that you will need to do with them, find, Delete , update and export the records. This first article will teach you how to connect to a Data Base using the ADO object. › Continue reading
Auto skip to next question after time limit
Thursday, January 21st, 2010 | No Comments
In this article we will learn how to create a JavaScript timer. Once we have the timer we will show you how to connect it to the next button on the page so that it gets pressed when the timer is done. › Continue reading
Clean a specified Context of HTML
Saturday, January 16th, 2010 | No Comments
Ever wanted to get rid of the html from a specific context? Have you needed to create a clean MDD and get rid of the annoying characters that are messing up your Reports for survey tables? If the answer is yes to either one or both of these questions then you should read this article. In it we explain how to open up your MDD file in your dms script and clean the metadata of all those unwanted characters before you export the data. › Continue reading
Quick Question : What spec hardware should I buy?
Tuesday, January 12th, 2010 | 2 Comments
Recently we where asked what spec hardware should we buy for our new Data Collection Interview Server setup, and we had to honestly reply we don’t know, but we know people that might have an in stite on some rules that they used. So … When you purchased your setup , how did you decide what hardware to buy? Did you use any sort of sizing calculator or was it just a guess?
If you did not use any sort of calculator, but have a setup in use and its working for you, what spec machines do you have , how many emails do you send out , and what is your response rate for WEB and CATI ? How many questions do you have on average in your surveys? What does DimensionNet or Interview Administrator say your max con-currents are ?
We would love to hear from you be it from a comment on this article or a email to admin@smarterDimensions.com if you are willing to send us all your IVW* log files ( from all servers in the cluster ) then that would be great , we plan to run some articles on how we can write programs to read these and work out actual concurrency and then perhaps come up with a sizing calculator. So anything you send us will help us write a realy cool set of articles and scripts. We promise that all confidentiality will be kept and no names will be given as to whose setup is who’s
Regards
The Smarter Dimensions Team.
PS We cannot do this without your input !!