7/10/2025 5:32:01 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
V6.1 Office Tab - shows No offices
Posted: 08 Apr 08 3:36 PM
|
Hi,
One of my clients, finally got a new server, the provider is fine, everything is working but it can not access the attachments (the old server is off). We moved the files to the new server, set up the rights, went into Administrator, System, office - and its BLANK.. No office show  . If you go into SQL Server, SystemInfo - you see 1 row - but the path is a binary field. How can I update this information?
Paul |
|
|
|
Re: V6.1 Office Tab - shows No offices
Posted: 09 Apr 08 6:37 AM
|
I haven't seen this for a while, but I believe tech support gave me this fix a few years ago - use at your own risk as I haven't had to do this for a while:
Run the folling SQL from the "Execute SQL" feature of the administrator:
insert into address (addressid, entityid) select addressid, sitecode from branchoptions where branchoptions.addressid not in(select addressid from address)
insert into address (addressid, entityid) select shippingid, sitecode from branchoptions where branchoptions.addressid not in(select addressid from address)
|
|
|
|
Re: V6.1 Office Tab - shows No offices
Posted: 10 Apr 08 8:16 AM
|
You need to go into the BranchOptions table and fix your Library and Attachment/Document path(s) there.
--
RJLedger - rjlSystems |
|
|
|
Re: V6.1 Office Tab - shows No offices
Posted: 16 Apr 08 7:24 PM
|
Thanks for all of your help. When I was applying the sql - I looked in the branch options table and saw the path and changed it issue.
My client still has not told me if it worked but seeing as type who complains when it does not work - I assume its all good.
I really appreciate everyones help on this forum. I just told some who works in another office about the forum (same company but differenet implementation) and how helpful you all have been.
Have a great day.
Paul |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|