Range recodes export is slightly different from exporting regular recodes. In this case export file will only contain already defined Ranges, so you need to have at least one to export a file, otherwise you will get an empty spreadsheet. After clicking "Export .xlsx" Halo Reports will generate an excel spreadsheet with thee columns. Columns "A" and "B" contain the information about the range of the recode, while column "C" has labels of recoded ranges. You can edit this file and then import it back to Halo Reports.
Import:
Click "Import .xlsx" and choose an excel file that you want to import. You have to remember a few rules:
Ranges defined in columns "A" and "B" cannot overlap, if they do you will not be able to import it;
Halo Reports reads the first column until first empty cell;
recoded labels in column "C" are case sensitive (it matters whether you use uppercase or lowercase letters).
Exported file
Imported file
After you import new mapping, Halo Reports will inform you about the number of found recodes:
Found 8 recode(s) in file. - this message means that Halo Reports found and applied 8 recodes.
