I have a list of funds I need to import, but I don't see a fund import on the menu. Is there an import?
  • 03 Jun 2023
  • Contributors
  • Dark
    Light
  • PDF

I have a list of funds I need to import, but I don't see a fund import on the menu. Is there an import?

  • Dark
    Light
  • PDF

Article summary

There doesn't seem to be a fund import utility on the file maintenance menu like there is for gifts, grants and scholarships. Is there an import tool I can use or do I have to type the information in?

Answer:
There is a general purpose import that currently will import fund information into the fund1 and fund 2 tabs. Before you can use the utility, you need to set up some system options:
  1. Tools > System Utilities > System Options.
  2. Click Editor tab.
  3. Scroll down to the section [System].
  4. Insert a line.
  5. Enter ImportTables=altaddress,fund,recontran,fund-rep,program,follow-up into the new line.
  6. Click OK to save and close.
The data you wish to import must be in an excel spreadsheet saved as an xls, not a csv or txt file.
You must have column headers in your data.

Test the utility in Test and Learn first, not in the Live database.
To run the procedure:
  1. Tools > System Utilities > Run Procedure.
  2. Enter or browse for gui\imports\d-ssimp.w.
  3. Click OK
  4. In the tool, click Next.
  5. Browse for your saved spreadsheet.
  6. Select the Worksheet tab number containing your data.  This will typically be 1.
  7. Enter in the data range for the imported data.  The From cell will most likely be A1 since the top row contains the labels, but adjust your values accordingly.
  8. Initially the Through cell should include the last column of your data, but you can limit the test number of rows to 1 by entering a value of 2 in the Through value row number.
  9. Check off the box since your first row contains the column labels.
  10. Click Next
  11. Select Fund in the table list
  12. Click Next
The next screen maps the columns in your spreadsheet to the columns in the table chosen in step 11.
The mapping process is to :
  1. Select a column in the Excel Column section
  2. Select the field you want that column to import into in the Data Map section
  3. Click Add
  4. Repeat for all values you want imported.
  5. When finished, click Save map and name and save the file.
  6. If you matched a column to the wrong data field, highlight the match and click Remove
  7. Click Next and then Finish to import the data
After importing review the imported information in the Fund module.
Correct the map and your excel spreadsheet until everything flows in correctly.
Since the map has been saved, if the imported data flowed into the correct fields and the resulting records are fine, you can easily repeat the process in the Live database and instead of mapping your data again, you can retrieve the saved map and be assured that the data will flow into the fund table correctly.

Was this article helpful?