dhis2-devs team mailing list archive

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

Not sure. Hard to say without the full stack trace of the entire process
whether this is a bug, but there are problems with the file I think.

1) All "NULLS" should be blanks instead.
2) Your timestamp is not in the correct format. You need dashes and not
slashes (I think).
3)  Everything should be double-quoted
4) "FALSE" should be lower case.

e.g from the manual.
"dataelelement","period","orgunit","categoryoptioncombo","value","storedby","timestamp","comment","followup"
"DUSpd8Jq3M7","201202","gP6hn503KUX","Prlt0C1RF0s","7","bombali","2010-04-17",,"false"I
would reformat the file, and try again. It looks like the error logging
could be improved.

Regards,

Jason








On Wed, Sep 11, 2013 at 9:05 PM, Tawanda Clement Murambi <
murambitc@xxxxxxxxx> wrote:

> Hi jason
>
> I forgot to say that I have 3 levels of organisational units..facility ,
> district and national level. The form giving me trouble is attached to
> the districts.
>
>
> ________________________________
>  From: jason.p.pickering <1222904@xxxxxxxxxxxxxxxxxx>
> To: murambitc@xxxxxxxxx
> Sent: Tuesday, September 10, 2013 12:58 PM
> Subject: Re: [Dhis2-devs] [Bug 1222904] [NEW] Import data fromExcel not
> showing in DHIS 2.0
>
>
> Can you give a bit more clarity (perhaps with an example) of what you Excel
> file looks like?
>
> In general, DHIS2 cannot import Excel directly but rather CSV files. The
> format is described in detail here.
> <http://www.dhis2.org/doc/snapshot/en/user/html/ch19s03.html>
>
> Regards,
> Jason
>
>
> On Mon, Sep 9, 2013 at 10:41 PM, Tawanda Clement Murambi <
> murambitc@xxxxxxxxx> wrote:
>
> > Public bug reported:
> >
> > I have lot of data in excel. I want to upload the data in dhis 2.0. I
> > have defined organisation units as well as data elements and data sets.
> > I have tried to use the import-export module in DHIS 2.0 to upload the
> > data. The system says import complete and lists the number of records
> > imported. But when I go to the dataset to view the data, there is
> > nothing.
> >
> > What could be the problem.
> >
> > ** Affects: dhis2
> >      Importance: Undecided
> >          Status: New
> >
> > --
> > You received this bug notification because you are a member of DHIS 2
> > developers, which is subscribed to DHIS.
> > https://bugs.launchpad.net/bugs/1222904
> >
> > Title:
> >   Import data fromExcel not showing in DHIS 2.0
> >
> > Status in DHIS 2:
> >   New
> >
> > Bug description:
> >   I have lot of data in excel. I want to upload the data in dhis 2.0. I
> >   have defined organisation units as well as data elements and data
> >   sets. I have tried to use the import-export module in DHIS 2.0 to
> >   upload the data. The system says import complete and lists the number
> >   of records imported. But when I go to the dataset to view the data,
> >   there is nothing.
> >
> >   What could be the problem.
> >
> > To manage notifications about this bug go to:
> > https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions
> >
> > _______________________________________________
> > 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
> >
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1222904
>
> Title:
>   Import data fromExcel not showing in DHIS 2.0
>
> Status in DHIS 2:
>   New
>
> Bug description:
>   I have lot of data in excel. I want to upload the data in dhis 2.0. I
>   have defined organisation units as well as data elements and data
>   sets. I have tried to use the import-export module in DHIS 2.0 to
>   upload the data. The system says import complete and lists the number
>   of records imported. But when I go to the dataset to view the data,
>   there is nothing.
>
>   What could be the problem.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions
>
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1222904
>
> Title:
>   Import data fromExcel not showing in DHIS 2.0
>
> Status in DHIS 2:
>   New
>
> Bug description:
>   I have lot of data in excel. I want to upload the data in dhis 2.0. I
>   have defined organisation units as well as data elements and data
>   sets. I have tried to use the import-export module in DHIS 2.0 to
>   upload the data. The system says import complete and lists the number
>   of records imported. But when I go to the dataset to view the data,
>   there is nothing.
>
>   What could be the problem.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1222904/+subscriptions
>
> _______________________________________________
> 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
>