CSV linked imports for some reason do not seem to be stable regards column
headings in Access. (GPS has colons in the csv column headings which may
have something to do with it). Queries and reports break down when column
headings change for no apparent reason.
Does anyone have any ideas why this is happening or how to get around it?
One solution i have tried.
Linking access directly to MySQL aggregate database online from Access.
This worked and imported the raw tables however its very slow.
I could replicate my online aggregate database onto a local server and then
link, but im not that familiar with replication.
http://dev.mysql.com/doc/refman/5.0/en/replication.html
Has anyone tried doing this? Any tips?
I do NOT want the main data collection aggregate to be hosted locally due
to connection local uptime issues and i want the security of a properly
backed up cloud copy.
Best,
Sean
···
--
Notice: The information contained in this e-mail and/or documents which
accompany it is confidential, may be privileged, proprietary and exempt
from disclosure, and is intended for the exclusive use of the person or
persons to whom it is addressed. If you are not the intended recipient or
if you have received this message in error for any reason, please advise us
immediately by reply e-mail and delete both the message and the copy
thereof contained in reply. Thank you.
Hi Sean,
I'm not sure I understand exactly what you are doing. Is this
description below correct?
You are trying to run Aggregate backed by Tomcat/MySQL on some hosted
provider, and you are linking directly to that MySQL server with
Access and using Access as a reporting framework. You have two
problems with this approach.
-
Aggregate's underling data structure changes are breaking your
Access connection.
-
The connection to the cloud MySQL server is slow and you want to
replicate the MySQL server locally so Access connects to that instead.
For issue 1, can you confirm if it is the colons? Can you also give us
an example of what inputs (form changes, form submissions) seem to
break Access? Create a ticket at
http://code.google.com/p/opendatakit/issues/list is a good place to
file this issue. It would be great if you included the version of
Aggregate you are using.
For issue 2, I'm totally new to replication too, but my intuition is
that it would work. Things I'd look into are what happens on the
Access side if you've only synced say 95% of the data, or if you have
enough bandwidth and uptime to keep the data synced, or if a partial
DB sync of only the critical tables would be adequate, etc.
Anyway, hope that helps.
Yaw
···
On Tue, Jan 3, 2012 at 16:56, Sean Watson wrote:
> CSV linked imports for some reason do not seem to be stable regards column
> headings in Access. (GPS has colons in the csv column headings which may
> have something to do with it). Queries and reports break down when column
> headings change for no apparent reason.
>
> Does anyone have any ideas why this is happening or how to get around it?
>
> One solution i have tried.
> Linking access directly to MySQL aggregate database online from Access.
> This worked and imported the raw tables however its very slow.
>
> I could replicate my online aggregate database onto a local server and then
> link, but im not that familiar with replication.
> http://dev.mysql.com/doc/refman/5.0/en/replication.html
>
> Has anyone tried doing this? Any tips?
>
> I do NOT want the main data collection aggregate to be hosted locally due to
> connection local uptime issues and i want the security of a properly backed
> up cloud copy.
>
> Best,
> Sean
>
>
> --
>
>
> Notice: The information contained in this e-mail and/or documents which
> accompany it is confidential, may be privileged, proprietary and exempt from
> disclosure, and is intended for the exclusive use of the person or persons
> to whom it is addressed. If you are not the intended recipient or if you
> have received this message in error for any reason, please advise us
> immediately by reply e-mail and delete both the message and the copy thereof
> contained in reply. Thank you.
>
>
> --
> Post: opendatakit@googlegroups.com
> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
> Options: http://groups.google.com/group/opendatakit?hl=en