dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Germine,
This can be done either with XML or SQL. From the documents, you can see
how it can be done with XML during the import process.

<dataValueSet xmlns="http://dhis2.org/schema/dxf/2.0"; dataSet="pBOMPrpg1QX"
  completeDate="2012-02-03" period="201201" orgUnit="DiszpKrYNg8">
  <dataValue dataElement="f7n9E0hX8qk" value="12"/>
  <dataValue dataElement="Ix2HsbDMLea" value="14"/>
  <dataValue dataElement="eY5ehpbEsB7" value="16"/>
</dataValueSet>

If you want to do it with SQL, you will need to look at the
"completedatasetregistration" table. Be sure all the fields are present, in
spite of the schema not requiring the date (which is a timestamp) and the
"storedby" attribute, which should be a username.

Regards,
Jason




On Wed, Jan 15, 2014 at 10:45 PM, Seide, Germine <GSeide@xxxxxxxxxxxxxxxx>wrote:

>  Good Morning All,
>
> I am dealing with a big issue on DHIS 2.
>
> I have done a data import from another program to DHIS2 by using XML. All
> data displayed pretty well in data entry forms but the forms are not
> complete. Is there any way I can mark as complete after importing data from
> XML file all the data entry forms for all the facilities  at the same? Do
> anyone  has done that with a SQL query directly in the database. If yes can
> you please provide us some assistance. We have data from 2006 to 2012.
>
> Regards,
>
>
>
>
>
> *Germine SEIDE, M. Sc. A. *
>
> *HMIS Advisor*
>
> *Futures Group International*
>
> 125, Rue Faubert, Pétion-Ville
>
> HT6140, Haiti
>
> Cell : (509) 4408-1567
>
> Off : (509) 2816-1434/ Skype ID : imergen
>
> Email : *GSeide@xxxxxxxxxxxxxxxx <GSeide@xxxxxxxxxxxxxxxx> *
>
> website : www.futuresgroup.com
>
> One Thomas Circle NW Suite 200 Washington DC 20005 USA
>
>
>
> Insight for a better world
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>