When you write mrStudio scripts you will frequently need to create connection strings. To help you achieve this SPSS has produced several tools that once connected to a data source will show you the connection string. This article will show you how to display the connection string while you are using the tool DMQUERY.
Data Management
How to use WinDMSRun
There are a few tools that you should always be using to help you with your Dimensions work this article is about the tool “WinDMSRun”. WinDMSRun helps you quickly export data via dms scripts withought having to write any code. The WinDMSRun tool comes with the Dimensions development library and if you have this installed you can find it in the following directory.
The mrStudio connection wizard
When you write mrStudio scripts you will frequently need to create connection strings. To help you achieve this , and to help you not to have to remember all the properties that you may want to use , there is a database connection string builder tool inside of mrStudio to walk you through the process of building a string and getting you the correct connection information.
Using the datalink properties wizard
No mater what you do with dimensions you will almost definitely come across the “Datalink Properties Wizard”, this article shows you how to use it. In this article we are going to connect to the museum database that comes with the Dimensions Development Library. It can be found in the following directory.
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.
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.
Dimensions To Surveycraft
Convert your Dimensions data files into Surveycraft CVT and SEQ files as easy as one…. two…. three…