"MySQL for Excel" excel addin to pull ODK Aggregate data?

I just found the MySQL addin for Excel and thought it would be very useful.
In theory, you could create reporting templates in excel and then easily
update the data by refreshing the data.

But I can't get it to connect to my database. I've used the correct
hostname (IP address) and I've tried the default addin port of 3306 as well
as the ODK port of 8080. I've tried the username of the MySQL database as
well as the ODK admin user login details. It never makes the connection.

Anyone have any ideas how to get this to work?

Link to the software info and download:
http://dev.mysql.com/doc/mysql-for-excel/en/

Thank you!
Che

Hi Che,

To make sure the problem isn't the MySQL for Excel plugin try MySQL
Workbench first.

You should also make sure your server is configured to let in DB
connections from outside machines. It probably only allows connections
from localhost. Either change that setting or make an SSH connection
to the machine first, then connect to the DB (localhost over 3306).

Yaw

ยทยทยท -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Mon, Jun 20, 2016 at 9:21 PM, Che Geiser chegeiser@gmail.com wrote:

I just found the MySQL addin for Excel and thought it would be very useful.
In theory, you could create reporting templates in excel and then easily
update the data by refreshing the data.

But I can't get it to connect to my database. I've used the correct hostname
(IP address) and I've tried the default addin port of 3306 as well as the
ODK port of 8080. I've tried the username of the MySQL database as well as
the ODK admin user login details. It never makes the connection.

Anyone have any ideas how to get this to work?

Link to the software info and download:
http://dev.mysql.com/doc/mysql-for-excel/en/

Thank you!
Che

--

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.