Hi all –

As decided in the meeting, we are moving our meetings to the 3^rd  Thursday of the month.  We will be holding our next Rochester User Group meeting on Thursday,

7-16-09 starting at 4:30pm.  Arrive early for networking.   We will try to stay on track with our agenda and start right at 4:30pm

Agenda:

4:30 – 4:40pm    Logistics/Action items:  Mary Ann Novosel

4:40 – 4:50pm    Introductions – new people

4:50 – 5:15pm    Monthly Challenge:  Round table – anyone who wants to share a challenge they had this month and how they solved it

5:15 – 6pm          Demos - Carestream – Data Loader; still open for another agenda item

We will be meeting at the Rochester Group’s facility located on Park Avenue.  Feel free to contact Marcia Olson from the Rochester Group for directions.  molson@rochgrp.com or (585) 281-4956.

Quick notes from the meeting held on 6-17-09:

·        Decided to change meeting time to 3^rd Thursday of month due to scheduling conflicts

·        Discussed changing agenda as listed above

·        Removing google group listing and only keeping the saleforce.com user group listing.  MA Novosel consolidated the two lists and put everyone in the sfdc user group site.

·        MA Novosel to review the blogging technology with ExactTarget which works with sfdc’s user group website

·        MA Novosel to work with Salesforce.com to understand how to properly utilize the user group website

·        Ron Willie and Tom Patios from VanDamme did a demo on their platform server showing us their procedure software and the basics of Visualforce

·        Scott VanAtta presented validation rules – attached preso for those who could not attend

Note:  If you have someone interested in joining, you can send me their contact info or they can fill out the form at this link:  http://usergroups.salesforce.com/rochester/

Thanks everyone.  Will be in touch during the month!

Mary Ann

This Meeting:

Theresa DeRycke from CRM Fusion on Data Thereapy

Next meeting:

January, 21st from 4-6:30 at the Rochester Group Headquarters.600 Park Avenue.

Topic: Google Groups demonstration and training and a possible demonstration of Snapshot and Dream Factory Utilities.

Meeting notes as scribed by Rod MacKenzie as follows:

The meeting began at 4:15 PM at the headquarters of the Rochester Group on Park Avenue.

Welcome to new user group members: Janet Mahoney (Paychex), Adam Kranitz (Avid), and Jim Papin (Qioptiq, spelled correctly)!

Rod MacKenzie, who never won anything in his life, won the raffle, a GPS.  What a super gift, in exchange for which taking minutes is no big deal!

Reminder that the User Group meets the third Wednesday of each month, kindly hosted by the Rochester Group.

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

Today we were lucky to have Theresa DeRycke of CRMfusion Inc. speak to us, on the subject "Data Therapy."  Also, she provided tasty munchies, as well as nifty miniature tool kits which perhaps symbolize one of the things her company does well - fix data.

14 years ago Theresa worked at Salesforce.com, on various projects involving data cleanup.  While there, she became acquainted with a CRMfusion product called DemandTools.  Eventually she left to work for CRMfusion.  It has 8-10 employees, and about 2,500 customers.

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

Start of Theresa's presentation.

DemandTools features:
- MassEffect (similar to SFDC Data Loader)
- De-duplication (includes ability to de-dupe custom objects and attachments)
- Tools for massaging phone numbers, stree addresses, and email addresses
- Discovery tool (compares external data to data already loaded into SFDC)
- Lead clean-up
- Re-assignment of Account ownership

PeopleImport features:
- Tool for importing Leads, Contacts, and Accounts
- Can stop duplicates from being imported into SFDC

DupeBlocker features:
- Stops users from being able to create duplicates in REAL time
- 100% Force.com native app

- Data cleansing is an art, not a science. For example, you (or your customer) have to answer these questions: What is a dupicate? In what scenarios do duplicates arise?  What is the business impact of duplicate data?  Even in this age of computers, manual review of possible duplicates is required.  Look for things like: Why are dupes being created in my SFDC org?

- Largest de-dupe she has done: 89,000 records

- Question: Is it possible to customize the product's de-duping rules?
- Answer: Some rules are built-in, e.g. "&" -> " and ".  But beware of creating rules such as "so" -> "south".  Also, in order to enable SFDC users to find Account names with which they're familiar, don't go overboard when converting Account names to their "legal" or "standard" form.

- Question: Advice on importing data into SFDC from other systems?
- Answer: Create a custom field on the Account (or whatever object you're importing into) which indicates which foreign system the data came from.  Then's it's readily identifiable if the need arises.

- Question: Who do you engage with when you undertake a clean-up for a customer?
- Answer: The best person is the one who "knows where they want the data to be," and how to get there.  Also, you should give a list of the proposed merges/duplicates to the customer and ask for verification.  Note that an IT-type person may be useful in the discussion - don't depend on only the end-user.

- Discussion: "Data Therapy"
Data cleansing is one of those things people never talk about, or take seriously, but needs to be done.  And it's not rocket science.

- Reminder: Even if you're not currently a CRMfusion customer, feel free to contact me for some initial guidance/wisdom.

- Question: What about Best Practices?  What are the real benefits of data cleansing?  What are the catalysts?
- Answer: The hardest part of data cleansing is deciding what you want DemandTools to do.  The tool itself is easy to use.  Go to www.crmfusion.com and download a demo.  FYI, it's no big deal to extend the demo period if it's required.

- Remark by Paychex: We use PeopleImport and DemandTools. De-duping is part of my daily routine, especially de-duping our sales reps' contact data. Can the feature "Find ID" be run by the Windows Task Scheduler?
- Reponse from Theresa: I will find out if the feature "Find ID" can be run by the Windows Task Scheduler

- Question: What is the business value of cleansing data?  How much time will I spend monitoring and cleaning data?
- Answer: One of my customers used to spend 9 days cleaning data, now that's dropped to 3 hours.  You (or your customer) really have to answer this question.  Basically, whatever data you put into SFDC is a candidate for monitoring and cleaning.  In addition, you have to decide whether you're getting any value from the data you're putting in!  Ongoing maintenance will always be required because so many different organizations and persons are able to share SFDC data or create Accounts. You can also consider turning off the ability to create Accounts.  Let only specific persons or groups create them.  But don't die if someone accidentally deletes an Account.  There's always the Recycle Bin or a backup.

- Question: Channels and SFDC Accounts: How to ensure correct visibility, and differentiate multiple sites?
- Answer: Using Dunn & Bradstreet to maintain corporate hierarchies is one solution. Or, have the right person (not necessarily a management person) make the right decision about Account merging and deleting.  Note that it's important to enable different views of account hierarchies.  But regardless of which approach you take, make sure that someone's "vision" about how to fix something can be correctly implemented.  When you (or your sales rep) proposes a data cleansing solution for your customer, make sure you understand what the customer wants to accomplish, whether you're using CRMfusion or any other tool.

- Question: Any overseas experience doing data cleansing?
- Answer: Spain and Australia.  Now I can see how many ways people have of saying "Missing value" or "Invalid data" in multiple languages!

- Remark: DemandTools requires a 32-bit operating system, won't work with 64-bit.

- Question: Can your products deal with double-byte (e.g., Chinese character) data?
- Response from Theresa: I will find out

- Final remark by Theresa: DemandTools is free for non-profits

End of Theresa's presentation.

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

Closing dicussion

- Question: Has anyone been using Google User Groups to submit questions?
- Answer: One did, but never got an answer.  Rich Bilsback will bring some screen prints to the next meeting, to illustrate how to do this.

- Topic for future meeting: How to Use Google User Groups

- Topic for future meeting: Mobile.
- Remark: This is hot.  Sprint would like to host a meeting, though it wouldn't necessarily be from a SFDC perspective.
- Remark: Paychex is trying to steer users away from mobile, and toward VisualForce pages.
- Remark: Different carriers treat SFDC integration differently.  E.g., AT&T sells IPhones, which have their own SFDC integration.
- Remark: Theresa might contact one of her customers who did a DreamForce presentation about mobile, which may be of use to us

- Question: Does anyone use the off-line version of SFDC?
- Answer: Not on a regular basis.  One person uses it only when she anticipates her network not being available.
- Answer: Uses it only sporadically.  Unfavorable opinion.

- Question: I'd like to see better integration between Outlook and SFDC. Any news?
- Answer: Theresa satisfied with Outlook integration.  Recommends you check for latest version of Outlook Edition from time to time
- Answer: Outlook Edition is not bad, and is always getting better.

- Remark by Rick Gary: SFDC is not the best tool for analytics - SAP Business Objects is better, especially when it comes to integrating SFDC data with other systems' data.  SFDC dashboards and reports have become unmanageable.  Report management seems to be easier with BO.
- Related remark by Theresa: Try submitting an enhancement request to CRMfusion, requesting a SFDC Report Management tool.

- Question: How do people manage reports?
- Answer: Xerox stopped people from using the data server for reporting purposes, due to performance problems.  Reporting has been completely offloaded to its own server.

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

The meeting ended at 5:45 PM.

___________________________________________________________________________________

Thanks to Rod for taking such great notes! 

Sorry for taking so long to get any new posts.  We promise to do better in the future.

A number of us just returned from a very successful Dreamforce event.  That is if you exclude the Dell commercial in one of the keynotes.  There was great information and sharing.  We are planning to do a debrief of the conference and plan for new meetings at our next session on November 19th from 4pm to 6pm. 

Please note that our previous venue has closed, so we will have this meeting at the following address:

Rochester Group Headquarters

600 Park Avenue

http://www.rochgrp.com/

Directions:

They are close to the Museum of Science

From the East:

I-490 W toward Rochester

Take exit 19 for Culver Rd

Right on Culver

Left on Park

600 Park Ave is located on the right - immediately after the large public parking lot next to Wilson Farms.

You will see one of the large homes Park Ave is famous for. There is a black wrought iron gate in front. There is parking in the front and the back. Park anywhere and come in the front door.

From the West:

I-490 E toward Rochester

Take exit 19 for Culver Rd

Left on Culver

Left on Park

We look forward to seeing everyone next week.

Take care,

Rick and MaryAnn

Rochester, NY 14607-2998

585-271-1110 - phone 

We had a great turn-out for our kick-off meeting.  18 people attended, representing 11 companies. 

Our agenda covered the following:

• Welcome and General Announcements
• Introductions and review of each company represented
• Agreement on meeting expectations and future meeting logistics
• Future agenda and guest speaker ideas
• Lots of networking and discussion
  

Meeting notes and action items were sent to members for their review. 

We agreed that our meetings will be held on the third Wednesday of each Month from 4:00 to 6:00PM at Tasteology, 3400 Monroe Ave, Pittsford, NY (Across the street from Pittsford Plaza).   

The next meeting is scheduled for August 20th and I will send out a reminder prior to the meeting.

See you all then!

Rick

We have changed our meeting location to Tasteology this Thurs 7/17/08 from 4-6pm for our first Local Users Group meeting.  Tasteology is located at 3400 Monroe Avenue in the Pittsford Colony Plaza - all the way in the back.  Free parking.

http://www.tasteology.net/

Directions to Tasteology can be found here

http://www.tasteology.net/find-us.htm

We are very excited to announce the creation of a User Group for salesforce.com customers in the Western New York area.  Rick Gary of Carestream Health has volunteered to lead the group and is planning a first meeting for Thursday, July 17th at 4:00.  The meeting will be Carestream's facility on Verona Street in Rochester.  He will need your help to make this user group a valuable resource where everyone can network, share ideas, and find creative solutions.  Just fill out the form on the left to get on the mailing list and look for information about the first meeting soon.

We hope you will get involved