aggregate Text column with unlimited length in aggregate database

Issue by atbentley Tuesday Jan 17, 2017 at 04:23 GMT Originally opened as https://github.com/opendatakit/opendatakit/issues/1265 (5 comment(s))

Hi,

It looks like creating specific length columns used to be supported, but there doesn't appear to be much documentation for how to do this using the newer app designer with formDef.json. Currently I'm only able to get column types of varchar(255), how can I get unlimited length text columns or arbitrary length text columns.

Aggregate: 1.4.12 App designer: 206b Database: postgres 9.4.4

Aug 12 '17 02:08 getodk-bot

Comment by mitchellsundt Thursday Jan 19, 2017 at 18:34 GMT

For the 2.0 tools, this requires creating a model sheet in your XLS file.

You may also need to update to ODK Aggregate v1.4.13 though string length should work prior to that release (that release is required for fully custom data types, and perhaps array storage size changes).

Attached is an exemplar form (which ONLY works on v1.4.13 because, in addition to exercising string length settings, also defines custom data types).

The way to define the column length is via the number in the ()'s under the elementType column. E.g., string(500) will declare a varchar(500) column or equivalent.

In the model sheet, the name column is the field name of the field.

'col5' is an example of increasing a string field to a longer length (you can also decrease the storage size)

'col14' is an example of increasing a select-multiple field to a longer length. This is also something to verify -- that you have enough space to store all selected choices ( the JSON serialization of all the data_value from the choice list ). Note that unbounded or very large select-multiples will eventually exceed storage capabilities. In that case, moving to a parent-child-form would be required -- like in the household / household-member form. In that implementation, the child form would have a select-one from the choice list, and hold the instance id of the parent form. The parent form then can display all choices the user has selected via the prompt types derived from linked-table linking to this child form.

'col12' and 'col1a' are examples of defining an array of integer values and an array of geopoints (e.g., for a different type of select multiple or a geoshape-like field -- no prompt type exists for these in our software, but you could create one).

On Mon, Jan 16, 2017 at 8:23 PM, Andrew Bentley [email protected] wrote:

Hi,

It looks like creating specific length columns used to be supported, but there doesn't appear to be much documentation for how to do this using the newer app designer with formDef.json. Currently I'm only able to get column types of varchar(255), how can I get unlimited length text columns or arbitrary length text columns.

Aggregate: 1.4.12 App designer: 206b Database: postgres 9.4.4

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/opendatakit/opendatakit/issues/1265, or mute the thread https://github.com/notifications/unsubscribe-auth/ACLO09t3HFheyFTVI8kADh8m3zmO1qY7ks5rTEIxgaJpZM4LlN4G .

-- Mitch Sundt Software Engineer University of Washington [email protected]

Aug 12 '17 02:08 getodk-bot

Comment by atbentley Thursday Jan 19, 2017 at 23:12 GMT

The attachment is missing

Aug 12 '17 02:08 getodk-bot

Comment by mitchellsundt Friday Jan 20, 2017 at 00:32 GMT

Must have been swallowed by antivirus software.

Here's the link to this file in the repo.

https://github.com/opendatakit/app-designer/blob/master/app/config/tables/datatypes/todo/forms/datatypes/datatypes.xlsx

Click the "Download" button to retrieve it.

On Thu, Jan 19, 2017 at 3:12 PM, Andrew Bentley [email protected] wrote:

The attachment is missing

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/opendatakit/opendatakit/issues/1265#issuecomment-273928571, or mute the thread https://github.com/notifications/unsubscribe-auth/ACLO04lP96El0ozqDHYYhUWzI_terATfks5rT-3rgaJpZM4LlN4G .

-- Mitch Sundt Software Engineer University of Washington [email protected]

Aug 12 '17 02:08 getodk-bot

Comment by atbentley Sunday Jan 22, 2017 at 22:49 GMT

Thanks Mitch, got this working now. I had to upgrade to 1.4.13 though.

Aug 12 '17 02:08 getodk-bot

Comment by mathieubossaert Friday Jun 09, 2017 at 08:08 GMT

Good morning, maybe I should create a new issue...

We are facing this problem and we "solved it" by modifying the xml (AGGREGATE 1.4.3 on PostgreSQL 9.6 and earlier version) We collect geoshape data and aggregate translate the type in a character varying(255) column. So we add a calculate hidden field named obs_coord: the string corresponding to the geoshape input value.

We need to modifiy the xml attribute for the field (odk:length="2000") and modify the header of the xml form to force aggregate to create a charactervarying(2000) column (xmlns:odk="http://www.opendatakit.org/xforms" ):

<?xml version="1.0" encoding="UTF-8"?>
<h:html xmlns:odk="http://www.opendatakit.org/xforms" xmlns="http://www.w3.org/2002/xforms" xmlns:ev="http://www.w3.org/2001/xml-events" xmlns:h="http://www.w3.org/1999/xhtml" xmlns:jr="http://openrosa.org/javarosa" xmlns:orx="http://openrosa.org/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <h:head><!-- ODK Aggregate upload time: 2017-06-07T15:59:36.305+0000 on http://localhost:8080/ODKAggregate -->
    <h:title>EXO_MOBILE_8</h:title>
    <model>
      <instance>
        <exo_mobile_8 id="exo_mobile_8" version="1">
          <releve>
            <id_etude/>
            <id_protocole/>
            <code_releve/>
          </releve>
          <saisie_observateur jr:template="">
            <saisie_structure/>
            <search_observateur/>
          </saisie_observateur>
          <saisie_date>
            <date_obs/>
            <duree_obs/>
          </saisie_date>
          <option_localisation/>
          <obs_geopoint/>
          <obs_geoshape_type>
            <obs_localisation/>
            <obs_coord/>
          </obs_geoshape_type>
          <local_rqs/>
          <saisie_observation jr:template="">
            <recherche_esp>
              <regne/>
              <searchtext_latin/>
            </recherche_esp>
            <search_nom_latin/>
            <lb_cd_nom_latin/>
            <carac_observation_flore>
              <flore_effectif/>
              <effectif_textuel/>
              <strate/>
              <phenologie/>
            </carac_observation_flore>
            <carac_observation_faune>
              <faune_effectif/>
              <age/>
              <sexe/>
            </carac_observation_faune>
            <statut_repro/>
            <remarques_obs>
              <obs_rqs/>
            </remarques_obs>
          </saisie_observation>
          <meta>
            <instanceID/>
            <instanceName/>
          </meta>
        </exo_mobile_8>
      </instance>
      <bind nodeset="/exo_mobile_8/releve/id_etude" required="true()" type="select1"/>
      <bind nodeset="/exo_mobile_8/releve/id_protocole" required="true()" type="select1"/>
      <bind nodeset="/exo_mobile_8/releve/code_releve" type="string"/>
      <bind nodeset="/exo_mobile_8/saisie_observateur/saisie_structure" type="select1"/>
      <bind nodeset="/exo_mobile_8/saisie_observateur/search_observateur" required="true()" type="select1"/>
      <bind nodeset="/exo_mobile_8/saisie_date/date_obs" required="true()" type="date"/>
      <bind nodeset="/exo_mobile_8/saisie_date/duree_obs" type="int"/>
      <bind nodeset="/exo_mobile_8/option_localisation" required="true()" type="select1"/>
      <bind nodeset="/exo_mobile_8/obs_geopoint" relevant="selected( /exo_mobile_8/option_localisation ,'gps_auto')" required="true()" type="geopoint"/>
      <bind nodeset="/exo_mobile_8/obs_geoshape_type" relevant="selected( /exo_mobile_8/option_localisation ,'map_object')"/>
      <bind nodeset="/exo_mobile_8/obs_geoshape_type/obs_localisation" required="true()" type="geoshape"/>
      <bind calculate="string( /exo_mobile_8/obs_geoshape_type/obs_localisation )" nodeset="/exo_mobile_8/obs_geoshape_type/obs_coord" type="string" odk:length="2000"/>
      <bind nodeset="/exo_mobile_8/local_rqs" type="string"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/recherche_esp/regne" required="true()" type="select1"/>
      <bind constraint="string-length( /exo_mobile_8/saisie_observation/recherche_esp/searchtext_latin )&gt;2" jr:constraintMsg="Au moins 3 lettres !" nodeset="/exo_mobile_8/saisie_observation/recherche_esp/searchtext_latin" required="true()" type="string"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/search_nom_latin" relevant="string-length( /exo_mobile_8/saisie_observation/recherche_esp/searchtext_latin )&gt;2" required="true()" type="select1"/>
      <bind calculate=" /exo_mobile_8/saisie_observation/search_nom_latin " nodeset="/exo_mobile_8/saisie_observation/lb_cd_nom_latin" type="string"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/carac_observation_flore" relevant="selected( /exo_mobile_8/saisie_observation/recherche_esp/regne ,'plantae')"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/carac_observation_flore/flore_effectif" type="int"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/carac_observation_flore/effectif_textuel" type="select1"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/carac_observation_flore/strate" type="select1"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/carac_observation_flore/phenologie" type="select1"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/carac_observation_faune" relevant="selected( /exo_mobile_8/saisie_observation/recherche_esp/regne ,'animalia')"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/carac_observation_faune/faune_effectif" type="int"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/carac_observation_faune/age" type="select1"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/carac_observation_faune/sexe" type="select1"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/statut_repro" relevant="selected( /exo_mobile_8/saisie_observation/recherche_esp/regne ,'animalia')" type="select1"/>
      <bind nodeset="/exo_mobile_8/saisie_observation/remarques_obs/obs_rqs" type="string"/>
      <bind calculate="concat('uuid:', uuid())" nodeset="/exo_mobile_8/meta/instanceID" readonly="true()" type="string"/>
      <bind calculate="concat( /exo_mobile_8/saisie_date/date_obs ,'-', /exo_mobile_8/releve/id_protocole ,'_', /exo_mobile_8/releve/id_etude )" nodeset="/exo_mobile_8/meta/instanceName" type="string"/>
    </model>
  <link xmlns="" rel="stylesheet" type="text/css" href="moz-extension://b2d6c94d-1316-411b-b124-b133e853761f/skin/socialwidgets.css"/></h:head>
  <h:body>
    <group ref="/exo_mobile_8/releve">
      <label>Informations sur le relevé effectué</label>
      <select1 appearance="quick search('etudes')" ref="/exo_mobile_8/releve/id_etude">
        <label>Etude</label>
        <item>
          <label>nom_etude</label>
          <value>id_etude</value>
        </item>
      </select1>
      <select1 appearance="quick search('protocoles')" ref="/exo_mobile_8/releve/id_protocole">
        <label>Protocole</label>
        <item>
          <label>libelle</label>
          <value>libelle_id</value>
        </item>
      </select1>
      <input ref="/exo_mobile_8/releve/code_releve">
        <label>Code du point de relevé</label>
      </input>
    </group>
    <group ref="/exo_mobile_8/saisie_observateur">
      <label>Observateurs du relevé</label>
      <repeat nodeset="/exo_mobile_8/saisie_observateur">
        <select1 appearance="quick search('structures')" ref="/exo_mobile_8/saisie_observateur/saisie_structure">
          <label>Structure de l'observateur</label>
          <hint>Saisissez une structure</hint>
          <item>
            <label>nom_structure</label>
            <value>id_structure</value>
          </item>
        </select1>
        <select1 appearance="quick search('observateurs','matches','id_structure', /exo_mobile_8/saisie_observateur/saisie_structure )" ref="/exo_mobile_8/saisie_observateur/search_observateur">
          <label>Observateur</label>
          <hint>Ajoutez un observateur</hint>
          <item>
            <label>nom_observateur</label>
            <value>id_observateur</value>
          </item>
        </select1>
      </repeat>
    </group>
    <group appearance="field-list" ref="/exo_mobile_8/saisie_date">
      <label>Date et durée du relevé</label>
      <input appearance="no-calendar" ref="/exo_mobile_8/saisie_date/date_obs">
        <label>Date de l'observation</label>
      </input>
      <input ref="/exo_mobile_8/saisie_date/duree_obs">
        <label>Durée de l'observation</label>
        <hint>en minutes</hint>
      </input>
    </group>
    <select1 appearance="quick" ref="/exo_mobile_8/option_localisation">
      <label>Choix du type de localisation des espèces</label>
      <item>
        <label>Prendre le point GPS où je suis</label>
        <value>gps_auto</value>
      </item>
      <item>
        <label>Placer un point sur la carte</label>
        <value>map_object</value>
      </item>
    </select1>
    <input ref="/exo_mobile_8/obs_geopoint">
      <label>Localisation GPS automatique</label>
    </input>
    <group ref="/exo_mobile_8/obs_geoshape_type">
      <label>Localisation sur la carte</label>
      <input appearance="placement-map" ref="/exo_mobile_8/obs_geoshape_type/obs_localisation">
        <label>Saisie de la localisation sur la carte</label>
        <hint>Saisissez un polygone ou une ligne pour localiser votre observation</hint>
      </input>
    </group>
    <input ref="/exo_mobile_8/local_rqs">
      <label>Remarques sur la localisation des observations</label>
    </input>
    <group ref="/exo_mobile_8/saisie_observation">
      <label>Saisie observation d'une liste d'espèces</label>
      <repeat nodeset="/exo_mobile_8/saisie_observation">
        <group appearance="field-list" ref="/exo_mobile_8/saisie_observation/recherche_esp">
          <label>Recherche d'une espèce</label>
          <select1 ref="/exo_mobile_8/saisie_observation/recherche_esp/regne">
            <label>Règne animal ou végétal ?</label>
            <item>
              <label>Animal</label>
              <value>animalia</value>
            </item>
            <item>
              <label>Végétal</label>
              <value>plantae</value>
            </item>
          </select1>
          <input ref="/exo_mobile_8/saisie_observation/recherche_esp/searchtext_latin">
            <label>Recherche d'une espèce nom latin</label>
            <hint>Tapez au moins 3 lettres du début du nom d'espèce.</hint>
          </input>
        </group>
        <select1 appearance="autocompletion search('taxref_sicen', 'startswith', 'lb_nom_key',  /exo_mobile_8/saisie_observation/recherche_esp/searchtext_latin ,'regne', /exo_mobile_8/saisie_observation/recherche_esp/regne )" ref="/exo_mobile_8/saisie_observation/search_nom_latin">
          <label>Espèce nom latin</label>
          <item>
            <label>lb_nom_key</label>
            <value>lb_nom_cd_key</value>
          </item>
        </select1>
        <group appearance="field-list" ref="/exo_mobile_8/saisie_observation/carac_observation_flore">
          <label>Description de l'observation flore</label>
          <input ref="/exo_mobile_8/saisie_observation/carac_observation_flore/flore_effectif">
            <label>Effectif</label>
            <hint>Saisir effectif OU abondance</hint>
          </input>
          <select1 appearance="minimal" ref="/exo_mobile_8/saisie_observation/carac_observation_flore/effectif_textuel">
            <label>Abondance</label>
            <item>
              <label>i</label>
              <value>i</value>
            </item>
            <item>
              <label>r</label>
              <value>r</value>
            </item>
            <item>
              <label>+</label>
              <value>+</value>
            </item>
            <item>
              <label>1</label>
              <value>1</value>
            </item>
            <item>
              <label>2</label>
              <value>2</value>
            </item>
            <item>
              <label>3</label>
              <value>3</value>
            </item>
            <item>
              <label>4</label>
              <value>4</value>
            </item>
            <item>
              <label>5</label>
              <value>5</value>
            </item>
          </select1>
          <select1 appearance="minimal" ref="/exo_mobile_8/saisie_observation/carac_observation_flore/strate">
            <label>Strate</label>
            <item>
              <label>Strate arborée</label>
              <value>Strate arborée</value>
            </item>
            <item>
              <label>Strate arbustive</label>
              <value>Strate arbustive</value>
            </item>
            <item>
              <label>Strate sous-arbustive</label>
              <value>Strate sous-arbustive</value>
            </item>
            <item>
              <label>Strate herbacée</label>
              <value>Strate herbacée</value>
            </item>
            <item>
              <label>Strate muscinale</label>
              <value>Strate muscinale</value>
            </item>
            <item>
              <label>Strate lichénique</label>
              <value>Strate lichénique</value>
            </item>
            <item>
              <label>Sol nu</label>
              <value>Sol nu</value>
            </item>
            <item>
              <label>Litière</label>
              <value>Litière</value>
            </item>
          </select1>
          <select1 appearance="minimal" ref="/exo_mobile_8/saisie_observation/carac_observation_flore/phenologie">
            <label>Phénologie</label>
            <item>
              <label>État végétatif</label>
              <value>État_végétatif</value>
            </item>
            <item>
              <label>En graine</label>
              <value>En_graine</value>
            </item>
            <item>
              <label>En bouton</label>
              <value>En_bouton</value>
            </item>
            <item>
              <label>En fleur</label>
              <value>En_fleur</value>
            </item>
            <item>
              <label>En fruit</label>
              <value>En_fruit</value>
            </item>
            <item>
              <label>Fané</label>
              <value>Fané</value>
            </item>
            <item>
              <label>Plantule</label>
              <value>Plantule</value>
            </item>
          </select1>
        </group>
        <group appearance="field-list" ref="/exo_mobile_8/saisie_observation/carac_observation_faune">
          <label>Description de l'observation faune</label>
          <input ref="/exo_mobile_8/saisie_observation/carac_observation_faune/faune_effectif">
            <label>Effectif</label>
          </input>
          <select1 appearance="minimal" ref="/exo_mobile_8/saisie_observation/carac_observation_faune/age">
            <label>Age</label>
            <item>
              <label>Oeuf/ponte</label>
              <value>Oeuf/ponte</value>
            </item>
            <item>
              <label>Juvénile</label>
              <value>Juvénile</value>
            </item>
            <item>
              <label>Adulte</label>
              <value>Adulte</value>
            </item>
            <item>
              <label>Indéterminé</label>
              <value>Indéterminé</value>
            </item>
          </select1>
          <select1 appearance="minimal" ref="/exo_mobile_8/saisie_observation/carac_observation_faune/sexe">
            <label>Sexe</label>
            <item>
              <label>Mâle</label>
              <value>Mâle</value>
            </item>
            <item>
              <label>Femelle</label>
              <value>Femelle</value>
            </item>
            <item>
              <label>Couple</label>
              <value>couple</value>
            </item>
            <item>
              <label>Indéterminé</label>
              <value>Indéterminé</value>
            </item>
          </select1>
        </group>
        <select1 appearance="quick search('statut_repro')" ref="/exo_mobile_8/saisie_observation/statut_repro">
          <label>Statuts / Reproduction</label>
          <item>
            <label>libelle_statut_repro</label>
            <value>id_statut_repro</value>
          </item>
        </select1>
        <group appearance="field-list" ref="/exo_mobile_8/saisie_observation/remarques_obs">
          <label>Remarques</label>
          <input ref="/exo_mobile_8/saisie_observation/remarques_obs/obs_rqs">
            <label>Remarques sur l'espèce vue</label>
          </input>
        </group>
      </repeat>
    </group>
  </h:body>
</h:html>

Aug 12 '17 02:08 getodk-bot

This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its recipients. This is a temporary error. The following address(es) deferred:

[email protected] Domain beorse.net has exceeded the max emails per hour (297/250 (118%)) allowed. Message will be reattempted later

------- This is a copy of the message, including all the headers. ------ Received: from o7.sgmail.github.com ([167.89.101.198]:62836) by hp159.hostpapa.com with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89) (envelope-from [email protected]) id 1dgMDd-000f2d-Ng for [email protected]; Fri, 11 Aug 2017 22:32:05 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=github.com; h=from:reply-to:to:cc:in-reply-to:references:subject:mime-version:content-type:content-transfer-encoding:list-id:list-archive:list-post:list-unsubscribe; s=s20150108; bh=jcdhBVd6HXBFlX8eLy6qNY0zO6s=; b=OV1Q/+1gVzpXrlO4 q0xITG7+vDOjnDIMINIbNdKxE7jjCIAI9jFFNCyerI7OEA2+yJTWXYeKdV5/GRYQ MM0qcUHWmVqsKPczPEqLZivMaqnuN+TZorAJNV81VEqphrz40Y+AhWfrhmI2Uqe6 MsP/Yf/aEw1hkE79+fsRk6dFCp0= Received: by filter1128p1mdw1.sendgrid.net with SMTP id filter1128p1mdw1-10246-598E687E-7 2017-08-12 02:31:26.068139332 +0000 UTC Received: from github-smtp2b-ext-cp1-prd.iad.github.net (github-smtp2b-ext-cp1-prd.iad.github.net [192.30.253.17]) by ismtpd0037p1mdw1.sendgrid.net (SG) with ESMTP id 8iRJZrhwQNWZ4b2XZy-5aQ for [email protected]; Sat, 12 Aug 2017 02:31:26.060 +0000 (UTC) Date: Sat, 12 Aug 2017 02:31:26 +0000 (UTC) From: Open Data Kit [email protected] Reply-To: opendatakit/aggregate [email protected] To: opendatakit/aggregate [email protected] Cc: Subscribed [email protected] Message-ID: opendatakit/aggregate/issues/84/[email protected] In-Reply-To: opendatakit/aggregate/issues/[email protected] References: opendatakit/aggregate/issues/[email protected] Subject: Re: [opendatakit/aggregate] Text column with unlimited length in aggregate database (#84) Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--==_mimepart_598e687db6049_19a23ff40beedc2c104298"; charset=UTF-8 Content-Transfer-Encoding: 7bit Precedence: list X-GitHub-Sender: opendatakit-bot X-GitHub-Recipient: jbeorse X-GitHub-Reason: subscribed List-ID: opendatakit/aggregate <aggregate.opendatakit.github.com> List-Archive: https://github.com/opendatakit/aggregate List-Post: mailto:[email protected] List-Unsubscribe: mailto:unsub+000519af25a56a538b7c65e9845327af0b69533cdccafa5b92cf0000000115a62a7d92a169ce0ee362c0@reply.github.com, https://github.com/notifications/unsubscribe/AAUZr5efz82duyp71MZUmisovZ-jJsU6ks5sXQ59gaJpZM4O1SR_ X-Auto-Response-Suppress: All X-GitHub-Recipient-Address: [email protected] X-SG-EID: JVRD81wLmvjBgNlAmNtibjEbEEhcPGKEESixoxP2c44rTVvViHBNja7ApP12lbyle0XBX4Ed9758Yw LcHjT6MPfyprPi4+QXuK52YVg26qNdwSjtM4UhxeIzbnI/8NwBeNpRnDAbNLc4f2/34gYDKxX+3FPy oTT57SNqxmC1tD343uhi4RphEBH1wLzYzhirizSu2uF+1gg8IaxdnEy1xEJM0bG6lpXMw2pvjD4exI g=

----==_mimepart_598e687db6049_19a23ff40beedc2c104298 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit

Comment by atbentley Thursday Jan 19, 2017 at 23:12 GMT

The attachment is missing

-- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/opendatakit/aggregate/issues/84#issuecomment-321952104 ----==_mimepart_598e687db6049_19a23ff40beedc2c104298 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Comment by atbentley
Thursday Jan 19, 2017 at 23:12 GMT

The attachment is missing

&mda= sh;
You are receiving this because you are subscribed to this thread.Reply to this email directly, view it on GitHub, or mute the thread.

=

----==_mimepart_598e687db6049_19a23ff40beedc2c104298--

Aug 12 '17 02:08 jbeorse

This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its recipients. This is a temporary error. The following address(es) deferred:

[email protected] Domain beorse.net has exceeded the max emails per hour (299/250 (119%)) allowed. Message will be reattempted later

------- This is a copy of the message, including all the headers. ------ Received: from github-smtp2-ext2.iad.github.net ([192.30.252.193]:43822 helo=github-smtp2b-ext-cp1-prd.iad.github.net) by hp159.hostpapa.com with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.89) (envelope-from [email protected]) id 1dgMDf-000f3E-7j for [email protected]; Fri, 11 Aug 2017 22:32:07 -0400 Date: Fri, 11 Aug 2017 19:31:27 -0700 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=github.com; s=pf2014; t=1502505087; bh=I9D1uZuTS5iuvZBd17XFeyerF1aLZZeWDNEAkEQBqdc=; h=From:Reply-To:To:Cc:In-Reply-To:References:Subject:List-ID: List-Archive:List-Post:List-Unsubscribe:From; b=MhOqa6YK6lWiulDurbFNXveGHvgt2PhlgSuTUhUcqG3Yaf446yYjIPrfjorTydhJA 3SnZJ4VWMn4x98UKSbSrOCBR39X7yxVUvBi59xqXUCphgadIuDtwcg7ZktTFibxIx6 zllHBUF1WZJgpRlR07m4vvcpbtgpkGUlgG8BBxcI= From: Open Data Kit [email protected] Reply-To: opendatakit/aggregate [email protected] To: opendatakit/aggregate [email protected] Cc: Subscribed [email protected] Message-ID: opendatakit/aggregate/issues/84/[email protected] In-Reply-To: opendatakit/aggregate/issues/[email protected] References: opendatakit/aggregate/issues/[email protected] Subject: Re: [opendatakit/aggregate] Text column with unlimited length in aggregate database (#84) Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--==_mimepart_598e687fa0760_5d13fb2774b1c3488526"; charset=UTF-8 Content-Transfer-Encoding: 7bit Precedence: list X-GitHub-Sender: opendatakit-bot X-GitHub-Recipient: jbeorse X-GitHub-Reason: subscribed List-ID: opendatakit/aggregate <aggregate.opendatakit.github.com> List-Archive: https://github.com/opendatakit/aggregate List-Post: mailto:[email protected] List-Unsubscribe: mailto:unsub+000519afc2ad8d26511f3a9f456b9468daedc30983c1be0a92cf0000000115a62a7f92a169ce0ee362c0@reply.github.com, https://github.com/notifications/unsubscribe/AAUZr6Hl2V_eVP3XOOzAErXzeJPKlGAKks5sXQ5_gaJpZM4O1SR_ X-Auto-Response-Suppress: All X-GitHub-Recipient-Address: [email protected]

----==_mimepart_598e687fa0760_5d13fb2774b1c3488526 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit

Comment by atbentley Sunday Jan 22, 2017 at 22:49 GMT

Thanks Mitch, got this working now. I had to upgrade to 1.4.13 though.

-- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/opendatakit/aggregate/issues/84#issuecomment-321952108 ----==_mimepart_598e687fa0760_5d13fb2774b1c3488526 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Comment by atbentley
Sunday Jan 22, 2017 at 22:49 GMT

Thanks Mitch, got this working now. I had to upgrade to 1.4.13 though.=

&m= dash;
You are receiving this because you are subscribed to this thre= ad.
Reply to this email directly, view it on GitHub= , or mute the thread.

=

----==_mimepart_598e687fa0760_5d13fb2774b1c3488526--

Aug 12 '17 02:08 jbeorse

This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its recipients. This is a temporary error. The following address(es) deferred:

[email protected] Domain beorse.net has exceeded the max emails per hour (294/250 (117%)) allowed. Message will be reattempted later

------- This is a copy of the message, including all the headers. ------ Received: from o8.sgmail.github.com ([167.89.101.199]:7424) by hp159.hostpapa.com with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89) (envelope-from [email protected]) id 1dgMDc-000f2A-3P for [email protected]; Fri, 11 Aug 2017 22:32:04 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=github.com; h=from:reply-to:to:cc:subject:mime-version:content-type:content-transfer-encoding:list-id:list-archive:list-post:list-unsubscribe; s=s20150108; bh=Ux5t68B3Bj9oPKWy7Ddk0PZJ4JE=; b=Ud3s3ye7zvBomkrI GA6VCxR9Jcd35l5twzaBiW3ddtYvqOsYaM1D/Y8/Zcx69Lqf1oIWQhTPRF1+aAWj 6y4maTc/aLM3XBJnl1jgnV3lyRVshXow23iGzSG0gKmK9Tkdl6cAwdRYPofAuU0P rgeHLOYNGEH68DTjMh/8jCDJyl4= Received: by filter0535p1mdw1.sendgrid.net with SMTP id filter0535p1mdw1-5587-598E687C-10 2017-08-12 02:31:24.350109796 +0000 UTC Received: from github-smtp2a-ext-cp1-prd.iad.github.net (github-smtp2a-ext-cp1-prd.iad.github.net [192.30.253.16]) by ismtpd0040p1mdw1.sendgrid.net (SG) with ESMTP id B33qFiFQTGOl0LQbq57y9A for [email protected]; Sat, 12 Aug 2017 02:31:24.298 +0000 (UTC) Date: Sat, 12 Aug 2017 02:31:24 +0000 (UTC) From: Open Data Kit [email protected] Reply-To: opendatakit/aggregate [email protected] To: opendatakit/aggregate [email protected] Cc: Subscribed [email protected] Message-ID: opendatakit/aggregate/issues/[email protected] Subject: [opendatakit/aggregate] Text column with unlimited length in aggregate database (#84) Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--==_mimepart_598e687bf04f6_5c223fb2774b1c344895d"; charset=UTF-8 Content-Transfer-Encoding: 7bit Precedence: list X-GitHub-Sender: opendatakit-bot X-GitHub-Recipient: jbeorse X-GitHub-Reason: subscribed List-ID: opendatakit/aggregate <aggregate.opendatakit.github.com> List-Archive: https://github.com/opendatakit/aggregate List-Post: mailto:[email protected] List-Unsubscribe: mailto:unsub+000519afc9886f7472d62caa850369788b96936d98bacb3c92cf0000000115a62a7b92a169ce0ee362c0@reply.github.com, https://github.com/notifications/unsubscribe/AAUZr6RDhCYaOxJRhIf0VmEQFagioikRks5sXQ57gaJpZM4O1SR_ X-Auto-Response-Suppress: All X-GitHub-Recipient-Address: [email protected] X-SG-EID: JVRD81wLmvjBgNlAmNtibjEbEEhcPGKEESixoxP2c45EbYLRIOlxVavCJUGQztAnp+Qhl/JGpdAGBn 2Hh/0w1/FcR7svALUqa7V5tlNirWSbLeudK2yBd7NDF8aZ8tKvrI43Wom64AYNWpIGHy/wEnImoqef P8TvWj2Lu1DCoGcpYKRB/0834kYNDnM9H2QbaEiy9tlrQUL/hqt9yezNwR4AC0X0Gq4jzr7+akThtF g=

----==_mimepart_598e687bf04f6_5c223fb2774b1c344895d Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit

Issue by atbentley Tuesday Jan 17, 2017 at 04:23 GMT Originally opened as https://github.com/opendatakit/opendatakit/issues/1265 (5 comment(s))

Hi,

It looks like creating specific length columns used to be supported, but there doesn't appear to be much documentation for how to do this using the newer app designer with formDef.json. Currently I'm only able to get column types of varchar(255), how can I get unlimited length text columns or arbitrary length text columns.

Aggregate: 1.4.12 App designer: 206b Database: postgres 9.4.4

-- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/opendatakit/aggregate/issues/84 ----==_mimepart_598e687bf04f6_5c223fb2774b1c344895d Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit

Issue by atbentley
Tuesday Jan 17, 2017 at 04:23 GMT
Originally opened as opendatakit/opendatakit#1265 (5 comment(s))

Hi,

It looks like creating specific length columns used to be supported, but there doesn't appear to be much documentation for how to do this using the newer app designer with formDef.json. Currently I'm only able to get column types of varchar(255), how can I get unlimited length text columns or arbitrary length text columns.

Aggregate: 1.4.12
App designer: 206b
Database: postgres 9.4.4

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.

----==_mimepart_598e687bf04f6_5c223fb2774b1c344895d--

Aug 12 '17 02:08 jbeorse

This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its recipients. This is a temporary error. The following address(es) deferred:

[email protected] Domain beorse.net has exceeded the max emails per hour (295/250 (118%)) allowed. Message will be reattempted later

------- This is a copy of the message, including all the headers. ------ ------ The body of the message is 12377 characters long; only the first ------ 5000 or so are included here. Received: from o1.sgmail.github.com ([192.254.114.176]:30679) by hp159.hostpapa.com with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89) (envelope-from [email protected]) id 1dgMDc-000f2J-Ji for [email protected]; Fri, 11 Aug 2017 22:32:04 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=github.com; h=from:reply-to:to:cc:in-reply-to:references:subject:mime-version:content-type:content-transfer-encoding:list-id:list-archive:list-post:list-unsubscribe; s=s20150108; bh=E3kG9LjlfLNCEMA614TnM1O15ss=; b=orUMWwgXlzZjw9Ii YJ9HI4yHZuD7eTXWEJN5LBFu9HvxgQwksSuyLwDfFlEmoessGbQ3RRr2VhMIT7Za /Aaqh2+t3fXlr6OB81rMdr8iZHDJHnLf0yofArGpI0WehPs42bsYh4qAS8A4W8fX KBIS4WG8odrjihMpOuW6/8YJddk= Received: by filter0983p1mdw1.sendgrid.net with SMTP id filter0983p1mdw1-12349-598E687C-5D 2017-08-12 02:31:24.951160675 +0000 UTC Received: from github-smtp2b-ext-cp1-prd.iad.github.net (github-smtp2b-ext-cp1-prd.iad.github.net [192.30.253.17]) by ismtpd0036p1mdw1.sendgrid.net (SG) with ESMTP id KerfP1yTTKagSi5sdzur6w for [email protected]; Sat, 12 Aug 2017 02:31:24.873 +0000 (UTC) Date: Sat, 12 Aug 2017 02:31:24 +0000 (UTC) From: Open Data Kit [email protected] Reply-To: opendatakit/aggregate [email protected] To: opendatakit/aggregate [email protected] Cc: Subscribed [email protected] Message-ID: opendatakit/aggregate/issues/84/[email protected] In-Reply-To: opendatakit/aggregate/issues/[email protected] References: opendatakit/aggregate/issues/[email protected] Subject: Re: [opendatakit/aggregate] Text column with unlimited length in aggregate database (#84) Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--==_mimepart_598e687c7c400_19b03fcaa4591c2c10484a"; charset=UTF-8 Content-Transfer-Encoding: 7bit Precedence: list X-GitHub-Sender: opendatakit-bot X-GitHub-Recipient: jbeorse X-GitHub-Reason: subscribed List-ID: opendatakit/aggregate <aggregate.opendatakit.github.com> List-Archive: https://github.com/opendatakit/aggregate List-Post: mailto:[email protected] List-Unsubscribe: mailto:unsub+000519af83499e3282d24a7465423cc1e7354dc39cee421392cf0000000115a62a7c92a169ce0ee362c0@reply.github.com, https://github.com/notifications/unsubscribe/AAUZr4WKsp40q8DnAbCGn4Sw-itrEPMsks5sXQ58gaJpZM4O1SR_ X-Auto-Response-Suppress: All X-GitHub-Recipient-Address: [email protected] X-SG-EID: JVRD81wLmvjBgNlAmNtibjEbEEhcPGKEESixoxP2c44wd4PATPE5GBtw2fzqgLv2mPuvx54LrZNAkj zscKJaSxsXrAuTGAD97Y1Jp0kAuS47TVbVlEfou4PF5bJ/1adEqKm2Fz7crTQY2bjPcaerq10F82mi Ie6ElwpCYf0VNTKtkFEv8t7zNWBt56HnfAhdK2tKR5KY+pUmm4rTsbkbpMEW65fLseaV0FIkoKjHDn 0=

----==_mimepart_598e687c7c400_19b03fcaa4591c2c10484a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

<a href=3D"https://github.com/mitchellsundt"><img src=3D"https://avatars1.g= ithubusercontent.com/u/2281171?v=3D4" align=3D"left" width=3D"48" height=3D= "48" hspace=3D"10"> Comment by [mitchellsundt](https://github.c= om/mitchellsundt) Thursday Jan 19, 2017 at 18:34 GMT