Querying collect earth survey results in Saiku

Hi,

I have carried out a survey using Collect Earth. I now have the results and would like to be able to make use of the Saiku Analytics tool to query and presents these results.

I manage to successfully start the Saiku analysis from Collect Earth (Tools > Start SAIKU anlysis). However when I try to query certain things (e.g. land use category vs plot count) I receive an error stating:

SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such column: land_use_use_code.land_use_use_label_).

I don't understand what appears to be the problem here, especially when I export the results from Collect Earth in .csv format there doesn't appear to be any issues.

Any help or suggestions would be much appreciated.

Thanks!!

Marcus

saiku collectearth

asked 28 Feb '19, 16:11

Marcus96
11●1●4
accept rate: 0%

3 Answers:

active answers oldest answers newest answers popular answers

Hi Marcus,

Can you share the CEP file? There might be some issue with the data structure... no need to send the data collected if you don't want to.

permanent link

answered 28 Feb '19, 17:41

Open Foris ♦♦
1.0k●5●7●14
accept rate: 10%

Hi,

Thanks for the quick response.

Here is the CEP file I have been using: https://drive.google.com/open?id=1hGhDB5uMQ26D_lmUE75lnhzP-84IrwsW

I hope you can access it okay.

Thanks!

Marcus

(04 Mar '19, 14:49) Marcus96

0	Hi, Thanks for the quick response. Here is the CEP file I have been using: https://drive.google.com/open?id=1hGhDB5uMQ26D_lmUE75lnhzP-84IrwsW I hope you can access it okay. Thanks! Marcus permanent link answered 01 Mar '19, 10:34 Marcus96 11●1●4 accept rate: 0%

Hi,

There seems to be an error in the survey that it doesn't set the language properly.

Go to Tools->Language->English (even if already set)

Did you edit the survey SML file directly or though the Survey Designer?

Also, you might want to change the names of the land use attributes as they are the same and Saiku cannot use them properly ( you will have to change the names in the special Saiku label section)

Have you collected data already?

permanent link

answered 04 Mar '19, 17:16

Open Foris ♦♦
1.0k●5●7●14
accept rate: 10%

Hi,

Thanks for getting back to me.

I adjusted the language setting as suggested. Also I changed the names of each attribute so they are different. Is this what you meant? Also I have given each of the attributes a "reporting" label for Saiku (in the 'other labels' section for each attribute in the Survey Designer.

To answer your questions:

I edited the survey through the Collect Survey Designer.

Yes, I've already collected data and have output tables.

Still, after making these changes I have the same issue. Does this mean I will have to survey again after making these corrections?

(05 Mar '19, 12:25) Marcus96

Your answer

toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

collectearth ×284
saiku ×42

question asked: 28 Feb '19, 16:11

question was seen: 3,383 times

last updated: 05 Mar '19, 12:25

Querying collect earth survey results in Saiku

Follow this question

Related questions