Issue
Export personnel pictures from the database and create a report
Environment
Personnel records in a database
Cause
Exporting data from the database can be used for auditing purposes.
Resolution
Exporting personnel pictures from the database
- Run the List_AllPersonnel listview
- Select the personnel of the pictures that are needed
- Right click and select Send to> Text File
- Create or select a folder on the hard drive and indicate a file name (*.dmp)
- Click OK on, Are you sure you want to save these objects to a dump file?
- This will create a dump file of the personnel AND send the personnel pictures to the same folder
To get a report of the list of personnel with their pictures
- Run the same list view from above
- Select the personnel you want
- Right click and select Export Selected
- Create or select a folder on the hard drive and indicate a file name (*.csv)
- If you need a report all of this on the same page
- Highlight the cell you want the picture in
- Select Insert> Picture> From File and navigate to the appropriate file