Limit column size for text

Hello good people

I want to find out if there is a way you can design your forms so that when
the tables are created on the database you have the capacity to limit the
size allocated to the text columns .An Example in particular is a column
like first name i noticed by default all text columns are defaulted to
varchar(255) , what i want is to be able to have this created with my
prefered value e.g. varchar(20) . If i am correct this is the reason why
ODK will create multiple tables for one form since it would have
calculated the worst case scenario's if all columns were to be completed .

thank you

Yes

http://opendatakit.org/help/form-design/guidelines/#datastore_string_length

··· On Fri, Jun 21, 2013 at 4:05 AM, Mukanya wrote:

Hello good people

I want to find out if there is a way you can design your forms so that
when the tables are created on the database you have the capacity to limit
the size allocated to the text columns .An Example in particular is a
column like first name i noticed by default all text columns are defaulted
to varchar(255) , what i want is to be able to have this created with my
prefered value e.g. varchar(20) . If i am correct this is the reason why
ODK will create multiple tables for one form since it would have
calculated the worst case scenario's if all columns were to be completed .

thank you

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Thanks Mitch

I see i can do this on the xml file and manage this ,is there a way of how
i could do this from the excel form in XLSForm besides editing the created
xml file ?

··· On Fri, Jun 21, 2013 at 6:19 PM, Mitch Sundt wrote:

Yes

http://opendatakit.org/help/form-design/guidelines/#datastore_string_length

On Fri, Jun 21, 2013 at 4:05 AM, Mukanya cleohwinya@gmail.com wrote:

Hello good people

I want to find out if there is a way you can design your forms so that
when the tables are created on the database you have the capacity to limit
the size allocated to the text columns .An Example in particular is a
column like first name i noticed by default all text columns are defaulted
to varchar(255) , what i want is to be able to have this created with my
prefered value e.g. varchar(20) . If i am correct this is the reason why
ODK will create multiple tables for one form since it would have
calculated the worst case scenario's if all columns were to be completed .

thank you

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/g_Em1hSb2dQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Apparently not, or it was never documented.

I've added that to this list:
http://code.google.com/p/opendatakit/issues/detail?id=887&start=200

··· On Mon, Jun 24, 2013 at 2:49 AM, Cleopas Hwinya wrote:

Thanks Mitch

I see i can do this on the xml file and manage this ,is there a way of how
i could do this from the excel form in XLSForm besides editing the
created xml file ?

On Fri, Jun 21, 2013 at 6:19 PM, Mitch Sundt mitchellsundt@gmail.comwrote:

Yes

http://opendatakit.org/help/form-design/guidelines/#datastore_string_length

On Fri, Jun 21, 2013 at 4:05 AM, Mukanya cleohwinya@gmail.com wrote:

Hello good people

I want to find out if there is a way you can design your forms so that
when the tables are created on the database you have the capacity to limit
the size allocated to the text columns .An Example in particular is a
column like first name i noticed by default all text columns are defaulted
to varchar(255) , what i want is to be able to have this created with my
prefered value e.g. varchar(20) . If i am correct this is the reason why
ODK will create multiple tables for one form since it would have
calculated the worst case scenario's if all columns were to be completed .

thank you

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups "ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/g_Em1hSb2dQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com