What would you like to know more about?

Import Fund Information

To use this process, you must first import your family data and member data.

CAUTION: You must set up the fund, fund periods, and fund activities in your PDS Office program before importing this information. If the fund isn't set up, the information won't import into the program.

Before you import fund information, make sure your file contains a value that connects the fund information to the family or member. This is the value you selected during the Family and Member Import processes for the Family/Member Key or ID/Env Number fields.

Note: When importing pledge information, only the total pledge (mapped to an activity with a Charge function) is imported. To import terms and rates, use the Import Pledge Information process.

You can import information for multiple funds at the same time as long as there's a column in your file that indicates the fund number to use. Or, if you'd like, you can run the process multiple times using the same .csv file, but select a different fund each time you run the process. If you run the process multiple times, the records that don't match the activities in the selected fund are not posted. This information is recorded in the Pre-Import and Import logs.

CAUTION: Never run the import process more than once for the same fund. Otherwise, duplicate records are posted.

How this process works: Once you identify the .csv file, you will match the values in that file with your PDS Office program fields. There are a few required fields, but other than that, you only have to enter information for the data you want to import into your program. No data is imported until you click Begin Import on the final tab. Your selections are automatically saved on each tab, so you can come back to this process at another time if needed.

You can use the Import Fund Information process to import existing fund data from a .csv file into your PDS Office program.

  1. On the File menu, click Import Data > Import Fund Information.
  2. The backup dialog box displays if you haven't performed a daily backup.
    CAUTION: This process alters data. We recommend backing up your data before proceeding.
  3. The Create Fund Records dialog box displays. On the File Information tab, click Browse to locate the .csv file. After you select a file and click Open, your data displays.
    Note: We strongly recommend that you include field names/headers so it's easier to select the corresponding value from the drop-down lists on other tabs.
  4. On each tab, select the appropriate values from the drop-down lists. For more information about fields on these tabs, refer to the related topic "Fund Import Field Information".
  5. On the final tab, before you import your data, click Pre-Import Data Check. This creates a file called "PreImportContribErrors.txt" in the program's data folder.
  6. Scroll through the items you're going to import to see if you need to make any adjustments.
  7. When you're ready to import the data into your PDS Office program, click Begin Import.
  8. Once the import is complete, a summary displays. This creates a file named "ContribErrors.txt" in the program's data folder.
  9. When you're done, click Finish.