PIMS Resource Center

PIMS Report Developer's Tookit
added 9/20/13

The Developer's Toolkit is a work-in-progress, which will be developed in September and October 2013 as a tool for independent developers to create PIMS reports.

Due to security features built into PIMS, you cannot directly open a PIMS data table. However, you can import PIMS data into a new secure database. With an administrator login to this new database, you can design your own queries or export data into Excel.

To do this:

  1. Download the developer's toolkit.
  2. In the Opening pims_devkit.zip window, check Save File and click OK. This should save a file named pims_devkit.zip to your desktop.
  3. Right click on pims_devkit.zip, select Open With and then Compressed (zipped) folders.
  4. In the pims_devkit.zip window, click Extract all files.
  5. You should see a window, Welcome to the Compressed Folders Extraction Wizard. Click Next.
  6. The next window asks you to select a destination. Click Browse...
  7. Navigate to C:, then Program Files), and click OK. If this folder doesn't exist (i.e. you haven't installed PIMS 7), create a new folder named pims7 in the Program Files directory.
  8. Back in the Select a Destination window, click Next.
  9. If you get a Confirm File Replace message, click Yes to All.
  10. The next window should let you know that the extraction was completed. Leave the box labeled show extracted files checked, and click Finish.
  11. Open the pims_devkit folder. Drag the Shortcut to PIMS Devkit to your desktop.
  12. If necessary, you may have to modify the shortcut to reflect your version of Microsoft Access by right-clicking on the shortcut, going to Properties, and then updating the version number of Office in both the Start In and Target boxes. In some cases you will need to rename "Program Files" to "Program Files (x86)" for the path to Microsoft Access.
  13. VersionTarget
    Office 2000Office
    Office XPOffice10
    Office 2003Office11
    Office 2007Office12
    Office 2010Office14
    Office 2013Office15
  14. Double-click on the Shortcut to PIMS Devkit.
  15. Log in using the password provided by your technical assistant.
  16. From the File menu, go to Get External Data, and select Link Tables....
  17. Locate your pims data table (which could be either PIMS data or supplemental data), and click Link.
  18. In the Import Objects window, select all the tables you wish to link, and click OK.
  19. If you subsequently want to link to a new dataset, first run the macro

  © Copyright 2007-2019 Prevent Child Abuse America. All rights reserved.