I have a set of tables where each table has to be formatted individually. I'm writing a Python script. I've managed to extract XML chart for each table however, I can't find a way to insert formatted XML to output window. Is there any solution? I'm aware of `OUTPUT CREATE` command but it requires JSON which schema is not compatible with XML chart (meaning, when I use `xmltodict` Python external library, I can't simply put this dictionary (hence JSON) into `OUTPUT CREATE`). So, alternatively, is there any way to extract JSON directly from output window (using OMS or `OUTPUT EXPORT`) - OR - any tool to convert easily this XML chart/Python dictionary extracted from XML to StatJSON 2.0 schema?

I have a set of tables where each table has to be formatted individually. I'm writing a Python script. I've managed to extract XML chart for each table however, I can't find a way to insert formatted XML to output window. Is there any solution? I'm aware of `OUTPUT CREATE` command but it requires JSON which schema is not compatible with XML chart (meaning, when I use `xmltodict` Python external library, I can't simply put this dictionary (hence JSON) into `OUTPUT CREATE`). So, alternatively, is there any way to extract JSON directly from output window (using OMS or `OUTPUT EXPORT`) - OR - any tool to convert easily this XML chart/Python dictionary extracted from XML to StatJSON 2.0 schema?

Thanks Jon.

This special formatting mostly deals with relocating some values from columns to rows, deleting certain columns and - most importantly - merging proportional comparison test into one table (`CTABLES` syntax does not offer satisfying results, not to mention that when results of comparison are automatically merged they are different than divided into two separate custom tables!).

I've just found statjson.py module in util folder (in site-packages) and I find it to may be possibly useful. Are there any examples how to use this API? In general, StatJSON and `OUTPUT CREATE` documentation lacks of good, various examples. If I'm wrong - where should I look for them?

Last but not least - do SPSS developers plan to implement (via `OMS` or `OUTPUT EXPORT`) feature to convert output elements to JSON? On the other hand, a Python module for extraction/conversion from XML would do a great job (I hope).

I have a set of tables where each table has to be formatted individually. I'm writing a Python script. I've managed to extract XML chart for each table however, I can't find a way to insert formatted XML to output window. Is there any solution? I'm aware of `OUTPUT CREATE` command but it requires JSON which schema is not compatible with XML chart (meaning, when I use `xmltodict` Python external library, I can't simply put this dictionary (hence JSON) into `OUTPUT CREATE`). So, alternatively, is there any way to extract JSON directly from output window (using OMS or `OUTPUT EXPORT`) - OR - any tool to convert easily this XML chart/Python dictionary extracted from XML to StatJSON 2.0 schema?

Thanks Jon.

This special formatting mostly deals with relocating some values from columns to rows, deleting certain columns and - most importantly - merging proportional comparison test into one table (`CTABLES` syntax does not offer satisfying results, not to mention that when results of comparison are automatically merged they are different than divided into two separate custom tables!).

I've just found statjson.py module in util folder (in site-packages) and I find it to may be possibly useful. Are there any examples how to use this API? In general, StatJSON and `OUTPUT CREATE` documentation lacks of good, various examples. If I'm wrong - where should I look for them?

Last but not least - do SPSS developers plan to implement (via `OMS` or `OUTPUT EXPORT`) feature to convert output elements to JSON? On the other hand, a Python module for extraction/conversion from XML would do a great job (I hope).

I have a set of tables where each table has to be formatted individually. I'm writing a Python script. I've managed to extract XML chart for each table however, I can't find a way to insert formatted XML to output window. Is there any solution? I'm aware of `OUTPUT CREATE` command but it requires JSON which schema is not compatible with XML chart (meaning, when I use `xmltodict` Python external library, I can't simply put this dictionary (hence JSON) into `OUTPUT CREATE`). So, alternatively, is there any way to extract JSON directly from output window (using OMS or `OUTPUT EXPORT`) - OR - any tool to convert easily this XML chart/Python dictionary extracted from XML to StatJSON 2.0 schema?

Thanks Jon.

This special formatting mostly deals with relocating some values from columns to rows, deleting certain columns and - most importantly - merging proportional comparison test into one table (`CTABLES` syntax does not offer satisfying results, not to mention that when results of comparison are automatically merged they are different than divided into two separate custom tables!).

I've just found statjson.py module in util folder (in site-packages) and I find it to may be possibly useful. Are there any examples how to use this API? In general, StatJSON and `OUTPUT CREATE` documentation lacks of good, various examples. If I'm wrong - where should I look for them?

Last but not least - do SPSS developers plan to implement (via `OMS` or `OUTPUT EXPORT`) feature to convert output elements to JSON? On the other hand, a Python module for extraction/conversion from XML would do a great job (I hope).

I have a set of tables where each table has to be formatted individually. I'm writing a Python script. I've managed to extract XML chart for each table however, I can't find a way to insert formatted XML to output window. Is there any solution? I'm aware of `OUTPUT CREATE` command but it requires JSON which schema is not compatible with XML chart (meaning, when I use `xmltodict` Python external library, I can't simply put this dictionary (hence JSON) into `OUTPUT CREATE`). So, alternatively, is there any way to extract JSON directly from output window (using OMS or `OUTPUT EXPORT`) - OR - any tool to convert easily this XML chart/Python dictionary extracted from XML to StatJSON 2.0 schema?