Updating CSV files without reloading forms?

Hi,

I have started using external CSV files uploaded as media to draw my selection lists from. My question is, is it possible to update these lists should something change e.g. there is another name to add to a multiple choice list? The problem we have had in the past is that every time we need to add a new entry to the multiple choice list we have to load a new version of the form. Is there a way to update or replace media files?

Thanks!

Don't think you can without re-downloading the forms. Perhaps your
team could contribute this feature?

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Fri, Aug 7, 2015 at 10:13 AM, bvodkdemo@gmail.com victoria@blueventures.org wrote:

Hi,

I have started using external CSV files uploaded as media to draw my selection lists from. My question is, is it possible to update these lists should something change e.g. there is another name to add to a multiple choice list? The problem we have had in the past is that every time we need to add a new entry to the multiple choice list we have to load a new version of the form. Is there a way to update or replace media files?

Thanks!

--

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.

I had a similar question and tried to add a version column in the XLS form but did not have luck. What I did was add a column in the settings tab named version. Then I assigned a file with the version number 1. I updated the file and renamed version 2. I tried to replace and got an error message. Are there more detailed instructions on how to do this anywhere?

Thanks,
Jen

··· On Friday, August 7, 2015 at 8:13:24 AM UTC-7, bvod...@gmail.com wrote: > Hi, > > I have started using external CSV files uploaded as media to draw my selection lists from. My question is, is it possible to update these lists should something change e.g. there is another name to add to a multiple choice list? The problem we have had in the past is that every time we need to add a new entry to the multiple choice list we have to load a new version of the form. Is there a way to update or replace media files? > > Thanks!

You can always update or revise any of the media files by simply
re-uploading the exact same form definition with the new media file.

However, on the ODK Collect side, it may not properly download and process
the CSV unless you have changed the version number of the form (to
communicate that something has changed). We never documented the details
of that behavior, and I don't remember how it works.

It is easy to change the version number of a form (you don't need to delete
the form or any of the data already collected).

THis is described here: https://opendatakit.org/help/form-design/guidelines/

Search for 'version' on that page

( It is apparently missing from the XLSForm.org site )

··· On Sat, Aug 8, 2015 at 8:10 AM, Yaw Anokwa wrote:

Don't think you can without re-downloading the forms. Perhaps your
team could contribute this feature?

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Fri, Aug 7, 2015 at 10:13 AM, bvodkdemo@gmail.com victoria@blueventures.org wrote:

Hi,

I have started using external CSV files uploaded as media to draw my
selection lists from. My question is, is it possible to update these lists
should something change e.g. there is another name to add to a multiple
choice list? The problem we have had in the past is that every time we need
to add a new entry to the multiple choice list we have to load a new
version of the form. Is there a way to update or replace media files?

Thanks!

--

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

Perhaps i'm missing something but if you reload the exact same form definition you get a message saying the form already exists. Is there a way of replacing this without deleting the data?

Also adding a different version, is this possible when using excel and then converting into XML?

··· On Saturday, 8 August 2015 16:10:56 UTC+1, Yaw Anokwa wrote: > Don't think you can without re-downloading the forms. Perhaps your > team could contribute this feature? > > Yaw > -- > Need ODK services? http://nafundi.com provides form design, server > setup, professional support, and software development for ODK. > > On Fri, Aug 7, 2015 at 10:13 AM, bvodkdemo@gmail.com wrote: > > Hi, > > > > I have started using external CSV files uploaded as media to draw my selection lists from. My question is, is it possible to update these lists should something change e.g. there is another name to add to a multiple choice list? The problem we have had in the past is that every time we need to add a new entry to the multiple choice list we have to load a new version of the form. Is there a way to update or replace media files? > > > > Thanks! > > > > -- > > -- > > 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.

It can't be the exact same form. It has to have a different version
number. It's recommended you use strings of the form: 'yyyymmddrr'
e.g., 2015012901 (the 1st revision on January 29, 2015. Search for
version at https://opendatakit.org/help/form-design/guidelines/ to
understand why.

To add to XLSForm, add a "version" header to the settings sheet (e.g.,
C1). Put the version number right below (e.g., C2).

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Tue, Aug 11, 2015 at 7:05 AM, bvodkdemo@blueventures.org victoria@blueventures.org wrote:

Perhaps i'm missing something but if you reload the exact same form definition you get a message saying the form already exists. Is there a way of replacing this without deleting the data?

Also adding a different version, is this possible when using excel and then converting into XML?

On Saturday, 8 August 2015 16:10:56 UTC+1, Yaw Anokwa wrote:

Don't think you can without re-downloading the forms. Perhaps your
team could contribute this feature?

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Fri, Aug 7, 2015 at 10:13 AM, bvodkdemo@gmail.com victoria@blueventures.org wrote:

Hi,

I have started using external CSV files uploaded as media to draw my selection lists from. My question is, is it possible to update these lists should something change e.g. there is another name to add to a multiple choice list? The problem we have had in the past is that every time we need to add a new entry to the multiple choice list we have to load a new version of the form. Is there a way to update or replace media files?

Thanks!

--

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.

I have a situation where I need to update Media file (CSV) of a Form. The data in the CSV File needs to be updated time and again.

I tried to upload new forms with the same name every time I have a updated version of the Media File. It was all good for like 15th time but suddenly it started showing ODKFormAlreadyExistsException

I can't upload a new form (with new form name) and attach a Media File with it and have multiple databases to play with.

Is there a workaround for this scenario??

Aggregate is no longer being updated. Please switch to Central.

The fastest way to solve this particular problem is to try a new form ID. The correct way is to look at your logs and see if they are any hints as to what is happening.