To show the media file, open iPhoto or Aperture. Then open the app library that contains the photo or video file. Opening the library brings the media file back online so it appears in the Motion project.