About

Originally operating as a training company in the automobile dealership industry, we have expanded over the years into a multi-faceted firm that consults, develops software, and designs management information systems for automobile dealerships, healthcare providers and other professional services companies. We consider ourselves experts in the ADP (now CDK Global) Dealership Management System (DMS) data model. We know what information is available in the ADP DMS and how to get at it, analyze it and present it to improve your operations.

John Donnelly became a Certified Public Accountant in California in 1984 and became the partner in charge of Management Advisory Services at Borbely and Donnelly CPAs in Culver City California. The firm had at one time over 100 automobile dealership clients. Today, Mr. Donnelly continues his career serving in an executive capacity in financial and general management.

Mr. Donnelly has since become a Microsoft Partner and develops software and custom solutions for his clients in many industries.

31 thoughts on “About”

  1. Hi John,

    So refreshing to find a glimmer of hope that someone outside ADP understands their system and English statements.

    Our company is in the process of creating an ecommerce website for a car dealership. In Google searching, it looks like you have experience with extracting data and importing data into an ADP system.

    We’re wondering if you would be willing to mentor on the ADP system with regard to the English statements.

    I’m not sure where you are located, but I’m in the US Central time zone and can be reached at (920) -788-8024 or via email. I do look forward to hearing from you.

    Thank you,
    Rhonda

  2. John,

    We are having issues with extracting data from Reynolds as everybody else is with the new changes.

    We also have a project coming up where we need help with data extract on ADP, Reynolds and possibly other DMS. Please email me if interested and I can elaborate.

    Thanks!

  3. Greetings John,

    I am a software developer working on automating various data feeds for an automobile dealership that uses the ADP Drive system.

    One of the data feeds we wish to automate is the process of manually running the following Vehicle Inventory Report on a daily basis against four different accounts and saving the output as text files:

    LIST CAR-INV WITH SOLD EQ “” AND WITH SERIAL NE “” AND WITH STOCK-NO. NE “” BY
    FIELD26 MAKE MODEL SERIAL STOCK-NO. FIELD26 SLIST YEAR MILES SCOST DAYS DEL-CD BALANCE ID-SUPP COL-HDR-SUPP

    I enjoyed reading your post entitled, “Using PowerShell to Request, Filter and Manipulate an [XML] SOAP Response” which contains logic that appears to be very similar to what we wish to accomplish.

    However, being new to the ADP Drive system, I have not yet aquired the knowledge to connect to the ADP system in this manner to be able to process SOAP requests and responses.

    Would you be interested in being hired as a consultant to help complete this task and potentially others?

    Thank you,
    Rob

  4. Hello John,

    I have a payroll client that needs to extract employee demographics and payroll history from Jan 1st through current from a Reynolds and Reynolds system. We are not familiar with R&R and need some help.

    Please let me know if you are interested.

    Thank you,
    Jim

  5. John, you sound like have all experience we are lacking! We are building a reporting application for dealerships and the biggest unknown is now we will be able to access the data. Would it be possible for me to bend your ear briefly, then possibly explore the option of consulting with us?

    Thank you for any guidance you can lend.
    Suzanne

  6. Hello John,
    Much like the comment above, we are also building an application that requires data from ADP, R&R etc. We would love your assistance on the best way to do this. Hope to hear from you soon.

    Thanks!
    Steve

  7. Hi John,

    I just got finished reading your article on 3rd Party Data Extraction with Reynolds and Reynolds and ERAccess. I am currently working on a vehicle tracking system for dealerships. I am having trouble figuring out how to extract data from R&R. I would greatly appreciate any assistance you could offer.

    Thank you,
    Kevin

  8. John,

    I work for an inventory marketing/data management company. We work with a ton of dealers that have the Reynolds system and are having a hard time getting the data from the system that we need to support our customers. Would you be available to help?

    Thank you,
    Jason

  9. Hello John,
    I have a software product company that develops products for automotive dealers and OEMs. We need to interface with Reynolds as well as ADP, and are running into a lot of FUD. Don’t know where to start or whether what we are trying to do is even feasible.
    Couple this with how hard R&R makes it to even talk to someone knowledgeable, has made it even harder.
    I was wondering if you will be able to help.

    Thanks,
    Gary

  10. Hi John,

    I’m doing some research on ADP Dealer Services. I was wondering if I could ask you a couple of questions since nobody at ADP seems to want to discuss how you can interface with their products unless you wait for a few weeks.

  11. John,

    I have a very innovative company that is launching a new vehicle tracking program for automobile dealerships. We already have installed several Reynolds Dealerships (I have over 25 years in the retail side with RR and UCS dealerships but have never worked with ADP). We just signed our first ADP client and have several more lined up. I was really hoping to shorten the learning curve for the extracts we need from the DMS and was looking to hire a consultant for that purpose.

    Please contact me at if you have an interest.

    Thank you,

    Randy Knapton
    President – Simply Brilliant Automotive Solutions

  12. Hi John,
    I read your blog with interest and you seems to have an ample experience in this field.

    Our startup is working on rewards system that facilitates stronger connections between car dealers and their customers.

    Our task is to build a custom solution (API or application) that would be able to extra customer data from R&R system and create an account for that customer in our rewards system, so both would function in unison.
    // Possibility to build API like that would be great:
    full_customer_data = GetCustomerDataFromRNRByCustomerID (customer_id);

    I wonder if you’d be able to offer any guidance or help in these aspects:
    – is it possible to accomplish?
    – what would it take?

    Hope to hear from you regarding any ideas that would could share…

    Gleb

    1. Hi Gleb,

      Extracting from Reynolds requires certification which is a costly proposition I hear ($50,000+ range). Not a reall big hill if you will be pushing out nationally. I have experience with the ADP API and not Reynolds. ADP Certification I believe is more reasonable ($10,000+ Range) and they have a huge market share.

      If I can help, let me know.

      JD

      1. Hi John,
        Thank you for your reply.
        Could you get back to me about the cost estimate to accomplish that. Say creating a set of dot NET classes including source code to interface with ADP for data retrieval functions.

        Gleb

  13. Hi John,

    I’ve read your blog, it’s impressive and I wanted to thank you for putting all this information out there, I know how much time it takes and it’s very helpful.

    We have a company that creates websites for dealers, one of our customers wants us to pull information from R&R and integrate that with other data from other sources to create a comprehensive view of their sales. We plan to make this feature generally available to our customers so we’ll want to solve this problem for our ADP clients as well.

    We’ve not done this before and would like to leverage your extensive expertise. Please contact me if you have any interest.

    Thanks,
    Ruben.

  14. Hi John,

    Love the blog! I’m hoping to employ your services. I have a small marketing company and I’m trying to pull data for a dealer. They use ADP and I’m pulling my hair out trying to make a deadline. If you can help please shoot me an email.

    Warm Regards,
    Tyrin

  15. John: one of your posts, from 2011, mentions that you assembled and XLS with valid ENGLISH/PICK statements. True, it also mentioned that you shelved trying to perfect your ENGLISH queries, in favor of another approach. But can you possibly post a representative sampling of your ENGLISH queries, in the ADP context ??

    1. Hi Mike,

      Well the ENGLISH statements are important to reduce the quantity of data returned from the server as much as you can before processing. However, one would use XPath queries to fine tune the results client side. This can be seen in my PowerShell scripts in the -xpath parameter of the Select-Xml command (the $query variable is passed into the -xpath param).

      If you use C#, you could use XPath queries with an XmlNavigator object or better yet you would use the very powerful LINQ to XML feature on the xml returned from the call the server and skip XPath altogether.

      If you need sample ENGLISH statements I can post about that. I’m just not sure what you would like to see Mike.

  16. Whats up this is kind of of off topic but I was wondering if blogs
    use WYSIWYG editors or if you have to manually code with HTML.

    I’m starting a blog soon but have no coding experience so I wanted to get guidance from someone with experience.
    Any help would be greatly appreciated!

    1. Hello ไฟโตเอสซี,

      Yes they do. You can get a free blog at wordpress.com. It is very user friendly and easy to get started. My blog (this one) is a wordpress blog.

      John

  17. Σερφάρω στο ιντερνέτ σήμερα για περισσότερες από 4 ώρες
    και δεν βρήκα πολλά άρθρα που να είναι εξίσου ενδιαφέροντα με το δικό σας.
    Πιστεύω ότι αν όλοι οι ιδιοκτήτες των sites έφτιαχναν τέτοιο ποιοτικό περιεχόμενο το ιντερνετ, θα ήταν πολύ
    καλύτερο για όλους.

  18. John, I’m exited to found you… several months ago I started to search info to help me to extract data from ADP… sadly it is very confusing and poor. But you seems are the master… Please give me some ideas how to get over that monster…

  19. Hey john,
    My family owns a dealership and I work there and have always been fascinated with programming. I want to learn on my own. What language do you recommend if I want to use programming to build programs to assist at the dealership?
    Thanks!

    1. Hi Shane, well the trend with dealerships is accessing the data to improve decision making, sales and operations in that order. You can help by learning PowerShell first. That will help you get at the data and automate some processes to analyze the data. Second learn C# and Microsoft’s .Net framework. They go together so if you get a book on C# you will be learning .Net too. If you need any help email me at jdonnelly at jdonnelly dot com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s