Aggregate 1.0 Alpha 4 downloads now available

The Alpha 4 release of Aggregate 1.0 is available on our downloads page (
http://code.google.com/p/opendatakit/downloads/ ) .

There are 2 downloads this week:
(1) Windows Installer for Tomcat 6 + MySQL
(2) Google AppEngine uploader

"Alpha" releases are not code complete. DO NOT USE THIS FOR PRODUCTION.

*Kick the tires, help us by testing and stressing it, and let us know what
you find broken.

··· * We are asking that people kick the tires and test out Aggregate-1.0 alpha 4 and file an issue about any problems they find. While we will be testing the software we won't be able to test every use case so we are asking developers to help us out and act as a tester and find what isn't working for their specific use case. The issues website can be found at http://code.google.com/p/opendatakit/issues/list.

It's only through our customers suggestions that this project gets
better so please test this trial version out and file an issue about
things you don't like.

Divergences from Aggregate 0.9.x:

  • stricter requirements on form ids defined using "xmlns" to conform to
    URN format (e.g., "http://your.domain.org/formId"). If you get an error
    complaining about the form id, change to use id="yourFormId" instead of
    xmlns="yourFormId"
  • stricter requirements for typing of the data fields. All data fields
    are now strongly typed. If a field is not typed (via ), the form will not load. The eIMCI form, for example, needed
    several dozen type declarations added before it could be uploaded to the
    server.

Features in Alpha 4:

  • now using Spring Framework Security for all authentication
  • plumbed for authorization and access control
  • working Postgresql codepaths
  • draft windows installer for Tomcat 6 & MySql

Todo:

  • briefcase applet and csvFragment web page
  • web pages for authorization and access control management
  • finalize multipart submission treatment (OpenRosa std)
  • finalize xformsList and xformsManifest formatting (OpenRosa std)
  • upload submission applet
  • repair broken publishing of xforms from ODK Build (broken this release)
  • installer for Postgresql

--
Mitch Sundt
Software Engineer

University of Washington
mitchellsundt@gmail.com

The Windows Tomcat & MySQL installer has two issues that prevent the
resulting installation from functioning. To remedy these, after the
install,

(1) Choose: Start / All Programs / ODK Aggregate / Stop Servers

(2) Issue #1: the install is missing the MySQL Connector/J jar file
(mysql-connector-java-5.1.14-bin Executable JAR File) in the C:\Program
Files\ODK Aggregate\apache-tomcat-6.0.26\lib directory. You will need to
download the zip containing that jar file from the MySQL website (
http://www.mysql.com/downloads/connector/j/ ) and copy the jar file (not the
zip) in C:\Program Files\ODK Aggregate\apache-tomcat-6.0.26\lib

(3) Issue #2: the MySql database is not fully configured. To configure it,
assuming the default install:
(a) save the attached file to C:\Program Files\ODK Aggregate\mysql-init.txt
(b) open a command window ( Start / Run... "cmd" ).
(c) in that window, execute:

"C:\Program Files\ODK Aggregate\mysql-5.1.40-win32\bin\mysqld"
--defaults-file="C:\Program Files\ODK Aggregate\mysql-5.1.40-win32\my.ini"
--skip-grant-tables --init-file="C:\Program Files\ODK
Aggregate\mysql-init.txt"

Be sure there are no extra spaces adjacent to the ='s. This command should
keep running (you're starting the database at the command line). If it
returns, there was a problem with the command. To diagnose, see the ERR
file in C:\Program Files\ODK Aggregate\mysql-5.1.40-win32\data\

(d) open a second command window ( Start / Run ... "cmd" )
(e) in that window, execute:

"C:\Program Files\ODK Aggregate\mysql-5.1.40-win32\bin\mysqladmin.exe" -u
root -p shutdown

And, when prompted for the root password, enter "odk_test" (without the
double-quotes).

This command directs the server you started in the first cmd window to
shutdown.

(4) close both cmd windows.
(5) Start / Programs / ODK Aggregate / Start Servers

Now, open a browser to localhost. The website should now display.

This install can construct improper URLs in published results to Fusion
tables and Google spreadsheets. That, and the above two issues will be
addressed in the next installer.

Mitch

mysql-init.txt (263 Bytes)

··· On Thu, Dec 23, 2010 at 3:17 PM, Mitch Sundt wrote:

The Alpha 4 release of Aggregate 1.0 is available on our downloads page (
http://code.google.com/p/opendatakit/downloads/ ) .

There are 2 downloads this week:
(1) Windows Installer for Tomcat 6 + MySQL
(2) Google AppEngine uploader

"Alpha" releases are not code complete. DO NOT USE THIS FOR PRODUCTION.

*Kick the tires, help us by testing and stressing it, and let us know what
you find broken.
*
We are asking that people kick the tires and test out Aggregate-1.0
alpha 4 and file an issue about any problems they find. While we will
be testing the software we won't be able to test every use case so we
are asking developers to help us out and act as a tester and find what
isn't working for their specific use case. The issues website can be
found at http://code.google.com/p/opendatakit/issues/list.

It's only through our customers suggestions that this project gets
better so please test this trial version out and file an issue about
things you don't like.

Divergences from Aggregate 0.9.x:

  • stricter requirements on form ids defined using "xmlns" to conform to
    URN format (e.g., "http://your.domain.org/formId"). If you get an
    error complaining about the form id, change to use id="yourFormId" instead
    of xmlns="yourFormId"
  • stricter requirements for typing of the data fields. All data fields
    are now strongly typed. If a field is not typed (via ), the form will not load. The eIMCI form, for example, needed
    several dozen type declarations added before it could be uploaded to
    the server.

Features in Alpha 4:

  • now using Spring Framework Security for all authentication
  • plumbed for authorization and access control
  • working Postgresql codepaths
  • draft windows installer for Tomcat 6 & MySql

Todo:

  • briefcase applet and csvFragment web page
  • web pages for authorization and access control management
  • finalize multipart submission treatment (OpenRosa std)
  • finalize xformsList and xformsManifest formatting (OpenRosa std)
  • upload submission applet
  • repair broken publishing of xforms from ODK Build (broken this
    release)
  • installer for Postgresql

--
Mitch Sundt
Software Engineer
http://www.OpenDataKit.org
University of Washington
mitchellsundt@gmail.com

--
Mitch Sundt
Software Engineer

University of Washington
mitchellsundt@gmail.com