SeedCode Support Forum

Hi,
I'm not sure what I'm missing but I've got the following problem:

My local Mobile file on my Mac syncs with the Hosted file fine. I run the 'Prep and Upload' script and then update the local file on the iPad device. This is now identical to the local file on my Mac.

I change a record on the Hosted file and sync the iPad but nothing is altered. I get the '1 of 1 packages (1 record)' screen but nothing changes.

Any pointers would be great...

Thanks
Brian.

Just checked the Zync Log on the iPad version of GoZync Mobile and found:
Error: 200 - We couldn't set this field "Table::MyField"

Why does this only happen on the iPad and not on my MacBook?

Thanks
Brian.

Hey Brian,

200 is a specific permissions issue so something must be different there. Maybe you've got something set in your keychain on the mac?

-Jason

Hi Jason,
That gives me a starting place I suppose but not too sure what I need to be looking for.

Cheers
Brian.

Hi,

So this is GoZyncMobile trying to write to a field in your mobile file, I believe. Can you paste the whole GoZyncMobile log here?

GoZync by default logs in with Admin (unless you've changed this). Whatever account GoZyncMobile is logged in as doesn't have permissions to the file with

brian.curran wrote:"Table::MyField"

. If you're using custom privileges in your mobile file, then it could be that specific table that the account can't write to. If you're doing custom privileges and add new tables, then typically access to that table is turned off by default, so that might be the issue as well.

Basically the account that opens GoZyncMobile needs to match an account in your mobile file that can write to this table. Are you logging into your mobile file on the iPad or do you have file options set to log into a specific account automatically?

Thanks!
-Jason

Hi Jason,
Thanks for the additional info', it's definitely a permissions problem.

If I open the Mobile file with my own login (Admin role but a different user name) and log into the Hosted file with a basic user login, the sync works fine.

The problem occurs when I log in to the Mobile file as one of the basic users so that's something I need to look at first...

Thanks
Brian.

Sorry, these are the logs of the failed sync...

!HEADER!
<f>Police::__kpPoliceID!•!Police::StationPhone!•!Police::StationTown!•!</f><ts>12/7/2012 10:34:34 PM</ts><ids>[Police]1!•!2!•!3!•!4!•!5!•!6!•!7!•!8!•!9!•!10!•!11!•!12!•!13!•!14!•!15!•!16!•!17!•!18!•!19!•!20!•!21!•!22!•!23!•!24!•!25!•!26!•!27!•!28!•!</ids>
!DATA!
1=1!•!2=01254 353749!•!3=Accrington 4!•!<!EOR!>
<!EOE!>

12/7/2012 10:30:11 PM - Started
-------------------------
Split Total
0:00:00 - 0:00:00 - Public API Started: Police
0:00:00 - 0:00:00 - Connecting to server...
0:00:02 - 0:00:02 - Getting settings from Host...
0:00:01 - 0:00:03 - Running default action for Police : Pull
0:00:00 - 0:00:03 - Asking the host for changed records: pulling down.
0:00:23 - 0:00:26 - Retrieving the Outbox from Host
0:00:00 - 0:00:26 - Processing 1 of 1 packages recd. (1 records)
0:00:00 - 0:00:26 - Looking for records to delete
0:00:00 - 0:00:26 - Record deletion completed
0:00:00 - 0:00:26 - ERROR:200 - We couldn't set this field "Police::StationPhone"
0:00:00 - 0:00:26 - ERROR:200 - We couldn't set this field "Police::StationTown"
0:00:00 - 0:00:26 - Processing completed
0:00:01 - 0:00:27 - Closing GoZyncMobile

I discovered that the basic user only had 'Read Only Access' so changed his role to 'Data Entry' and it works great. Thanks for your help Jason, I wouldn't have been able to pinpoint this on my own...

Great Brian! and thanks for the feedback. FM Security is a little tricky to work with and also a little tricky to explain.

Not sure if you and John went over this, but we have some docs on Security here:

http://www.seedcode.com/pmwiki/pmwiki.p ... 3.Security

We like using the approach of leaving the mobile files all "open" and securing the device itself. Then have them log-into GoZyncHosted when doing the sync itself, but we've seen folks approach this all sorts of ways. No "right way" to do it...although there are certainly wrong ways!

Cheers and don't work all Weekend!

Yes, I looked at that page recently and think I'll go with the following:

Complex password to secure the device.
Simple username (Initials) and password (ID No.) for FM Go. I think this is necessary as iPads are shared between employees during working hours plus there is the risk of family playing/snooping when they are at home.

The rest of that page will take a bit more consideration...

Thanks
Brian.

Right Brian, If it's a shared device then I think your approach is a good one.

Cheers!