File Importer Service
The File Importer Service can automatically upload and index network files into GoFileRoom. It is a Visual Basic (VB) script that uses criteria, like the file name, file type, or folder name to organize them in GoFileRoom correctly. For example, you can have tax returns that were created in another program and saved as PDF files to a specific network location with a specific naming convention get automatically uploaded to the proper client drawers. You can also do database lookups using this service.
You can also use this service to upload and properly file existing files or as they are created in the network location.
The following are the standard installation and configuration instructions, which includes multiple parts. If you'd prefer our Technical Services team to install and configure this service for you, contact your Sales Representative. Our Technical Services team can also customize your configuration to allow the service to upload and index additional file types.
Configure the network file location
You'll first need to create a location on your network where GoFileRoom can temporarily sort PDF copies of tax returns that'll be imported into GoFileRoom.
- On your network, create a folder that will be easy to recognize, such asGFR_FILE_IMPORTER.
- Right-click on the folder and chooseProperties.
- Go to the Sharing tab, and selectAdvanced Sharing.
- Mark theShare this foldercheckbox, then selectPermissions.
- Make sure this folder is shared andFull Controlis marked in the Allow column for theEveryonegroup.
- Select OK twice to save and close the windows.
- Take note of the network path from the Sharing tab. You'll need to enter it when you install the utility.
Install the File Importer Service Utility
- Download the File_Importer.zip file.
- Save and extract the files to an easy-to-find location.
- Double-click theGoFileRoom_FileImportUtility.msifile, and follow the prompts in the installation wizard.
- Close the File Import Configuration dialog that opens automatically.
- SelectFinish.
- Go to the location where you saved the extracted files, and copy the.vbsscript file that corresponds to the tax program your firm uses. For example, with UltraTax CS, go to the extracted folder namedUltraTaxCSand copy thescript_tax.vbsfile.
- Go toC:\Program Files (x86)\GoFileRoom\GFRFileImporterfolder, and paste the.vbsfile there.
- Right-click theGFRFileImporterConfiguration.exefile and chooseRun as administrator.
- On theGeneraltab of this window, enter the following:
- Your fir's upload account inGFR User ID.
- The password for your firm’s upload account inGFR Password.
- The schedule for how often you want the utility to run in military time. We recommend running it every 30 minutes between 6:00 AM and 11:00 PM. So you would enter0600inStart,0030inInterval, and2300inEnd.
- Move to the Folders tab and enter the following:
- Enter the path to the shared network folder you created in the previous steps in theFolderfield. Mark the sub Folder checkbox if there are subfolders.
- Enter0000000001inGFR Drawer ID.
- Enter1inGFR Cabinet ID.
- Enter the name of the .vbs file you added in step 6 in theScript File Name.
- Choose DELETE inDone Action.
- Choose RENAME inError Action.
- Enter_in theDelimeterfield (a single underscore).
- SelectAddto add it to the list.
- Leave the Exclude tab blank.
- Go to the Email tab and enter the following:
- Select Errors only in theLevelfield.
- Enter the email you'd like to receive notification if an error occurs in the File Importer utility. You can enter multiple by using a semicolon to separate them.
- Leave no-reply@thomsonreuters.com in theImmediatech Support eMailfield.
- Leave theLogin IDandPasswordfields blank.
- Leave the Database tab blank.
- SelectApplyandSave.
Install and configure the service
- Go to the files you extracted earlier, right-click thesrvinstw.exefile, and selectRun as administrator.
- Follow the prompts in the installation wizard.
- Select theInstall a serviceoption, then selectNext.
- Select theLocal Machineoption, then selectNext.
- EnterGFR_File_Importeras the service name, then selectNext.
- SelectBrowseand go toC:\Program Files (x86)\GoFileRoom\GFRFileImporter\. ChooseGFRFileImporterService.exe, selectOpen, thenNext.
- Select theService is its own processoption, then selectNext.
- Select theSystem Accountoption (unless the firm requires other credentials like Domain Administrator).
- Mark theAllow Service interact with Desktopcheckbox, then selectNext.
- Select theAutomaticoption, selectNext, then selectFinish.
- SelectOK.
- After the service is installed, select the Windows Start button, select theRunlink, and enterservices.mscin theRunwindow.
- In theServiceswindow, right-click the newGFR_File_Importerservice and selectProperties.
- Select theRecoverytab and selectRestart the Servicefor the three failure fields.
- SelectApply, selectOK, and restart the service.