casper114
asked on
Not all contacts showing in ACT 2009
I have an issue with a user (the boss's secretary) who is normally very good with programs showed me today that she is only showing 763 contacts in her copy of ACT running on her computer. I know for a fact we have 1665 on the server. This number doesn't change even after she syncs with the server. A stranger thing is that I saw her sync earlier today and it updated 39 records. However, when I went in a little while ago to check a record she said she knows was finished before she ran the sync, it doesn't show up in the database on the server. We only run 1 ACT database on the server so she can't be connected to another one, even though that's what it sounds like. Does anybody have any ideas.
You could also try logging into the remote database as an administrator. Maybe the user is restricted to certain contacts due to team security.
But most likely the user is apart of a certain sync set that doesn't include all contacts from within the database. Your best bet is to just recreate the remote:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=14116&p_created=1120417554&p_sid=c73Aa-8k&p_accessibility=0&p_redirect=&p_lva=14072&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MzgwOCwzODA4JnBfcHJvZHM9MCZwX2NhdHM9JnBfcHY9JnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD1jcmVhdGluZyByZW1vdGUgZGF0YWJhc2U*&p_li=&p_topview=1
But most likely the user is apart of a certain sync set that doesn't include all contacts from within the database. Your best bet is to just recreate the remote:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=14116&p_created=1120417554&p_sid=c73Aa-8k&p_accessibility=0&p_redirect=&p_lva=14072&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MzgwOCwzODA4JnBfcHJvZHM9MCZwX2NhdHM9JnBfcHY9JnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD1jcmVhdGluZyByZW1vdGUgZGF0YWJhc2U*&p_li=&p_topview=1
ASKER
I only have 1 sync sec defined and it's for all users and for all contacts. This is what puzzles me. I have confirmed that all the most recent data she's synced is in the main database. I am leaning toward 60Cal's suggestion of just creating a new remote database for her and hopefully being done with it. If you have any other thoughts feel free to post them. Otherwise I'll update this thread with what I decide and if it works or not.
You might want to re-create the sync set before you create the remote database. Sometime you can find that the sync sets may have become corrupt and can cause issue when synchronising.
As 50 cal posted:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=14072&p_created=1120414914&p_sid=r4hhiY8k&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MjUyOCwyNTI4JnBfcHJvZHM9MCZwX2NhdHM9JnBfcHY9JnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD1TeW5jIHNldHM*&p_li=&p_topview=1
As 50 cal posted:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=14072&p_created=1120414914&p_sid=r4hhiY8k&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MjUyOCwyNTI4JnBfcHJvZHM9MCZwX2NhdHM9JnBfcHY9JnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD1TeW5jIHNldHM*&p_li=&p_topview=1
Just on another note, have you tried logging into her remote with your username and password to see if you can see all the contacts?
50cal.
50cal.
ASKER
50Cal,
As stupid as it sounds, I have not. I think I will try that before attaching to the new remote database.
60Cal,
I will check with other users to see if they are experiencing a similar problem or if they can still see everything. I will definitely recreate the sync set if it looks like it's needed.
Thank you gentlemen. I'll keep you updated on how things go.
As stupid as it sounds, I have not. I think I will try that before attaching to the new remote database.
60Cal,
I will check with other users to see if they are experiencing a similar problem or if they can still see everything. I will definitely recreate the sync set if it looks like it's needed.
Thank you gentlemen. I'll keep you updated on how things go.
On another question... is she on the LAN?
If so, why are you using sync?
If so, why are you using sync?
ASKER
Okay, when I log into the other user's database as myself (an admin) I can see all contacts as you would expect. However, when logged in under this other user I can still only see about 45% of the contacts.
She is on the LAN. When the system was 1st setup all but 1 user were laptop carriers who would be in and out of the office on sales calls and so I believe she was setup the same as the others for the sake of convenience I would say. Due to this, she has a remote database running and then syncs back to the main database at the end of each day to make sure all is current
She is on the LAN. When the system was 1st setup all but 1 user were laptop carriers who would be in and out of the office on sales calls and so I believe she was setup the same as the others for the sake of convenience I would say. Due to this, she has a remote database running and then syncs back to the main database at the end of each day to make sure all is current
If you can log into her remote and see all contacts that means that there is team security in place.
Here is an article on what team security is:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=15322&p_created=1125687396&p_sid=dUN6859k&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MTA3LDEwNyZwX3Byb2RzPTAmcF9jYXRzPSZwX3B2PSZwX2N2PSZwX3NlYXJjaF90eXBlPWFuc3dlcnMuc2VhcmNoX25sJnBfcGFnZT0xJnBfc2VhcmNoX3RleHQ9dGVhbXM*&p_li=&p_topview=1
If you add her account to all the teams (tools Manage teams)>> and then try to sync, it should pull across the changes and failing that if you add her to the teams lists and recreate the remote then she will have access to the entire database.
Or you can bump up her security role to administrator and then she will have access to the entire database as well.
Here is an article on what team security is:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=15322&p_created=1125687396&p_sid=dUN6859k&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MTA3LDEwNyZwX3Byb2RzPTAmcF9jYXRzPSZwX3B2PSZwX2N2PSZwX3NlYXJjaF90eXBlPWFuc3dlcnMuc2VhcmNoX25sJnBfcGFnZT0xJnBfc2VhcmNoX3RleHQ9dGVhbXM*&p_li=&p_topview=1
If you add her account to all the teams (tools Manage teams)>> and then try to sync, it should pull across the changes and failing that if you add her to the teams lists and recreate the remote then she will have access to the entire database.
Or you can bump up her security role to administrator and then she will have access to the entire database as well.
Also if you open act and go lookup>all contacts> highlight them all and right click> edit contact access>Make contacts public,
this will override any private contact access limiting her access to the database.
this will override any private contact access limiting her access to the database.
ASKER
60Cal,
You had me quite excited for minute with the prospect of Team Security. However, I checked the database and we do not have any Teams setup. You are right that I could move her from Manager to Administrator, but if possible I'd like to avoid that. I actually created a new remote database for her and opened it up on her machine this morning and it appears to be working fine for now. However, I'd still like to get to the bottom of this issue so that should it come up again I can resolve it.
You had me quite excited for minute with the prospect of Team Security. However, I checked the database and we do not have any Teams setup. You are right that I could move her from Manager to Administrator, but if possible I'd like to avoid that. I actually created a new remote database for her and opened it up on her machine this morning and it appears to be working fine for now. However, I'd still like to get to the bottom of this issue so that should it come up again I can resolve it.
ASKER
60Cal,
If I make all the contacts public and override any private status's. Won't that translate back to the master datase once she does a sync?
If I make all the contacts public and override any private status's. Won't that translate back to the master datase once she does a sync?
If Private contacts are in place and you make them public then that will transfer back up to the remote database.
Private contacts can only be seen by the records owner and Administrators, which would explain why you can see them. If you want your colleague to see them then they either have to be public or she will need to be admin. Failing that you could look into setting up Limited Access rather than using public/private.
50cal.
Private contacts can only be seen by the records owner and Administrators, which would explain why you can see them. If you want your colleague to see them then they either have to be public or she will need to be admin. Failing that you could look into setting up Limited Access rather than using public/private.
50cal.
Contact Access KB if you would like to review the limited access point
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=15228&p_created=1124291639&p_sid=USbjj59k&p_accessibility=0&p_redirect=&p_lva=15228&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MSwxJnBfcHJvZHM9MCZwX2NhdHM9JnBfcHY9JnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD0xNTIyOA**&p_li=&p_topview=1
50cal.
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=15228&p_created=1124291639&p_sid=USbjj59k&p_accessibility=0&p_redirect=&p_lva=15228&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MSwxJnBfcHJvZHM9MCZwX2NhdHM9JnBfcHY9JnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD0xNTIyOA**&p_li=&p_topview=1
50cal.
If she is on the LAN, I'd also have her directly access the server database, not use sync
any luck on this?
ASKER
I finally figured out what the problem was on this. I had to recreate the login the secretary uses a while back due to various reasons that still drive me crazy. However, it turns out the new login just hadn't been added to have visibility to all of the existing contacts, but could see all the public contacts. Once I selected all contacts and had her contact access added to them she could see everything she needed to be able to see.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry about that 50Cal, I thought I remembered all of the postings over the past weeks and forgot this one. You are right on about this.
Remote databases utilise a sync set. This basically specifies the records that are copied to the offline database. Check the sync set for the remote to see if it is limiting the number of contacts.
Check the following link for more details on sync sets.
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=14072&p_created=1120414914&p_sid=r4hhiY8k&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MjUyOCwyNTI4JnBfcHJvZHM9MCZwX2NhdHM9JnBfcHY9JnBfY3Y9JnBfc2VhcmNoX3R5cGU9YW5zd2Vycy5zZWFyY2hfbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD1TeW5jIHNldHM*&p_li=&p_topview=1
In the sync panel click manage database (or it may be subscription list) to see what remote uses what sync set.
50cal.