Simplesoft Solutions Blog

Database migration MS SQL Server 2000 to 2005 post changes

December 20th, 2011 by Paul

I have been thinking about the changes that occur with the differences between MS SQL Server 2000 and MS SQL Server 2005.  Here are some specific steps that should be taken to ensure that you proactively avoid problems with your SalesLogix database.  One big item is to adjust the compatibility level.

These steps are very specific to make sure that the process is completed in the best possible manner. I would confirm them with your DBA to determine if he suggests anything additional. There is no ‘undo’ button on the setting changes and it is per database on a SQL server instance setting.

===========================================

Standard Disclaimers

1.      Kick off the users.

2.      Perform off hours.

3.      Back up your database.

===========================================

Steps

1.      Change the compatibility level (2000 to 2005 etc.)

2.      Run the following scripts in Query Analyzer on the appropriate SalesLogix database

a.      Run the statement and review the results

b.      If there are messages in the first statement (step 3), run query statement (step 4)

DBCC CHECKDB with all_errormsgs

– This statement may take a while to run, on average 7 to 10 minutes

DBCC UPDATEUSAGE (databasename)

– Will update the database for the differences in the pages and row counts, etc. Replace (databasename) with the actual database name

EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’)”

– This is a standard MS SQL Server 2005 reindex statement

EXEC sp_updatestats

– This is a stored procedure for updating the stats

DBCC CHECKDB with all_errormsgs

– Check the database at the end to make sure everything looks fine

3.      Make sure the normal database maintenance tasks and jobs are fully operational

Here is also a helpful reference link: http://msdn.microsoft.com/en-us/library/ms176064.aspx. Let me know if you need additional assistance. We are more than willing to assist, but wanted you to have the information at your disposal.

“Any fool can make things bigger, more complex, and more violent. It takes a touch of genius-and a lot of courage-to move in the opposite direction.”

Albert Einstein

If you would like to learn more tips, or if you have a CRM topic you would like us to write about, please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

How to reset IIS website for SalesLogix

September 19th, 2011 by Paul

How to reset IIS with the IIS Reset command

You might need to restart Internet Information Services (IIS) before certain configuration changes take effect or when applications become unavailable. Restarting IIS is the same as first stopping IIS, and then starting it again.

1. From the Start menu, click Run.

2. In the Open box, type cmd, and click OK.

3. At the command prompt, type iisreset /stop. IIS will attempt to stop all services and will return confirmation once all services have been stopped.

4. At the command prompt, type iisreset /start.

If you would like to learn more tips, or have a CRM topic you would like us to write about, please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

SalesLogix Spring Cleaning – End User Tasks

February 28th, 2011 by Janetta

shutterstock_48211747

Spring is a great time to involve all your users in help cleaning up Sage SalesLogix.  Let’s consider some basic cleaning tasks by major entity:

Accounts – Some key fields at the Account entity are Type, Subtype, Industry, and Status.  Clean up your pick lists for each, lock down the pick lists for each,  and create some administrative groups to push out to your users where these fields are blank.  Be very specific about what fields are to be completed, the name of the Account Group, and give them a target date for completion.  Along with the key fields above, you should also encourage general address, phone number, and web address information be completed and updated.  Create some positive press on the project by sending out emails with updates on who has completed the tasks and/or what % of the tasks has been completed.  Ex.  75% of our Accounts are complete!

Contacts – The key fields for Contacts are Status and email.  Again, create the groups with missing information and set a timeline for completion. 

Opportunities – The key fields for updating Opportunities are Status, Close Date, Probability, and Opportunity Value (which is done by making sure the products and pricing are current).  If you are serious about using SalesLogix for forecasting these fields must be kept up to date and your users should be conditioned to update these fields on a regular basis.

Activities – Encourage users to update their scheduled Activities that are way out of date range.  You could create groups for Activities 90 days old, 6 months old, and 12 months old then suggest they reconnect with these Prospects, etc. 

When making a fire people like to join you, when cleaning the ashes you are often alone”  African Proverb

Interested in more on this topic?  - join us for the next Heartland SalesLogix Users Group

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

Sage SalesLogix Cloud Enhancements Now Available

January 25th, 2011 by Lisa

I am pleased to announce a couple of enhancements for Sage SalesLogix Cloud and the Sage SalesLogix Web client!


Sage KnowledgeSync for SalesLogix Cloud

Enhance the intelligence of your CRM system with proactive CRM Alerts.

  • Now, Sage SalesLogix Cloud customers can enjoy the proactive monitoring and alerts available with Sage SalesLogix KnowledgeSync. Customers can define alert criteria and dynamic business rules and sit back as Sage SalesLogix KnowledgeSync proactively monitors their CRM system, sending alerts or triggering an action in the system when business conditions are met.
  • Sage SalesLogix KnowledgeSync is available to Sage SalesLogix Cloud customers beginning at $350/mo for a system license. Please contact Simplesoft Solutions for additional pricing details and terms.

Customer Portal for Sage SalesLogix Cloud
Empower customers with convenient self-service options.

  • Now your customers can empower their clients to get the support they need 24×7 with Sage SalesLogix Customer Portal, improving the customer experience and reducing service and support costs.
  • The Sage SalesLogix Customer Portal is available to Sage SalesLogix Cloud customers beginning at $350 per month for a system license.

Sage SalesLogix Cloud is a next-generation Cloud-based CRM offering built upon the Amazon Elastic Compute Cloud™ (EC2™) infrastructure. Sage SalesLogix Cloud customers enjoy the flexibility and rapid time to value of on-demand systems, combined with the security, control and data ownership associated with traditional on-premise solutions.

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

1 Comment - Click here to join the Discussion!

Do we need a CRM solution?

December 14th, 2010 by Lisa

I recently had a prospect ask me to help him make a case for CRM in his business. After learning more about his unique situation and giving it some thought, I came up with a list of questions that he should ask himself. I think this list could apply to many companies.

Do we need a CRM solution?

A full suite CRM solution like Sage SalesLogix can impact every area of your business. You don’t necessarily want to take on everything at once, but you should consider the impact that a full suite and fully integrated solution might have on the bottom line. Alternatively, what is the cost of the lost opportunity if you do nothing?

Ask yourself these questions:

1.   Can we do a better job with the information flowing to our customers?

  • A good CRM system will help you capture useful details about a customer including sales history, service records, responses to marketing campaigns, demographics, and not to mention, a complete picture of call history and email activity.
  • A good CRM system will allow your customers and prospects to interact with you through a web portal for sales or customer service functions.
  • A good CRM system will provide quick and easy grouping capability to create call lists for internal or external call handling.

2.    Could we benefit from the ability to analyze data more effectively using an integrated system?

  • A good CRM system will allow for integration with most accounting or ERP packages to push and pull data between systems and avoid double entry.
  • A good CRM system will offer integrated dashboards providing a view of important information and metrics in one click.
  • A good CRM system will offer integration with various E-Marketing programs for outbound marketing campaigns and tracking marketing metrics.
  • A good CRM system will be easily customized to fit your particular business needs rather than your business practices changing to fit the software.

3.   Can our customer service or internal processes be improved?

  • A good CRM system can transform your computer into a call center allowing your staff to have customer details on their screen as soon as the phone rings.
  • A good CRM system will play well with Outlook and other E-mail packages helping you automate replies and never again lose an important chain of E-mails.
  • A good CRM system will help you qualify and follow up on new leads without anyone falling through the cracks.
  • A good CRM system will track customer service issues and provide escalation rules to handle even the most complex processes.

4.   Are we managing our supply chain effectively?

  • A good CRM system will allow your supply chain to access your CRM data to collaborate and make informed decisions across the board.
  • A good CRM system will help your supply chain communicate through the use of web services improving the relationship between you and your supply chain.

How can you measure the benefits of CRM?

  • Is it the reduction of operating costs?
  • Could it be the 360 degree view of all your data?
  • Is it the higher percentage of cross-selling opportunities?
  • Maybe it is closing deals faster because of more efficient follow through with leads and customers.
  • Could it be a result of the more efficient marketing and sales processes provided by an increased understanding of your customer needs?
  • Or maybe it is because of the improved responsiveness to customer service that has led to higher customer loyalty.

If I had to guess….I think I would say ‘All of the above!’

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

1 Comment - Click here to join the Discussion!

Tips on Managing users in SalesLogix

November 22nd, 2010 by Paul

“Truth is simple, life is complex” – Anonymous

In the real world, changes happen, and you need to be ready for the “normal” changes that can be ascribed to the life cycle of a system. I recently performed an upgrade that had a set of user management change requests that needed attention. The changes involved the usual requests of adding a new user or two, retiring a few users, and realigning some data. I wanted to review some typical tasks and provide some tactical advice to help others who might be needing answers in similar situations.

User Management in SalesLogix

1. How to change a user type

Users never change roles, right? Not in the real world; people move to new departments and are promoted and/or transferred. Let’s assume a change in user’s role and walk through a couple of situations. The basics of the changes are the same for both [ remote user to network user] and [remote user to web user].

In Sage SalesLogix, it is an easy procedure to change user types. (Note: Let’s assume the remote user is all synchronized and doesn’t have any TEF files to send to the server.)

Click: Start | Programs | SalesLogix | Administrator
Log into application as the Admin user or a user with an Administrative role

Select the Users button in the Navigation icon.

Note: Now you have two choices in how to perform the user type change.

A. You can highlight the user that needs the change in the list, right-click the user and select Change Type.

B. You can double-click the user and on the first tab use the drop-drop on the Change Type field.

Your user has now been changed from one type to another.  It only takes a few clicks, so be careful.  The happy result,  the change is made and away you go!

2.  How to retire a user

Note: When a user leaves your company, the best option is to convert them to a retired user. Retired users do not use a license and cannot log on, but their name is preserved in the database. This prevents history records from displaying “Unknown User” because the user was deleted. Use the following checklist when a user needs retired.  When a user is retired it frees up a SalesLogix license and their system history is preserved.  We don’t recommend the delete feature except in rare circumstances.

Click: Start | Programs | SalesLogix | Administrator
Log into application as the Admin user or a user with an Administrative role

In the Users view, double-click the user to open the User Profile dialog box

- If the user is active deactivate the user (see below).

- If the user is a remote, then make sure the Sync settings are unchecked, site code is recorded and the synchronization files are cleaned up and managed properly. (If you are a customer, you can ask for the ‘SalesLogix Cleaning Up Remote User TEF files.doc’ document.

Note: It might be necessary to manually remove TEF files from the Outfiles and Archives folders under the Host logging path. This should only be done if a Remote user leaves the company or is out of the office for an extended period of time (after which a new database needs to be created). To delete the TEF files in the Outfiles and Archives folders, sort by File Type (the file extension is the site code) and remove any files that have types that match the current active user’s site code that will be retired.

- If the Manager box is selected, clear it. (You cannot retire a user if he or she is a manager.)

- If the user has other users reporting to them, the other users will need to report to another user (at minimum the Admin user).

- In the Name box, type _RET or something similar in front of the user’s name. This step is not essential; however, it makes it easier to identify the person as a retired user in other areas of SalesLogix.

In the User Type list, select Retired User to change the user’s settings.

Press the F5 (Refresh) icon to refresh SalesLogix Administrator to ensure all changes have been made.

3.  How to reinstate a user

Note: Make sure a license is available for the reinstated user. You might need to set up the synchronization settings for the user as well.

Click: Start | Programs | SalesLogix | Administrator
Log into application as the Admin user or a user with an Administrative role

In the Users view, double-click the user to open the User Profile dialog box

Note: You might need to select the Retired Users tab.

Change the user type from retired to the appropriate user type

On the General Tab, clear the Login Active check box

Click OK

Note: It is not a bad idea to have the user’s password reset.

4.  How to deactivate a user

Note: When a user is deactivated they can not log in to SalesLogix, but they are still taking up a license. Users can be deactivated for many reasons, such as maternity leave, military leave or extended sickness.

Click: Start | Programs | SalesLogix | Administrator
Log into application as the Admin user or a user with an Administrative role

In the Users view, double-click the user to open the User Profile dialog box

You can highlight the user that needs the change and right-click the user

On the General Tab, clear the Login Active check box

Click OK

-If the user is a remote, it’s a good idea to clear the ‘Synchronize Changes’ and ‘Sequence Files’ check boxes on the remote tabs. This ensures that files will not write out for synchronization and sit on the server without reason.

To keep the Sage SalesLogix system running smoothly, you should perform certain administrative tasks on a regular basis. This is especially true when it comes to managing users. There are other data and user management tasks that might need to be performed along with user management like realigning data and activities. This will be a future blog entry. I hope these tips have been helpful in some way to help perform some common tasks in SalesLogix.

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

How to uninstall the SalesLogix client

November 10th, 2010 by Paul

On occasion, there might be a need for a System Administrator to uninstall SalesLogix due to an installation issue, migration to a new client type, or the discontinued need for the SalesLogix client on the computer. Regardless of the situation, here are a few pointers to assist in the tasks to remove the SalesLogix client in a manual and efficient manner.

How to uninstall the SalesLogix client:

1. Shut down running Windows services (SalesLogix related).
Note: In some clients, no SalesLogix services may be running. If any services are running locally (optionally) then they should be shut down. This will make the uninstall a little cleaner.

  • From the Start button, click Run
  • In the Open field, type: Services.msc
  • Note: This opens the Services Management console.
  • Select OK
  • Scroll down the list and review the services listed in the S’s for SalesLogix related services
  • Highlight and right click them to select stop for each service

2. Use Add/Remove Programs to uninstall SalesLogix related applications.

  • Start | Control Panel | Add/Remove Programs
  • Remove SalesLogix Client
  • Remove Intellisync Client   (might not be there, but just in case)
  • Remove SalesLogix Mail Client  (should not be there, but just in case)

Note: Remove the SalesLogix Administrator if installed.

3. Remove the SalesLogix application related folders.

Browse in Windows Explorer for the following folders for removal. These folders are slightly different in Windows 7.

  • <drive>:\Program Files\SalesLogix
  • <drive>:\Documents and Settings\All Users\Application Data\SalesLogix\
  • <drive>:\Documents and Settings\<users>\Application Data\SalesLogix
  • <drive:>:\Program Files\Common Files\PUMATECH Shared\Connectors\SalesLogix

4. Remove “SalesLogix” and “SLX” entries from registry.

Note: Regedit is the way I edit the registry, but be very careful when making changes in the Windows registry: unless you back it up first there is not an easy way to recover after some actions.

  • From the Start button, click Run
  • In the Open field, Type: Regedit
  • Click OK
  • Expand to HKEY_LOCAL_MACHINE\SOFTWARE
  • Right-click on the SalesLogix folder and click Delete
  • Expand to HKEY_CURRENT_USER\SOFTWARE
  • Right-click on the SalesLogix folder and click Delete

5. Reboot the computer. Now you are ready for your next actions.

The uninstall instructions may vary slightly from version to version of SalesLogix and operating system, but these are the basic tasks to perform the uninstall action. Let us know if and how these tasks differ in your environment and we can add to or adjust our list.

If you would like more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. at one of our three locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

To Cold Call or not to Cold Call: That is the Question

November 1st, 2010 by Lisa

Don’t you wish your phone would ring off the hook with prospective customers asking to buy your product or service? I sure do! Unfortunately business doesn’t come to you and instead you have to go out and find it.

I’ve heard it said that 90 percent of people hate cold-calling and the other 10 percent are lying. Even the term cold calling can make your stomach churn.  That is why some refer to it as prospecting or lead qualification. The truth is, picking up the phone is still one of the best ways to speak to a company executive.

Why do we try so hard to avoid it? The reasons are different for all of us. Maybe we don’t like talking to new people or we don’t want to bother someone at home or work. Or maybe we’re a little lazy and just prefer to make the easy calls. For most of us, it is a fear of rejection! I don’t want to call someone and have him or her get annoyed and act rudely toward me.

According to a research firm that tracks what works in the marketing industry, only 11 to 17 percent of prospects were annoyed by getting an unsolicited cold call. That translates into less than 2 rude responses for every 100 calls. And not all of the uninterested prospects will exhibit rude behavior. Let’s do the math, if only half of the uninterested prospects are rude and you make 50 calls a day, then you would only encounter about 2.5 crusty customers a week. I don’t know about you, but I encounter more than that in one trip to the grocery store. Don’t focus on the fearful 2.5 calls, but on the other 247.5 calls that could push your prospect one step closer to becoming a customer!

Go ahead… pick up that phone!

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

1 Comment - Click here to join the Discussion!

Never underestimate the features of your SalesLogix Calendar!

October 26th, 2010 by Janetta

I was asked by a client for some help with all the calendar features in Sage SalesLogix.  We use a format called Quick Cards (Qcards) to document business processes for training of Sage SalesLogix,  so I thought I would share my work with everyone.  Attached are two Qcards for the Sage SalesLogix Calendar.  Download and distribute to your users.  Call on us for Sage SalesLogix training help and check out our free monthly SalesLogix training webinars called “CRM in Session.”

SLX Calendar Qcard 2010-04

If you would like to learn more tips or have a CRM topic you would like us to write about please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:

Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net

Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net

Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net

Comment on this Post

Simplesoft Solutions Bottom
Register | Log in