Thank Clint, in my case, just filter the submission date is enough, not inside the form data.
And the "hot" submissions that I need live pull to Odata Power BI is in current month, but it maybe various for others( it can be 1 week, or 2 months, etc) . So the filter should be flexible so that we can choose the best fit. Thank your team's effort to make Central better
Hi Yaw
I am not sure if I have missed it in the documentation, but I cant find instructions on how to log into the sandbox, what email and password combo is needed.
I have tried my forum ones and have t ried resetting rhe password.
Could you point me in the right direction?
Thanks,
@DavidM to use the sandbox, you have to send me a PM. See https://docs.opendatakit.org/central-install/#using-the-sandbox.
Thank you for your feedback, @Mariano_Corzo_Toscan!
We're seeing this issue as well. We've created a GitHub issue to track it here.
Could you tell us more about the date format problem that you're seeing? Would you be able to upload an example form for which you're seeing the problem?
Once a form is deleted in Central, a Collect user should not see it when they pull the list of blank forms. However, right now deleted forms are visible in the list. Is that the issue that you're seeing? We've created a GitHub issue to track the issue here.
Right now the submissions table only shows the first ten fields of the form, and it does not show repeat groups. However, that's not very clear in the user interface, and we're planning to update it to make it clearer. We're also considering ways to include more than the first ten columns. In the meantime, the full data set is available through .csv download or OData.
I only have so much experience with OpenOffice and LibreOffice, but they don't appear to have OData support. Let us know if you find a way to connect OpenOffice to OData!
Ok. I understand what happened with the submission view in Central and with the form list in Collect. Thank you very much.
In relation with the date format, I was using the form "Formulario_basico". After setting the app language to English, i filled in a form. Then I changed the app language again to Spanish. When I sent the form I got the error: "An expected header field (Date) did not match the expected format....".
Hi. I’m interested in the tying ODK central on the sandbox cloud. Could I get an invite? I’m not able to get my digital ocean to work.
Thanks
@Felix_Mutua I know you got your copy of Central working, but I'm curious what the problem was so we can maybe add it to the documentation.
Hi,
The issue was server memory- we couldn’t download the submissions until we added more RAM(we were working with DigitalOcean, 1Gb RAM)
Hey Felix: that's interesting information. How many submissions were there? How big, roughly, is the form? How many questions? What would it do instead of let you download the submissions?
Ideally, no matter how big the form is it should still be able to export the submissions, just more slowly. I'd like to fix the problems if this is not the case.
Not so many, just 46 submissions and a small form(~25 fields) but with photos and totaling to around 200mb. It would download as an empty zip file... for small forms with less than 20 submissions it was ok..
Ah, okay. The photos must have done it. Can you give me a sense of how many photos per form and how big each one roughly is? I'd like to recreate your scenario and see what's happening. Thanks for the information so far already though!
One photo per submission... using default camera settings.
Great, perfect, thanks!
Hi guys, i'm trying to install central into my local machine. I've followed the installing steps from github but when trying to run step 12; "docker-compose create" / "docker-compose up" (by the way, "create" command is now deprecated) i get the following error message:
jsparrow@BlackPearl:~/odkCentral-docker/central$ docker-compose up
central_mail_1 is up-to-date
central_postgres_1 is up-to-date
central_service_1 is up-to-date
Starting central_nginx_1 ...
Starting central_nginx_1 ... error
ERROR: for central_nginx_1 Cannot start service nginx: driver failed programming external connectivity on endpoint central_nginx_1 (3ebd42407cb0f8b92ef11c78a16bcc097db5e23a0aef5bc0aec6e6f05614e346): Error starting userland proxy: listen tcp 0.0.0.0:80: listen: address already in use
ERROR: for nginx Cannot start service nginx: driver failed programming external connectivity on endpoint central_nginx_1 (3ebd42407cb0f8b92ef11c78a16bcc097db5e23a0aef5bc0aec6e6f05614e346): Error starting userland proxy: listen tcp 0.0.0.0:80: listen: address already in use
ERROR: Encountered errors while bringing up the project.
My local machine is running under Ubuntu 16.04.
I'm not an expert in docker (a newbie, in fact) so anyone can give a hand wuth this error?
Thanks in advance.
Best regards.
El Neri (previously from Mexico, now from Guatemala) 
I think you already have something running at port 80 on your host machine! lsof -i :80 | grep LISTEN might help you find what it is. Then you can try again after terminating that application.
Thanks for the reply, and sorry for the delay.
Well i tried to find out what was runing in port 80 but i couldnt find any service...
My local machine is confiigured as LAMP server, perhaps there is something colliding around there.
I will create a VM inside my machine and retry the install Central, i will keep you posted on my results.
Best regards and thanks again, Helene!
Port 80 is the default HTTP port, ie your webserver. So if you are running a LAMP stack, I'd suggest looking at your Apache service (the 'A' of "LAMP") configuration. You can change Apache to use a different port - eg 8080 is not uncommon - but then you need to be aware that any web client (Firefox, Chrome, ...) you may now have to explicitly specify the port when accessing your web pages; eg http://www.example.com:8080
There's plenty of HOWTOs on the web for how to change the Apache port; eg https://stackoverflow.com/questions/3940909
I was testing the ODK Central API. This is the response which I get in return when I call following URL:
https://sandbox.central.opendatakit.org/v1/forms/testqr/submissions/3ad91554-720c-43ef-a382-7abaa79398e6
Returned JSON:
{"instanceId":"3ad91554-720c-43ef-a382-7abaa79398e6","xml":"30.3402146 78.0440021 0.0 25.286TtFf55uuid:0c24d8da-3639-4a98-8090-acfc2547e5a2","createdAt":"2018-10-09T09:22:09.055Z","updatedAt":null,"submitter":81}'
Only thing is that the 'xml' attribute does not contain actual XML. I was expecting same XML content which I used to get by calling aggregate API.
Is this a bug or there is some other way to parse the actual data from submissions ?
Hey Shiva:
I think you might be missing the xml because you are viewing the output in a web browser, which tries to treat those tags as HTML. When I make that same request from a command line tool, this is what I get back:
cxlt@Durindana:~$ http get https://sandbox.central.opendatakit.org/v1/forms/testqr/submissions/3ad91554-720c-43ef-a382-7abaa79398e6 'Authorization: Bearer (redacted)'
HTTP/1.1 200 OK
Connection: keep-alive
Content-Length: 614
Content-Type: application/json; charset=utf-8
Date: Tue, 09 Oct 2018 21:16:06 GMT
ETag: W/"266-LZmUnoiMVNYTmVOrmE7bejkjTag"
Server: nginx
Strict-Transport-Security: max-age=31536000
X-Content-Type-Options: nosniff
X-Powered-By: Express
{
"createdAt": "2018-10-09T09:22:09.055Z",
"instanceId": "3ad91554-720c-43ef-a382-7abaa79398e6",
"submitter": 81,
"updatedAt": null,
"xml": "<?xml version='1.0' ?><testqr id=\"testqr\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:orx=\"http://openrosa.org/xforms\" xmlns:ev=\"http://www.w3.org/2001/xml-events\" xmlns:odk=\"http://www.opendatakit.org/xforms\" xmlns:jr=\"http://openrosa.org/javarosa\" xmlns:h=\"http://www.w3.org/1999/xhtml\"><GEOMETRY>30.3402146 78.0440021 0.0 25.286</GEOMETRY><text>Tt</text><type>Ff</type><number>55</number><ODKUUID>uuid:0c24d8da-3639-4a98-8090-acfc2547e5a2</ODKUUID></testqr>"
}
I cannot establish a connection from Excel to Analyze submissions using OData. Excel says that
"The remote server returned an error: (403) Forbidden."
I'm using my email address and password I used to log into ODK Central.