ProConnect HelpIntuit HelpIntuit

Document Management System Intuit Hosting onboarding and setup guide

SOLVEDby Intuit3Updated February 21, 2024

Before you start:

  • The end-to-end process for onboarding a Document Management System (DMS) database is considerably lengthy. It's normal for the process to take several days. It's important that you and your users do not use DMS at all while zipping the files or copying files needed to run a database repair and do not use DMS for anything other than viewing documents that are already stored in DMS while the files are being uploaded.
  • It's important to run a Database Repair first, in case there are any issues with your DMS database.
  • Since repairing the database can take hours, it can save a lot of time if you start zipping up the Detail folder while the Database Repair is running.
  • For Lacerte's DMS we suggest using the onboarding automation instead of the steps in this article. See this article for more information.

Table of contents:

Running a Database Repair
Zipping
Uploading
Errors during upload or upload failed
Extracting
Installing DMS
Completing setup

Running a Database Repair

To avoid bringing DMS database issues with you to the hosted environment, it's important to repair your database. If you recently ran DBRepair to fix an issue with your DMS database, this can be skipped. To repair your DMS database:

  1. Create a folder on your local desktop named DMS.
  2. Open the DMS program and make note of the Current Database Path shown at the bottom.
    Current Database Path visible at bottom of DMS
  3. Have all users close out of DMS.
  4. Open File Explorer and browse to the noted path.
  5. Highlight all DATA, Locks, Refresh, and Users files and copy then paste them into the DMS folder you created on your desktop.
  6. Browse to C:\Program Files (x86)\Intuit\DMS and double-click DBRepair.exe.
    • This will appear as DBRepair if known extensions are set to be hidden on your computer.
  7. Click OK to close the Information pop-up.
  8. Select Browse, and then double-click Desktop.
    Browse then double click Desktop
  9. Highlight the DMS folder then click OK.
  10. Once the repair completes, copy and paste the DMS folder from your local desktop into the I drive in the Rightworks environment (it can be zipped if needed, but the size is often small enough that it can just be copied and pasted).

Back to Table of ContentsPCG_ASSET_spacer_11px.pngA black and white photo of a street light.

Zipping

If your DMS Database is on a server it can save a lot of time if the files are zipped from the server itself. Remote into the server if possible to run the zipping process.

  1. Open the DMS program and make note of the Current Database Path.
    Current Database Path visible at bottom of DMS
  2. Have all users close out of DMS.
  3. Open File Explorer and browse to the noted path.
    • If you skipped Running a Database Repair, when you browse to the last folder in the path, don't open that folder since you'll be zipping up the entire folder.
    • If you have started Running a Database Repair, open the last folder in the path. You will be zipping up the Detail folder inside.
  4. Right-click on the folder you will be zipping and select to Send to.
  5. Choose Compressed (zipped) folder.
    DMS1.png

Zipping may take a very long time, during this time make sure that your computer does not power off or go to sleep as this will interrupt the process.

Back to Table of ContentsPCG_ASSET_spacer_11px.pngA black and white photo of a street light.

Uploading

 

It is recommended to use a hard-wired internet connection. Avoid running background applications that use large amounts of internet bandwidth during the upload.

  1. Sign in to the Rightworks File Manager. The I:\ drive is selected by default in the left column.
    • File Manager should be accessed locally, outside the hosted environment.
  2. Click the blue .
  3. Either drag and drop the file(s) into the Drag and drop files here area, or click Add... and highlight the folder and click Open.
  4. Once you have the zipped folder added to the Upload Files window, click Upload.

Back to Table of ContentsPCG_ASSET_spacer_11px.pngA black and white photo of a street light.

Errors during upload or upload failed

Errors received during uploading, or the upload failing, are due to connection instability. Before you begin: these steps require 3rd Party Software to be installed on your computer. Please click here for more information on this program before installing. If your DMS Database is on a server it can save a lot of time if the files are zipped from the server itself. Remote into the server if possible to download 7-Zip and run the zipping process.

Zipping may take a very long time, during this time make sure that your computer does not power off or go to sleep as this will interrupt the process.

  1. Click here to download 7 Zip installer.
  2. Run 7z1900-x64.exe.
    • After clicking the link above, this will usually been seen at the bottom left of your internet browser screen or in your Downloads folder. You can also use Ctrl+J to open the Downloads window in your internet browser.
  3. On the 7-Zip 19.00 (x64) Setup window, leave the default location for your Destination folder then click the Install button.
  4. When the green bar reaches the end it will tell you 7-Zip 19.00 (x64) is installed, click the Close button.
  5. Use File Explorer to browse to your DMS Database.
    • See steps 1-3 in the Zipping section for detailed instructions. You will be re-zipping the same folder as in those steps but this time using 7-Zip to create smaller, easier to upload zipped files.
  6. Right click on the folder you will be zipping then hover your mouse over 7-Zip and choose Add to archive…
  7. Click on the Archive format drop-down and select zip if not already selected.
  8. Near the bottom left, click on the Split to volumes drop-down and select 1000M.
    2020-11-17_10-45-32.png
  9. Click OK. You will see a progress window displaying the status. This will take some time, depending on the size of the folder.
  10. After this completes you will see the smaller zip files in the same location as the original folder (*.zip.001, *.zip.002, *.zip.003, etc where * is the name of the original folder)
  11. Upload all of these zip files created by 7-Zip. Refer to the Uploading your zipped folder section above for detailed instructions. If the process fails, take note of the last file that successfully uploaded and begin the upload again where you left off.
    • For example: If the upload fails while uploading file 056, you should re-upload files 056 to the end, you do not need to select 001 through 055 again.
  12. Once the upload is complete, you can click the Log Off button in the upper-right corner if additional files do not need to be uploaded at this time.

Back to Table of ContentsPCG_ASSET_spacer_11px.pngA black and white photo of a street light.

Extracting

If files were zipped using 7-Zip, call to speak with an Intuit Hosting expert. 

For more information on how to contact Lacerte, as well as our operating hours, see here.

For more information on how to contact ProSeries, as well as our operating hours, see here.

If you zipped sending to compressed (zipped) folder:

  1. Open File Explorer.
  2. Highlight the zipped folder.
  3. Select the Compressed Folder Tools Extract tab that appears.
  4. Click on the Extract all button.
    File Explorer's Extract Tab's Extract All
  5. On the Extract Compressed (Zipped) Folders pop-up click Browse to browse to where you would like the folder extracted or type the desired path.
    • If you zipped up just your Detail folder, use the path I:\DMS to have the Detail folder directly extracted into the DMS folder with the repaired database from the Running a Database Repair instructions.
  6. Click Extract once the desired path is entered.

Back to Table of ContentsPCG_ASSET_spacer_11px.pngA black and white photo of a street light.

Installing DMS

  1. Sign in to the Rightworks AppHub.
    • Users with the User (no catalog) role will need the Account Owner or someone with the Account Admin role to install apps for them.
  2. Select My Apps.
  3. Scroll down to the Available Applications section and locate Lacerte Document Management System or ProSeries Document Management System.
  4. Select Install.
    • The installation will begin, and when it's complete, you'll see the app in the Installed Applications section.
  5. If you are the Account Owner, or an Account Admin, and also want to install DMS for your other users:
    1. Select the Admin Console.
    2. Go to the Users tab.
    3. Click on the name of the user to be taken to their Apps screen.
    4. Scroll down to the Available Applications section and locate Lacerte Document Management System or ProSeries Document Management System.
    5. Choose Install.
      • The installation will begin, and when it's complete, you'll see the app in the Installed Applications section.
    6. Select All Users in the upper left to quickly get back to your list of users if you need to repeat to install for additional users.

Back to Table of ContentsPCG_ASSET_spacer_11px.pngA black and white photo of a street light.

Completing setup

Agent Note: Hosted trained agents can use the Support Hub's Lacerte Quick Fixes choice for Prep File Copy to quickly copy the prep file to the needed locations. See this article for more information.

  1. Download the prep file from your Intuit My Account dashboard, or copy it from where it's saved for the Lacerte tax program at I:\Lacerte\22tax\Option22.
    • You can use Ctrl+C (keyboard shortcuts work by default in the hosted environment when it's maximized) or select the Home tab in File Explorer and use the Copy button.
  2. Open File Explorer.
  3. Select This PC from the left column, then browse to H:\Settings\ProgramData\Intuit\DMS.
    • If you can't see the Settings folder, select the View tab and check the box for Hidden items.
      File Explorer's Hidden Items checkbox
  4. Paste the prep.22 file inside the DMS folder.
    • You can use Ctrl+V or select the Home tab in File Explorer and use the Paste button.
  5. Browse to H:\Settings\Program Files\Lacerte\​​22taxpln\Data.
  6. Paste the prep.22 file inside the Data folder.
  7. Open DMS in the hosted environment and close out of all pop-up windows until you see the main DMS window.
  8. From the File menu, go to Database and choose Open.
  9. Click Browse then browse to your DMS Database then click OK.
  1. Open DMS in the hosted environment.
  2. Enter your Customer Number (CAN) and Zip Code for licensing when prompted then click OK.
    • If you closed out of this window by mistake, you'll be in demo mode. Click on the Tools drop-down at the top of DMS and select Update License Information to get to where you can enter this information.
  3. Close out of all pop-up windows until you see the main DMS window.
  4. From the File menu, go to Database and choose Open.
  5. Click Browse then browse to your DMS Database then click OK.

Back to Table of ContentsPCG_ASSET_spacer_11px.pngA black and white photo of a street light.

Was this helpful?

You must sign in to vote, reply, or post
Lacerte TaxProSeries BasicProSeries ProfessionalThird-party partnersWorkflow Add-On Document Management System

Sign in for the best experience

Ask questions, get answers, and join our large community of Intuit Accountants users.

More like this

Dynamic AdsDynamic Ads