Google spreadsheets (and Fusion Table) not showing image URL in table

Hi,
I have been ODK for the past few months and its been going smoothly. Right now, I have a form in which there are three photo questions, all of them skippable. I have uploaded 10 entries with photos on the server, and when I export the csv on the appspot site, it shows the image URLs.

However, the published spreadsheet at my google drive only showed the URL to the first photo and left the other URLs blank. All the other fields are filling up properly.

Please advise me what to do to correct this.

Unless you have customized the source code of ODK Aggregate or ODK Collect,
this question should be asked on the opendatakit@ list. Please use that
list in follow-ups.

  • what version of ODK Aggregate are you using? If an older version, please
    upgrade to the latest.

  • did you customize anything?

  • from your screen shots, it is hard to verify that the data rows
    correspond. Note that if you upload a record to ODK Aggregate, then delete
    it on the server, if you have set up publishers, the deleted row may or may
    not be published to the downstream service (Google Spreadsheets / Google
    Fusion Tables). It is timing-dependent.

Can you repeat this by creating two new publishers now, one into Fusion
Tables, one into Google Spreadsheets, (publishing both existing and
streaming of new records)?

  • did you specify any filters when creating the publishers?
··· On Tue, Nov 18, 2014 at 7:20 PM, wrote:

Hi,
I have been ODK for the past few months and its been going smoothly.
Right now, I have a form in which there are three photo questions, all of
them skippable. I have uploaded 10 entries with photos on the server, and
when I export the csv on the appspot site, it shows the image URLs.

However, the published spreadsheet at my google drive only showed the URL
to the first photo and left the other URLs blank. All the other fields are
filling up properly.

Please advise me what to do to correct this.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

Hi Mitch,
I will use the other list for later follow-ups.

-Currently, I am using Aggregate 1.4.3 Production, and it has not been giving me this problem on another similar server I am using, hosted elsewhere.

-No customization of any kind

-The data records do correspond. The issue is that apart from the 2nd row, all the other rows have the image URL data missing. However, when I export to CSV, all the data is perfectly intact.

-I tried publishing to spreadsheets and fusion tables multiple times, however, the same issue persists.

-No filters have been applied.

If you are able, please invite me ( mitchellsundt@gmail.com ) as a
developer on that appspot instance, and also add me with form management
permissions on the Aggregate (so I can set up my own publishers).

I will take a look at the logs.

I have no idea what could be causing this, as the code makes no distinction
between the 1st and any subsequent image attachments in a submission.

··· On Sun, Nov 23, 2014 at 4:05 AM, wrote:

Hi Mitch,
I will use the other list for later follow-ups.

-Currently, I am using Aggregate 1.4.3 Production, and it has not been
giving me this problem on another similar server I am using, hosted
elsewhere.

-No customization of any kind

-The data records do correspond. The issue is that apart from the 2nd
row, all the other rows have the image URL data missing. However, when I
export to CSV, all the data is perfectly intact.

-I tried publishing to spreadsheets and fusion tables multiple times,
however, the same issue persists.

-No filters have been applied.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

I have added you to both aggregate and the appengine instance.

Yeah, I really have no clue what's causing the problem either. I thought it
might be something obvious I am missing.

··· On 24-Nov-2014 11:12 pm, "Mitch Sundt" wrote:

If you are able, please invite me ( mitchellsundt@gmail.com ) as a
developer on that appspot instance, and also add me with form management
permissions on the Aggregate (so I can set up my own publishers).

I will take a look at the logs.

I have no idea what could be causing this, as the code makes no
distinction between the 1st and any subsequent image attachments in a
submission.

On Sun, Nov 23, 2014 at 4:05 AM, saurabhmaurya06@gmail.com wrote:

Hi Mitch,
I will use the other list for later follow-ups.

-Currently, I am using Aggregate 1.4.3 Production, and it has not been
giving me this problem on another similar server I am using, hosted
elsewhere.

-No customization of any kind

-The data records do correspond. The issue is that apart from the 2nd
row, all the other rows have the image URL data missing. However, when I
export to CSV, all the data is perfectly intact.

-I tried publishing to spreadsheets and fusion tables multiple times,
however, the same issue persists.

-No filters have been applied.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/n4Tgszv98kQ/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi,
I made a big mistake (same field name in two non-repeating groups, data not transferring in Fusion Tables) and I would like to know if it's possible to extract these data with a workaround. I've got around 2 000 rows and this data is pretty important to me since someone has collect these data on the field.
Thanks
Alex

OK. Found the problem. I've updated our Data Transfer page (
https://opendatakit.org/use/aggregate/data-transfer/ ) with this
clarification:

Non-repeating grouping information is not preserved! This implies that if
your form has a non-repeating group "purchaser" and a second non-repeating
group "supplier" and within each of these groups, you have a "name" field,
then when you publish to Fusion Tables, there will be two columns called
"name." Unfortunately, that badly confuses Fusion Tables, and generally
results in data not transferring successfully into Fusion Tables. The
solution is to design your forms with field names like "purchaser_name" and
"supplier_name"

··· On Mon, Nov 24, 2014 at 9:49 AM, saurabhmaurya94 . < saurabhmaurya06@gmail.com> wrote:

I have added you to both aggregate and the appengine instance.

Yeah, I really have no clue what's causing the problem either. I thought
it might be something obvious I am missing.
On 24-Nov-2014 11:12 pm, "Mitch Sundt" mitchellsundt@gmail.com wrote:

If you are able, please invite me ( mitchellsundt@gmail.com ) as a
developer on that appspot instance, and also add me with form management
permissions on the Aggregate (so I can set up my own publishers).

I will take a look at the logs.

I have no idea what could be causing this, as the code makes no
distinction between the 1st and any subsequent image attachments in a
submission.

On Sun, Nov 23, 2014 at 4:05 AM, saurabhmaurya06@gmail.com wrote:

Hi Mitch,
I will use the other list for later follow-ups.

-Currently, I am using Aggregate 1.4.3 Production, and it has not been
giving me this problem on another similar server I am using, hosted
elsewhere.

-No customization of any kind

-The data records do correspond. The issue is that apart from the 2nd
row, all the other rows have the image URL data missing. However, when I
export to CSV, all the data is perfectly intact.

-I tried publishing to spreadsheets and fusion tables multiple times,
however, the same issue persists.

-No filters have been applied.

--
You received this message because you are subscribed to the Google
Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/n4Tgszv98kQ/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

And, in your instance, the issue is with Image_1/Photograph and
Image_2/Photograph.

You would need Image_1/Photograph_1 and Image_2/Photograph_2 in order for
the publishing to work.

and the same for Caption_1, Caption_2

··· On Mon, Nov 24, 2014 at 10:26 AM, Mitch Sundt wrote:

OK. Found the problem. I've updated our Data Transfer page (
https://opendatakit.org/use/aggregate/data-transfer/ ) with this
clarification:

Non-repeating grouping information is not preserved! This implies that if
your form has a non-repeating group "purchaser" and a second non-repeating
group "supplier" and within each of these groups, you have a "name" field,
then when you publish to Fusion Tables, there will be two columns called
"name." Unfortunately, that badly confuses Fusion Tables, and generally
results in data not transferring successfully into Fusion Tables. The
solution is to design your forms with field names like "purchaser_name" and
"supplier_name"

On Mon, Nov 24, 2014 at 9:49 AM, saurabhmaurya94 . < saurabhmaurya06@gmail.com> wrote:

I have added you to both aggregate and the appengine instance.

Yeah, I really have no clue what's causing the problem either. I thought
it might be something obvious I am missing.
On 24-Nov-2014 11:12 pm, "Mitch Sundt" mitchellsundt@gmail.com wrote:

If you are able, please invite me ( mitchellsundt@gmail.com ) as a
developer on that appspot instance, and also add me with form management
permissions on the Aggregate (so I can set up my own publishers).

I will take a look at the logs.

I have no idea what could be causing this, as the code makes no
distinction between the 1st and any subsequent image attachments in a
submission.

On Sun, Nov 23, 2014 at 4:05 AM, saurabhmaurya06@gmail.com wrote:

Hi Mitch,
I will use the other list for later follow-ups.

-Currently, I am using Aggregate 1.4.3 Production, and it has not been
giving me this problem on another similar server I am using, hosted
elsewhere.

-No customization of any kind

-The data records do correspond. The issue is that apart from the 2nd
row, all the other rows have the image URL data missing. However, when I
export to CSV, all the data is perfectly intact.

-I tried publishing to spreadsheets and fusion tables multiple times,
however, the same issue persists.

-No filters have been applied.

--
You received this message because you are subscribed to the Google
Groups "ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

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

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/n4Tgszv98kQ/unsubscribe
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+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

OK will take care of the above in the future.

Thanks a lot Mitch!

Alex,

Maybe you can provide a few examples of what the data currently look
likes in Aggregate and in Fusion Tables, and what it should look like?

Yaw

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

On Mon, Aug 3, 2015 at 8:53 AM, ngelec.collect@gmail.com wrote:

Hi,
I made a big mistake (same field name in two non-repeating groups, data not transferring in Fusion Tables) and I would like to know if it's possible to extract these data with a workaround. I've got around 2 000 rows and this data is pretty important to me since someone has collect these data on the field.
Thanks
Alex

--

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.

Hi,

Thank you for your reply.

You see in ODK Aggregate print screen there are numbers in the column decoratif
lamp_num but those numbers are not transferring in Fusion Table since
there is two column with the same name (Lamp_num).

I hope this will help.

[image: Inline image 1]

Noting in both column "Lamp_num"
[image: Inline image 2]

··· On Mon, Aug 3, 2015 at 10:08 AM, Yaw Anokwa wrote:

Alex,

Maybe you can provide a few examples of what the data currently look
likes in Aggregate and in Fusion Tables, and what it should look like?

Yaw

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

On Mon, Aug 3, 2015 at 8:53 AM, ngelec.collect@gmail.com wrote:

Hi,
I made a big mistake (same field name in two non-repeating groups, data
not transferring in Fusion Tables) and I would like to know if it's
possible to extract these data with a workaround. I've got around 2 000
rows and this data is pretty important to me since someone has collect
these data on the field.
Thanks
Alex

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/GpBxKyr48H8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Alex,

Easiest fix is probably to export the data from Aggregate as a CSV and
copy and paste that column into Fusion Tables.

Yaw

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

On Mon, Aug 3, 2015 at 9:34 AM, Alexandre Giasson ngelec.collect@gmail.com wrote:

Hi,

Thank you for your reply.

You see in ODK Aggregate print screen there are numbers in the column
decoratif lamp_num but those numbers are not transferring in Fusion Table
since there is two column with the same name (Lamp_num).

I hope this will help.

Noting in both column "Lamp_num"

On Mon, Aug 3, 2015 at 10:08 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Alex,

Maybe you can provide a few examples of what the data currently look
likes in Aggregate and in Fusion Tables, and what it should look like?

Yaw

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

On Mon, Aug 3, 2015 at 8:53 AM, ngelec.collect@gmail.com wrote:

Hi,
I made a big mistake (same field name in two non-repeating groups, data
not transferring in Fusion Tables) and I would like to know if it's possible
to extract these data with a workaround. I've got around 2 000 rows and this
data is pretty important to me since someone has collect these data on the
field.
Thanks
Alex

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/GpBxKyr48H8/unsubscribe.
To unsubscribe from this group and all its topics, 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.

Has I know, it's not possible to Export grouping in .CSV. Only the maine
table is exported. That's why a use Publishing Fonction.

CSV (comma-separated values)
https://opendatakit.org/use/aggregate/data-transfer/#CSV_(comma-separated_values)

CSV files are a text only, tabular representation of the data. Multimedia
files are represented by including standard web links to the files. Repeats
are also represented with links to the underlying data. Grouping
information is not preserved. Metadata is only preserved if a filter is
created with the metadata.

··· On Mon, Aug 3, 2015 at 8:01 PM, Yaw Anokwa wrote:

Alex,

Easiest fix is probably to export the data from Aggregate as a CSV and
copy and paste that column into Fusion Tables.

Yaw

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

On Mon, Aug 3, 2015 at 9:34 AM, Alexandre Giasson ngelec.collect@gmail.com wrote:

Hi,

Thank you for your reply.

You see in ODK Aggregate print screen there are numbers in the column
decoratif lamp_num but those numbers are not transferring in Fusion
Table
since there is two column with the same name (Lamp_num).

I hope this will help.

Noting in both column "Lamp_num"

On Mon, Aug 3, 2015 at 10:08 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Alex,

Maybe you can provide a few examples of what the data currently look
likes in Aggregate and in Fusion Tables, and what it should look like?

Yaw

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

On Mon, Aug 3, 2015 at 8:53 AM, ngelec.collect@gmail.com wrote:

Hi,
I made a big mistake (same field name in two non-repeating groups,
data

not transferring in Fusion Tables) and I would like to know if it's
possible

to extract these data with a workaround. I've got around 2 000 rows
and this

data is pretty important to me since someone has collect these data
on the

field.
Thanks
Alex

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/GpBxKyr48H8/unsubscribe.
To unsubscribe from this group and all its topics, 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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/GpBxKyr48H8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Alex,

Use ODK Briefcase to download the data. It'll get the repeat data as a CSV.

Yaw

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

On Mon, Aug 3, 2015 at 8:38 PM, Alexandre Giasson ngelec.collect@gmail.com wrote:

Has I know, it's not possible to Export grouping in .CSV. Only the maine
table is exported. That's why a use Publishing Fonction.

CSV (comma-separated values)

CSV files are a text only, tabular representation of the data. Multimedia
files are represented by including standard web links to the files. Repeats
are also represented with links to the underlying data. Grouping information
is not preserved. Metadata is only preserved if a filter is created with the
metadata.

On Mon, Aug 3, 2015 at 8:01 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Alex,

Easiest fix is probably to export the data from Aggregate as a CSV and
copy and paste that column into Fusion Tables.

Yaw

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

On Mon, Aug 3, 2015 at 9:34 AM, Alexandre Giasson ngelec.collect@gmail.com wrote:

Hi,

Thank you for your reply.

You see in ODK Aggregate print screen there are numbers in the column
decoratif lamp_num but those numbers are not transferring in Fusion
Table
since there is two column with the same name (Lamp_num).

I hope this will help.

Noting in both column "Lamp_num"

On Mon, Aug 3, 2015 at 10:08 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Alex,

Maybe you can provide a few examples of what the data currently look
likes in Aggregate and in Fusion Tables, and what it should look like?

Yaw

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

On Mon, Aug 3, 2015 at 8:53 AM, ngelec.collect@gmail.com wrote:

Hi,
I made a big mistake (same field name in two non-repeating groups,
data
not transferring in Fusion Tables) and I would like to know if it's
possible
to extract these data with a workaround. I've got around 2 000 rows
and this
data is pretty important to me since someone has collect these data
on the
field.
Thanks
Alex

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/GpBxKyr48H8/unsubscribe.
To unsubscribe from this group and all its topics, 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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/GpBxKyr48H8/unsubscribe.
To unsubscribe from this group and all its topics, 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.

Yaw,

You are THE MAN!

I've been able to recover all my data flawlessly!

Thank you very very much!

··· On Mon, Aug 3, 2015 at 9:45 PM, Yaw Anokwa wrote:

Alex,

Use ODK Briefcase to download the data. It'll get the repeat data as a CSV.

Yaw

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

On Mon, Aug 3, 2015 at 8:38 PM, Alexandre Giasson ngelec.collect@gmail.com wrote:

Has I know, it's not possible to Export grouping in .CSV. Only the maine
table is exported. That's why a use Publishing Fonction.

CSV (comma-separated values)

CSV files are a text only, tabular representation of the data. Multimedia
files are represented by including standard web links to the files.
Repeats
are also represented with links to the underlying data. Grouping
information
is not preserved. Metadata is only preserved if a filter is created with
the
metadata.

On Mon, Aug 3, 2015 at 8:01 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Alex,

Easiest fix is probably to export the data from Aggregate as a CSV and
copy and paste that column into Fusion Tables.

Yaw

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

On Mon, Aug 3, 2015 at 9:34 AM, Alexandre Giasson ngelec.collect@gmail.com wrote:

Hi,

Thank you for your reply.

You see in ODK Aggregate print screen there are numbers in the column
decoratif lamp_num but those numbers are not transferring in Fusion
Table
since there is two column with the same name (Lamp_num).

I hope this will help.

Noting in both column "Lamp_num"

On Mon, Aug 3, 2015 at 10:08 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Alex,

Maybe you can provide a few examples of what the data currently look
likes in Aggregate and in Fusion Tables, and what it should look
like?

Yaw

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

On Mon, Aug 3, 2015 at 8:53 AM, ngelec.collect@gmail.com wrote:

Hi,
I made a big mistake (same field name in two non-repeating groups,
data
not transferring in Fusion Tables) and I would like to know if it's
possible
to extract these data with a workaround. I've got around 2 000 rows
and this
data is pretty important to me since someone has collect these data
on the
field.
Thanks
Alex

--

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 a topic in
the

Google Groups "ODK Community" group.
To unsubscribe from this topic, visit

https://groups.google.com/d/topic/opendatakit/GpBxKyr48H8/unsubscribe.

To unsubscribe from this group and all its topics, 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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/GpBxKyr48H8/unsubscribe.
To unsubscribe from this group and all its topics, 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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/GpBxKyr48H8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.