Import csv file data into Aggregate

I looked into both Aggregate and Briefcase but couldn't find a way to
'import from csv". I see "export to csv" feature.

Is there import csv file data into Aggregate?

Thanks
Jaideep

Correct. There is not.

Data input is expected to be done via ODK Collect. ODK Aggregate and
Briefcase hold data-of-record from the ODK Collect data collection process,
and provide mechanisms to export that data into other systems for further
analysis.

(In ODK 2.0, the ODK Tables tool has an import-from-csv capability via the
'+' on the ODK Tables table manager screen. And external applications can
upload data to ODK Tables using the 2.0 REST API.)

··· On Thu, Apr 30, 2015 at 4:02 AM, Jaideep Baphna, CFA wrote:

I looked into both Aggregate and Briefcase but couldn't find a way to
'import from csv". I see "export to csv" feature.

Is there import csv file data into Aggregate?

Thanks
Jaideep

--

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

Am facing a similar challenge. i accidentally deleted my form from the Aggregate. i recovered it and now have the csv file. i would like to know how exactly i can import it back to Aggregate.

Jaideep,

While this functionality is not built in, there are plenty of ways to
move CSV data in and out of ODK. What precisely are you trying to
accomplish?

Yaw

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

On Thu, Apr 30, 2015 at 11:53 AM, Mitch Sundt mitchellsundt@gmail.com wrote:

Correct. There is not.

Data input is expected to be done via ODK Collect. ODK Aggregate and
Briefcase hold data-of-record from the ODK Collect data collection process,
and provide mechanisms to export that data into other systems for further
analysis.

(In ODK 2.0, the ODK Tables tool has an import-from-csv capability via the
'+' on the ODK Tables table manager screen. And external applications can
upload data to ODK Tables using the 2.0 REST API.)

On Thu, Apr 30, 2015 at 4:02 AM, Jaideep Baphna, CFA jbaphna@gmail.com wrote:

I looked into both Aggregate and Briefcase but couldn't find a way to
'import from csv". I see "export to csv" feature.

Is there import csv file data into Aggregate?

Thanks
Jaideep

--

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.

The easiest thing to do is look at the CSV and enter that data into a
blank form with ODK Collect.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Wed, Jun 15, 2016 at 9:29 AM, ofoemma@gmail.com wrote:

Am facing a similar challenge. i accidentally deleted my form from the Aggregate. i recovered it and now have the csv file. i would like to know how exactly i can import it back to Aggregate.

--

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 -- thanks, the tables approach might work for us. We are planning to
use ODK 2.0 Survey with Aggregate 1.4.6. Will start looking at Tables too.

@Yaw -- we need to import historic data and also data from a parallel
system that won't be integrated into ODK.

··· On Friday, May 1, 2015 at 12:26:27 AM UTC+5:30, Yaw Anokwa wrote: > > Jaideep, > > While this functionality is not built in, there are plenty of ways to > move CSV data in and out of ODK. What precisely are you trying to > accomplish? > > Yaw > -- > Need ODK services? http://nafundi.com provides form design, server > setup, professional support, and software development for ODK. > > On Thu, Apr 30, 2015 at 11:53 AM, Mitch Sundt <mitche...@gmail.com > wrote: > > Correct. There is not. > > > > Data input is expected to be done via ODK Collect. ODK Aggregate and > > Briefcase hold data-of-record from the ODK Collect data collection > process, > > and provide mechanisms to export that data into other systems for > further > > analysis. > > > > (In ODK 2.0, the ODK Tables tool has an import-from-csv capability via > the > > '+' on the ODK Tables table manager screen. And external applications > can > > upload data to ODK Tables using the 2.0 REST API.) > > > > > > On Thu, Apr 30, 2015 at 4:02 AM, Jaideep Baphna, CFA <jba...@gmail.com > wrote: > >> > >> I looked into both Aggregate and Briefcase but couldn't find a way to > >> 'import from csv". I see "export to csv" feature. > >> > >> Is there import csv file data into Aggregate? > >> > >> Thanks > >> Jaideep > >> > >> -- > >> -- > >> 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 > > > > -- > > -- > > 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. >

The easiest thing to do is look at the CSV and enter that data into a
blank form with ODK Collect.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

Am facing a similar challenge. i accidentally deleted my form from the Aggregate. i recovered it and now have the csv file. i would like to know how exactly i can import it back to Aggregate.

--

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.

@ Yaw. I have a similar issue but in entering the data into a blank form on odk collect the photo and description was okay to enter. IT's the location that i can't enter since the blank form has to take a new location. any further assisstance ?

··· On Thursday, 23 June 2016 10:44:13 UTC, Yaw Anokwa wrote: > On Wed, Jun 15, 2016 at 9:29 AM, wrote:

Not sure it is documented anywhere....

You need to first define your table, with all of its columns. This is
easiest done by creating a form for the table, even if you never use it. If
the form id is the same as the table id, the application designer will
write out a definition.csv and properties.csv that is used when Tables
starts up to create the table. Once the table is created, you can then
import the csv (it looks for it under the assets/csv directory, filename is
tableid.csv or tableid.qualifier.csv).

The csv file does not need to have all the columns that are present in the
table definition -- any columns omitted will be assigned null values.

The dates and date times in the file need to be in iso8601 format, (in
UTC), or perhaps that format with 6 extra trailing zeros:

2015-05-01T09:50:02.000000000

Time zone information needs to be managed separately. The web view always
renders times in device local time; we use UTC to store time so that we
don't have to worry about the device that collected it. We intend to
provide a property to report the device time zone so that if your
deployment does span multiple time zones, you can handle the time
information in whatever way is appropriate for your needs.

If you have any trouble with it, just ask. There are undoubtedly quirks
that we have been working with for years and no longer even notice.

Mitch

··· On Thu, Apr 30, 2015 at 11:54 PM, Jaideep Baphna, CFA wrote:

Mitch -- thanks, the tables approach might work for us. We are planning to
use ODK 2.0 Survey with Aggregate 1.4.6. Will start looking at Tables too.

@Yaw -- we need to import historic data and also data from a parallel
system that won't be integrated into ODK.

On Friday, May 1, 2015 at 12:26:27 AM UTC+5:30, Yaw Anokwa wrote:

Jaideep,

While this functionality is not built in, there are plenty of ways to
move CSV data in and out of ODK. What precisely are you trying to
accomplish?

Yaw

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

On Thu, Apr 30, 2015 at 11:53 AM, Mitch Sundt mitche...@gmail.com wrote:

Correct. There is not.

Data input is expected to be done via ODK Collect. ODK Aggregate and
Briefcase hold data-of-record from the ODK Collect data collection
process,
and provide mechanisms to export that data into other systems for
further
analysis.

(In ODK 2.0, the ODK Tables tool has an import-from-csv capability via
the
'+' on the ODK Tables table manager screen. And external applications
can
upload data to ODK Tables using the 2.0 REST API.)

On Thu, Apr 30, 2015 at 4:02 AM, Jaideep Baphna, CFA jba...@gmail.com wrote:

I looked into both Aggregate and Briefcase but couldn't find a way to
'import from csv". I see "export to csv" feature.

Is there import csv file data into Aggregate?

Thanks
Jaideep

--

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

--

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.

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

Hi Fummy,

Your issue is different enough that you should send a new email or
start a new post.

In that post, please describe the high-level problem you are trying to
solve. It sounds like you want to enter location manually? Or load it
into a form from CSV?

Yaw

··· On Tue, Mar 14, 2017 at 3:12 AM, Fummy wrote: > On Thursday, 23 June 2016 10:44:13 UTC, Yaw Anokwa wrote: >> The easiest thing to do is look at the CSV and enter that data into a >> blank form with ODK Collect. >> >> Yaw >> -- >> Need ODK consultants? Nafundi provides form design, server setup, >> in-field training, and software development for ODK. Go to >> https://nafundi.com to get started. >> >> >> On Wed, Jun 15, 2016 at 9:29 AM, wrote: >> > Am facing a similar challenge. i accidentally deleted my form from the Aggregate. i recovered it and now have the csv file. i would like to know how exactly i can import it back to Aggregate. >> > >> > -- >> > -- >> > 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. > > @ Yaw. I have a similar issue but in entering the data into a blank form on odk collect the photo and description was okay to enter. IT's the location that i can't enter since the blank form has to take a new location. any further assisstance ? > > -- > -- > 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.

Cc: @yanokwa

Were you able to accomplish this?

I am wondering what functionalities differ with the new ODK 2.0 please