2007-08-13

These notes need to be updated and the process made easier.

This was just to take notes while doing it the hard way to make it easier to optimize later.

datapoint 

enter as usual via import of csv

--see attached template (Suzanne send me a template)

 
dataset

-dataSetOID = this created (Al needs to set this to auto inc)

--soource oid opt

--typeOID = this is realted issue area ie Hunger = 18

--locationtypeoid = geo level table ie county = 2

--Long desc

--dataset is the name

 
datasetxissue

-enter datasetoid

--issueoid = from issue ie Hunger 18 (typeoid in dataset)

 
datasetXLocationType 

-dataSetOID

-locationTypeOID = ie county etc