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”
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.
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.
Learn ODBC : Deleting a records
In this article we are going to learn how to delete a record with ODBC. We will use the same base code as we have done in the previous examples and just add the additional delete function.
Learn ODBC : Inserting Records
In this article we are going to learn how to insert records into a sql database. The function we will create will be setup to insert into a non Data Collection Table.
Learn ODBC : Finding a record
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.
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.
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.
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.