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

asked 28 Feb '19, 16:11

Marcus96's gravatar image

Marcus96
1114
accept rate: 0%


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%20Foris's gravatar image

Open Foris ♦♦
1.0k5714
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 Marcus96's gravatar image

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's gravatar image

Marcus96
1114
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%20Foris's gravatar image

Open Foris ♦♦
1.0k5714
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 Marcus96's gravatar image
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

Question tags:

×284
×42

question asked: 28 Feb '19, 16:11

question was seen: 3,379 times

last updated: 05 Mar '19, 12:25