Skip to content
Sign in
Open Ticket
  • There are no suggestions because the search field is empty.

The export function in CMS Enterprise is not working

When attempting to use any of the export functions in CMSE, it either doesn't return anything or the resulting CSV file contains invalid data.

When exports fail or don’t produce the expected CSV/ZIP files, it’s often due to a missing or mismatched ODBC driver or a missing Utilities package. While these components are typically installed with the CMSE setup, they can occasionally be removed or altered during server updates or system audits, or if CMSE was configured to use an external SQL server.

  1. First go to Control Panel > Uninstall
  2. Look for a line item named "ODBC Driver".  Check the version listed on the right hand column and note it down and also note down the number right after "ODBC Driver", which in the screenshot below is "13".
  3. Now, open a cmd prompt and type in sqlcmd -?.  Again, note down the version that's output right below the command.
  4. Lastly, type in the command bcp -v.  Note down the version listed here.
  5. The results above will determine what package we need the customer to install. Below are a couple of different combo options.  If the output of sqlcmd and bcp commands = version 14.x, then it must be matched with ODBC Driver 13.  If the output of the commands = version 15, then you must install ODBC Driver 17.
Packages: