Update files .csv in a form currently uploaded to aggregate

Hello,

I have created a form that refers to 4 .csv files, sometimes these .csv files need to be updated and they change, but keeping the same name.

Changing the .csv directly into the odk folder of my tablet works, I delete the old .csv file and I paste the new one.

The problem is into aggregate. Once I've uploaded the form and the .csv files into aggregate, I don't know how to update the .csv, because if I delete the form I lose all the data I've already colected, and I can't upload a file with the same name.

Do you Know how to solve this problem?

Thank you very much!

Files associated with the form definition are not strictly
version-controlled.

You can overwrite them by:

  1. Go to the Form Management tab
  2. Click on "Add New Form"
  3. Specify exactly the same form definition file as you are already using
    (if needed, download the form definition and then select the file you just
    downloaded)
  4. Specify the csv files (or any subset of the form definition's media
    files) you want to update.

This overwrites the existing files with the new files while preserving your
form definition.

If the files are interrelated or need to be updated together on a device,
you should uncheck the "Downloadable" checkbox while doing this to ensure
that no device attempts to download the updated form definition during this
upload (and possibly get only one of the changed files) while you are doing
this change. Once the upload succeeds, you can then check the
"Downloadable" checkbox, and devices will then be able to download the new
files.

If you want to track the version of the csv files in your filled-in form
submissions, you could update the version in your form definition at the
same time you update your csv files and use the form version to track the
version of the csv in use.

··· On Thu, Jul 2, 2015 at 1:54 AM, wrote:

Hello,

I have created a form that refers to 4 .csv files, sometimes these .csv
files need to be updated and they change, but keeping the same name.

Changing the .csv directly into the odk folder of my tablet works, I
delete the old .csv file and I paste the new one.

The problem is into aggregate. Once I've uploaded the form and the .csv
files into aggregate, I don't know how to update the .csv, because if I
delete the form I lose all the data I've already colected, and I can't
upload a file with the same name.

Do you Know how to solve this problem?

Thank you very much!

--

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

Lomiode,

With little addition to the ODK collect you can add functionality to
UPDATE/OVERRIDE existing CSV(s) files in device's internal storage.

This would be the flow:

  1. Set up a URL that offers a CSV file for download (using existing records
    needed to be in CSV).
  2. Device reaches this URL and accepts file for download.
  3. Stores file with right name to the device's internal storage.

Benefit for this would be to make whole process automatic with very little
intervention involved with making CSV files i.e. manually.

Regards,
Ayub

Thank you very much!

It works properly!

Thank you very much for all your comments!!!

I've tried changing the version of the form and the .csv still don't get
updated

Christopher Robert what is the survey CTO?

··· El jueves, 9 de julio de 2015, 7:25:03 (UTC+2), Ayub escribió: > > Lomiode, > > With little addition to the ODK collect you can add functionality to > UPDATE/OVERRIDE existing CSV(s) files in device's internal storage. > > This would be the flow: > > 1) Set up a URL that offers a CSV file for download (using existing > records needed to be in CSV). > 2) Device reaches this URL and accepts file for download. > 3) Stores file with right name to the device's internal storage. > > Benefit for this would be to make whole process automatic with very little > intervention involved with making CSV files i.e. manually. > > Regards, > Ayub >

Hello again Mitch!

I've tried to upload the new .csv into aggregate and it seems to work, but
when I try to fill the form in my smart phone the csv that I find is the
same one I uploaded the first time, even with other smartphones I've
downloaded the form from aggregate and I don't have the updated version.

It doesn't seem to overwrite the existing forms.

Do you know why?

Thank you very much

··· El lunes, 6 de julio de 2015, 12:26:45 (UTC+2), Lomoide Lomotero escribió: > > > Thank you very much! >> > > It works properly! >

Hi Lomiode,

SurveyCTO is an extended, more-heavily-documented version of ODK that's
professionally hosted and supported. As you've seen, ODK is an incredible
platform, and in general we've tried to expand its reach so that less
technical users might be able to use it more easily and effectively. See
our website (http://www.surveycto.com) or our blog (
http://blog.surveycto.com) for more.

[ In the interest of full disclosure: SurveyCTO is built on the ODK 1.x
platform but adds support for certain new types of data flow, allows for
flexible form updates, and generally tries to relax some of the key
limitations present in the 1.0 platform; the core ODK team has been doing
amazing things with the 2.0 platform to allow for greater customizability
and more flexible data flows, and that platform may be the ideal solution
for many new types of application moving forward. So our team has been
focused on 1.x+ while the core ODK team has been focused on 2.0. Hope that
makes sense! ]

Best,

Chris

··· --- Christopher Robert Dobility, Inc. (SurveyCTO) http://www.surveycto.com/ http://blog.surveycto.com/

On Fri, Jul 10, 2015 at 9:06 AM Lomoide Lomotero olmoide@gmail.com wrote:

Thank you very much for all your comments!!!

I've tried changing the version of the form and the .csv still don't get
updated

Christopher Robert what is the survey CTO?

El jueves, 9 de julio de 2015, 7:25:03 (UTC+2), Ayub escribió:

Lomiode,

With little addition to the ODK collect you can add functionality to
UPDATE/OVERRIDE existing CSV(s) files in device's internal storage.

This would be the flow:

  1. Set up a URL that offers a CSV file for download (using existing
    records needed to be in CSV).
  2. Device reaches this URL and accepts file for download.
  3. Stores file with right name to the device's internal storage.

Benefit for this would be to make whole process automatic with very
little intervention involved with making CSV files i.e. manually.

Regards,
Ayub

--

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.

Thank you very much for all your comments!!!

I've tried changing the version of the form and the .csv still don't get updated

Christopher Robert what is the survey CTO?

Lomiode,

With little addition to the ODK collect you can add functionality to UPDATE/OVERRIDE existing CSV(s) files in device's internal storage.

This would be the flow:

  1. Set up a URL that offers a CSV file for download (using existing records needed to be in CSV).
  2. Device reaches this URL and accepts file for download.
  3. Stores file with right name to the device's internal storage.

Benefit for this would be to make whole process automatic with very little intervention involved with making CSV files i.e. manually.

Regards,
Ayub

Is this still the latest situation? Is the csv not updated on the ODK collect even if it is changed on Aggregate?

Aurelio

··· Il giorno venerdì 10 luglio 2015 15:06:34 UTC+2, Lomoide Lomotero ha scritto: > El jueves, 9 de julio de 2015, 7:25:03 (UTC+2), Ayub escribió:

That code was contributed. Perhaps one of the contributors will chime in?

··· On Wed, Jul 8, 2015 at 12:56 AM, Lomoide Lomotero wrote:

Hello again Mitch!

I've tried to upload the new .csv into aggregate and it seems to work, but
when I try to fill the form in my smart phone the csv that I find is the
same one I uploaded the first time, even with other smartphones I've
downloaded the form from aggregate and I don't have the updated version.

It doesn't seem to overwrite the existing forms.

Do you know why?

Thank you very much

El lunes, 6 de julio de 2015, 12:26:45 (UTC+2), Lomoide Lomotero escribió:

Thank you very much!

It works properly!

--

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

Hi Aurelio,

I haven't tested this, but it's likely still the case. I've filed an
issue here: https://github.com/opendatakit/collect/issues/822.

If this is an important issue for you, please check the behavior and
report what you find on that issue. Include the versions of Collect
and Aggregate you tested and include the test forms. If the CSV is
indeed not updated, then we can look at fixing it.

Thanks,

Yaw

··· On Wed, Mar 22, 2017 at 1:32 AM, wrote: > Il giorno venerdì 10 luglio 2015 15:06:34 UTC+2, Lomoide Lomotero ha scritto: >> Thank you very much for all your comments!!! >> >> >> I've tried changing the version of the form and the .csv still don't get updated >> >> >> Christopher Robert what is the survey CTO? >> >> El jueves, 9 de julio de 2015, 7:25:03 (UTC+2), Ayub escribió: >> Lomiode, >> >> >> With little addition to the ODK collect you can add functionality to UPDATE/OVERRIDE existing CSV(s) files in device's internal storage. >> >> >> This would be the flow: >> >> >> 1) Set up a URL that offers a CSV file for download (using existing records needed to be in CSV). >> 2) Device reaches this URL and accepts file for download. >> 3) Stores file with right name to the device's internal storage. >> >> >> Benefit for this would be to make whole process automatic with very little intervention involved with making CSV files i.e. manually. >> >> >> Regards, >> Ayub > > Is this still the latest situation? Is the csv not updated on the ODK collect even if it is changed on Aggregate? > > Aurelio > > -- > -- > 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 was my impression that Aggregate required the form's version number to
be updated whenever changing an attachment -- except for some brief window
of time after a form definition was first uploaded (maybe 10 minutes?). I
believe that neither Collect nor Aggregate will react particularly well to
attempts to change the attachments to a form without updating the form's
version. (From Collect's point of view, if a particular form version has
already been downloaded, why would it re-download attachments it already
thinks it has?)

I would suggest that you try bumping up the version number of the form
definition at the same time that you change its attachment(s). Then, when
you re-download the form onto a device, you should be able to verify that
(a) it shows the new version number and (b) the new attachment(s) are there.

SurveyCTO has added separate version tracking for datasets attached to
forms -- plus automatic updating from the Collect side -- in order to make
this whole process a bit more seamless: data attached to forms can be
updated independently of the form itself (and, in many cases,
automatically). But for the core ODK system, the 2.0 framework is where
you'll find more flexible data flows; for now, you'll need to manually
update form versions as you change attached data.

Best,

Chris

··· --- Christopher Robert Dobility, Inc. (SurveyCTO) http://www.surveycto.com/ http://blog.surveycto.com/

On Wed, Jul 8, 2015 at 12:04 PM Mitch Sundt mitchellsundt@gmail.com wrote:

That code was contributed. Perhaps one of the contributors will chime in?

On Wed, Jul 8, 2015 at 12:56 AM, Lomoide Lomotero olmoide@gmail.com wrote:

Hello again Mitch!

I've tried to upload the new .csv into aggregate and it seems to work,
but when I try to fill the form in my smart phone the csv that I find is
the same one I uploaded the first time, even with other smartphones I've
downloaded the form from aggregate and I don't have the updated version.

It doesn't seem to overwrite the existing forms.

Do you know why?

Thank you very much

El lunes, 6 de julio de 2015, 12:26:45 (UTC+2), Lomoide Lomotero escribió:

Thank you very much!

It works properly!

--

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.