the date problem happenns the same day
···
On 9/5/12, opendatakit@googlegroups.com wrote: > ============================================================================= > Today's Topic Summary > ============================================================================= > > Group: opendatakit@googlegroups.com > Url: http://groups.google.com/group/opendatakit/topics > > - Understanding the "Select Multiple" CSV output [5 Updates] > http://groups.google.com/group/opendatakit/t/d188975e6e39d4cf > - Android Virtual Device - How to install Collect [2 Updates] > http://groups.google.com/group/opendatakit/t/56c67b3e26f76539 > - can't login to aggregate server - AppEngine Application Problem [4 > Updates] > http://groups.google.com/group/opendatakit/t/186f9e2c4e2c73d1 > - signature field crashing ODK [1 Update] > http://groups.google.com/group/opendatakit/t/5c1dad440cb15938 > - xpath evaluation: type mismatch nodeset [1 Update] > http://groups.google.com/group/opendatakit/t/48fb8faeb39d027a > - Date [2 Updates] > http://groups.google.com/group/opendatakit/t/d74ab4d169f25d9a > > > ============================================================================= > Topic: Understanding the "Select Multiple" CSV output > Url: http://groups.google.com/group/opendatakit/t/d188975e6e39d4cf > ============================================================================= > > ---------- 1 of 5 ---------- > From: Curtis Broderick > Date: Sep 04 01:37PM -0700 > Url: http://groups.google.com/group/opendatakit/msg/167e58bd99b20b06 > > I am very interested to understand why the "Select Multiple", as made with > ODK Build stores the results of the data as it does (space separated). > Never seen space separated before. It seems very natural that a variable > with say four options, each of which is checked/not checked, should be > expanded into four separate boolean variables. The output on the CSV from > aggregate is horrible to deal with. I am guessing this was discussed at > some point, but I don't understand the tradeoffs. It seems to me if you > have a variable "shower", and you ask someone to check the days of the week > > they take a shower, that instead of getting a return value of "1 3 5 6" > (each day of the week's value being 1 to 7), it makes more sense to create > 7 variables, "shower[0], shower[1]... ", etc. with values true or false. > This would at least make the csv output usable. Thanks for helping me to > understand this choice. > PS. Let the record reflect that this is not necessarily my shower schedule > ; ) > > > ---------- 2 of 5 ---------- > From: "W. Brunette" > Date: Sep 04 01:53PM -0700 > Url: http://groups.google.com/group/opendatakit/msg/2edc03a7e30190e8 > > It's a OpenRosa/JavaRosa decision so you should ask that list. Since ODK > tools are built on top of the JavaRosa core and follow the OpenRosa > standard ODK tools simply follow the specification. > > Quoting Mitch on a previous thread: > "If you have a multi-select with 30 choices, would you want a spreadsheet > to be generated with 30 column headings for this one multi-select, and a > "X" under the columns with matching values? What if there are 50 > choices? What if the number of choices is unlimited (this is possible > with itemsets drawing their choices from an external database)? At some > point, it makes more sense to produce a spreadsheet with just "N" columns > for a given multi-select (1st choice, 2nd choice, ...), and show up to N > choices for that multiselect (but which N do you show?)." > > Waylon > > On Tue, Sep 4, 2012 at 1:37 PM, Curtis Broderick > > > ---------- 3 of 5 ---------- > From: Curtis Broderick > Date: Sep 04 11:25PM +0200 > Url: http://groups.google.com/group/opendatakit/msg/d60013c3f9975863 > > Thanks for the quick reply Waylon. I really did search the forum for this > subject, honest. I am not sure I understand Mitch's response. He suggests a > separate csv for the one 40 choice variable aside from the main form's csv? > That sounds pretty reasonable. I know computer science people like the > "need to take into account all situations", but the nature of a multichoice > is by definition a finite set, so unlimited seems a bit far fetched. As for > 40 for 50 possible responses, that sounds pretty crazy. The selections are > captured for the goal of being analysed, no? If someone thinks it is that > important to have 50 possible check responses to a given question, OK, > maybe "Which countries have you visited?" (with 50 possible check boxes) > then it does not seem unreasonable to me that he/she ends up with 50 > columns. How can you ask the average person to use Excel to parse space > separated data to give you a simple count? OK, this still does not change > javarosa. > Curtis > > 2012/9/4 W. Brunette > >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en > > -- > > *Curtis BRODERICK* > Head of training and user support > Tél : + 33(0)1.53.02.40.61 06.15.33.57.37 > > ---------------------------EpiConcept--------------------------- > Systèmes d'Information en Santé > Health Information System > 47, rue de Charenton - 75012 PARIS > Tel : +33 (0)1 53 02 40 60 Fax : +33 (0)1 53 02 40 62 > -----------------------www.epiconcept.fr------------------------ > > Ce message et toutes les pièces jointes sont établis à l'intention > exclusive de ses destinataires et sont confidentiels. > Si vous recevez ce message par erreur, merci de le détruire et d'en > avertir l'expéditeur. > > The information contained in the Email and any attachments is > confidential and intended solely and for the attention and use of the > named address(es). It may not be disclosed to any other person without > the express authority of EpiConcept, or the intended recipient, or > both. > If you are not the intended recipient, you must not disclose, copy, > distribute or retain this message or any part of it. > > > ---------- 4 of 5 ---------- > From: Yaw Anokwa > Date: Sep 04 02:37PM -0700 > Url: http://groups.google.com/group/opendatakit/msg/42055a3e978285fe > > Hey Curtis, > > An auto-complete widget (which builds on selects) with a list of > animals or diseases could easily take hundreds of options. Anyway, the > reason it's done this way is because this is the XForms spec and I > doubt the JavaROSA community is going to change it. > > A better option is to change how Aggregate generates the CSV (file a > bug or submit a patch), or write a script to change that output to > something that is easier to analyze. I think the Kobo > (http://koboproject.org) team has done the latter so might be a good > place to start looking. > > Yaw > > On Tue, Sep 4, 2012 at 2:25 PM, Curtis Broderick > > > ---------- 5 of 5 ---------- > From: Gaetano Borriello > Date: Sep 04 04:40PM -0700 > Url: http://groups.google.com/group/opendatakit/msg/dfae23a854f5bcbf > > Or you can add the following to your Excel file: > > =IFERROR(FIND("mutli-select-value", A1), 0) > Put this is in a parallel column to your multi-select. The A1 would point > to the cell in the same row under the multi-select column. The formula > above will evaluate to a 0 or 1 depending on whether the multi-select-value > appears in that cell - you need the IFERROR because FIND returns an error > code if the string is not found. You should also make sure none of your > multi-select values are substrings of each other for this to work properly. > It should work fine with your examples of numbers. > > You can then count the number of occurrences at the bottom of the column > using "COUNT(B1:Bn)" to sum up all the ones. > > Given the number of ways different people would want to do this, it is > better to customize in Excel or wherever you take you .csv file. Aggregate > was designed to be minimal functionality. > > Gaetano > > > > > > > > ============================================================================= > Topic: Android Virtual Device - How to install Collect > Url: http://groups.google.com/group/opendatakit/t/56c67b3e26f76539 > ============================================================================= > > ---------- 1 of 2 ---------- > From: Mitch S > Date: Sep 04 10:11AM -0700 > Url: http://groups.google.com/group/opendatakit/msg/7011f6e4611e8b8c > > Download the .apk file(s) to your PC. > > adb install yourapp.apk > > (adb is in the platform-tools directory of the SDK). > > Mitch > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitchellsundt@gmail.com > > > ---------- 2 of 2 ---------- > From: Curtis Broderick > Date: Sep 04 11:54PM +0200 > Url: http://groups.google.com/group/opendatakit/msg/a801bf6c5463e5b7 > > Mitch, thanks. Worked like a charm. > Curtis > > 2012/9/4 Mitch S > >> Post: opendatakit@googlegroups.com >> Unsubscribe: opendatakit+unsubscribe@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en > > -- > > *Curtis BRODERICK* > Head of training and user support > Tél : + 33(0)1.53.02.40.61 06.15.33.57.37 > > ---------------------------EpiConcept--------------------------- > Systèmes d'Information en Santé > Health Information System > 47, rue de Charenton - 75012 PARIS > Tel : +33 (0)1 53 02 40 60 Fax : +33 (0)1 53 02 40 62 > -----------------------www.epiconcept.fr------------------------ > > Ce message et toutes les pièces jointes sont établis à l'intention > exclusive de ses destinataires et sont confidentiels. > Si vous recevez ce message par erreur, merci de le détruire et d'en > avertir l'expéditeur. > > The information contained in the Email and any attachments is > confidential and intended solely and for the attention and use of the > named address(es). It may not be disclosed to any other person without > the express authority of EpiConcept, or the intended recipient, or > both. > If you are not the intended recipient, you must not disclose, copy, > distribute or retain this message or any part of it. > > > > ============================================================================= > Topic: can't login to aggregate server - AppEngine Application Problem > Url: http://groups.google.com/group/opendatakit/t/186f9e2c4e2c73d1 > ============================================================================= > > ---------- 1 of 4 ---------- > From: abie > Date: Sep 04 06:01AM -0700 > Url: http://groups.google.com/group/opendatakit/msg/7d7cd3150e027d8b > > On Friday, August 31, 2012 4:03:02 PM UTC-4, abie wrote: > > > ---------- 2 of 4 ---------- > From: abie > Date: Sep 04 06:17AM -0700 > Url: http://groups.google.com/group/opendatakit/msg/890d24fb4eb57de3 > > Mitch, > > Just as a follow up on further attempts to log in to the aggregate server > thismorning - I tried (multiple times) logging into the aggregateserver I > > set up in the google app engine and had the same problemsas posted > earlier. I noticed that the log files for the attempts that didntwork had > errors (one critical) and warnings toward the bottom and they ended ina > similar way - but I am not sure how to decipher the errors to determine > ifthey may be > related and or explain the cause of the problem > > I have pasted that last few lines of one of the login attempts below - > > I guess I am wondering if this provides any additional valuable > information. > > Thanks for any insights you might have on this > > Abie > > I 2012-09-04 05:22:13.002 > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry > destroySingletons: Destroying singletons in > org.springframework.beans.factory.s > E 2012-09-04 05:22:13.030 org.springframework.web.context.ContextLoader > > initWebApplicationContext: Context initialization failed > org.springframework.beans.factory.BeanCreationE > E 2012-09-04 05:22:13.030 at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry > > > W 2012-09-04 05:22:13.035 Failed startup of context > com.google.apphosting.utils.jetty.RuntimeAppEngineWebAppContext@189c12a{/,/base/data/home/apps/s~westatodk/1.360458340633350 > > > W 2012-09-04 05:22:13.035 at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry > > > W 2012-09-04 05:22:13.037 Nested in > org.springframework.beans.factory.BeanCreationException: Error creating > > bean with name 'serverSpringSecurityFilterChain' defined in ServletC > C 2012-09-04 05:22:13.045 Uncaught exception from servlet > javax.servlet.UnavailableException: Initialization failed. at > com.google.apphosting.runtime.jetty.AppVersionHandlerMa > I 2012-09-04 05:22:13.057 This request caused a new process to be > started for your application, and thus caused your application code to > be loaded for the first time. This requ > W 2012-09-04 05:22:13.057 A problem was encountered with the process > that handled this request, causing it to exit. This is likely to cause > a new proces > > > On Tuesday, September 4, 2012 9:01:44 AM UTC-4, abie wrote: > > > > ---------- 3 of 4 ---------- > From: Mitch S > Date: Sep 04 12:28PM -0700 > Url: http://groups.google.com/group/opendatakit/msg/6dddbb03a900974f > > There are a number of problem reports from other AppSpot users with issues > related to what you have experienced over the last few days: > > http://code.google.com/p/googleappengine/issues/detail?id=7982 > > http://code.google.com/p/googleappengine/issues/detail?id=8004 > > Furthermore, checking our logs, http://opendatakit.appspot.com has also > experienced errors like you have seen on: > August 28, between 18:20 and 18:50, and > August 23rd, between 03:10 and 04:10 > > During those times, what had been a typical website start-up time of 25 > seconds grew to exceed the 60-second maximum request processing time, > causing AppEngine to fail your login attempts with a 500 error, which is > interpreted as an out-of-quota error. > > E.g., at the bottom of each request error log on your appspot instance, I'm > seeing: > > Caused by: com.google.apphosting.api.DeadlineExceededException: This > request (5f1faef6221eac12) started at 2012/09/04 12:21:13.399 UTC and > was still executing at 2012/09/04 12:22:12.862 UTC. > at > com.google.appengine.runtime.Request.process-5f1faef6221eac12(Request.java) > at java.util.zip.ZipFile.read(Native Method) > at java.util.zip.ZipFile.access$1200(ZipFile.java:57) > at java.util.zip.ZipFile$ZipFileInputStream.read(ZipFile.java:476) > at java.util.zip.ZipFile$1.fill(ZipFile.java:259) > at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158) > at sun.misc.Resource.getBytes(Resource.java:124) > at java.net.URLClassLoader.defineClass(URLClassLoader.java:273) > at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:616) > at java.lang.ClassLoader.loadClass(ClassLoader.java:266) > at > org.codehaus.jackson.map.deser.StdDeserializerProvider.(StdDeserializerProvider.java:84) > at org.codehaus.jackson.map.ObjectMapper.(ObjectMapper.java:396) > at org.codehaus.jackson.map.ObjectMapper.(ObjectMapper.java:356) > at org.codehaus.jackson.map.ObjectMapper.(ObjectMapper.java:326) > at > org.opendatakit.common.security.spring.Oauth2ResourceFilter.(Oauth2ResourceFilter.java:88) > > > You can create a New Issue here: > http://code.google.com/p/googleappengine/issues/list to report this. This > should use the "Production Issue" template. Be sure to verify that you are > having repeated failures in a narrow interval of time and that all the > failures are due to "DeadlineExceeededException" The appspot system may > occasionally be sluggish -- this is only an issue that they will look at if > it is repeatedly sluggish. Don't expect immediate or rapid response. > > Mitch > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitchellsundt@gmail.com > > > ---------- 4 of 4 ---------- > From: abie > Date: Sep 04 02:36PM -0700 > Url: http://groups.google.com/group/opendatakit/msg/608e74a188e9a43d > > Mitch, > > Thanks for looking into this - for the past 2 hours this appears to be > working reliably. I will wait to see how tomorrow goes and if it appears as > > though there is a problem will post an issue on the app engine issue list. > > Thanks again for looking a this. > > Abie > > On Tuesday, September 4, 2012 3:28:34 PM UTC-4, Mitch wrote: > > > > ============================================================================= > Topic: signature field crashing ODK > Url: http://groups.google.com/group/opendatakit/t/5c1dad440cb15938 > ============================================================================= > > ---------- 1 of 1 ---------- > From: Mitch S > Date: Sep 04 10:27AM -0700 > Url: http://groups.google.com/group/opendatakit/msg/8aec4a5a891ab82b > > Please capture the error log produced when the signature widget dies and > create an issue: > http://code.google.com/p/opendatakit/wiki/CollectTroubleshooting > > Mitch > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitchellsundt@gmail.com > > > > ============================================================================= > Topic: xpath evaluation: type mismatch nodeset > Url: http://groups.google.com/group/opendatakit/t/48fb8faeb39d027a > ============================================================================= > > ---------- 1 of 1 ---------- > From: Mitch S > Date: Sep 04 10:22AM -0700 > Url: http://groups.google.com/group/opendatakit/msg/ff0f9bd7d175fceb > > It is actually in a private e-mail thread. Synopsis: > > I have created a form, attached, that uses a data instance('choices') to > present 3 cascading select lists. > > It is complicated by repeat groups. The last select needs to filter the > selection itemset by the value of its enclosing repeat group. > > Note that the XPath expression I've used in the innermost question may be > overly complex. I am not an XPath expert and went through a half-dozen > expressions before coming up with this one. > > PROBLEM: I believe the XPathNodeset and/or TreeReference in an XPath > expression are being prematurely resolved to an IAnswerData value. > > If I write: > > /form/path/element[self::node()=.] > > I expect that 'self::node()' would resolve to an XPath node > (TreeReference), and '.' would resolve to an XPath node (TreeReference), > and that the '=' would test for equality of the two underlying FormIndex > structures. I.e., it wouldn't test for data value equality, but for a > matching element in the DOM. At it is, these appear to resolve down to > their values(??) and those are compared. > > I think: > > /form/path/element[self::text()=.] > > would test for equality between the IAnswerData in the element and the > IAnswerData of the current node within the form (granted, you wouldn't > write it this way, but I wanted a parallel construction [NOTE: ::text() is > not supported by the JR parser]). > > --------------------- > Mitch > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitchellsundt@gmail.com > > > > ============================================================================= > Topic: Date > Url: http://groups.google.com/group/opendatakit/t/d74ab4d169f25d9a > ============================================================================= > > ---------- 1 of 2 ---------- > From: Ken Mwai > Date: Sep 04 12:25PM +0300 > Url: http://groups.google.com/group/opendatakit/msg/cb3200a8b5f112c8 > > Hi All; > I am collecting data using a date variable and if i edit the data and swipe > back the forth the date variable it reduces the date by 1. What could be > the problem? > > -- > *Thanks* > *Ken Mwai * > www.ken.talantabits.com > *****"Technology is a lyfstyle live it"* > > > ---------- 2 of 2 ---------- > From: Roxroy Bollers > Date: Sep 04 05:59AM -0400 > Url: http://groups.google.com/group/opendatakit/msg/68e0882ec235e3ff > > Ken: > Confirm you are saying that this happens on the same day? I notice that if > I edit the form another day after initial collection. > > Sent from my iPhone > > On Sep 4, 2012, at 5:25 AM, Ken Mwai wrote: > > Hi All; > I am collecting data using a date variable and if i edit the data and swipe > back the forth the date variable it reduces the date by 1. What could be > the problem? > > -- > *Thanks* > *Ken Mwai * > www.ken.talantabits.com > *****"Technology is a lyfstyle live it"* > > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > > > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en >--
Thanks
*Ken Mwai *
www.ken.talantabits.com
****"Technology is a lyfstyle live it"