Skip to main content
  1. Foundant Technologies
  2. CommunitySuite
  3. CommunitySuite - Implementation
  4. CommunitySuite - FIMS Migration

Data Migration: Web-Based FIMS to CommunitySuite

  • Last Updated

Extracting data from Host*Net for your Foundant data conversion to CommunitySuite is a necessary step in the data migration process.

If you access FIMS through an icon on your desktop, do not use these instructions.  Follow the instructions in Data Migration: FIMS to CommunitySuite instead.

 

Before starting the data migration process, ensure that you have an account with administrator privileges on your computer and in FIMS. If you don't have administrator privileges on your computer, you will not be able to create the directory for the data.
 
Once you download the file attached at the bottom of this article, continue with the steps below.
 
The following steps only need to be completed the first time you migrate data from FIMS to CommunitySuite.
  1. Click Launch to open the My Files application from your Host*Net desktop. 
    • If the My Files window doesn't open, view your downloads and click the .ics file to launch.
    • There may be a message that appears asking for permission to read/write local files. You will need to grant that permission to proceed.launch button

  2. Navigate to your Desktop folder and click the caret to expand the Local Disk.
    caret

  3. Expand the Users folder, the folder with your Windows username, and then the Desktop folder.
    expanded folders

  4. Right-click the "dumpdb.p" file, and then click the copy icon.
    copy icon

  5. Expand the S: drive, and then the custom folder.expanded folders

  6. Inside the custom folder, right-click in the white space, and then click the paste icon.paste icon
The following steps only need to be completed the first time you migrate data from FIMS to CommunitySuite.
  1. Open My Files and navigate to the S: drive.
  2. Right-click in the white space, click New, and then click Folder.
    new folder button

  3. Name this folder "Dump."
The following steps only need to be completed the first time you extract data with the computer you are currently using.
  1. Open File Explorer and navigate to the Local Disk. 
  2. Right-click in the white space, click New, and then click Folder.
    new folder button

  3. Name this folder "fims."
  4. Open the fims folder.
  5. Create a second folder using step 2 above, and then name it "data."
  1. From the FIMS homepage, click the Tools drop-down menu. Next, click System Utilities and Run Procedure.
    run procedure drop-down option

  2. Enter “dumpdb.p” into the Procedure Name field if it doesn't automatically appear. Click the box next to Disable GUI for Character-Based Procedure, and then click OK.
    OK button

    • Depending on the size of your database, this process may take 30 minutes or more to run.
    • You will see something similar to the image shown below and possibly a “Not Responding” message. This message will disappear once the process is finished.
      • To monitor the process, open My Files, and navigate to the S:\dump folder. When you see a file named "zipmaste.d" with the current date and time, the process has completed. 
  1. Open My Files.
  2. Expand the S: drive, and then the dump folder.
    expanded folders

  3. Hold the Ctrl key down on your keyboard, and then press the A key to select all files in the folder. 
  4. Right-click on the selected files, and then click Copy.
  5. Expand the Local Disk, the fims folder, and then the data folder.
    expanded folders

  6. Inside the Data folder, right-click in the white space, and then click the paste icon.
    paste icon

    • If the progress bar doesn't appear, open the data folder in My Files or File Explorer. Then, scroll to the bottom and watch for the "zipmaste.d" file to be created. Once it is created, the copy is finished. 
  1. From the FIMS homepage, click the Tools drop-down menu. Next, click System Utilities, System Reports, and then Display FIMS Tables and Fields.
    display FIMS tables and fields drop-down option

  2. Check the Show Unused Tables and Fields box. Next, click the Order button, and then click OK.
    • When finished, the report will appear in the FIMS Viewer.
      OK button

  3. Click File, and then select Save As.
    file button

  4. Click the FIMS folder in the Local Disk, enter "tables.txt" as the file name, and then click Save.
    save button
  1. Open File Explorer and navigate to the Local Disk.
  2. Right click the FIMS folder, and then click Compress to ZIP file.
    compress to ZIP file button

  3. Name the file "fims."
    • Rather than saving it on the Local Disk, your computer may only allow it to be saved on the desktop. You will receive a similar message as shown below, and then click Yes.yes button
  1. Login to your Live site in CommunitySuite.
    • If this is your first time logging in to the system, reference the body of the email you received from Foundant for your URL, username, and password.
  2. Navigate to the Home page and click System Data.
    system data button

  3. Click Files in the left-side menu.
  4. Click Create in the left-side menu. 
  5. Click Choose Files.
    choose files button

  6. Select your zipped FIMS file, and then click Open.
    open button

  7. Enter a description, and then click Start Upload.
    • It is recommended that the description be "FIMS Data as of MM/DD/YY," with the date information being the date you moved the data.
      start upload button

    • The FIMS zip file should now appear on the Files page.files page
The following steps are recommended, but not required.
  1. Open File Explorer and navigate to the Data folder. 
  2. Hold the Ctrl key down on your keyboard, and then press the A key to select all files in the folder. 
  3. Hold the Shift key down on your keyboard, and then click the trash can icon.
    • A pop-up message confirming the deletion of several files will appear.
      trash can icon

  4. Click Yes.
    yes button
Was this article helpful?
0 out of 0 found this helpful
Return to top