Safe to edit selected values on Postgres database?

Support
1

Good day,

I have Aggregate deployed on my own server running Postgres.
During one day of our survey enumerators picked the wrong "town" from a
select-one prompt (similar name for a nearby town).

It is a fairly simple SQL command to correct that batch of submissions.
Assuming I'm only changing the text stored in that submitted field (and in
a calculated field based on that field), can I safely make changes to the
values?
i.e. There are no checksums that Aggregate runs on the data to ensure
nothing has changed

The other option would be to publish data, modify and then push back using
Briefcase, but we have some media files attached which ups the chance of
errors (in my process) and will use a chunk more bandwidth and time.

Thanks,
Andrew

2

Correct. There are no checksums or data integrity checks.

You can directly update the database rows with new user values.

Note that this will not re-publish that data. If you have external
publishers, they will not get these updates.

··· On Thu, May 26, 2016 at 6:31 AM, Andrew wrote:

Good day,

I have Aggregate deployed on my own server running Postgres.
During one day of our survey enumerators picked the wrong "town" from a
select-one prompt (similar name for a nearby town).

It is a fairly simple SQL command to correct that batch of submissions.
Assuming I'm only changing the text stored in that submitted field (and in
a calculated field based on that field), can I safely make changes to the
values?
i.e. There are no checksums that Aggregate runs on the data to ensure
nothing has changed

The other option would be to publish data, modify and then push back using
Briefcase, but we have some media files attached which ups the chance of
errors (in my process) and will use a chunk more bandwidth and time.

Thanks,
Andrew

--

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

3

(but publishers you set up after this revision will see the changes -- any
existing streaming publishers won't).

··· On Thu, May 26, 2016 at 12:08 PM, Mitch Sundt wrote:

Correct. There are no checksums or data integrity checks.

You can directly update the database rows with new user values.

Note that this will not re-publish that data. If you have external
publishers, they will not get these updates.

On Thu, May 26, 2016 at 6:31 AM, Andrew acawood777@gmail.com wrote:

Good day,

I have Aggregate deployed on my own server running Postgres.
During one day of our survey enumerators picked the wrong "town" from a
select-one prompt (similar name for a nearby town).

It is a fairly simple SQL command to correct that batch of submissions.
Assuming I'm only changing the text stored in that submitted field (and
in a calculated field based on that field), can I safely make changes to
the values?
i.e. There are no checksums that Aggregate runs on the data to ensure
nothing has changed

The other option would be to publish data, modify and then push back
using Briefcase, but we have some media files attached which ups the chance
of errors (in my process) and will use a chunk more bandwidth and time.

Thanks,
Andrew

--

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

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

4

Great, thanks for confirming this, and for the note on the publishers.

Regards,
Andrew

··· On Thursday, 26 May 2016 21:09:30 UTC+2, Mitch Sundt wrote: > > (but publishers you set up after this revision will see the changes -- any > existing streaming publishers won't). > > On Thu, May 26, 2016 at 12:08 PM, Mitch Sundt <mitche...@gmail.com > wrote: > >> Correct. There are no checksums or data integrity checks. >> >> You can directly update the database rows with new user values. >> >> Note that this will not re-publish that data. If you have external >> publishers, they will not get these updates. >> >> >> On Thu, May 26, 2016 at 6:31 AM, Andrew <acawo...@gmail.com wrote: >> >>> Good day, >>> >>> I have Aggregate deployed on my own server running Postgres. >>> During one day of our survey enumerators picked the wrong "town" from a >>> select-one prompt (similar name for a nearby town). >>> >>> It is a fairly simple SQL command to correct that batch of submissions. >>> Assuming I'm only changing the text stored in that submitted field (and >>> in a calculated field based on that field), can I safely make changes to >>> the values? >>> i.e. There are no checksums that Aggregate runs on the data to ensure >>> nothing has changed >>> >>> >>> The other option would be to publish data, modify and then push back >>> using Briefcase, but we have some media files attached which ups the chance >>> of errors (in my process) and will use a chunk more bandwidth and time. >>> >>> Thanks, >>> Andrew >>> >>> -- >>> -- >>> 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. >>> >> >> >> >> -- >> Mitch Sundt >> Software Engineer >> University of Washington >> mitche...@gmail.com >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >