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.
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.
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.
It is hosted at cmcablr.appspot.com and the form is called "Acts of Active Citizenship V3"
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.
It is hosted at cmcablr.appspot.com and the form is called "Acts of
Active Citizenship V3"
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.
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.
It is hosted at cmcablr.appspot.com and the form is called "Acts of
Active Citizenship V3"
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
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.
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.
It is hosted at cmcablr.appspot.com and the form is called "Acts of
Active Citizenship V3"
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"
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.
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.
It is hosted at cmcablr.appspot.com and the form is called "Acts of
Active Citizenship V3"
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
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]
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
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).
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
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.
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).
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
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.
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).
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
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.
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).
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