Data loader tool

[devilgate]

Peter's comments:

I would recommend a new simple loading tool as part of the main RIF web application that just loads data in a predefined format direct into the database. It would be able to:

• Convert age and sex to AGE_SEX_GROUP;
• Add additional required geography fields as long as the highest resolution is provided;
• Verify the defined primary key;
• Partition and index

[peterhambly]

A new simple loading tool that is part of the main RIF web application that just loads data in a predefined format directly into the database. The tool would be a "Data Loading" tab on the main RIF screen, visible only the users with the rif_manager role. It wouild have four new icons similar to the tree focused on:

• Geographies;
• Denominator data;
• Covariates;
• Numerator data;

It would be able to:

• Convert age and sex to AGE_SEX_GROUP;
• Add additional required geography fields as long as the highest resolution is provided;
• Verify the defined primary key;
• Partition and index

Longer term the data loader tool could support more formats, e.g. typical SAHSU study extracts or CDC datasets and the loading of covariates and denominator data

Support for geographies would require the tileMaker functionality to be moved into the RIF - see below and Issue #91 Tilemaker updates.