dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Hi Ola

Jørn sent some excel sheets from Gambia which I have been looking at
importing.  My strategy is to convert to xlsx (for which purpose I needed to
borrow my wife's computer 'cos I don't have excel).

Then we have the excel data as an xml stream (actually a few streams) which
I translate to dxf and import in the normal way as dxf.  Much as I did with
the IMR MDG indicators.  In principle any input source which is xml based,
including sdmx, dhis1.4 etc can all be treated the same way and thus take
advantage of shared functionality of dxf import eg. preview.

Hoping to be able to demo all this in Geneva.  Currently there are a few
dependencies which need to be lined up.  With all the amazing work Lars has
been doing on the dimension model there's quite a bit of resulttng work we
need to do on dxf to catch up on the improved model.

I'll do one of the Gambia sheets using the existing dxf and existing model
as a proff of concept.

Regards
Bob

2009/10/21 Ola Hodne Titlestad <olatitle@xxxxxxxxx>

> In a bit longer perspective it would be great if we could include a
> mainstream excel import as part of the import service. We've discussed this
> before. There is a great need for this and we already have a blueprint if I
> remember correctly. The idea was to have predefined (generated by DHIS)
> excel sheets with metadata that could easily be imported into DHIS. Preview
> and other import  functionality is needed here in the same way as with DXF
> import. Hopefully efforts and local modules from India and Vietnam can merge
> into this over time.
>
> Ola
> ----------
>
> 2009/10/21 Lars Helge Øverland <larshelge@xxxxxxxxx>
>
>>
>>
>> 2009/10/21 Thuy Nguyen <thuy.hispvietnam@xxxxxxxxx>
>>
>>> Hi Lars,
>>> Today the team has discussed and found that there is problem in importing
>>> excel function. We also have the solution to fix it. But it need to be
>>> approved by you, so that we will work and commit it. Please find enclosed
>>> the blue print has been created below and give us suggestion.
>>>
>>> https://blueprints.launchpad.net/dhis2/+spec/import-data-from-excel-file-to-dhis
>>>
>>>
>>> --
>>>
>>
>>
>> Hi Thuy,
>>
>> as far as I understand from the blueprint it seems this function will be
>> pretty different from the existing import code... So rather than squeezing
>> that code into the importexport module I suggest you simply put it inside
>> the excel reporting service for now. The user can then deal with excel
>> reporting and importing in the same module (the excel reporting web module).
>> Is that okay with you?
>>
>> Lars
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>