Wow, you've saved me like a week's worth of life! I'm having proxy issues here at work, but I'll try it when I get home. I'll try and get it to work first, then take on the connection issues.
Thanks! Tom ________________________________ From: Jason Pickering [mailto:[email protected]] Sent: 23 May 2012 12:48 To: Hiatt, Mr Tom (WPRO) Cc: [email protected]; [email protected] Subject: Re: [Dhis2-users] Connect to data Hi Tom and Lars, The following R code will retrieve the data as per Lars example, and place this into an R data frame. Maybe this will help to get you started. Best Regards, Jason library(RCurl) h = basicTextGatherer() response<-getURL("http://apps.dhis2.org/dev/api/reportTables/data.csv?de=fbfJHSPpUQD&de=cYeuwXTCPkU&in=Uvn6LCg7dVU&ou=O6uvpzGd5pu&last12Months=true ",userpwd="admin:district",httpauth = 1L, header=TRUE,headerfunction=h$update) #Ugly hack to get ride of the header stripme<-paste("HTTP/1.1 200 OK\r\n",paste(h$value(NULL)[-1], collapse=""),sep="") data<-gsub(stripme,"",response) #Unquote the data data<-noquote(data) #here is the data. foo<-read.table(textConnection(data),sep=",",header=T) On Wed, May 23, 2012 at 5:17 AM, <[email protected]<mailto:[email protected]>> wrote: Thanks, Lars. This is great and very useful! Now I just have to figure out how to have R pass those parameters to the URL and then return the CSV file into R. Thanks again, Tom ________________________________ From: Lars Helge Øverland [mailto:[email protected]<mailto:[email protected]>] Sent: 23 May 2012 06:03 To: Hiatt, Mr Tom (WPRO) Cc: [email protected]<mailto:[email protected]>; [email protected]<mailto:[email protected]> Subject: Re: [Dhis2-users] Connect to data Hi Tom, if you refer to aggregated data (from the aggregated* tables) there is a way to do this - unfortunately it is in trunk only and not documented yet - will try a quick explanation here: To get the aggregated data you can interact with the reportTables resource. First you need to look up the ids (uids) of the data elements, indicators, org units you need using the api starting here (from the snapshot demo in this example): http://apps.dhis2.org/dev/api/resources You can then retrieve the data like this : http://apps.dhis2.org/dev/api/reportTables/data.xml?de=fbfJHSPpUQD&de=cYeuwXTCPkU&in=Uvn6LCg7dVU&ou=O6uvpzGd5pu&last12Months=true You can substitute ".xml" with any of ".json", ".jsonp", ".csv", ".pdf", ".xls", ".html". You can repeat the de, in and ou query params as many times you want to get data for multiple meta-data objects. Valid params for periods are reportingMonth reportingBimonth reportingQuarter lastSixMonth monthsThisYear quartersThisYear thisYear monthsLastYear quartersLastYear lastYear last5Years last12Months last6BiMonths last4Quarters last2SixMonths thisFinancialYear lastFinancialYear last5FinancialYears last52Weeks Let me know it this helps. Lars ________________________________ This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses. Disclaimer: This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law. If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone. ==================================================== This message was scanned for viruses with Trend Micro ScanMail, GFI MailSecurity and GFI MailEssentials by the World Health Organization Regional Office for the Western Pacific. However, the recipient is advised to scan this e-mail and any attached files for viruses. Disclaimer: This e-mail, together with any attachments, is intended for the named recipients only and is confidential. It may also be privileged or otherwise protected by law. If you have received it in error, please notify the sender immediately by reply e-mail and delete it and any attachments from your system. You may not copy or disclose its contents to anyone.
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
