Software Available for Download

HieroGenius Extract

Description: The HeiroGenius Extract desktop executable Python script is a specialized tool to convert 1EdTech Caliper standard JSON data structures into an Excel format by leveraging the json and openpxl open-source libraries. Operating recursively, it iterates down the data hierarchy to disassemble nested dictionaries and lists within the JSON data, transforming them into concatenated strings. This process of data flattening and conversion ensures that complex, multi-layered information in the Terracotta JSON export files is parsed into a tabular Excel layout. Excel's compatibility with statistical software packages such as SigmaStat and PRISM enables direct importation of JSON export data for advanced statistical modeling and hypothesis testing.

Executable Download Link: