Querying collect earth survey results in Saiku

Question

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

Answer 1 · 2019-02-28T17:41:33

0

Accepted answer

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.

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

Marcus96 04 Mar '19, 14:49

Answer 2 · 2019-03-01T10:34:47

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

Answer 3 · 2019-03-04T17:16:50

0

Accepted answer

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?

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?

Marcus96 05 Mar '19, 12:25

Querying collect earth survey results in Saiku

3 Answers

Your answer

Insert a link

Insert an image

Follow this question

By Email

By RSS

Open Foris

Question tags

Related questions

Keyboard shortcuts

Anywhere

Lists of questions

Question pages