← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Data import to a Dataset linked to a combination of categories

 

One possible solution is to simply transform your data directly to a form
which can be imported directly into the database itself.  If you are doing
a one off or supervised data import, it should be relatively simple to
transform the data to import to SQL and inject it directly, while this
feature is implemented.

Regards,
Jason

--
Sent from my mobile
On Jul 22, 2014 10:42 AM, "Maheed Ramadan" <maheed.ramadan@xxxxxx> wrote:

>  Hello Lars,
>
>
>
> As you know, we are still investigating the DHIS system to see if we can
> use it in our organization.
>
> Actually, we started implementing a small pilot project in one country
> area and we are trying to collect the data and move it into DHIS and then
> analyze it and create some reports.
>
>
>
> A requirement in our design is to have all our datasets be linked to a
> category combination attribute which allows us to add another dimension to
> our data entry forms. The extra dimension we need to specify is the actual
> “Project” that will be linked to the data in addition to the org unit and
> period dimensions.
>
>
>
> Since we have a lot of data that we need to push into DHIS, we need a
> quick and fast solution for this and the only path we have is to import
> this data from an external source (i.e. Excel/CSV file). As you know, the
> data import tool still does not support datasets with custom category
> combination.
>
>
>
> Honestly I was following up and reviewing all recent updates to the system
> including bugs and blueprints and I was shocked when I found that this bug
> è (Import) Attribute option combos in import
> <https://blueprints.launchpad.net/dhis2/+spec/attribute-option-combos-in-import> has
> been moved/postponed to milestone 2.17 !!!
>
>
>
> For us, this is a very important & critical feature to have for the
> reasons mentioned above. Our decision to use DHIS is highly based on the
> import functionality. Not having this functionality will prevent us to move
> forward.
>
>
>
> We were hoping that this will be resolved in milestone 2.16 so waiting for
> this release was not a big deal. However, this is a problem if we have to
> wait 3-4 months until 2.17 is released.
>
>
>
> Sorry Lars for all these details. I don’t know if this issue could be
> revised from your side and be included in the upcoming release? We like the
> system and we appreciate your support with all the developers contributing
> to make it successful.
>
>
>
> As a final request, is there any possible solution that we could use to
> get data in batch into DHIS, taking into consideration the requirement we
> have? This could be a turnaround or a temporary solution until the issue is
> resolved.
>
>
>
>
>
> Thanks a lot.
>
> Hope to hear from you soon….
>
>
>
>
>
> Maheed.
>
>
>
>
>
>
>
> *From:* Lars Helge Øverland [mailto:larshelge@xxxxxxxxx]
> *Sent:* Wednesday, July 02, 2014 12:17 PM
> *To:* Maheed Ramadan
> *Cc:* dhis2-devs@xxxxxxxxxxxxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] Data import to a Dataset linked to a
> combination of categories
>
>
>
> Hi there,
>
>
>
> according to schedule we will release on July 4th. It seems that we will
> need some extra days to wrap up the last features.
>
>
>
> cheers
>
>
>
> Lars
>
>
>
>
>
>
>
> On Wed, Jul 2, 2014 at 11:13 AM, Maheed Ramadan <maheed.ramadan@xxxxxx>
> wrote:
>
>  Hello Lars,
>
>
>
> Thanks for the quick response. Hoping this issue can be resolved soon.
>
>
>
> One question please. When do you think the next version of DHIS (i.e.
> 2.16) will be released?
>
>
>
>
>
> Thanks again.
>
>
>
> Maheed
>
>
>
>
>
>
>
> *From:* Lars Helge Øverland [mailto:larshelge@xxxxxxxxx]
> *Sent:* Wednesday, July 02, 2014 11:12 AM
> *To:* Maheed Ramadan
> *Cc:* dhis2-devs@xxxxxxxxxxxxxxxxxxx; dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] Data import to a Dataset linked to a
> combination of categories
>
>
>
> HI Maheed,
>
>
>
> good spot and you are correct. We simply haven't implemented it yet due to
> time constraints. We have a blueprint for it here
> <https://blueprints.launchpad.net/dhis2/+spec/attribute-option-combos-in-import>.
> We will prioritize it and let you know when its done.
>
>
>
> regards,
>
>
>
> Lars
>
>
>
>
>
>
>
> On Wed, Jul 2, 2014 at 8:39 AM, Maheed Ramadan <maheed.ramadan@xxxxxx>
> wrote:
>
>  Dear DHIS users/developers,
>
>
>
> As you know, we have a feature in DHIS that allows a dataset to be linked
> to a “Combination of categories”.
>
> In the data entry form, these category combinations will be rendered as
> dropdown lists in addition to the Org Unit and period.
>
>
>
> These category combinations are configured as “Attributes” so they could
> be linked to the dataset in that way.
>
> This is a very good feature and works well from the web user interface
> data entry forms.
>
>
>
> However, if we want to import data using xml/csv file, this doesn’t work
> as needed. That is because the import template does not support any
> category combinations defined in the dataset. It only works if the dataset
> is configured with the “default” category combination.
>
>
>
> My question è is there any way that we can import data to this kind of
> dataset and set the values of the category combination attributes from the
> input file (xml/csv).
>
>
>
> Has anyone faced this issue and found a solution for it? If it is it a bug
> in the system, do you know if there is any plan to fix it?
>
> Awaiting your feedback please…
>
>
>
> Note that I am using the latest version of DHIS 2.15 Rev. 15181
>
>
>
>
>
> Thanks,
>
>
>
> Maheed
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> _______________________________________________
> 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
>
>

References