Hi WizardMac team!

First of all, thank you very much for your hard work on this open source project.

I've started to build a tool to read SPSS files and I have a problem with time/duration columns. I use readstat/extract_metadata and extract_metadata extracts time column as simple integer. However, when I use WizardMac, it recognises the time column. (See screenshot)

Our tool vs WizardMac

extract_metadata output

I tested with both 1.1.4 and 1.1.5.

{
  "type": "SPSS",
  "variables": [
    {
      "type": "DATE",
      "name": "Date1",
      "label": "Date format 1"
    },
    {
      "type": "DATE",
      "name": "Date2",
      "label": "Date format 2"
    },
    {
      "type": "NUMERIC",
      "name": "Heure",
      "label": "Date - heure/seconde"
    },
    {
      "type": "STRING",
      "name": "Texte",
      "label": "Blabla"
    }
  ]
}

Source file

date.sav.zip

Time-related PRs

1. Question: variables with DATE and DATETIME formats not read correctly in PSPP #211
2. New time display format for SPSS #155 (Has this been implemented already?)
3. Support new SPSS formats MTIME and YMDHMS #91

Metadata

Besides time/duration, is there another known data type currently not extracted?

Cheers!