Dun and Bradstreet Lessons Learned
Dun and Bradstreet Lessons Learned MYM Session June 10, 2015
2015 Mid-Year Meeting
2
What we’ll discuss… • Purpose of the Meeting • D&B Taskforce Recommendations • Communication Plan • Resources available • Implementation Feedback • Discussion
2015 Mid-Year Meeting
3
Purpose of Meeting • Review the efforts and accomplishments of the DNB Transition • Review the processes, resources and activities provided by AgGateway supporting the transition • Evaluate the successes and identify improvements that can be made for any similar future activities
• Identify any remaining areas that need to be addressed and that can be facilitated by AgGateway
2015 Mid-Year Meeting
4
TASKFORCE RECOMMENDATIONS
2015 Mid-Year Meeting
5
Recommendations D&B Taskforce began work in late 2011 • Phase 1: Stop requesting verification from D&B for EBID numbers and asking for numbers for new entities • Phase 2 – Start issuing GLN’s for new entities that have EBID’s requested and place the GLN number into both the GLN and the EBID field. • Phase 1 & 2 Completed September 15, 2012
• Phase 3- Replace the current EBID’s with GLN’s in a systematic
conversion process • Phase 3 Completed the weekend of February 13 -15, 2015
2015 Mid-Year Meeting
6
COMMUNICATION PLAN
2015 Mid-Year Meeting
7
Communication Plan • Three Target Audiences • Primary and Secondary AGIIS Subscriber Contacts, D&B
Leader Board Contacts • AGIIS Non-Subscriber Trading Partners • AgGateway Membership • 25 plus communications • Countdown Clock
• August – November - Focused on awareness • November – February - Focus on implementation
2015 Mid-Year Meeting
8
IMPLEMENTATION RESOURCES
2015 Mid-Year Meeting
9
Resources • D&B Leader Board • Provided status on: • Testing readiness • Synchronization information • Acknowledgement Letter status • Company Contacts
• Acknowledgement Letter • Allowed companies to formally acknowledge participation
• 40 out of 40 participants were committed to a successful
transition
2015 Mid-Year Meeting
10
Resources • AGIIS Website and Web Services • Pre and Post conversion functionality • Search results provided both EBID and GLN Identifiers • Schedule Subset Extracts • Resource was high value to participants
2015 Mid-Year Meeting
11
Resources • AGIIS Non-Subscriber EBID to GLN Look-up • Initially reached out to 151 Non-Subscribers • Website Look-up feature (Leverage from Expanding
Access to GLN initiative) • January 9 – February 15, 2015 • User count 50 / Individual Searches 1,565
• EBID Spreadsheet Look-up • 50 spreadsheets submitted
2015 Mid-Year Meeting
12
Resources • Conversion Spreadsheet • EBID to GLN CSV file (306,184) • Was available December 8, 2014 • Only available to AGIIS subscribers • Was downloadable from AGIIS website • Resource was high value to participants
2015 Mid-Year Meeting
13
Resources - Continued • AGIIS Test Environment • Support FTP Site Conversion • Support AGIIS Bulk File Processing • 8 subscribers/authorized providers utilized testing • Was available January 15, 2014
2015 Mid-Year Meeting
14
IMPLEMENTATION FEEDBACK
2015 Mid-Year Meeting
15
Implementation Feedback • Implementation Weekend – Went as planned • Friday February 13th (7pm CT) AGIIS website closed • Saturday February 14th • Pre-Conversion Subset extracts creation • Apply Transition change to AGIIS System • Post - Conversion Subset extracts creation • Enable GLN Look-up Functionality • Sunday February 15th • Testing • Released to Production Mid-day
2015 Mid-Year Meeting
16
Implementation Feedback • The first week we had 5 companies contact us regarding
picking up files off the ftp site. • We have had 2 companies that ongoing issues uploading files to the ftp site because they were using the old identifier. • Aware that there were a few message specific challenges, but this was being addressed trading partner to trading partner.
2015 Mid-Year Meeting
17
DISCUSSION
2015 Mid-Year Meeting
18
Discussion • Communication • Did we reach the right audience? • Was our message communicated clearly and effectively? • What would you suggest we do differently in
communications for future activities of this scale? • Implementation • Did you receive all the resources needed from AgGateway to support your transition? • What if any additional resources would you suggest AgGateway provide for future activities of this scale?
2015 Mid-Year Meeting
19
QUESTIONS?
2015 Mid-Year Meeting
20
THANK YOU! For additional information: www.aggateway.org
Member Services at 866-251-8618 or [email protected] Josh Wall, AGIIS Product Manager, AgGateway at 913-469-8700 ext 4134
2015 Mid-Year Meeting
2015 Mid-Year Meeting
2
What we’ll discuss… • Purpose of the Meeting • D&B Taskforce Recommendations • Communication Plan • Resources available • Implementation Feedback • Discussion
2015 Mid-Year Meeting
3
Purpose of Meeting • Review the efforts and accomplishments of the DNB Transition • Review the processes, resources and activities provided by AgGateway supporting the transition • Evaluate the successes and identify improvements that can be made for any similar future activities
• Identify any remaining areas that need to be addressed and that can be facilitated by AgGateway
2015 Mid-Year Meeting
4
TASKFORCE RECOMMENDATIONS
2015 Mid-Year Meeting
5
Recommendations D&B Taskforce began work in late 2011 • Phase 1: Stop requesting verification from D&B for EBID numbers and asking for numbers for new entities • Phase 2 – Start issuing GLN’s for new entities that have EBID’s requested and place the GLN number into both the GLN and the EBID field. • Phase 1 & 2 Completed September 15, 2012
• Phase 3- Replace the current EBID’s with GLN’s in a systematic
conversion process • Phase 3 Completed the weekend of February 13 -15, 2015
2015 Mid-Year Meeting
6
COMMUNICATION PLAN
2015 Mid-Year Meeting
7
Communication Plan • Three Target Audiences • Primary and Secondary AGIIS Subscriber Contacts, D&B
Leader Board Contacts • AGIIS Non-Subscriber Trading Partners • AgGateway Membership • 25 plus communications • Countdown Clock
• August – November - Focused on awareness • November – February - Focus on implementation
2015 Mid-Year Meeting
8
IMPLEMENTATION RESOURCES
2015 Mid-Year Meeting
9
Resources • D&B Leader Board • Provided status on: • Testing readiness • Synchronization information • Acknowledgement Letter status • Company Contacts
• Acknowledgement Letter • Allowed companies to formally acknowledge participation
• 40 out of 40 participants were committed to a successful
transition
2015 Mid-Year Meeting
10
Resources • AGIIS Website and Web Services • Pre and Post conversion functionality • Search results provided both EBID and GLN Identifiers • Schedule Subset Extracts • Resource was high value to participants
2015 Mid-Year Meeting
11
Resources • AGIIS Non-Subscriber EBID to GLN Look-up • Initially reached out to 151 Non-Subscribers • Website Look-up feature (Leverage from Expanding
Access to GLN initiative) • January 9 – February 15, 2015 • User count 50 / Individual Searches 1,565
• EBID Spreadsheet Look-up • 50 spreadsheets submitted
2015 Mid-Year Meeting
12
Resources • Conversion Spreadsheet • EBID to GLN CSV file (306,184) • Was available December 8, 2014 • Only available to AGIIS subscribers • Was downloadable from AGIIS website • Resource was high value to participants
2015 Mid-Year Meeting
13
Resources - Continued • AGIIS Test Environment • Support FTP Site Conversion • Support AGIIS Bulk File Processing • 8 subscribers/authorized providers utilized testing • Was available January 15, 2014
2015 Mid-Year Meeting
14
IMPLEMENTATION FEEDBACK
2015 Mid-Year Meeting
15
Implementation Feedback • Implementation Weekend – Went as planned • Friday February 13th (7pm CT) AGIIS website closed • Saturday February 14th • Pre-Conversion Subset extracts creation • Apply Transition change to AGIIS System • Post - Conversion Subset extracts creation • Enable GLN Look-up Functionality • Sunday February 15th • Testing • Released to Production Mid-day
2015 Mid-Year Meeting
16
Implementation Feedback • The first week we had 5 companies contact us regarding
picking up files off the ftp site. • We have had 2 companies that ongoing issues uploading files to the ftp site because they were using the old identifier. • Aware that there were a few message specific challenges, but this was being addressed trading partner to trading partner.
2015 Mid-Year Meeting
17
DISCUSSION
2015 Mid-Year Meeting
18
Discussion • Communication • Did we reach the right audience? • Was our message communicated clearly and effectively? • What would you suggest we do differently in
communications for future activities of this scale? • Implementation • Did you receive all the resources needed from AgGateway to support your transition? • What if any additional resources would you suggest AgGateway provide for future activities of this scale?
2015 Mid-Year Meeting
19
QUESTIONS?
2015 Mid-Year Meeting
20
THANK YOU! For additional information: www.aggateway.org
Member Services at 866-251-8618 or [email protected] Josh Wall, AGIIS Product Manager, AgGateway at 913-469-8700 ext 4134
2015 Mid-Year Meeting
