Export function for "report" data - Deadline March 15

[patricechataigner]

in 2 weeks from now we will start implementing a new severity scoring system in the DEEP, in collaboration with OCHA, JRC, CDC, etc. For the pilot i would need to be able to export the data available in the report screen: One row= one crisis= one week, with all the data from humanitarian profile, people in need, humanitarian access etc in one row only. Is it possible to have an export of the report? no need to implement filters for the moment, just the export in excel.

[eoglethorpe]

@patricechataigner is '10 days' supposed to mean the deadline?

[patricechataigner]

Yes please, if possible for the 15 of march, that would be perfect

Patrice Chataigner Senior Analyst Email pc@acaps.orgmailto:pc@acaps.org Direct +41 22 338 15 97 Mobile + 41 792 358 174 Skype: pchataigner Website www.acaps.org

23, Avenue de France CH-1202 Geneva 5th Floor

From: Ewan Oglethorpe [mailto:notifications@github.com] Sent: Monday, March 6, 2017 11:34 AM To: eoglethorpe/deep deep@noreply.github.com Cc: Patrice Chataigner pc@acaps.org; Mention mention@noreply.github.com Subject: Re: [eoglethorpe/deep] Export function for "report" data . 10 days (#317)

@patricechataignerhttps://github.com/patricechataigner is '10 days' supposed to mean the deadline?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/eoglethorpe/deep/issues/317#issuecomment-284359934, or mute the threadhttps://github.com/notifications/unsubscribe-auth/APQWqjm_oSSUTKTNuhR5tZHh8US1-0EHks5ri-EwgaJpZM4MTZyj.

[bibekdahal]

We are confused on the format of export.

• Do you want to export all weekly reports of all crises at once or only weekly reports of selected crisis? Or do you want only the last weekly reports of all crises?

• You said that you want all data per weekly report in a single row. But this raise some issues regarding number of columns. For example: how do we handle sub-rows data in humanitarian profile tab? The same goes for key events tab as it can contain any number of events, we cannot have different column for each event.

It would be great if we can have a simple sample format for this.

Thanks in advance.

[patricechataigner]

Will prepare you this! The simplest the better for the moment, I would say one export with all crises and all weeks. Will send you a format today. Patrice

Patrice Chataigner Senior Analyst Email pc@acaps.orgmailto:pc@acaps.org Direct +41 22 338 15 97 Mobile + 41 792 358 174 Skype: pchataigner Website www.acaps.org

23, Avenue de France CH-1202 Geneva 5th Floor

From: Bibek Dahal [mailto:notifications@github.com] Sent: Tuesday, March 7, 2017 6:21 AM To: eoglethorpe/deep deep@noreply.github.com Cc: Patrice Chataigner pc@acaps.org; Mention mention@noreply.github.com Subject: Re: [eoglethorpe/deep] Export function for "report" data - Deadline March 15 (#317)

We are confused on the format of export.

· Do you want to export all weekly reports of all crises at once or only weekly reports of selected crisis? Or do you want only the last weekly reports of all crises?

· You said that you want all data per weekly report in a single row. But this raise some issues regarding number of columns. For example: how do we handle sub-rows data in humanitarian profile tab? The same goes for key events tab as it can contain any number of events, we cannot have different column for each event.

It would be great if we can have a simple sample format for this.

Thanks in advance.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/eoglethorpe/deep/issues/317#issuecomment-284624964, or mute the threadhttps://github.com/notifications/unsubscribe-auth/APQWqkIkfl7Lgt6-eILOqeOZJNwk4jkvks5rjOlEgaJpZM4MTZyj.

[bibekdahal]

While we are waiting for the format, here is a simple export of all reports (which is a lot of columns):

http://deep.togglecorp.com/1/entries/exportxls/weekly

[patricechataigner]

Well my friend you nailed it! no need for more than this, I can work with that. All my best

Shows also that analysts are not really consistent with the sourcing, will remind them… Thanks!!

Patrice Chataigner Senior Analyst Email pc@acaps.orgmailto:pc@acaps.org Direct +41 22 338 15 97 Mobile + 41 792 358 174 Skype: pchataigner Website www.acaps.org

23, Avenue de France CH-1202 Geneva 5th Floor

From: Bibek Dahal [mailto:notifications@github.com] Sent: Wednesday, March 8, 2017 6:47 AM To: eoglethorpe/deep deep@noreply.github.com Cc: Patrice Chataigner pc@acaps.org; Mention mention@noreply.github.com Subject: Re: [eoglethorpe/deep] Export function for "report" data - Deadline March 15 (#317)

While we are waiting for the format, here is a simple export of all reports (which is a lot of columns):

http://deep.togglecorp.com/1/entries/exportxls/weekly

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/eoglethorpe/deep/issues/317#issuecomment-284953222, or mute the threadhttps://github.com/notifications/unsubscribe-auth/APQWqtEnI6S0_Twl0HBfhq6GFoqUZX8Qks5rjkDUgaJpZM4MTZyj.