aarnott / spss.net

A .NET library for read/writing SPSS Data (.sav) files. This wraps the functionality exposed by the spssio32.dll native library that comes with SPSS.

SPSS .NET Interop library

A .NET library for read/writing SPSS Data (.sav) files. This wraps the functionality exposed by the spssio32.dll native library that comes with SPSS.

SPSS is a statistical software application popular among students and researchers.

Recently updated to include spssio32.dll from SPSS 15 and to work with that version and possibly later versions.

See also the SPSSLib CodePlex project which has the same goals as this project, but without using spssio32.dll

Need support while using this library? Make a Bitcoin donation to 1LVV7oF3na4bcKBeTH2E2nY5u4Gcn7fy5Q and then write to the Discussions tab referencing your donation.

spss.net's Issues

Not able to read latest spss files.

I 've noticed this many times that when tried to read sav files with this dll, it reads all variable labels, value labels etc but no records are read, when I opened the same file in spss and saved it back and then tried to read the saved file, it reads all the records.

Add method to set encoding for the files

Is there a way to set encoding while writing values to .sav file? The Unicode characters like Arabic are shown as '????' in the output file

Nuget Install Command

Hi,

What's the NuGet install command for the project? I have tried "Install-Package Spss.Net" and "Install-Spss.Net-Master" without success.

I'm using the Package Manager in Visual Studio 2015 if that helps.

Thx

Syd.

Problem Deploying SPSS.NET App Using ClickOnce

Hi,

I've been using the SPSS.NET Wrapper for a couple of years now and appreciated the power of the wrapper. I have recently prepared a small WinForms data build app for one of my clients based on the current SPSS.NET repository using Visual Studio 2013. The app works fine inside Visual Studio but when I publish the app using ClickOnce and the CD-ROM option, any attempt to run it directly from my PC or the client's PC results in a system exception of "The Type Initiialiser for 'Spss.SpssThinWrapper' threw an exception. "

The Details dialog shows:

System.TypeInitializationException: The type initializer for 'Spss.SpssThinWrapper' threw an exception. ---> System.DllNotFoundException: C:\Users\Setup\AppData\Local\Apps\2.0\26XLD7NJ.AEO\9RYGRCCL.VKT\milt..tion_cdeb9d73f3f9454f_0001.0000_49d21d1c6226cfea\win64\spssio64.dll not found.
at Spss.SpssThinWrapper.LoadSpssDll()
at Spss.SpssThinWrapper..cctor()
--- End of inner exception stack trace ---
at Spss.SpssSafeWrapper.spssOpenRead(String fileName, Int32& handle)
at Spss.SpssDataDocument..ctor(String filename, SpssFileAccess access)
at Spss.SpssDataDocument.Open(String filename, SpssFileAccess access)
at MiltonModels.FirstForm.button4_Click(Object sender, EventArgs e) ...

The problem relates to the Win32 and Win64 spssio*.dll and possibly the expected location of the DLLs in the app directory. When I had similar problems with an earlier version of the Wrapper I circumvented the problem by copying the DLLs into \Windows\System32\ and registering them with Regsvr32.

I tried this approach and it did not work as I could not even register the DLLs (ie running regsvr32 spssio32.dll at a c:\ prompt in the \lib\win32\ directory gave an error "The module "spssio32.dll" was loaded but the entry-point DllRegisterServer was not found.Make sure that "spssio32.dll" is a valid DLL or OCX file and then try again.".)

I then changed the Build Action on the SPSS dlls to "Embedded Resource" thinking that maybe it would bundle the DLLs in with the library but I still received the same LoadDll error.

I note Microsoft does detail a manner to deploy COM components with CllickOnce (https://msdn.microsoft.com/en-us/library/ms165432(v=vs.120).aspx) but I have not been able recreate their approach using the SPSSIO DLLs.

So in summary,

a) Is there an option I should be using in the ClickOnce deployment which will automatically bring the DLLs and dependencies to the install process on a new PC ?
b) If I can't use the ClickOnce approach, is there another way to build the app using Visual Studio that would allow me to easily install the app with the associated DLL dependencies?
c) Is there a solution/link that might show me how to use the Registration-Free COM approach?
d) Failing all that, how is it possible to register the DLLs on the client machine using RegSvr32 in a way that gets around the RegSvr32 problem identified above?

Any suggestions much appreciated,

Regards

Ian (Sydney is the non-de-plume)

Why I saw this error while I try to add values label

I try to add 4 characters length values label. But It will show this error

Cannot add value labels to a long string variable

SpssDataDocument.Create(MemoryStream mso) ...

Is it possible SAV file to be generated in memory instead on hard file? I see SpssConvert.ToStream uses MemoryStream, but it's just a wrapper for temp file created.