SPSS Data (.sav) incl Metadata into a MongoDB

[Lucie Krennwallner]

Hi, 

am wondering how to get SPSS Data (.sav) incl Metadata INTO a MongoDB as Collections. 

It seems one can import CSV or JSON into Mongo, alas converting .sav Files to JSON files (either via online converter or using R) either provide scrambles or lose the Meta-Data.

What's the best/most efficient way to solve this challenge!

Thanks for any advice!

[Robert Cochran]

Hi!

You don't mention what version of SPSS you have, but it should allow you to export your data to comma separated values ("csv") format, which you can then import into MongoDB. 

I Googled quickly and seemed to find a fair number of matches on how to export SPSS data to a file in csv format.

Thanks so much

Bob

[Lucie Krennwallner]

Hi, Thanks Bob.

Sorry concerning the SPSS version: my colleagues use various versions ranging from 22 to 24.

Am aware, one can export the data as CSV or XLS, or one could convert .sav files to CSV, for example, using R or Python.

Yet my question is: has MongoDB a feature that can work with/process  .sav files DIRECTLY . Without preprocessing, conversions or "detours".

It seems not. 

Thanks again, Cheers, Lucie

[Robert Cochran]

Hi,

MongoDB provides excellent documentation of all its tools. The mongoimport documentation is here. 

I am not an employee of MongoDB, Inc. I am just another list user trying to help you.

Thanks so much

Bob

[Lucie Krennwallner]

Hi Robert,

thanks you so much!

Had searched the documentation and only found "The mongoimport tool imports content from an Extended JSON, CSV, or TSV export created by mongoexport". No mentioning of SPSS or ".sav" files

However often experienced people developed solutions that did not find the way (yet) into documentation. In other words: because it is not mentioned in the documentation does not mean, it is not possible. 

Alas I am not a programmer, but an analyst, so cannot help developing new features.

Nevertheless, I am grateful for the comments, because it at least confirms, that I haven't missed anything.

So, thank you - and everyone - very much again!

Best, Lucie







On Tuesday, May 28, 2019 at 12:37:30 PM UTC+2, Lucie Krennwallner wrote: