Error: Please define a 'form_id' setting_name on the settings sheet and specify the unique form id for the form in ODK apllication designer


(nefiscoartfish@gmail.com) #1

Dear group

I want to edit my forms in ODK application designer, I installed everything
ODK application designer. It opens nicely. The forms are running nicely on
my tablet so they are ok only I do not like the appearance

In ODK application designer I go to XLSX converter to upload my form file,
I choose my file and then I get the message: Error: Please define a
'form_id' setting_name on the settings sheet and specify the unique form id
for the form

anybody knows what I am doing wrong?

Regards
Gertjan


(nefiscoartfish@gmail.com) #2

Dear All

found one problem in orginal ODK forms the settings are in colums while the
ODK application designer wants the settngs in rows.bit now I get the next
error application designer does not accept filtering in my choice list.

Is there not a simple tool to edit my form. i.e to change the fonts, change
colours and alignment of the text?

regards
gertjan

··· On Tuesday, June 2, 2015 at 12:58:39 PM UTC+2, nefisco...@gmail.com wrote:

Dear group

I want to edit my forms in ODK application designer, I installed
everything ODK application designer. It opens nicely. The forms are running
nicely on my tablet so they are ok only I do not like the appearance

In ODK application designer I go to XLSX converter to upload my form file,
I choose my file and then I get the message: Error: Please define a
'form_id' setting_name on the settings sheet and specify the unique form id
for the form

anybody knows what I am doing wrong?

Regards
Gertjan


(clarice larson) #3

It sounds like you need to include the form_id setting on your settings
worksheet in your XLSX file. I've attached an example for you to
reference. You will notice that the form_id on the worksheet is set to the
same name as the XLSX file. If there are still issues, feel free to
include your XLSX file.

Clarice

exampleForm.xlsx (15.3 KB)

··· On Tue, Jun 2, 2015 at 3:58 AM, nefiscoartfish@gmail.com < nefiscoartfish@gmail.com> wrote:

Dear group

I want to edit my forms in ODK application designer, I installed
everything ODK application designer. It opens nicely. The forms are running
nicely on my tablet so they are ok only I do not like the appearance

In ODK application designer I go to XLSX converter to upload my form file,
I choose my file and then I get the message: Error: Please define a
'form_id' setting_name on the settings sheet and specify the unique form id
for the form

anybody knows what I am doing wrong?

Regards
Gertjan

--

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 S) #4

Application Designer is a 2.0 tool.
It is not for use with ODK Collect or XLSXForm.

··· -------------------

The ODK 2.0 XLSX format is different from the ODK 1.0 XLSX format.

You cannot start with an ODK 1.0 XLSX file and expect it to work in the ODK
2.0 Application Designer (or vice-versa).

If you use the 2.0 tools, the only documentation on the ODK 2.0 XLSX file
format is under the XLSXConverter heading (e.g., for the current release,
it is here:
https://opendatakit.org/use/2_0_tools/odk-application-designer-2-0-rev126/odk-xlsxconverter-2-0-rev126/
)

On Tue, Jun 2, 2015 at 10:40 AM, clarice larson clarlars@gmail.com wrote:

It sounds like you need to include the form_id setting on your settings
worksheet in your XLSX file. I've attached an example for you to
reference. You will notice that the form_id on the worksheet is set to the
same name as the XLSX file. If there are still issues, feel free to
include your XLSX file.

Clarice

On Tue, Jun 2, 2015 at 3:58 AM, nefiscoartfish@gmail.com < nefiscoartfish@gmail.com> wrote:

Dear group

I want to edit my forms in ODK application designer, I installed
everything ODK application designer. It opens nicely. The forms are running
nicely on my tablet so they are ok only I do not like the appearance

In ODK application designer I go to XLSX converter to upload my form
file, I choose my file and then I get the message: Error: Please define
a 'form_id' setting_name on the settings sheet and specify the unique form
id for the form

anybody knows what I am doing wrong?

Regards
Gertjan

--

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


#5

Hi Clarice and Mitch,

I am having the same problem as in the OP. XLSXConverter returns an error
of:

"Error: Please define a 'form_id' setting_name on the settings sheet and
specify the unique form id for the form"

I have verified that I have a form_id row in the settings tab, and that it
matches the name of the .xlsx file. In fact, I copied and pasted the
settings sheet used in exampleForm.xlsx posted on the ODK website and in
Clarice's post, and I get the same error message. I've attached my .xlsx
file if that would help -- any suggestions you have for getting around this
problem would be greatly appreciated!

Thanks!

Test1.xlsx (14.3 KB)

··· On Tuesday, June 2, 2015 at 8:40:54 PM UTC+3, clarice larson wrote: > > It sounds like you need to include the form_id setting on your settings > worksheet in your XLSX file. I've attached an example for you to > reference. You will notice that the form_id on the worksheet is set to the > same name as the XLSX file. If there are still issues, feel free to > include your XLSX file. > > Clarice > > On Tue, Jun 2, 2015 at 3:58 AM, nefisco...@gmail.com < nefisco...@gmail.com > wrote: > >> Dear group >> >> I want to edit my forms in ODK application designer, I installed >> everything ODK application designer. It opens nicely. The forms are running >> nicely on my tablet so they are ok only I do not like the appearance >> >> In ODK application designer I go to XLSX converter to upload my form >> file, I choose my file and then I get the message: Error: Please define >> a 'form_id' setting_name on the settings sheet and specify the unique form >> id for the form >> >> anybody knows what I am doing wrong? >> >> Regards >> Gertjan >> >> >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@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...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

(clarice larson) #6

I've attached a modified version of the form that should fix all of your
issues. The things that I corrected on this form are the following.

  1. Renamed the setting worksheet to settings.
  2. Removed an end screen on line 26 as there was no matching begin
    screen. Also, begin screen and end screen go under the clause column and
    not the type column.
  3. Changed the data_values on the choices worksheet to text. Currently,
    the select prompts only work with text. We are working on a different
    prompt that would support integers.

If you have more questions or issues, let us know.

Clarice

Test2.xlsx (14.2 KB)

··· On Tue, Jun 30, 2015 at 5:42 PM, wrote:

Hi Clarice and Mitch,

I am having the same problem as in the OP. XLSXConverter returns an error
of:

"Error: Please define a 'form_id' setting_name on the settings sheet and
specify the unique form id for the form"

I have verified that I have a form_id row in the settings tab, and that it
matches the name of the .xlsx file. In fact, I copied and pasted the
settings sheet used in exampleForm.xlsx posted on the ODK website and in
Clarice's post, and I get the same error message. I've attached my .xlsx
file if that would help -- any suggestions you have for getting around this
problem would be greatly appreciated!

Thanks!

On Tuesday, June 2, 2015 at 8:40:54 PM UTC+3, clarice larson wrote:

It sounds like you need to include the form_id setting on your settings
worksheet in your XLSX file. I've attached an example for you to
reference. You will notice that the form_id on the worksheet is set to the
same name as the XLSX file. If there are still issues, feel free to
include your XLSX file.

Clarice

On Tue, Jun 2, 2015 at 3:58 AM, nefisco...@gmail.com < nefisco...@gmail.com> wrote:

Dear group

I want to edit my forms in ODK application designer, I installed
everything ODK application designer. It opens nicely. The forms are running
nicely on my tablet so they are ok only I do not like the appearance

In ODK application designer I go to XLSX converter to upload my form
file, I choose my file and then I get the message: Error: Please define
a 'form_id' setting_name on the settings sheet and specify the unique form
id for the form

anybody knows what I am doing wrong?

Regards
Gertjan

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@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...@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.


(Walid Chrouqui94) #7

Hello Clarice;
i have the same problem here; i have verified too that i have form_id row in the settings worksheet; and that it matches the name of the .xlsx . I have copied ur file Test2.xlsx and i get the same error message.
Thank you a lot


(clarice larson) #8

Hi,

The form that you referenced is outdated. I have uploaded the Test2.xlsx (14.3 KB)
example with the correct column headings. Also, I have added the missing table_id field. Let me know if you find other problems.

Clarice