Creating Requests

Create new Requests from a CSV file, ensuring that the first two columns of the import file are LastName and Request.  Any other Request column may then be included, excepting ReferenceID and ArqID. The name of the Requests table in the Data Dictionary Report is tblActRequest.

There is a System Option for Requests to always be assigned to someone is ‘Requests must be assigned to an Organisational Unit’. When True this means that the AssignTo column must be present and have a positive integer value that is a foreign key to tblObs.OrgID.

A typical use for this Function is to load Requests generated in another system, for which works management is to take place using Conquest Actions.  Conquest’s Request/Action system allows the assignment of Actions to Assets, which means that the Requests can then be associated with an Asset.