Sync Issues from SQL Server to Remote Users

[CWUserid]

We are a company with 32 GoldMine 6.6 users. One of my responsibilities is to act as "GoldMine Administrator" and I am stumped. I have a number of tasks (pending and history) that are not synching properly from the SQL server to the remote users.

One example - Person A schedules a literature request for Person B. Person A sees it pending and it is pending on the server (when looking at both the contact records Pending folder as well as when looking at the calendar for the person the task is assigned to). However, Person B does not see it on their "task list" on the calendar.

Sync logs say it is a successful sync. We try synching multiple times. And we have tried rebuilds.

What is causing this and more importantly, how do I fix it?

Thank you!

 

[M8KWR]

have you got all items flagged on the sync???

 

[CWUserid]

Yes, we do. It's inconsistent - most things sync but not all.

Another example: A salesrep completes two appointments on Monday and syncs that information that night. Tuesday his manager looks at his calendar and sees only one completed appointment on that rep's calendar.

The server is SQL and our remotes are dBase. Is that the problem?

 

[M8KWR]

all you using the cut of date, make sure the ones that are not been seeing are beneath the date, as goldmine will thinks is sync'd them already.

Your first issue is with the cal table, and you second the local Conthist table.

You should in theory have no issues with sql and dbase, the remote laptop has the files stored as dbase, and then justs sync with the server.... or so it should...

The history/calendar activities aren't private by any change.

If you log in as a master user are you able to see them...

 

[CWUserid]

New question. I am sure now that this is related to the cut-off date. I set everyone back to 1/1/05 and told them to expect a longer sync afterwards... but to keep the issue of losing information in the sync from happening again I want the cutoff date to default to one week prior to their last sync.

Short of going in there manually after everyone syncs daily, can I set it to automatically set it one week back?

Detailed instructions would be extremely helpful!!

THANKS!

 

[M8KWR]

The sync will always default to the last time it was sync'd.

So if you are syncing more then one database, this is bit of an issue.

I am not aware of any automatic options for the sync.

But if i have a wierd question i find it best to go to this website

http://www.contactreview.com/mb/ubbthreads.php/Cat/0

more direct goldmine questions answered.

I hope you find your answer.

 

[CWUserid]

THANK YOU!