Configure the CMC Extract Application

Owned by Keith Mangold
Last updated: Nov 30, 2022 by Scott Althaus (Unlicensed)
2 min read

When implementing a new client that is migrating from CMC, the CMC Extract application is used to import G/L Historical Data.

Pre-Requisites

  1. Access to the FTP Site

  2. Installation of the CMC ODBC Drivers

Step-by-Step Guide

  1. Access the Server where you wish to install the CMC Extract application.
     

  2. Create a new folder at C:\Program Files (x86)\Cultura\CMCExtract.


  3. Download the all of the CMCExtract*.* files from the FTP Site under the CMC Migration folder to the newly created folder.


     

  4. Edit the CMCExtract.exe.config file using Notepad.




    1. Set the Data Source value to the name of the SQL Server instance.

    2. Set the Catalog value to the name of the ERP Database.

    3. Set the Paths of the GLScrub and GLLog to the proper paths (as exampled above).


  5. Save the file and exit.


  6. Optional: If desired, create a Shortcut of the CMCExtract application by right clicking on the CMCExtract.exe file and selecting Create shortcut, then move the shortcut file to the desktop.


     


  7. Set CMC to ERP Company Division Conversion tables 

    1.  

  8. Modify stored procedure sp_CMC_GLAccount_List to set source to GLacct or GLAccountConversion table 


  9. You are now ready to use the CMC Extract application and Import Journal Entries.