dhis2-devs team mailing list archive

Thread
Date

Importing data elements via DXF--problems with Shortname

To: dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
From: Jason Pickering <jason.p.pickering@xxxxxxxxx>
Date: Mon, 27 Dec 2010 16:33:20 +0200

Hi there,
I am attempting to use the "preferred" route for data migration from a
legacy system into DHIS2. This means transforming the legacy source
into XML and importing via the normal mechanisms. I have attached an
XML file which can be uploaded and processed, but after that, I get an
error..
What is not entirely clear is I do not see any element which has a
NULL shortname Certainly some of them have shortnames, but these do
not show up in the SQL statement

 It seems that maybe the shortname is being ignored entirely.

Any tips or perhaps better eyes?

Best regards,
Jason



Caused by: org.h2.jdbc.JdbcSQLException: NULL not allowed for column "SHORTNAME"
; SQL statement:
INSERT INTO dataelement (uuid,name,alternativename,shortname,code,description,ac
tive,valuetype,domaintype,aggregationtype,extendeddataelementid,categorycomboid,
sortorder,lastupdated) VALUES (null,'Antenatal 1st visits total (calc)',null,nul
l,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Benzyl penici
llin stock out',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-0
5'),(null,'InStock_Chloro',null,null,null,null,true,'int',null,'sum',null,1,null
,'2010-11-05'),(null,'Antenatal follow up visit',null,null,null,null,true,'int',
null,'sum',null,1,null,'2010-11-05'),(null,'Cotrimoxazole 480mg stock out',null,
null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'AntiBio_Pr
escribed',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(n
ull,'BCG dose <1 year',null,null,null,null,true,'int',null,'sum',null,1,null,'20
10-11-05'),(null,'Bed days',null,null,null,null,true,'int',null,'sum',null,1,nul
l,'2010-11-05'),(null,'Below the dotted line under 5',null,null,null,null,true,'
int',null,'sum',null,1,null,'2010-11-05'),(null,'Caesarean section',null,null,nu
ll,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'DPT-HepB+Hib vacc
ine stock out',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05
'),(null,'CHWs_Active',null,null,null,null,true,'int',null,'sum',null,1,null,'20
10-11-05'),(null,'CHWs_Patients',null,null,null,null,true,'int',null,'sum',null,
1,null,'2010-11-05'),(null,'Vector Rodent complaints received',null,null,null,nu
ll,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Any Anti malaria for I
PT stock out',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'
),(null,'InStock_Keta',null,null,null,null,true,'int',null,'sum',null,1,null,'20
10-11-05'),(null,'InStock_Lance',null,null,null,null,true,'int',null,'sum',null,
1,null,'2010-11-05'),(null,'Complicated_Deliveries',null,null,null,null,true,'in
t',null,'sum',null,1,null,'2010-11-05'),(null,'Vector Rodent complaints attended
 to',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'
Deaths_48hours',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-0
5'),(null,'Deaths_O5',null,null,null,null,true,'int',null,'sum',null,1,null,'201
0-11-05'),(null,'Deaths_U5',null,null,null,null,true,'int',null,'sum',null,1,nul
l,'2010-11-05'),(null,'DPT-Hib+HepB 3rd dose',null,null,null,null,true,'int',nul
l,'sum',null,1,null,'2010-11-05'),(null,'Drug_Kits',null,null,null,null,true,'in
t',null,'sum',null,1,null,'2010-11-05'),(null,'Expiry_Drug',null,null,null,null,
true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Expiry_HIV',null,null,nul
l,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Expiry_RPR',null,n
ull,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Expiry_Uri'
,null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Immu
nised fully <1 year new',null,null,null,null,true,'int',null,'sum',null,1,null,'
2010-11-05'),(null,'Attendance Family Planning - New',null,null,null,null,true,'
int',null,'sum',null,1,null,'2010-11-05'),(null,'Attendance Family Planning - Re
visit',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null
,'HC_Staff',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),
(null,'Hosp_OPDStaff',null,null,null,null,true,'int',null,'sum',null,1,null,'201
0-11-05'),(null,'Hosp_SuppStaff',null,null,null,null,true,'int',null,'sum',null,
1,null,'2010-11-05'),(null,'Hosp_WardStaff',null,null,null,null,true,'int',null,
'sum',null,1,null,'2010-11-05'),(null,'Food inspections performed',null,null,nul
l,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Food inspections r
esulting in seizure and disposal of food',null,null,null,null,true,'int',null,'s
um',null,1,null,'2010-11-05'),(null,'Premises inspected',null,null,null,null,tru
e,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Premises inspected in compli
ance',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,
'Usable beds total',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-
11-05'),(null,'InStock_Measles',null,null,null,null,true,'int',null,'sum',null,1
,null,'2010-11-05'),(null,'InStock_OPV',null,null,null,null,true,'int',null,'sum
',null,1,null,'2010-11-05'),(null,'Amoxicillin capsules stock out',null,null,nul
l,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'InStock_OralCon',n
ull,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'InStoc
k_BCG',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null
,'Paracetamol 500mg stock out',null,null,null,null,true,'int',null,'sum',null,1,
null,'2010-11-05'),(null,'RPR test stock out',null,null,null,null,true,'int',nul
l,'sum',null,1,null,'2010-11-05'),(null,'InStock_TT',null,null,null,null,true,'i
nt',null,'sum',null,1,null,'2010-11-05'),(null,'OP_U5_First_Attendances_Refer',n
ull,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Inpati
ent Under 5 Admissions',null,null,null,null,true,'int',null,'sum',null,1,null,'2
010-11-05'),(null,'Inpatient Over 5 Admissions',null,null,null,null,true,'int',n
ull,'sum',null,1,null,'2010-11-05'),(null,'Inpatient discharge 5 years and over'
,null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Inpa
tient discharges under 5',null,null,null,null,true,'int',null,'sum',null,1,null,
'2010-11-05'),(null,'Old_HMIS_Default_LiveBirths',null,null,null,null,true,'int'
,null,'sum',null,1,null,'2010-11-05'),(null,'Live birth in facility under 2500g'
,null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Majo
r_Surgical_Procedures',null,null,null,null,true,'int',null,'sum',null,1,null,'20
10-11-05'),(null,'Maternal_Deaths',null,null,null,null,true,'int',null,'sum',nul
l,1,null,'2010-11-05'),(null,'Measles first dose under 1 year',null,null,null,nu
ll,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Normal delivery in fac
ility',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null
,'OP_O5_First_Attendances',null,null,null,null,true,'int',null,'sum',null,1,null
,'2010-11-05'),(null,'OP_O5_First_Attendances_ByPass',null,null,null,null,true,'
int',null,'sum',null,1,null,'2010-11-05'),(null,'OP_O5_First_Attendances_Refer',
null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'OP_O5
_Reattendances',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-0
5'),(null,'OP_U5_First_Attendances',null,null,null,null,true,'int',null,'sum',nu
ll,1,null,'2010-11-05'),(null,'OP_U5_First_Attendances_ByPass',null,null,null,nu
ll,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'OP_U5_Reattendances',n
ull,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'OPV 3r
d dose',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(nul
l,'Postnatal first attendances',null,null,null,null,true,'int',null,'sum',null,1
,null,'2010-11-05'),(null,'PostOp_Wound_Infections',null,null,null,null,true,'in
t',null,'sum',null,1,null,'2010-11-05'),(null,'Tetanus Toxoid 2nd or booster dos
e to pregnant woman',null,null,null,null,true,'int',null,'sum',null,1,null,'2010
-11-05'),(null,'Water samples taken',null,null,null,null,true,'int',null,'sum',n
ull,1,null,'2010-11-05'),(null,'Still births',null,null,null,null,true,'int',nul
l,'sum',null,1,null,'2010-11-05'),(null,'Supervisory_Visits',null,null,null,null
,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Salt samples tested with
 adequate iodine',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11
-05'),(null,'TBAs_Active',null,null,null,null,true,'int',null,'sum',null,1,null,
'2010-11-05'),(null,'Delivery by a trained traditional birth attendant',null,nul
l,null,null,true,'int',null,'sum',null,1,null,'2010-11-05'),(null,'Child <5 year
s weighed total',null,null,null,null,true,'int',null,'sum',null,1,null,'2010-11-
05'),(null,'OPD First Attendances Over 5',null,null,null,null,true,'int',null,'s
um',null,1,null,'2010-11-05'),(null,'OPD First Attendances Under 5',null,null,nu
ll,null,true,'int',null,'sum',null,1,null,'2010-11-05') [90006-143]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.table.Column.validateConvertUpdateSequence(Column.java:294)
        at org.h2.table.Table.validateConvertUpdateSequence(Table.java:621)
        at org.h2.command.dml.Insert.insertRows(Insert.java:117)
        at org.h2.command.dml.Insert.update(Insert.java:83)
        at org.h2.command.CommandContainer.update(CommandContainer.java:70)
        at org.h2.command.Command.executeUpdate(Command.java:199)
        at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:12
5)
        at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110)
        at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractB
atchHandler.java:276)
        ... 7 more

-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+260968395190

<?xml version="1.0" ?> 
<dxf xmlns="http://dhis2.org/schema/dxf/1.0"; minorVersion="1.1" exported="2010-12-27">
 <categoryOptions>
 <categoryOption>
  <id>8</id> 
  <name>default</name> 
  </categoryOption>
 </categoryOptions>
<categories>
 <category>
   <id>9</id> 
  <name>default</name> 
  <concept /> 
  </category>
 </categories>
<categoryCombos>
  <categoryCombo>
  <id>10</id> 
  <name>default</name> 
  </categoryCombo>
</categoryCombos>
<categoryOptionCombos>
 <categoryOptionCombo>
  <id>11</id> 
 <categoryCombo>
  <id>10</id> 
  <name>default</name> 
  </categoryCombo>
 <categoryOptions>
 <categoryOption>
  <id>8</id> 
  <name>default</name> 
  </categoryOption>
  </categoryOptions>
  </categoryOptionCombo>
  </categoryOptionCombos>
<categoryCategoryOptionAssociations>
 <categoryCategoryOptionAssociation>
  <category>9</category> 
  <categoryOption>8</categoryOption> 
  <sortOrder>1</sortOrder> 
  </categoryCategoryOptionAssociation>
  </categoryCategoryOptionAssociations>
<categoryComboCategoryAssociations>
 <categoryComboCategoryAssociation>
  <categoryCombo>10</categoryCombo> 
  <category>9</category> 
  <sortOrder>1</sortOrder> 
  </categoryComboCategoryAssociation>
  </categoryComboCategoryAssociations>
<dataElements><dataElement>
<id>1</id>
<uuid />
<name>Antenatal 1st visits total (calc)</name>
<alternativename>antenatal_first</alternativename>
<shortname>Antenatal 1st visits total (calc)</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>37</id>
<uuid />
<name>Benzyl penicillin stock out</name>
<alternativename>instock_benzylpen</alternativename>
<shortname>Benzyl penicillin stock out</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>38</id>
<uuid />
<name>InStock_Chloro</name>
<alternativename>instock_chloro</alternativename>
<shortname>InStock_Chloro</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>2</id>
<uuid />
<name>Antenatal follow up visit</name>
<alternativename>antenatal_reattendance</alternativename>
<shortname>Antenatal follow up visit</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>39</id>
<uuid />
<name>Cotrimoxazole 480mg stock out</name>
<alternativename>instock_cotri</alternativename>
<shortname>Cotrimoxazole 480mg stock out</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>3</id>
<uuid />
<name>AntiBio_Prescribed</name>
<alternativename>antibio_prescribed</alternativename>
<shortname>AntiBio_Prescribed</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>4</id>
<uuid />
<name>BCG dose &lt;1 year</name>
<alternativename>bcg_under1</alternativename>
<shortname>BCG dose &lt;1 year</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>5</id>
<uuid />
<name>Bed days</name>
<alternativename>bed_days</alternativename>
<shortname>Bed days</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>6</id>
<uuid />
<name>Below the dotted line under 5</name>
<alternativename>below_line_under5</alternativename>
<shortname>Below the dotted line under 5</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>7</id>
<uuid />
<name>Caesarean section</name>
<alternativename>caesarean_sections</alternativename>
<shortname>Caesarean section</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>40</id>
<uuid />
<name>DPT-HepB+Hib vaccine stock out</name>
<alternativename>instock_dpt</alternativename>
<shortname>DPT-HepB+Hib vaccine stock out</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>8</id>
<uuid />
<name>CHWs_Active</name>
<alternativename>chws_active</alternativename>
<shortname>CHWs_Active</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>9</id>
<uuid />
<name>CHWs_Patients</name>
<alternativename>chws_patients</alternativename>
<shortname>CHWs_Patients</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>10</id>
<uuid />
<name>Vector Rodent complaints received</name>
<alternativename>compl_rodent</alternativename>
<shortname>Vector Rodent complaints received</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>41</id>
<uuid />
<name>Any Anti malaria for IPT stock out</name>
<alternativename>instock_fansidar</alternativename>
<shortname>Any Anti malaria for IPT stock out</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>43</id>
<uuid />
<name>InStock_Keta</name>
<alternativename>instock_keta</alternativename>
<shortname>InStock_Keta</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>44</id>
<uuid />
<name>InStock_Lance</name>
<alternativename>instock_lance</alternativename>
<shortname>InStock_Lance</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>12</id>
<uuid />
<name>Complicated_Deliveries</name>
<alternativename>complicated_deliveries</alternativename>
<shortname>Complicated_Deliveries</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>11</id>
<uuid />
<name>Vector Rodent complaints attended to</name>
<alternativename>compl_rodent_attended</alternativename>
<shortname>Vector Rodent complaints attended to</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>13</id>
<uuid />
<name>Deaths_48hours</name>
<alternativename>deaths_48hours</alternativename>
<shortname>Deaths_48hours</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>14</id>
<uuid />
<name>Deaths_O5</name>
<alternativename>deaths_o5</alternativename>
<shortname>Deaths_O5</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>15</id>
<uuid />
<name>Deaths_U5</name>
<alternativename>deaths_u5</alternativename>
<shortname>Deaths_U5</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>17</id>
<uuid />
<name>DPT-Hib+HepB 3rd dose</name>
<alternativename>dpt3_under1</alternativename>
<shortname>DPT-Hib+HepB 3rd dose</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>18</id>
<uuid />
<name>Drug_Kits</name>
<alternativename>drug_kits</alternativename>
<shortname>Drug_Kits</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>19</id>
<uuid />
<name>Expiry_Drug</name>
<alternativename>expiry_drug</alternativename>
<shortname>Expiry_Drug</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>20</id>
<uuid />
<name>Expiry_HIV</name>
<alternativename>expiry_hiv</alternativename>
<shortname>Expiry_HIV</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>21</id>
<uuid />
<name>Expiry_RPR</name>
<alternativename>expiry_rpr</alternativename>
<shortname>Expiry_RPR</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>22</id>
<uuid />
<name>Expiry_Uri</name>
<alternativename>expiry_uri</alternativename>
<shortname>Expiry_Uri</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>23</id>
<uuid />
<name>Immunised fully &lt;1 year new</name>
<alternativename>fic_under1</alternativename>
<shortname>Immunised fully &lt;1 year new</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>24</id>
<uuid />
<name>Attendance Family Planning - New</name>
<alternativename>fp_new</alternativename>
<shortname>Attendance Family Planning - New</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>25</id>
<uuid />
<name>Attendance Family Planning - Revisit</name>
<alternativename>fp_reattendance</alternativename>
<shortname>Attendance Family Planning - Revisit</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>26</id>
<uuid />
<name>HC_Staff</name>
<alternativename>hc_staff</alternativename>
<shortname>HC_Staff</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>27</id>
<uuid />
<name>Hosp_OPDStaff</name>
<alternativename>hosp_opdstaff</alternativename>
<shortname>Hosp_OPDStaff</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>28</id>
<uuid />
<name>Hosp_SuppStaff</name>
<alternativename>hosp_suppstaff</alternativename>
<shortname>Hosp_SuppStaff</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>29</id>
<uuid />
<name>Hosp_WardStaff</name>
<alternativename>hosp_wardstaff</alternativename>
<shortname>Hosp_WardStaff</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>30</id>
<uuid />
<name>Food inspections performed</name>
<alternativename>insp_food</alternativename>
<shortname>Food inspections performed</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>31</id>
<uuid />
<name>Food inspections resulting in seizure and disposal of food</name>
<alternativename>insp_food_seized</alternativename>
<shortname>Food inspections resulting in seizure and disposa</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>32</id>
<uuid />
<name>Premises inspected</name>
<alternativename>insp_prem</alternativename>
<shortname>Premises inspected</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>33</id>
<uuid />
<name>Premises inspected in compliance</name>
<alternativename>insp_prem_comp</alternativename>
<shortname>Premises inspected in compliance</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>34</id>
<uuid />
<name>Usable beds total</name>
<alternativename>institution_beds</alternativename>
<shortname>Usable beds total</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>45</id>
<uuid />
<name>InStock_Measles</name>
<alternativename>instock_measles</alternativename>
<shortname>InStock_Measles</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>46</id>
<uuid />
<name>InStock_OPV</name>
<alternativename>instock_opv</alternativename>
<shortname>InStock_OPV</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>35</id>
<uuid />
<name>Amoxicillin capsules stock out</name>
<alternativename>instock_amoxy</alternativename>
<shortname>Amoxicillin capsules stock out</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>47</id>
<uuid />
<name>InStock_OralCon</name>
<alternativename>instock_oralcon</alternativename>
<shortname>InStock_OralCon</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>36</id>
<uuid />
<name>InStock_BCG</name>
<alternativename>instock_bcg</alternativename>
<shortname>InStock_BCG</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>48</id>
<uuid />
<name>Paracetamol 500mg stock out</name>
<alternativename>instock_para</alternativename>
<shortname>Paracetamol 500mg stock out</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>50</id>
<uuid />
<name>RPR test stock out</name>
<alternativename>instock_rpr</alternativename>
<shortname>RPR test stock out</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>51</id>
<uuid />
<name>InStock_TT</name>
<alternativename>instock_tt</alternativename>
<shortname>InStock_TT</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>68</id>
<uuid />
<name>OP_U5_First_Attendances_Refer</name>
<alternativename>op_u5_first_attendances_refer</alternativename>
<shortname>OP_U5_First_Attendances_Refer</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>53</id>
<uuid />
<name>Inpatient Under 5 Admissions</name>
<alternativename>ip_u5_admissions</alternativename>
<shortname>Inpatient Under 5 Admissions</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>52</id>
<uuid />
<name>Inpatient Over 5 Admissions</name>
<alternativename>ip_o5_admissions</alternativename>
<shortname>Inpatient Over 5 Admissions</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>54</id>
<uuid />
<name>Inpatient discharge 5 years and over</name>
<alternativename>ipd_dis_o5</alternativename>
<shortname>Inpatient discharge 5 years and over</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>55</id>
<uuid />
<name>Inpatient discharges under 5</name>
<alternativename>ipd_dis_u5</alternativename>
<shortname>Inpatient discharges under 5</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>56</id>
<uuid />
<name>Old_HMIS_Default_LiveBirths</name>
<alternativename>live_births</alternativename>
<shortname>Old_HMIS_Default_LiveBirths</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>57</id>
<uuid />
<name>Live birth in facility under 2500g</name>
<alternativename>low_birth_weight</alternativename>
<shortname>Live birth in facility under 2500g</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>58</id>
<uuid />
<name>Major_Surgical_Procedures</name>
<alternativename>major_surgical_procedures</alternativename>
<shortname>Major_Surgical_Procedures</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>59</id>
<uuid />
<name>Maternal_Deaths</name>
<alternativename>maternal_deaths</alternativename>
<shortname>Maternal_Deaths</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>60</id>
<uuid />
<name>Measles first dose under 1 year</name>
<alternativename>measles_under1</alternativename>
<shortname>Measles first dose under 1 year</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>61</id>
<uuid />
<name>Normal delivery in facility</name>
<alternativename>normal_deliveries</alternativename>
<shortname>Normal delivery in facility</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>62</id>
<uuid />
<name>OP_O5_First_Attendances</name>
<alternativename>op_o5_first_attendances</alternativename>
<shortname>OP_O5_First_Attendances</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>63</id>
<uuid />
<name>OP_O5_First_Attendances_ByPass</name>
<alternativename>op_o5_first_attendances_bypass</alternativename>
<shortname>OP_O5_First_Attendances_ByPass</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>64</id>
<uuid />
<name>OP_O5_First_Attendances_Refer</name>
<alternativename>op_o5_first_attendances_refer</alternativename>
<shortname>OP_O5_First_Attendances_Refer</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>65</id>
<uuid />
<name>OP_O5_Reattendances</name>
<alternativename>op_o5_reattendances</alternativename>
<shortname>OP_O5_Reattendances</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>66</id>
<uuid />
<name>OP_U5_First_Attendances</name>
<alternativename>op_u5_first_attendances</alternativename>
<shortname>OP_U5_First_Attendances</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>67</id>
<uuid />
<name>OP_U5_First_Attendances_ByPass</name>
<alternativename>op_u5_first_attendances_bypass</alternativename>
<shortname>OP_U5_First_Attendances_ByPass</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>69</id>
<uuid />
<name>OP_U5_Reattendances</name>
<alternativename>op_u5_reattendances</alternativename>
<shortname>OP_U5_Reattendances</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>72</id>
<uuid />
<name>OPV 3rd dose</name>
<alternativename>opv3_under1</alternativename>
<shortname>OPV 3rd dose</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>73</id>
<uuid />
<name>Postnatal first attendances</name>
<alternativename>postnatal_first</alternativename>
<shortname>Postnatal first attendances</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>74</id>
<uuid />
<name>PostOp_Wound_Infections</name>
<alternativename>postop_wound_infections</alternativename>
<shortname>PostOp_Wound_Infections</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>75</id>
<uuid />
<name>Tetanus Toxoid 2nd or booster dose to pregnant woman</name>
<alternativename>pregnancies_tt</alternativename>
<shortname>Tetanus Toxoid 2nd or booster dose to pregnant wo</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>76</id>
<uuid />
<name>Water samples taken</name>
<alternativename>samp_water</alternativename>
<shortname>Water samples taken</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>77</id>
<uuid />
<name>Still births</name>
<alternativename>still_births</alternativename>
<shortname>Still births</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>78</id>
<uuid />
<name>Supervisory_Visits</name>
<alternativename>supervisory_visits</alternativename>
<shortname>Supervisory_Visits</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>79</id>
<uuid />
<name>Salt samples tested with adequate iodine</name>
<alternativename>test_iodine</alternativename>
<shortname>Salt samples tested with adequate iodine</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>80</id>
<uuid />
<name>TBAs_Active</name>
<alternativename>ttbas_active</alternativename>
<shortname>TBAs_Active</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>81</id>
<uuid />
<name>Delivery by a trained traditional birth attendant</name>
<alternativename>ttbas_deliveries</alternativename>
<shortname>Delivery by a trained traditional birth attendant</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>82</id>
<uuid />
<name>Child &lt;5 years weighed total</name>
<alternativename>weighed_under5</alternativename>
<shortname>Child &lt;5 years weighed total</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>70</id>
<uuid />
<name>OPD First Attendances Over 5</name>
<alternativename>opd_first_o5</alternativename>
<shortname>OPD First Attendances Over 5</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
<dataElement>
<id>71</id>
<uuid />
<name>OPD First Attendances Under 5</name>
<alternativename>opd_first_u5</alternativename>
<shortname>OPD First Attendances Under 5</shortname>
<code /> 
<description />
<active>true</active> 
<type>int</type> 
<aggregationOperator>sum</aggregationOperator> 
<categoryCombo>10</categoryCombo> 
<lastUpdated>2010-11-05</lastUpdated> 
</dataElement>
</dataElements>
</dxf>

Follow ups

Re: Importing data elements via DXF--problems with Shortname
From: Jason Pickering, 2010-12-27