***This CDI guide is for QuickBooks single currency configurations***

Note - In many cases CDI automation for QuickBooks is not possible. Please contact us at support@centage.com if you would like inquire about the possibility of automation based on your specific environment.

 

Content: 

Introduction

Installation

Configuration

Introduction

Centage Data Integrator (CDI) is a 32-bit Window’s application used to facilitate a transfer of General Ledger data to Centage’s web-based application, Planning Maestro. In this document we will cover installation, configuration, and automation as well as provisioning access for the CDI application to access your General Ledger data.

 

Installation

CDI will need access to your General Ledger data. CDI should be installed on the same environment as QuickBooks. This can be a PC or Server.

1. Download CDI installer from a Centage-provided download link.
2. Extract CDI installer from ZIP folder.
3. Run CDI installer on desired install location(s), preferably as an Administrator.
4. A small window will appear.  Click Setup to begin.
   
5. Click Next.
   
6. Review and accept the terms in the license agreement to proceed, then click Next.
7. Specify the desired installation path (default setting recommended) and click Next.
8. Click Install.
9. Click Finish.
   Centage Data Integrator has now been installed.

 

Configuration

Create a Preferences folder for CDI

This can be done within CDI but due to potential permissions conflicts it is easier to do through File Explorer.

Open File Explorer and navigate to the CDI installation path. If you used the default for installation, go to C:\Program Files (x86)\Centage\Centage Data Integrator

Add a new folder named Preferences.

 

Open the CDI application

It is recommended to run CDI as Administrator. CDI may not be able to save files unless it is explicitly run as Administrator (right-click > Run as Administrator) even if you are logged into the server as a user with Administrator privileges.

1. Launch CDI as Administrator. On the Configuration tab, click the Create button.
   
   
2. A “Save As” window will appear. Navigate to the Preferences folder you created if it does not automatically open to that folder. Enter your company name as the File Name and click Save.
   • If you get an error message prompting to save the Preferences file to your Documents folder, try closing CDI and re-opening it as Administrator.
   • If that fails, it is ok to save the Preferences file to the Documents folder. However if it is deleted, CDI will need to be re-configured.
3. Once the File Location text box has populated with the file path, click the Source tab in CDI tool bar.

4. Click the Down arrow button next to the <Select Source Provider> text box. Then select QuickBooks.
5. In the Choose File section that appears, click the ... button and find your QuickBooks company file. The exact location of this file is determined by your organization. Please note: UNC paths are not supported, please use a mapped drive letter path to open the file. 
6. Click Connect so that the file selection is saved. This will result in error messages. Close all error windows that appear. Do not worry, we will address these issues in the next steps.
7. Close CDI
8. Open the QuickBooks Company File in QuickBooks. Log into QuickBooks as the Admin user. 
9. Change QuickBooks to Single User Mode by clicking File > Switch to Single User Mode (if the only option is Switch to Multi User Mode, you are already in Single User Mode)
10. Close any pop up windows that QuickBooks may open after changing User Mode.
11. Now, Start CDI again, while keeping QuickBooks open (Do not run CDI as Administrator this time, QuickBooks will reject the connection)
12. On the Configuration tab, select Load, then select the Preferences file you created earlier. Once CDI finishes loading, click the Source tab.
13. The Provider selection (QuickBooks) and the QuickBooks file selection should be saved and be automatically populated here. 
14. Click Connect
15. QuickBooks Should open a Certificate window prompting or permission to allow access. This window can sometimes open behind other windows so you may have to minimize windows you have open. 

     16. Under 'Do you want to allow this application to read this company file?' select 'Yes, always; allow access even if QuickBooks is not running'

      17. Select the drop down arrow next to 'Login as:' and select the Admin user

      18. Click Continue,

      19. On the Access Confirmation window, select Done

      20. CDI should now show the connection status as "Connected"

      21. Close CDI and navigate back to QuickBooks, in QuickBooks, change back to Multi User mode, then close QuickBooks

      22. Re open CDI (run CDI as Administrator if possible or the settings may not save to the Preferences file)

      23. On the Configuration tab, select Load, then select the Preferences file you created earlier. Once CDI finishes loading, click the Source tab.

      24. Confirm that the Connection Status displays Connected, if it does not, click the Connect button. 

      25. Click on the Extract Data tab

      26. The default settings will be correct. Click Generate Files 

       27. You should receive a notification once the Data Extraction is completed

      28. Once the Data Extraction has completed, select the Upload tab.

      29. Folder to upload should default to the correct path.

• • Make sure it is set to the same path as the Output Path in the Extract Data tab.
  • This will typically be C:\Program Files (x86)\Centage\Centage Data Integrator\Output
  • The Centage Planning Maestro site, Planning Maestro Username, and Planning Maestro password will be supplied to you directly and securely by our Centage Support team.

      30. Once you have entered the information provided by the Centage Support team, click Connect.

      31. Under the Connect button, the connection status should appear indicating a success or failure.

      32. If the Connection was successful you should be able to click on the drop down list under “Planning Maestro Profile” and select your Planning Maestro Profile name. This will usually be your company name.

• • The Profile is set up by Centage for you.

      33. Once the Profile is selected, click the Upload button to start the Data Upload.

      32. The upload can take some time depending on your data and environment. You should receive a confirmation notification when the Upload has completed.

• • If more that one Upload runs at the same time it will fail. Please wait until your Upload completes before re-attempting an upload.