I've uploaded my .xlsx file (on annex) with the "XLSX Converter" from my "Application Designer" following the tutorial at:
But I can't preview the form, have I done something wrong?
tableId.xlsx (10.6 KB)
Your form is correct except that lines 2-4 in your tableId.xlsx file should
be added to the survey worksheet in app/framework/framework.xlsx. You will
need to add an entry into the choices worksheet of the framework.xlsx file
for your form (see attached image). The framework.xlsx file will need to
be run through the XLSX Converter with the new formDef.json put into the
app/framework/ directory as well.
Also, you will need to create an app/tables/tableId/forms/tableId directory
to put the tableId.xlsx file and the corresponding formDef.json emitted by
the XLSX Converter.
Finally, is there any reason not to upgrade to rev 126? Many things have
changed from rev 122.
Clarice
···
On Thu, Feb 26, 2015 at 8:55 AM, wrote:I've uploaded my .xlsx file (on annex) with the "XLSX Converter" from my
"Application Designer" following the tutorial at:But I can't preview the form, have I done something wrong?
--
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/d/optout.
Dueling responses... yes, you should use the latest release (rev 126), as
there were significant bug fixes between the two releases.
-----------here's what I was putting together------------
Yes 
There are two Excel spreadsheets that are involved:
(1) tableId.xlsx -- your new form
(2) framework.xlsx -- the 'launching page' that displays the forms that can
be opened and provides links to them.
In this section
https://opendatakit.org/use/2_0_tools/older-versions/september-2014-rev-122/odk-application-designer-2-0-rev122/#ODK_Survey_Designing_a_Form
we expect that you name your new form's Excel file with a filename that
matches the formId. In this case, your tableId and formId are both '
tableId' so you would name the file 'tableId.xlsx'
and place it here:
- app\tables\tableId\forms\tableId\tableId.xlsx*
When you run that through the XLSXconverter, you can either click the "Save
to Filesystem" button or manually save the formDef.json into
app\tables\tableId\forms\tableId\formDef.json
This is all good.
The next step is where you made a mistake.
You then need to edit the framework.xlsx file, located at
app\framework\framework.xlsx
And modify that to add your 'tableId' to the choices tab, and the code
snippet from the documentation onto the bottom of the survey tab.
(In this case, you copied the snippit into your tableId.xlsx file and not
into the framework.xlsx file)
You then must edit the snippit.
You need to change the quoted string within the snippit:
'../tables/testForm/forms/testForm/'
to correctly reference the tableId and formId of your form. In this case,
you would edit this and change it to:
'../tables/tableId/forms/tableId/'
Then, save changes, run XLSXConverter, choosing the framework.xlsx and
saving the changes either using the "Save to Filesystem" button or manually
save the formDef.json into
app\framework\formDef.json
When you then go to the Preview tab, you should see, in the list of forms
(likely at the bottom -- it uses the order of the choices list for display
ordering), your tableId form. You can then click that, and should have the
button to click.
···
On Thu, Feb 26, 2015 at 11:34 AM, clarice larson wrote:Your form is correct except that lines 2-4 in your tableId.xlsx file
should be added to the survey worksheet in app/framework/framework.xlsx.
You will need to add an entry into the choices worksheet of the
framework.xlsx file for your form (see attached image). The framework.xlsx
file will need to be run through the XLSX Converter with the new
formDef.json put into the app/framework/ directory as well.Also, you will need to create an app/tables/tableId/forms/tableId
directory to put the tableId.xlsx file and the corresponding formDef.json
emitted by the XLSX Converter.Finally, is there any reason not to upgrade to rev 126? Many things have
changed from rev 122.Clarice
On Thu, Feb 26, 2015 at 8:55 AM, ruirochalima1@gmail.com wrote:
I've uploaded my .xlsx file (on annex) with the "XLSX Converter" from my
"Application Designer" following the tutorial at:But I can't preview the form, have I done something wrong?
--
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/d/optout.--
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/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Good call on the explaining of the "Save to FileSystem", but I still like
my picture. 
Clarice
···
On Thu, Feb 26, 2015 at 11:37 AM, Mitch Sundt wrote:Dueling responses... yes, you should use the latest release (rev 126), as
there were significant bug fixes between the two releases.-----------here's what I was putting together------------
Yes
There are two Excel spreadsheets that are involved:
(1) tableId.xlsx -- your new form
(2) framework.xlsx -- the 'launching page' that displays the forms that
can be opened and provides links to them.In this section
https://opendatakit.org/use/2_0_tools/older-versions/september-2014-rev-122/odk-application-designer-2-0-rev122/#ODK_Survey_Designing_a_Formwe expect that you name your new form's Excel file with a filename that
matches the formId. In this case, your tableId and formId are both '
tableId' so you would name the file 'tableId.xlsx'and place it here:
- app\tables\tableId\forms\tableId\tableId.xlsx*
When you run that through the XLSXconverter, you can either click the
"Save to Filesystem" button or manually save the formDef.json into
app\tables\tableId\forms\tableId\formDef.jsonThis is all good.
The next step is where you made a mistake.
You then need to edit the framework.xlsx file, located at
app\framework\framework.xlsxAnd modify that to add your 'tableId' to the choices tab, and the code
snippet from the documentation onto the bottom of the survey tab.(In this case, you copied the snippit into your tableId.xlsx file and not
into the framework.xlsx file)You then must edit the snippit.
You need to change the quoted string within the snippit:
'../tables/testForm/forms/testForm/'
to correctly reference the tableId and formId of your form. In this case,
you would edit this and change it to:'../tables/tableId/forms/tableId/'
Then, save changes, run XLSXConverter, choosing the framework.xlsx and
saving the changes either using the "Save to Filesystem" button or manually
save the formDef.json intoapp\framework\formDef.json
When you then go to the Preview tab, you should see, in the list of forms
(likely at the bottom -- it uses the order of the choices list for display
ordering), your tableId form. You can then click that, and should have the
button to click.On Thu, Feb 26, 2015 at 11:34 AM, clarice larson clarlars@gmail.com wrote:
Your form is correct except that lines 2-4 in your tableId.xlsx file
should be added to the survey worksheet in app/framework/framework.xlsx.
You will need to add an entry into the choices worksheet of the
framework.xlsx file for your form (see attached image). The framework.xlsx
file will need to be run through the XLSX Converter with the new
formDef.json put into the app/framework/ directory as well.Also, you will need to create an app/tables/tableId/forms/tableId
directory to put the tableId.xlsx file and the corresponding formDef.json
emitted by the XLSX Converter.Finally, is there any reason not to upgrade to rev 126? Many things have
changed from rev 122.Clarice
On Thu, Feb 26, 2015 at 8:55 AM, ruirochalima1@gmail.com wrote:
I've uploaded my .xlsx file (on annex) with the "XLSX Converter" from my
"Application Designer" following the tutorial at:But I can't preview the form, have I done something wrong?
--
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/d/optout.--
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/d/optout.--
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 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/d/optout.