Follow @dporton

De-dupe your data files

In this article I will show you one way that you could use to de-dupe your data collection datafiles. I am not sure how you would get duplicates in it in the first place , but let’s just assume you do have them. This example will use the Museum.ddf file in the DDL. This file & the ddf can be found here “.DDLDataData Collection File”

Read more

Connecting to an Excel file using the ADO DSC

On our site we have a few articles about how to connect to SQL databases using ODBC connections, but have you ever wanted to use ODBC to read an XLS file? Not Everyone has access to SQL so using Excel to store data for perhaps a CAPI survey is often a viable option. In this article we will show you how to build the connection string required to connect.

Read more

Learn ODBC : Updating records

Now that we know how to connect , find , insert and delete records there is one more action that we will  write about in this series of articles on ODBC. As well as all the above we will need at some point in time  to know how to update a record. This article will show you how to do just that.

Read more

Learn ODBC : Getting Connected

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.

Read more

How to use DMQuery to find out my connection string

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.

Read more

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.

Read more

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.

Read more

%d bloggers like this: