← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Store external spreadheet-like data in DHIS2

 

If however you want to use the analytical output and visualization in
DHIS2, there is now an app available that allows you to map the spreadsheet
to data elements, periods and orgunits in DHIS2 - in other words, there is
a way to import from Excel provided it the structure is relatively
straightforward and mappable. But you will first have to make sure all the
metadata is in DHIS2 or if not, create them.

Knut

On Mon, Jul 25, 2016 at 10:23 PM, Raminosoa Rabemanantsoa, Tantely <
traminosoa@xxxxxxxxxx> wrote:

> Hi Jason,
>
> Thank you for your suggestions. This is helpful.
>
> Regards
>
> Tantely
>
> Le 25 juil. 2016 18:34, "Jason Pickering" <jason.p.pickering@xxxxxxxxx> a
> écrit :
>
> Hi Tantely,
>
> Please have a look here
> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s12.html
>
> for how DHIS2 can be used to store file resources.
>
> Data stored there however will not be available for visualization or other
> analytics.
>
> Regards,
> Jason
>
>
> On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely <
> traminosoa@xxxxxxxxxx> wrote:
>
>> Dear Community,
>>
>> I would like to use DHIS2, in addition to its classic uses (data capture,
>> data analysis and reporting,...), to store a tabular data that is sourced
>> from MS Excel spreadsheet (or probably from another database) without any
>> link to organization unit, period or dataset. Would it be possible to
>> integrate this tabular data directly into a dashboard? Or should I still
>> prepare all the data elements to receive the spreadsheet cells values? Or
>> what would be the best way to use the DHIS2 database to store the
>> spreadsheet-like data? I plan to make this spreadsheet to be available in
>> DHIS2 for the users to visualize or to download.
>>
>> Your suggestions are welcome.
>>
>> Ragards,
>>
>> Tantely.
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>
>
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
>
> _______________________________________________
> 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
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org

Follow ups

References